16: ---------------------------------------------------------------------------
17:
18:
19: TYPE deal_rec_type is record (
20: chr_id okl_k_headers_full_v.id%type,
21: chr_contract_number okl_k_headers_full_v.contract_number%type,
22: chr_description okl_k_headers_full_v.description%type,
23: vers_version VARCHAR2(30),
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
17:
18:
19: TYPE deal_rec_type is record (
20: chr_id okl_k_headers_full_v.id%type,
21: chr_contract_number okl_k_headers_full_v.contract_number%type,
22: chr_description okl_k_headers_full_v.description%type,
23: vers_version VARCHAR2(30),
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
18:
19: TYPE deal_rec_type is record (
20: chr_id okl_k_headers_full_v.id%type,
21: chr_contract_number okl_k_headers_full_v.contract_number%type,
22: chr_description okl_k_headers_full_v.description%type,
23: vers_version VARCHAR2(30),
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
20: chr_id okl_k_headers_full_v.id%type,
21: chr_contract_number okl_k_headers_full_v.contract_number%type,
22: chr_description okl_k_headers_full_v.description%type,
23: vers_version VARCHAR2(30),
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
21: chr_contract_number okl_k_headers_full_v.contract_number%type,
22: chr_description okl_k_headers_full_v.description%type,
23: vers_version VARCHAR2(30),
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
22: chr_description okl_k_headers_full_v.description%type,
23: vers_version VARCHAR2(30),
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
23: vers_version VARCHAR2(30),
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
24: chr_sts_code okl_k_headers_full_v.sts_code%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
25: chr_start_date okl_k_headers_full_v.start_date%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
26: chr_end_date okl_k_headers_full_v.end_date%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
27: khr_term_duration okl_k_headers_full_v.term_duration%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
28: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
29: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
30: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
31: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
32: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
33: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
34: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
35: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
36: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
44: mla_contract_number okl_k_headers_full_v.contract_number%type,
37: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
44: mla_contract_number okl_k_headers_full_v.contract_number%type,
45: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
38: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
44: mla_contract_number okl_k_headers_full_v.contract_number%type,
45: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
46: mla_gvr_id okl_k_headers_full_v.id%type,
39: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
44: mla_contract_number okl_k_headers_full_v.contract_number%type,
45: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
46: mla_gvr_id okl_k_headers_full_v.id%type,
47: cust_id okc_k_party_roles_v.id%type,
40: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
44: mla_contract_number okl_k_headers_full_v.contract_number%type,
45: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
46: mla_gvr_id okl_k_headers_full_v.id%type,
47: cust_id okc_k_party_roles_v.id%type,
48: cust_object1_id1 okc_k_party_roles_v.object1_id1%type,
42: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
44: mla_contract_number okl_k_headers_full_v.contract_number%type,
45: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
46: mla_gvr_id okl_k_headers_full_v.id%type,
47: cust_id okc_k_party_roles_v.id%type,
48: cust_object1_id1 okc_k_party_roles_v.object1_id1%type,
49: cust_object1_id2 okc_k_party_roles_v.object1_id2%type,
50: cust_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
53: lessor_object1_id1 okc_k_party_roles_v.object1_id1%type,
54: lessor_object1_id2 okc_k_party_roles_v.object1_id2%type,
55: lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
56: lessor_name varchar2(250),
57: chr_currency_code okl_k_headers_full_v.currency_code%type,
58: currency_name varchar2(250),
59: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
60: product_name okl_products_v.name%type,
61: product_description okl_products_v.description%type,
55: lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
56: lessor_name varchar2(250),
57: chr_currency_code okl_k_headers_full_v.currency_code%type,
58: currency_name varchar2(250),
59: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
60: product_name okl_products_v.name%type,
61: product_description okl_products_v.description%type,
62: khr_khr_id okl_k_headers_full_v.khr_id%type,
63: program_contract_number okl_k_headers_full_v.contract_number%type,
58: currency_name varchar2(250),
59: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
60: product_name okl_products_v.name%type,
61: product_description okl_products_v.description%type,
62: khr_khr_id okl_k_headers_full_v.khr_id%type,
63: program_contract_number okl_k_headers_full_v.contract_number%type,
64: cl_contract_number okl_k_headers_full_v.contract_number%type,
65: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
66: cl_gvr_id okl_k_headers_full_v.id%type,
59: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
60: product_name okl_products_v.name%type,
61: product_description okl_products_v.description%type,
62: khr_khr_id okl_k_headers_full_v.khr_id%type,
63: program_contract_number okl_k_headers_full_v.contract_number%type,
64: cl_contract_number okl_k_headers_full_v.contract_number%type,
65: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
66: cl_gvr_id okl_k_headers_full_v.id%type,
67: rg_larles_id okc_rule_groups_v.id%type,
60: product_name okl_products_v.name%type,
61: product_description okl_products_v.description%type,
62: khr_khr_id okl_k_headers_full_v.khr_id%type,
63: program_contract_number okl_k_headers_full_v.contract_number%type,
64: cl_contract_number okl_k_headers_full_v.contract_number%type,
65: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
66: cl_gvr_id okl_k_headers_full_v.id%type,
67: rg_larles_id okc_rule_groups_v.id%type,
68: r_larles_id okc_rule_groups_v.id%type,
61: product_description okl_products_v.description%type,
62: khr_khr_id okl_k_headers_full_v.khr_id%type,
63: program_contract_number okl_k_headers_full_v.contract_number%type,
64: cl_contract_number okl_k_headers_full_v.contract_number%type,
65: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
66: cl_gvr_id okl_k_headers_full_v.id%type,
67: rg_larles_id okc_rule_groups_v.id%type,
68: r_larles_id okc_rule_groups_v.id%type,
69: r_larles_rule_information1 okc_rules_v.rule_information1%type,
62: khr_khr_id okl_k_headers_full_v.khr_id%type,
63: program_contract_number okl_k_headers_full_v.contract_number%type,
64: cl_contract_number okl_k_headers_full_v.contract_number%type,
65: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
66: cl_gvr_id okl_k_headers_full_v.id%type,
67: rg_larles_id okc_rule_groups_v.id%type,
68: r_larles_id okc_rule_groups_v.id%type,
69: r_larles_rule_information1 okc_rules_v.rule_information1%type,
70: col_larles_form_left_prompt varchar2(250),
95: rg_LAPACT_id okc_rule_groups_v.id%type,
96: r_LAPACT_id okc_rule_groups_v.id%type,
97: r_LAPACT_rule_information1 okc_rules_v.rule_information1%type,
98: col_lapact_form_left_prompt varchar2(250),
99: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
100: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
101: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
102: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
103: legal_entity_id NUMBER
96: r_LAPACT_id okc_rule_groups_v.id%type,
97: r_LAPACT_rule_information1 okc_rules_v.rule_information1%type,
98: col_lapact_form_left_prompt varchar2(250),
99: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
100: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
101: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
102: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
103: legal_entity_id NUMBER
104: );
97: r_LAPACT_rule_information1 okc_rules_v.rule_information1%type,
98: col_lapact_form_left_prompt varchar2(250),
99: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
100: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
101: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
102: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
103: legal_entity_id NUMBER
104: );
105:
98: col_lapact_form_left_prompt varchar2(250),
99: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
100: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
101: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
102: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
103: legal_entity_id NUMBER
104: );
105:
106: TYPE deal_tab_type is table of deal_rec_type INDEX BY BINARY_INTEGER;
135: TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
136:
137:
138: TYPE upd_deal_rec_type is record (
139: chr_id okl_k_headers_full_v.id%type,
140: chr_contract_number okl_k_headers_full_v.contract_number%type,
141: chr_description okl_k_headers_full_v.description%type,
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
136:
137:
138: TYPE upd_deal_rec_type is record (
139: chr_id okl_k_headers_full_v.id%type,
140: chr_contract_number okl_k_headers_full_v.contract_number%type,
141: chr_description okl_k_headers_full_v.description%type,
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
137:
138: TYPE upd_deal_rec_type is record (
139: chr_id okl_k_headers_full_v.id%type,
140: chr_contract_number okl_k_headers_full_v.contract_number%type,
141: chr_description okl_k_headers_full_v.description%type,
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
138: TYPE upd_deal_rec_type is record (
139: chr_id okl_k_headers_full_v.id%type,
140: chr_contract_number okl_k_headers_full_v.contract_number%type,
141: chr_description okl_k_headers_full_v.description%type,
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
146: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
139: chr_id okl_k_headers_full_v.id%type,
140: chr_contract_number okl_k_headers_full_v.contract_number%type,
141: chr_description okl_k_headers_full_v.description%type,
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
146: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
147: chr_currency_code okl_k_headers_full_v.currency_code%type,
140: chr_contract_number okl_k_headers_full_v.contract_number%type,
141: chr_description okl_k_headers_full_v.description%type,
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
146: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
147: chr_currency_code okl_k_headers_full_v.currency_code%type,
148: legal_entity_id NUMBER
141: chr_description okl_k_headers_full_v.description%type,
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
146: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
147: chr_currency_code okl_k_headers_full_v.currency_code%type,
148: legal_entity_id NUMBER
149: );
142: chr_start_date okl_k_headers_full_v.start_date%type,
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
146: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
147: chr_currency_code okl_k_headers_full_v.currency_code%type,
148: legal_entity_id NUMBER
149: );
150:
143: chr_end_date okl_k_headers_full_v.end_date%type,
144: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
146: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
147: chr_currency_code okl_k_headers_full_v.currency_code%type,
148: legal_entity_id NUMBER
149: );
150:
151: TYPE upd_deal_tab_type is table of upd_deal_rec_type INDEX BY BINARY_INTEGER;