[Home] [Help]
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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,
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,
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
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: );
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:
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: