bc_trigger2.ddl

DROP SEQUENCE BC_Amendment_seq ; 
create sequence BC_Amendment_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Amendment_PK_trig 
before insert on BC_Amendment
for each row 
begin 
select BC_Amendment_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Amendment add dflex date ; 
alter table BC_Amendment add iflex1 integer ; 
alter table BC_Amendment add iflex2 integer ; 
alter table BC_Amendment add vflex1 VARCHAR2 (4000) ; 
alter table BC_Amendment add vflex2 VARCHAR2 (4000) ; 
alter table BC_Amendment add vflex3 VARCHAR2 (4000) ; 
alter table BC_Amendment add created date ; 
alter table BC_Amendment add created_by VARCHAR2 (255) ; 
alter table BC_Amendment add row_version_number integer ; 
alter table BC_Amendment add updated date ; 
alter table BC_Amendment add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Amendment_AUD_trig 
before insert or update on BC_Amendment 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Contact_Log_seq ; 
create sequence BC_Contact_Log_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Contact_Log_PK_trig 
before insert on BC_Contact_Log
for each row 
begin 
select BC_Contact_Log_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Contact_Log add dflex date ; 
alter table BC_Contact_Log add iflex1 integer ; 
alter table BC_Contact_Log add iflex2 integer ; 
alter table BC_Contact_Log add vflex1 VARCHAR2 (4000) ; 
alter table BC_Contact_Log add vflex2 VARCHAR2 (4000) ; 
alter table BC_Contact_Log add vflex3 VARCHAR2 (4000) ; 
alter table BC_Contact_Log add created date ; 
alter table BC_Contact_Log add created_by VARCHAR2 (255) ; 
alter table BC_Contact_Log add row_version_number integer ; 
alter table BC_Contact_Log add updated date ; 
alter table BC_Contact_Log add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Contact_Log_AUD_trig 
before insert or update on BC_Contact_Log 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Contract_seq ; 
create sequence BC_Contract_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Contract_PK_trig 
before insert on BC_Contract
for each row 
begin 
select BC_Contract_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Contract add dflex date ; 
alter table BC_Contract add iflex1 integer ; 
alter table BC_Contract add iflex2 integer ; 
alter table BC_Contract add vflex1 VARCHAR2 (4000) ; 
alter table BC_Contract add vflex2 VARCHAR2 (4000) ; 
alter table BC_Contract add vflex3 VARCHAR2 (4000) ; 
alter table BC_Contract add created date ; 
alter table BC_Contract add created_by VARCHAR2 (255) ; 
alter table BC_Contract add row_version_number integer ; 
alter table BC_Contract add updated date ; 
alter table BC_Contract add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Contract_AUD_trig 
before insert or update on BC_Contract 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Department_seq ; 
create sequence BC_Department_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Department_PK_trig 
before insert on BC_Department
for each row 
begin 
select BC_Department_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Department add dflex date ; 
alter table BC_Department add iflex1 integer ; 
alter table BC_Department add iflex2 integer ; 
alter table BC_Department add vflex1 VARCHAR2 (4000) ; 
alter table BC_Department add vflex2 VARCHAR2 (4000) ; 
alter table BC_Department add vflex3 VARCHAR2 (4000) ; 
alter table BC_Department add created date ; 
alter table BC_Department add created_by VARCHAR2 (255) ; 
alter table BC_Department add row_version_number integer ; 
alter table BC_Department add updated date ; 
alter table BC_Department add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Department_AUD_trig 
before insert or update on BC_Department 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Document_seq ; 
create sequence BC_Document_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Document_PK_trig 
before insert on BC_Document
for each row 
begin 
select BC_Document_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Document add dflex date ; 
alter table BC_Document add iflex1 integer ; 
alter table BC_Document add iflex2 integer ; 
alter table BC_Document add vflex1 VARCHAR2 (4000) ; 
alter table BC_Document add vflex2 VARCHAR2 (4000) ; 
alter table BC_Document add vflex3 VARCHAR2 (4000) ; 
alter table BC_Document add created date ; 
alter table BC_Document add created_by VARCHAR2 (255) ; 
alter table BC_Document add row_version_number integer ; 
alter table BC_Document add updated date ; 
alter table BC_Document add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Document_AUD_trig 
before insert or update on BC_Document 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Escalation_seq ; 
create sequence BC_Escalation_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Escalation_PK_trig 
before insert on BC_Escalation
for each row 
begin 
select BC_Escalation_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Escalation add dflex date ; 
alter table BC_Escalation add iflex1 integer ; 
alter table BC_Escalation add iflex2 integer ; 
alter table BC_Escalation add vflex1 VARCHAR2 (4000) ; 
alter table BC_Escalation add vflex2 VARCHAR2 (4000) ; 
alter table BC_Escalation add vflex3 VARCHAR2 (4000) ; 
alter table BC_Escalation add created date ; 
alter table BC_Escalation add created_by VARCHAR2 (255) ; 
alter table BC_Escalation add row_version_number integer ; 
alter table BC_Escalation add updated date ; 
alter table BC_Escalation add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Escalation_AUD_trig 
before insert or update on BC_Escalation 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Invoice_seq ; 
create sequence BC_Invoice_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Invoice_PK_trig 
before insert on BC_Invoice
for each row 
begin 
select BC_Invoice_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Invoice add dflex date ; 
alter table BC_Invoice add iflex1 integer ; 
alter table BC_Invoice add iflex2 integer ; 
alter table BC_Invoice add vflex1 VARCHAR2 (4000) ; 
alter table BC_Invoice add vflex2 VARCHAR2 (4000) ; 
alter table BC_Invoice add vflex3 VARCHAR2 (4000) ; 
alter table BC_Invoice add created date ; 
alter table BC_Invoice add created_by VARCHAR2 (255) ; 
alter table BC_Invoice add row_version_number integer ; 
alter table BC_Invoice add updated date ; 
alter table BC_Invoice add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Invoice_AUD_trig 
before insert or update on BC_Invoice 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Location_seq ; 
create sequence BC_Location_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Location_PK_trig 
before insert on BC_Location
for each row 
begin 
select BC_Location_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Location add dflex date ; 
alter table BC_Location add iflex1 integer ; 
alter table BC_Location add iflex2 integer ; 
alter table BC_Location add vflex1 VARCHAR2 (4000) ; 
alter table BC_Location add vflex2 VARCHAR2 (4000) ; 
alter table BC_Location add vflex3 VARCHAR2 (4000) ; 
alter table BC_Location add created date ; 
alter table BC_Location add created_by VARCHAR2 (255) ; 
alter table BC_Location add row_version_number integer ; 
alter table BC_Location add updated date ; 
alter table BC_Location add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Location_AUD_trig 
before insert or update on BC_Location 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Note_seq ; 
create sequence BC_Note_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Note_PK_trig 
before insert on BC_Note
for each row 
begin 
select BC_Note_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Note add dflex date ; 
alter table BC_Note add iflex1 integer ; 
alter table BC_Note add iflex2 integer ; 
alter table BC_Note add vflex1 VARCHAR2 (4000) ; 
alter table BC_Note add vflex2 VARCHAR2 (4000) ; 
alter table BC_Note add vflex3 VARCHAR2 (4000) ; 
alter table BC_Note add created date ; 
alter table BC_Note add created_by VARCHAR2 (255) ; 
alter table BC_Note add row_version_number integer ; 
alter table BC_Note add updated date ; 
alter table BC_Note add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Note_AUD_trig 
before insert or update on BC_Note 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Party_seq ; 
create sequence BC_Party_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Party_PK_trig 
before insert on BC_Party
for each row 
begin 
select BC_Party_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Party add dflex date ; 
alter table BC_Party add iflex1 integer ; 
alter table BC_Party add iflex2 integer ; 
alter table BC_Party add vflex1 VARCHAR2 (4000) ; 
alter table BC_Party add vflex2 VARCHAR2 (4000) ; 
alter table BC_Party add vflex3 VARCHAR2 (4000) ; 
alter table BC_Party add created date ; 
alter table BC_Party add created_by VARCHAR2 (255) ; 
alter table BC_Party add row_version_number integer ; 
alter table BC_Party add updated date ; 
alter table BC_Party add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Party_AUD_trig 
before insert or update on BC_Party 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Payment_seq ; 
create sequence BC_Payment_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Payment_PK_trig 
before insert on BC_Payment
for each row 
begin 
select BC_Payment_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Payment add dflex date ; 
alter table BC_Payment add iflex1 integer ; 
alter table BC_Payment add iflex2 integer ; 
alter table BC_Payment add vflex1 VARCHAR2 (4000) ; 
alter table BC_Payment add vflex2 VARCHAR2 (4000) ; 
alter table BC_Payment add vflex3 VARCHAR2 (4000) ; 
alter table BC_Payment add created date ; 
alter table BC_Payment add created_by VARCHAR2 (255) ; 
alter table BC_Payment add row_version_number integer ; 
alter table BC_Payment add updated date ; 
alter table BC_Payment add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Payment_AUD_trig 
before insert or update on BC_Payment 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Receving_Log_seq ; 
create sequence BC_Receving_Log_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Receving_Log_PK_trig 
before insert on BC_Receving_Log
for each row 
begin 
select BC_Receving_Log_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Receving_Log add dflex date ; 
alter table BC_Receving_Log add iflex1 integer ; 
alter table BC_Receving_Log add iflex2 integer ; 
alter table BC_Receving_Log add vflex1 VARCHAR2 (4000) ; 
alter table BC_Receving_Log add vflex2 VARCHAR2 (4000) ; 
alter table BC_Receving_Log add vflex3 VARCHAR2 (4000) ; 
alter table BC_Receving_Log add created date ; 
alter table BC_Receving_Log add created_by VARCHAR2 (255) ; 
alter table BC_Receving_Log add row_version_number integer ; 
alter table BC_Receving_Log add updated date ; 
alter table BC_Receving_Log add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Receving_Log_AUD_trig 
before insert or update on BC_Receving_Log 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP SEQUENCE BC_Vendor_seq ; 
create sequence BC_Vendor_seq 
start with 100 
increment by 1 
nomaxvalue 
;

