[Home] [Help]
PACKAGE: APPS.OKC_IMP_RECORD_TYPES
Source
1 PACKAGE OKC_IMP_RECORD_TYPES AUTHID CURRENT_USER AS
2 /* $Header: OKCPIRECTS.pls 120.0.12020000.2 2013/03/02 06:24:51 kkolukul noship $ */
3
4 TYPE contract_rec_type IS RECORD (contract_id OKC_REP_IMP_CONTRACTS_T.imp_contract_id%TYPE ,
5 contract_number OKC_REP_IMP_CONTRACTS_T.contract_number%TYPE ,
6 contract_name OKC_REP_IMP_CONTRACTS_T.contract_name%TYPE ,
7 contract_version_num OKC_REP_IMP_CONTRACTS_T.contract_version_num%TYPE ,
8 description OKC_REP_IMP_CONTRACTS_T.description%TYPE ,
9 --contract_type OKC_REP_IMP_CONTRACTS_T.contract_type%TYPE ,
10 contract_type_txt OKC_REP_IMP_CONTRACTS_T.contract_type_txt%TYPE ,
11 authoring_party_txt OKC_REP_IMP_CONTRACTS_T.authoring_party_txt%TYPE ,
12 contract_status_txt OKC_REP_IMP_CONTRACTS_T.contract_status_txt%TYPE ,
13 version_comments OKC_REP_IMP_CONTRACTS_T.version_comments%TYPE ,
14 contract_effective_date OKC_REP_IMP_CONTRACTS_T.contract_effective_date%TYPE ,
15 contract_expiration_date OKC_REP_IMP_CONTRACTS_T.contract_expiration_date%TYPE ,
16 currency_code OKC_REP_IMP_CONTRACTS_T.currency_code%TYPE ,
17 contract_amount OKC_REP_IMP_CONTRACTS_T.contract_amount%TYPE ,
18 org_name OKC_REP_IMP_CONTRACTS_T.org_name%TYPE ,
19 owner_user_name OKC_REP_IMP_CONTRACTS_T.owner_user_name%TYPE ,
20 keywords OKC_REP_IMP_CONTRACTS_T.keywords%TYPE ,
21 physical_location OKC_REP_IMP_CONTRACTS_T.physical_location%TYPE ,
22 orig_system_reference_code OKC_REP_IMP_CONTRACTS_T.orig_system_reference_code%TYPE ,
23 orig_system_reference_id1 OKC_REP_IMP_CONTRACTS_T.orig_system_reference_id1%TYPE ,
24 orig_system_reference_id2 OKC_REP_IMP_CONTRACTS_T.orig_system_reference_id2%TYPE ,
25 creation_date OKC_REP_IMP_CONTRACTS_T.creation_date%TYPE ,
26 latest_signed_ver_number OKC_REP_IMP_CONTRACTS_T.latest_signed_ver_number%TYPE ,
27 overall_risk_txt OKC_REP_IMP_CONTRACTS_T.overall_risk_txt%TYPE ,
28 cancellation_comments OKC_REP_IMP_CONTRACTS_T.cancellation_comments%TYPE ,
29 cancellation_date OKC_REP_IMP_CONTRACTS_T.cancellation_date%TYPE ,
30 termination_comments OKC_REP_IMP_CONTRACTS_T.termination_comments%TYPE ,
31 termination_date OKC_REP_IMP_CONTRACTS_T.termination_date%TYPE ,
32 expire_ntf_flag OKC_REP_IMP_CONTRACTS_T.expire_ntf_flag%TYPE ,
33 expire_ntf_period OKC_REP_IMP_CONTRACTS_T.expire_ntf_period%TYPE ,
34 notify_contact_role_id OKC_REP_IMP_CONTRACTS_T.notify_contact_role_id%TYPE ,
35 notify_contact_role_txt OKC_REP_IMP_CONTRACTS_T.notify_contact_role_txt%TYPE ,
36 attribute_category OKC_REP_IMP_CONTRACTS_T.attribute_category%TYPE ,
37 attribute1 OKC_REP_IMP_CONTRACTS_T.attribute1%TYPE ,
38 attribute2 OKC_REP_IMP_CONTRACTS_T.attribute2%TYPE ,
39 attribute3 OKC_REP_IMP_CONTRACTS_T.attribute3%TYPE ,
40 attribute4 OKC_REP_IMP_CONTRACTS_T.attribute4%TYPE ,
41 attribute5 OKC_REP_IMP_CONTRACTS_T.attribute5%TYPE ,
42 attribute6 OKC_REP_IMP_CONTRACTS_T.attribute6%TYPE ,
43 attribute7 OKC_REP_IMP_CONTRACTS_T.attribute7%TYPE ,
44 attribute8 OKC_REP_IMP_CONTRACTS_T.attribute8%TYPE ,
45 attribute9 OKC_REP_IMP_CONTRACTS_T.attribute9%TYPE ,
46 attribute10 OKC_REP_IMP_CONTRACTS_T.attribute10%TYPE ,
47 attribute11 OKC_REP_IMP_CONTRACTS_T.attribute11%TYPE ,
48 attribute12 OKC_REP_IMP_CONTRACTS_T.attribute12%TYPE ,
49 attribute13 OKC_REP_IMP_CONTRACTS_T.attribute13%TYPE ,
50 attribute14 OKC_REP_IMP_CONTRACTS_T.attribute14%TYPE ,
51 attribute15 OKC_REP_IMP_CONTRACTS_T.attribute15%TYPE ,
52 reference_document_type OKC_REP_IMP_CONTRACTS_T.reference_document_type%TYPE ,
53 reference_document_number OKC_REP_IMP_CONTRACTS_T.reference_document_number%TYPE ,
54 reference_document_id OKC_REP_IMP_CONTRACTS_T.reference_document_id%TYPE ,
55 run_id OKC_REP_IMP_CONTRACTS_T.run_id%TYPE ,
56 source_code OKC_REP_IMP_CONTRACTS_T.source_code%TYPE ,
57 contract_type OKC_REP_IMP_CONTRACTS_T.contract_type%TYPE ,
58 valid_flag OKC_REP_IMP_CONTRACTS_T.valid_flag%TYPE,
59 sbcr_coordination_type OKC_REP_CONTRACTS_ALL.sbcr_coordination_type%TYPE,
60 contract_status_code OKC_REP_IMP_CONTRACTS_T.contract_status_code%TYPE
61 );
62
63 TYPE contract_tbl_type IS TABLE OF contract_rec_type INDEX BY PLS_INTEGER;
64
65 TYPE contract_parties_rec_type IS RECORD (--run_id okc_rep_imp_parties_t.run_id%type ,
66 -- imp_party_id okc_rep_imp_parties_t.imp_party_id%TYPE
67 -- imp_contract_id okc_rep_imp_parties_t.imp_contract_id%TYPE ,
68 party_index okc_rep_imp_parties_t.party_index%type ,
69 signed_by_txt okc_rep_imp_parties_t.signed_by_txt%type ,
70 signed_date okc_rep_imp_parties_t.signed_date%type ,
71 party_name_txt okc_rep_imp_parties_t.party_name_txt%type ,
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 ,
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
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 ,
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
107 TYPE document_rec_type IS RECORD ( business_document_type okc_rep_contract_usages.business_document_type%TYPE ,
108 business_document_id okc_rep_contract_usages.business_document_id%TYPE ,
109 business_document_version okc_rep_contract_usages.business_document_version%TYPE ,
110 document_number okc_rep_contract_usages.document_number%TYPE ,
111 pk1_value okc_rep_contract_usages.pk1_value%TYPE ,
112 pk2_value okc_rep_contract_usages.pk2_value%TYPE ,
113 pk3_value okc_rep_contract_usages.pk3_value%TYPE ,
114 pk4_value okc_rep_contract_usages.pk4_value%TYPE ,
115 pk5_value okc_rep_contract_usages.pk5_value%TYPE ,
116 source_code okc_rep_contract_usages.source_code%TYPE ,
117 relationship_id okc_rep_contract_usages.relationship_id%TYPE ,
118 display_in_contract okc_rep_contract_usages.display_in_contract%TYPE
119 );
120
121 END OKC_IMP_RECORD_TYPES;