18: -- SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
19: -- SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
20:
21: TYPE deal_rec_type is record (
22: chr_id okl_k_headers_full_v.id%type
23: ,chr_contract_number okl_k_headers_full_v.contract_number%type
24: ,chr_description okl_k_headers_full_v.description%type
25: ,vers_version VARCHAR2(30)
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
19: -- SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
20:
21: TYPE deal_rec_type is record (
22: chr_id okl_k_headers_full_v.id%type
23: ,chr_contract_number okl_k_headers_full_v.contract_number%type
24: ,chr_description okl_k_headers_full_v.description%type
25: ,vers_version VARCHAR2(30)
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
20:
21: TYPE deal_rec_type is record (
22: chr_id okl_k_headers_full_v.id%type
23: ,chr_contract_number okl_k_headers_full_v.contract_number%type
24: ,chr_description okl_k_headers_full_v.description%type
25: ,vers_version VARCHAR2(30)
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
22: chr_id okl_k_headers_full_v.id%type
23: ,chr_contract_number okl_k_headers_full_v.contract_number%type
24: ,chr_description okl_k_headers_full_v.description%type
25: ,vers_version VARCHAR2(30)
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
23: ,chr_contract_number okl_k_headers_full_v.contract_number%type
24: ,chr_description okl_k_headers_full_v.description%type
25: ,vers_version VARCHAR2(30)
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
24: ,chr_description okl_k_headers_full_v.description%type
25: ,vers_version VARCHAR2(30)
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
25: ,vers_version VARCHAR2(30)
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
26: ,chr_sts_code okl_k_headers_full_v.sts_code%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
27: ,chr_start_date okl_k_headers_full_v.start_date%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
28: ,chr_end_date okl_k_headers_full_v.end_date%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
29: ,khr_term_duration okl_k_headers_full_v.term_duration%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
30: ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
31: ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
32: ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
33: ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
34: ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
35: ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
36: ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
37: ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45: ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
38: ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45: ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
46: ,mla_contract_number okl_k_headers_full_v.contract_number%type
39: ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45: ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
46: ,mla_contract_number okl_k_headers_full_v.contract_number%type
47: ,mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type
40: ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45: ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
46: ,mla_contract_number okl_k_headers_full_v.contract_number%type
47: ,mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type
48: ,mla_gvr_id okl_k_headers_full_v.id%type
41: ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45: ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
46: ,mla_contract_number okl_k_headers_full_v.contract_number%type
47: ,mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type
48: ,mla_gvr_id okl_k_headers_full_v.id%type
49: ,cust_id okc_k_party_roles_v.id%type
42: ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43: ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45: ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
46: ,mla_contract_number okl_k_headers_full_v.contract_number%type
47: ,mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type
48: ,mla_gvr_id okl_k_headers_full_v.id%type
49: ,cust_id okc_k_party_roles_v.id%type
50: ,cust_object1_id1 okc_k_party_roles_v.object1_id1%type
44: ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45: ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
46: ,mla_contract_number okl_k_headers_full_v.contract_number%type
47: ,mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type
48: ,mla_gvr_id okl_k_headers_full_v.id%type
49: ,cust_id okc_k_party_roles_v.id%type
50: ,cust_object1_id1 okc_k_party_roles_v.object1_id1%type
51: ,cust_object1_id2 okc_k_party_roles_v.object1_id2%type
52: ,cust_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type
55: ,lessor_object1_id1 okc_k_party_roles_v.object1_id1%type
56: ,lessor_object1_id2 okc_k_party_roles_v.object1_id2%type
57: ,lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type
58: ,lessor_name varchar2(250)
59: ,chr_currency_code okl_k_headers_full_v.currency_code%type
60: ,currency_name varchar2(250)
61: ,khr_pdt_id okl_k_headers_full_v.pdt_id%type
62: ,product_name okl_products_v.name%type
63: ,product_description okl_products_v.description%type
57: ,lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type
58: ,lessor_name varchar2(250)
59: ,chr_currency_code okl_k_headers_full_v.currency_code%type
60: ,currency_name varchar2(250)
61: ,khr_pdt_id okl_k_headers_full_v.pdt_id%type
62: ,product_name okl_products_v.name%type
63: ,product_description okl_products_v.description%type
64: ,khr_khr_id okl_k_headers_full_v.khr_id%type
65: ,program_contract_number okl_k_headers_full_v.contract_number%type
60: ,currency_name varchar2(250)
61: ,khr_pdt_id okl_k_headers_full_v.pdt_id%type
62: ,product_name okl_products_v.name%type
63: ,product_description okl_products_v.description%type
64: ,khr_khr_id okl_k_headers_full_v.khr_id%type
65: ,program_contract_number okl_k_headers_full_v.contract_number%type
66: ,cl_contract_number okl_k_headers_full_v.contract_number%type
67: ,cl_gvr_chr_id_referred okl_k_headers_full_v.id%type
68: ,cl_gvr_id okl_k_headers_full_v.id%type
61: ,khr_pdt_id okl_k_headers_full_v.pdt_id%type
62: ,product_name okl_products_v.name%type
63: ,product_description okl_products_v.description%type
64: ,khr_khr_id okl_k_headers_full_v.khr_id%type
65: ,program_contract_number okl_k_headers_full_v.contract_number%type
66: ,cl_contract_number okl_k_headers_full_v.contract_number%type
67: ,cl_gvr_chr_id_referred okl_k_headers_full_v.id%type
68: ,cl_gvr_id okl_k_headers_full_v.id%type
69: ,rg_larles_id okc_rule_groups_v.id%type
62: ,product_name okl_products_v.name%type
63: ,product_description okl_products_v.description%type
64: ,khr_khr_id okl_k_headers_full_v.khr_id%type
65: ,program_contract_number okl_k_headers_full_v.contract_number%type
66: ,cl_contract_number okl_k_headers_full_v.contract_number%type
67: ,cl_gvr_chr_id_referred okl_k_headers_full_v.id%type
68: ,cl_gvr_id okl_k_headers_full_v.id%type
69: ,rg_larles_id okc_rule_groups_v.id%type
70: ,r_larles_id okc_rule_groups_v.id%type
63: ,product_description okl_products_v.description%type
64: ,khr_khr_id okl_k_headers_full_v.khr_id%type
65: ,program_contract_number okl_k_headers_full_v.contract_number%type
66: ,cl_contract_number okl_k_headers_full_v.contract_number%type
67: ,cl_gvr_chr_id_referred okl_k_headers_full_v.id%type
68: ,cl_gvr_id okl_k_headers_full_v.id%type
69: ,rg_larles_id okc_rule_groups_v.id%type
70: ,r_larles_id okc_rule_groups_v.id%type
71: ,r_larles_rule_information1 okc_rules_v.rule_information1%type
64: ,khr_khr_id okl_k_headers_full_v.khr_id%type
65: ,program_contract_number okl_k_headers_full_v.contract_number%type
66: ,cl_contract_number okl_k_headers_full_v.contract_number%type
67: ,cl_gvr_chr_id_referred okl_k_headers_full_v.id%type
68: ,cl_gvr_id okl_k_headers_full_v.id%type
69: ,rg_larles_id okc_rule_groups_v.id%type
70: ,r_larles_id okc_rule_groups_v.id%type
71: ,r_larles_rule_information1 okc_rules_v.rule_information1%type
72: ,col_larles_form_left_prompt varchar2(250)
97: ,rg_LAPACT_id okc_rule_groups_v.id%type
98: ,r_LAPACT_id okc_rule_groups_v.id%type
99: ,r_LAPACT_rule_information1 okc_rules_v.rule_information1%type
100: ,col_lapact_form_left_prompt varchar2(250)
101: ,khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type
102: ,khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type
103: ,khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type
104: ,khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type
105: --Added by dpsingh for LE Uptake
98: ,r_LAPACT_id okc_rule_groups_v.id%type
99: ,r_LAPACT_rule_information1 okc_rules_v.rule_information1%type
100: ,col_lapact_form_left_prompt varchar2(250)
101: ,khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type
102: ,khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type
103: ,khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type
104: ,khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type
105: --Added by dpsingh for LE Uptake
106: ,legal_entity_id NUMBER
99: ,r_LAPACT_rule_information1 okc_rules_v.rule_information1%type
100: ,col_lapact_form_left_prompt varchar2(250)
101: ,khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type
102: ,khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type
103: ,khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type
104: ,khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type
105: --Added by dpsingh for LE Uptake
106: ,legal_entity_id NUMBER
107: -- sjalasut, added attribute columns below for okl_k_headers. START code changes
100: ,col_lapact_form_left_prompt varchar2(250)
101: ,khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type
102: ,khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type
103: ,khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type
104: ,khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type
105: --Added by dpsingh for LE Uptake
106: ,legal_entity_id NUMBER
107: -- sjalasut, added attribute columns below for okl_k_headers. START code changes
108: ,attribute_category okl_k_headers.attribute_category%TYPE
103: ,khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type
104: ,khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type
105: --Added by dpsingh for LE Uptake
106: ,legal_entity_id NUMBER
107: -- sjalasut, added attribute columns below for okl_k_headers. START code changes
108: ,attribute_category okl_k_headers.attribute_category%TYPE
109: ,attribute1 okl_k_headers.attribute1%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
104: ,khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type
105: --Added by dpsingh for LE Uptake
106: ,legal_entity_id NUMBER
107: -- sjalasut, added attribute columns below for okl_k_headers. START code changes
108: ,attribute_category okl_k_headers.attribute_category%TYPE
109: ,attribute1 okl_k_headers.attribute1%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
105: --Added by dpsingh for LE Uptake
106: ,legal_entity_id NUMBER
107: -- sjalasut, added attribute columns below for okl_k_headers. START code changes
108: ,attribute_category okl_k_headers.attribute_category%TYPE
109: ,attribute1 okl_k_headers.attribute1%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
106: ,legal_entity_id NUMBER
107: -- sjalasut, added attribute columns below for okl_k_headers. START code changes
108: ,attribute_category okl_k_headers.attribute_category%TYPE
109: ,attribute1 okl_k_headers.attribute1%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
107: -- sjalasut, added attribute columns below for okl_k_headers. START code changes
108: ,attribute_category okl_k_headers.attribute_category%TYPE
109: ,attribute1 okl_k_headers.attribute1%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
108: ,attribute_category okl_k_headers.attribute_category%TYPE
109: ,attribute1 okl_k_headers.attribute1%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
109: ,attribute1 okl_k_headers.attribute1%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
110: ,attribute2 okl_k_headers.attribute2%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
111: ,attribute3 okl_k_headers.attribute3%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
112: ,attribute4 okl_k_headers.attribute4%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
113: ,attribute5 okl_k_headers.attribute5%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
114: ,attribute6 okl_k_headers.attribute6%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
122: ,attribute14 okl_k_headers.attribute14%TYPE
115: ,attribute7 okl_k_headers.attribute7%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
122: ,attribute14 okl_k_headers.attribute14%TYPE
123: ,attribute15 okl_k_headers.attribute15%TYPE
116: ,attribute8 okl_k_headers.attribute8%TYPE
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
122: ,attribute14 okl_k_headers.attribute14%TYPE
123: ,attribute15 okl_k_headers.attribute15%TYPE
124: -- sjalasut, added attribute columns below for okl_k_headers. END code changes
117: ,attribute9 okl_k_headers.attribute9%TYPE
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
122: ,attribute14 okl_k_headers.attribute14%TYPE
123: ,attribute15 okl_k_headers.attribute15%TYPE
124: -- sjalasut, added attribute columns below for okl_k_headers. END code changes
125: -- ,labill_labacc_billto varchar2(200)
118: ,attribute10 okl_k_headers.attribute10%TYPE
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
122: ,attribute14 okl_k_headers.attribute14%TYPE
123: ,attribute15 okl_k_headers.attribute15%TYPE
124: -- sjalasut, added attribute columns below for okl_k_headers. END code changes
125: -- ,labill_labacc_billto varchar2(200)
126: -- sjalasut, modified the record structure to have labill_labacc_billto data type of as number
119: ,attribute11 okl_k_headers.attribute11%TYPE
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
122: ,attribute14 okl_k_headers.attribute14%TYPE
123: ,attribute15 okl_k_headers.attribute15%TYPE
124: -- sjalasut, added attribute columns below for okl_k_headers. END code changes
125: -- ,labill_labacc_billto varchar2(200)
126: -- sjalasut, modified the record structure to have labill_labacc_billto data type of as number
127: ,labill_labacc_billto number
120: ,attribute12 okl_k_headers.attribute12%TYPE
121: ,attribute13 okl_k_headers.attribute13%TYPE
122: ,attribute14 okl_k_headers.attribute14%TYPE
123: ,attribute15 okl_k_headers.attribute15%TYPE
124: -- sjalasut, added attribute columns below for okl_k_headers. END code changes
125: -- ,labill_labacc_billto varchar2(200)
126: -- sjalasut, modified the record structure to have labill_labacc_billto data type of as number
127: ,labill_labacc_billto number
128: ,labill_labacc_rgp_id okc_rule_groups_b.id%TYPE