create or replace trigger BC_Vendor_PK_trig 
before insert on BC_Vendor
for each row 
begin 
select BC_Vendor_seq.nextval into :new.id from dual; 
end; 
/
alter table BC_Vendor add dflex date ; 
alter table BC_Vendor add iflex1 integer ; 
alter table BC_Vendor add iflex2 integer ; 
alter table BC_Vendor add vflex1 VARCHAR2 (4000) ; 
alter table BC_Vendor add vflex2 VARCHAR2 (4000) ; 
alter table BC_Vendor add vflex3 VARCHAR2 (4000) ; 
alter table BC_Vendor add created date ; 
alter table BC_Vendor add created_by VARCHAR2 (255) ; 
alter table BC_Vendor add row_version_number integer ; 
alter table BC_Vendor add updated date ; 
alter table BC_Vendor add updated_by VARCHAR2 (255) ; 
/
create or replace trigger BC_Vendor_AUD_trig 
before insert or update on BC_Vendor 
for each row 
begin 
  if inserting then 
    :new.created := localtimestamp; 
    :new.created_by := nvl(wwv_flow.g_user,user); 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
    :new.row_version_number := 1; 
  elsif updating then 
    :new.row_version_number := nvl(:old.row_version_number,1) + 1; 
  end if; 
  if inserting or updating then 
    :new.updated := localtimestamp; 
    :new.updated_by := nvl(wwv_flow.g_user,user); 
  end if; 
