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 ,
91: -- imp_contract_id okc_rep_imp_risks_t.imp_contract_id%TYPE ,
92: business_document_type okc_rep_imp_risks_t.business_document_type%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%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 ,
91: -- imp_contract_id okc_rep_imp_risks_t.imp_contract_id%TYPE ,
92: business_document_type okc_rep_imp_risks_t.business_document_type%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
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 ,
91: -- imp_contract_id okc_rep_imp_risks_t.imp_contract_id%TYPE ,
92: business_document_type okc_rep_imp_risks_t.business_document_type%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
89:
90: TYPE contract_risks_rec_type IS RECORD (--run_id okc_rep_imp_risks_t.run_id%TYPE ,
91: -- imp_contract_id okc_rep_imp_risks_t.imp_contract_id%TYPE ,
92: business_document_type okc_rep_imp_risks_t.business_document_type%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
90: TYPE contract_risks_rec_type IS RECORD (--run_id okc_rep_imp_risks_t.run_id%TYPE ,
91: -- imp_contract_id okc_rep_imp_risks_t.imp_contract_id%TYPE ,
92: business_document_type okc_rep_imp_risks_t.business_document_type%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
91: -- imp_contract_id okc_rep_imp_risks_t.imp_contract_id%TYPE ,
92: business_document_type okc_rep_imp_risks_t.business_document_type%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
92: business_document_type okc_rep_imp_risks_t.business_document_type%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
100: risk_occured_YN okc_rep_imp_risks_t.risk_occured_YN%TYPE ,
93: business_document_id okc_rep_imp_risks_t.business_document_id%TYPE ,
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
100: risk_occured_YN okc_rep_imp_risks_t.risk_occured_YN%TYPE ,
101: risk_occurence_date okc_rep_imp_risks_t.risk_occurence_date%TYPE
94: business_document_version okc_rep_imp_risks_t.business_document_version%TYPE ,
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
100: risk_occured_YN okc_rep_imp_risks_t.risk_occured_YN%TYPE ,
101: risk_occurence_date okc_rep_imp_risks_t.risk_occurence_date%TYPE
102: --created_by okc_rep_imp_risks_t.created_by%TYPE
95: risk_index okc_rep_imp_risks_t.risk_index%TYPE ,
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
100: risk_occured_YN okc_rep_imp_risks_t.risk_occured_YN%TYPE ,
101: risk_occurence_date okc_rep_imp_risks_t.risk_occurence_date%TYPE
102: --created_by okc_rep_imp_risks_t.created_by%TYPE
103: );
96: risk_event_txt okc_rep_imp_risks_t.risk_event_txt%TYPE ,
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
100: risk_occured_YN okc_rep_imp_risks_t.risk_occured_YN%TYPE ,
101: risk_occurence_date okc_rep_imp_risks_t.risk_occurence_date%TYPE
102: --created_by okc_rep_imp_risks_t.created_by%TYPE
103: );
104:
97: probability_txt okc_rep_imp_risks_t.probability_txt%TYPE ,
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
100: risk_occured_YN okc_rep_imp_risks_t.risk_occured_YN%TYPE ,
101: risk_occurence_date okc_rep_imp_risks_t.risk_occurence_date%TYPE
102: --created_by okc_rep_imp_risks_t.created_by%TYPE
103: );
104:
105: TYPE contract_risks_tbl_type IS TABLE OF contract_risks_rec_type INDEX BY PLS_INTEGER;
98: risk_impact_txt okc_rep_imp_risks_t.risk_impact_txt%TYPE ,
99: risk_comments okc_rep_imp_risks_t.risk_comments%TYPE ,
100: risk_occured_YN okc_rep_imp_risks_t.risk_occured_YN%TYPE ,
101: risk_occurence_date okc_rep_imp_risks_t.risk_occurence_date%TYPE
102: --created_by okc_rep_imp_risks_t.created_by%TYPE
103: );
104:
105: TYPE contract_risks_tbl_type IS TABLE OF contract_risks_rec_type INDEX BY PLS_INTEGER;
106: