72: party_role_txt okc_rep_imp_parties_t.party_role_txt%type );
73:
74: TYPE contract_parties_tbl_type IS TABLE OF contract_parties_rec_type INDEX BY PLS_INTEGER;
75:
76: TYPE party_contacts_rec_type IS RECORD (--run_id okc_rep_imp_contacts_t.run_id%TYPE ,
77: -- imp_contact_id okc_rep_imp_contacts_t.imp_contact_id%TYPE
78: -- imp_party_id okc_rep_imp_contacts_t.imp_party_id%TYPE
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
73:
74: TYPE contract_parties_tbl_type IS TABLE OF contract_parties_rec_type INDEX BY PLS_INTEGER;
75:
76: TYPE party_contacts_rec_type IS RECORD (--run_id okc_rep_imp_contacts_t.run_id%TYPE ,
77: -- imp_contact_id okc_rep_imp_contacts_t.imp_contact_id%TYPE
78: -- imp_party_id okc_rep_imp_contacts_t.imp_party_id%TYPE
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
74: TYPE contract_parties_tbl_type IS TABLE OF contract_parties_rec_type INDEX BY PLS_INTEGER;
75:
76: TYPE party_contacts_rec_type IS RECORD (--run_id okc_rep_imp_contacts_t.run_id%TYPE ,
77: -- imp_contact_id okc_rep_imp_contacts_t.imp_contact_id%TYPE
78: -- imp_party_id okc_rep_imp_contacts_t.imp_party_id%TYPE
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
75:
76: TYPE party_contacts_rec_type IS RECORD (--run_id okc_rep_imp_contacts_t.run_id%TYPE ,
77: -- imp_contact_id okc_rep_imp_contacts_t.imp_contact_id%TYPE
78: -- imp_party_id okc_rep_imp_contacts_t.imp_party_id%TYPE
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
76: TYPE party_contacts_rec_type IS RECORD (--run_id okc_rep_imp_contacts_t.run_id%TYPE ,
77: -- imp_contact_id okc_rep_imp_contacts_t.imp_contact_id%TYPE
78: -- imp_party_id okc_rep_imp_contacts_t.imp_party_id%TYPE
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
84: contact_id okc_rep_imp_contacts_t.contact_id%TYPE ,
77: -- imp_contact_id okc_rep_imp_contacts_t.imp_contact_id%TYPE
78: -- imp_party_id okc_rep_imp_contacts_t.imp_party_id%TYPE
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
84: contact_id okc_rep_imp_contacts_t.contact_id%TYPE ,
85: contact_name_txt okc_rep_imp_contacts_t.contact_name%TYPE ,
78: -- imp_party_id okc_rep_imp_contacts_t.imp_party_id%TYPE
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
84: contact_id okc_rep_imp_contacts_t.contact_id%TYPE ,
85: contact_name_txt okc_rep_imp_contacts_t.contact_name%TYPE ,
86: contact_role_txt okc_rep_imp_contacts_t.contact_role_txt%TYPE );
79: -- imp_contract_id okc_rep_imp_contacts_t.imp_contract_id%TYPE ,
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
84: contact_id okc_rep_imp_contacts_t.contact_id%TYPE ,
85: contact_name_txt okc_rep_imp_contacts_t.contact_name%TYPE ,
86: contact_role_txt okc_rep_imp_contacts_t.contact_role_txt%TYPE );
87:
80: contract_id okc_rep_imp_contacts_t.contact_id%TYPE ,
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
84: contact_id okc_rep_imp_contacts_t.contact_id%TYPE ,
85: contact_name_txt okc_rep_imp_contacts_t.contact_name%TYPE ,
86: contact_role_txt okc_rep_imp_contacts_t.contact_role_txt%TYPE );
87:
88: TYPE party_contacts_tbl_type IS TABLE OF party_contacts_rec_type INDEX BY PLS_INTEGER;
81: contact_index okc_rep_imp_contacts_t.contact_index%TYPE ,
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
84: contact_id okc_rep_imp_contacts_t.contact_id%TYPE ,
85: contact_name_txt okc_rep_imp_contacts_t.contact_name%TYPE ,
86: contact_role_txt okc_rep_imp_contacts_t.contact_role_txt%TYPE );
87:
88: TYPE party_contacts_tbl_type IS TABLE OF party_contacts_rec_type INDEX BY PLS_INTEGER;
89:
82: party_role_txt okc_rep_imp_contacts_t.party_role_txt%TYPE ,
83: party_name_txt okc_rep_imp_contacts_t.party_name_txt%TYPE ,
84: contact_id okc_rep_imp_contacts_t.contact_id%TYPE ,
85: contact_name_txt okc_rep_imp_contacts_t.contact_name%TYPE ,
86: contact_role_txt okc_rep_imp_contacts_t.contact_role_txt%TYPE );
87:
88: TYPE party_contacts_tbl_type IS TABLE OF party_contacts_rec_type INDEX BY PLS_INTEGER;
89:
90: TYPE contract_risks_rec_type IS RECORD (--run_id okc_rep_imp_risks_t.run_id%TYPE ,