end; 
/

DROP INDEX Contract_id_FK_0 ;
CREATE INDEX Contract_id_FK_0 ON BC_Amendment(Contract_id) ;
DROP INDEX Department_id_FK_1 ;
CREATE INDEX Department_id_FK_1 ON BC_Amendment(Department_id) ;
DROP INDEX Contract_id_FK_2 ;
CREATE INDEX Contract_id_FK_2 ON BC_Contact_Log(Contract_id) ;
DROP INDEX Party_id_FK_3 ;
CREATE INDEX Party_id_FK_3 ON BC_Contact_Log(Party_id) ;
DROP INDEX Vendor_id_FK_4 ;
CREATE INDEX Vendor_id_FK_4 ON BC_Contract(Vendor_id) ;
DROP INDEX Location_id_FK_5 ;
CREATE INDEX Location_id_FK_5 ON BC_Department(Location_id) ;
DROP INDEX Amendment_id_FK_6 ;
CREATE INDEX Amendment_id_FK_6 ON BC_Document(Amendment_id) ;
DROP INDEX Contract_id_FK_7 ;
CREATE INDEX Contract_id_FK_7 ON BC_Document(Contract_id) ;
DROP INDEX Amendment_id_FK_8 ;
CREATE INDEX Amendment_id_FK_8 ON BC_Escalation(Amendment_id) ;
DROP INDEX Contract_id_FK_9 ;
CREATE INDEX Contract_id_FK_9 ON BC_Invoice(Contract_id) ;
DROP INDEX Amendment_id_FK_10 ;
CREATE INDEX Amendment_id_FK_10 ON BC_Location(Amendment_id) ;
DROP INDEX Amendment_id_FK_11 ;
CREATE INDEX Amendment_id_FK_11 ON BC_Note(Amendment_id) ;
DROP INDEX Contact_Log_id_FK_12 ;
CREATE INDEX Contact_Log_id_FK_12 ON BC_Note(Contact_Log_id) ;
DROP INDEX Contract_id_FK_13 ;
CREATE INDEX Contract_id_FK_13 ON BC_Note(Contract_id) ;
DROP INDEX Vendor_id_FK_14 ;
CREATE INDEX Vendor_id_FK_14 ON BC_Party(Vendor_id) ;
DROP INDEX Invoice_id_FK_15 ;
CREATE INDEX Invoice_id_FK_15 ON BC_Payment(Invoice_id) ;
DROP INDEX Contract_id_FK_16 ;
CREATE INDEX Contract_id_FK_16 ON BC_Receving_Log(Contract_id) ;
DROP INDEX Party_id_FK_17 ;
CREATE INDEX Party_id_FK_17 ON BC_Vendor(Party_id) ;