9: SUBTYPE bpe_tbl_type is oks_bpe_pvt.bpe_tbl_type;
10: /*
11: -- OKS_BILLING_PROFILES_V Record Spec
12: TYPE bpev_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,sfwt_flag OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
10: /*
11: -- OKS_BILLING_PROFILES_V Record Spec
12: TYPE bpev_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,sfwt_flag OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
11: -- OKS_BILLING_PROFILES_V Record Spec
12: TYPE bpev_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,sfwt_flag OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
12: TYPE bpev_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,sfwt_flag OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
13: id NUMBER := OKC_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,sfwt_flag OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,sfwt_flag OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
15: ,sfwt_flag OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
16: ,mda_code OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
17: ,owned_party_id1 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
18: ,owned_party_id2 OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
19: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
20: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
21: ,bill_to_address_id1 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_to_address_id2 OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
23: ,uom_code_frequency OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
24: ,tce_code_frequency OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
25: ,uom_code_sec_offset OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,tce_code_sec_offset OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,uom_code_pri_offset OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
28: ,tce_code_pri_offset OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
29: ,profile_number OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
30: ,summarised_yn OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
31: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
32: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
33: ,first_billto_date OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
34: ,first_invoice_date OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
35: ,message OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
36: ,description OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
37: ,instructions OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute_category OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute1 OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute2 OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute3 OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute4 OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute5 OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute6 OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute7 OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute8 OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
47: ,attribute9 OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute10 OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
49: ,attribute11 OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,attribute12 OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
51: ,attribute13 OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute14 OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute15 OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
55: ,creation_date OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
57: ,last_update_date OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: ,invoice_object1_id1 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
67: ,interval OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
60: ,invoice_object1_id2 OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
67: ,interval OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
68: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
61: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
67: ,interval OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
68: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
69: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
62: ,account_object1_id1 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
67: ,interval OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
68: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
69: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
70: G_MISS_bpev_rec bpev_rec_type;
63: ,account_object1_id2 OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
67: ,interval OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
68: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
69: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
70: G_MISS_bpev_rec bpev_rec_type;
71: TYPE bpev_tbl_type IS TABLE OF bpev_rec_type
64: ,account_jtot_object1_code OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
67: ,interval OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
68: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
69: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
70: G_MISS_bpev_rec bpev_rec_type;
71: TYPE bpev_tbl_type IS TABLE OF bpev_rec_type
72: INDEX BY BINARY_INTEGER;
65: ,billing_level OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
66: ,billing_type OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
67: ,interval OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
68: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
69: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
70: G_MISS_bpev_rec bpev_rec_type;
71: TYPE bpev_tbl_type IS TABLE OF bpev_rec_type
72: INDEX BY BINARY_INTEGER;
73: -- OKS_BILLING_PROFILES_B Record Spec
71: TYPE bpev_tbl_type IS TABLE OF bpev_rec_type
72: INDEX BY BINARY_INTEGER;
73: -- OKS_BILLING_PROFILES_B Record Spec
74: TYPE bpe_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,mda_code OKS_BILLING_PROFILES_B.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
77: ,owned_party_id1 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
72: INDEX BY BINARY_INTEGER;
73: -- OKS_BILLING_PROFILES_B Record Spec
74: TYPE bpe_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,mda_code OKS_BILLING_PROFILES_B.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
77: ,owned_party_id1 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
73: -- OKS_BILLING_PROFILES_B Record Spec
74: TYPE bpe_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,mda_code OKS_BILLING_PROFILES_B.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
77: ,owned_party_id1 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
74: TYPE bpe_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,mda_code OKS_BILLING_PROFILES_B.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
77: ,owned_party_id1 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,mda_code OKS_BILLING_PROFILES_B.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
77: ,owned_party_id1 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
76: ,mda_code OKS_BILLING_PROFILES_B.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
77: ,owned_party_id1 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
77: ,owned_party_id1 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
78: ,owned_party_id2 OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
79: ,dependent_cust_acct_id1 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
80: ,dependent_cust_acct_id2 OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
81: ,bill_to_address_id1 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,bill_to_address_id2 OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
83: ,uom_code_frequency OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
84: ,tce_code_frequency OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
85: ,uom_code_sec_offset OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,tce_code_sec_offset OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,uom_code_pri_offset OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
88: ,tce_code_pri_offset OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
89: ,profile_number OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,summarised_yn OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
91: ,reg_invoice_pri_offset NUMBER := OKC_API.G_MISS_NUM
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,reg_invoice_sec_offset NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
93: ,first_billto_date OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
94: ,first_invoice_date OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
95: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
96: ,created_by NUMBER := OKC_API.G_MISS_NUM
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
97: ,creation_date OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
98: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
99: ,last_update_date OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
100: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute_category OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute1 OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute2 OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute3 OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute4 OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute5 OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute6 OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
108: ,attribute7 OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
109: ,attribute8 OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
110: ,attribute9 OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
111: ,attribute10 OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
112: ,attribute11 OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
113: ,attribute12 OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute13 OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute14 OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute15 OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
117: ,invoice_object1_id1 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
125: ,interval OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
118: ,invoice_object1_id2 OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
125: ,interval OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
126: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
119: ,invoice_jtot_object1_code OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
125: ,interval OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
126: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
127: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
120: ,account_object1_id1 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
125: ,interval OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
126: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
127: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
128: G_MISS_bpe_rec bpe_rec_type;
121: ,account_object1_id2 OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
125: ,interval OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
126: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
127: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
128: G_MISS_bpe_rec bpe_rec_type;
129: TYPE bpe_tbl_type IS TABLE OF bpe_rec_type
122: ,account_jtot_object1_code OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
125: ,interval OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
126: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
127: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
128: G_MISS_bpe_rec bpe_rec_type;
129: TYPE bpe_tbl_type IS TABLE OF bpe_rec_type
130: INDEX BY BINARY_INTEGER;
123: ,billing_level OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
124: ,billing_type OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
125: ,interval OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
126: ,interface_offset NUMBER := OKC_API.G_MISS_NUM
127: ,invoice_offset NUMBER := OKC_API.G_MISS_NUM);
128: G_MISS_bpe_rec bpe_rec_type;
129: TYPE bpe_tbl_type IS TABLE OF bpe_rec_type
130: INDEX BY BINARY_INTEGER;
131: */
130: INDEX BY BINARY_INTEGER;
131: */
132: -- OKS_BILLING_PROFILES_TL Record Spec
133: TYPE bpt_rec_type IS RECORD (
134: id NUMBER := OKC_API.G_MISS_NUM
135: ,language OKS_BILLING_PROFILES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
136: ,source_lang OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
131: */
132: -- OKS_BILLING_PROFILES_TL Record Spec
133: TYPE bpt_rec_type IS RECORD (
134: id NUMBER := OKC_API.G_MISS_NUM
135: ,language OKS_BILLING_PROFILES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
136: ,source_lang OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
132: -- OKS_BILLING_PROFILES_TL Record Spec
133: TYPE bpt_rec_type IS RECORD (
134: id NUMBER := OKC_API.G_MISS_NUM
135: ,language OKS_BILLING_PROFILES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
136: ,source_lang OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
133: TYPE bpt_rec_type IS RECORD (
134: id NUMBER := OKC_API.G_MISS_NUM
135: ,language OKS_BILLING_PROFILES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
136: ,source_lang OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
134: id NUMBER := OKC_API.G_MISS_NUM
135: ,language OKS_BILLING_PROFILES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
136: ,source_lang OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
135: ,language OKS_BILLING_PROFILES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
136: ,source_lang OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
136: ,source_lang OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
144: ,last_update_date OKS_BILLING_PROFILES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,sfwt_flag OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
144: ,last_update_date OKS_BILLING_PROFILES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
138: ,description OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
144: ,last_update_date OKS_BILLING_PROFILES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
146: G_MISS_bpt_rec bpt_rec_type;
139: ,instructions OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
144: ,last_update_date OKS_BILLING_PROFILES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
146: G_MISS_bpt_rec bpt_rec_type;
147: TYPE bpt_tbl_type IS TABLE OF bpt_rec_type
140: ,message OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
144: ,last_update_date OKS_BILLING_PROFILES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
146: G_MISS_bpt_rec bpt_rec_type;
147: TYPE bpt_tbl_type IS TABLE OF bpt_rec_type
148: INDEX BY BINARY_INTEGER;
141: ,created_by NUMBER := OKC_API.G_MISS_NUM
142: ,creation_date OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
144: ,last_update_date OKS_BILLING_PROFILES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
146: G_MISS_bpt_rec bpt_rec_type;
147: TYPE bpt_tbl_type IS TABLE OF bpt_rec_type
148: INDEX BY BINARY_INTEGER;
149: ---------------------------------------------------------------------------
148: INDEX BY BINARY_INTEGER;
149: ---------------------------------------------------------------------------
150: -- GLOBAL MESSAGE CONSTANTS
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
149: ---------------------------------------------------------------------------
150: -- GLOBAL MESSAGE CONSTANTS
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
150: -- GLOBAL MESSAGE CONSTANTS
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
152: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
162: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
162: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
163: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
162: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
163: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
164: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
162: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
163: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
164: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
165:
171: ---------------------------------------------------------------------------
172: -- GLOBAL VARIABLES
173: ---------------------------------------------------------------------------
174: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BILLING_PROFILES_PVT';
175: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
176: ---------------------------------------------------------------------------
177: -- Procedures and Functions
178: ---------------------------------------------------------------------------
179:
182: PROCEDURE api_copy;
183: PROCEDURE add_language;
184: PROCEDURE insert_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_bpev_rec IN bpev_rec_type,
190: p_bpev_rec IN bpev_rec_type,
191: x_bpev_rec OUT NOCOPY bpev_rec_type);
192: PROCEDURE insert_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_bpev_tbl IN bpev_tbl_type,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_bpev_tbl IN bpev_tbl_type,
199: x_bpev_tbl OUT NOCOPY bpev_tbl_type,
200: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
201: PROCEDURE insert_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
199: x_bpev_tbl OUT NOCOPY bpev_tbl_type,
200: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
201: PROCEDURE insert_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_bpev_tbl IN bpev_tbl_type,
207: p_bpev_tbl IN bpev_tbl_type,
208: x_bpev_tbl OUT NOCOPY bpev_tbl_type);
209: PROCEDURE lock_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_bpev_rec IN bpev_rec_type);
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_bpev_rec IN bpev_rec_type);
216: PROCEDURE lock_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_bpev_tbl IN bpev_tbl_type,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_bpev_tbl IN bpev_tbl_type,
223: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
224: PROCEDURE lock_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
222: p_bpev_tbl IN bpev_tbl_type,
223: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
224: PROCEDURE lock_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_bpev_tbl IN bpev_tbl_type);
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_bpev_tbl IN bpev_tbl_type);
231: PROCEDURE update_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_bpev_rec IN bpev_rec_type,
237: p_bpev_rec IN bpev_rec_type,
238: x_bpev_rec OUT NOCOPY bpev_rec_type);
239: PROCEDURE update_row(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_bpev_tbl IN bpev_tbl_type,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_bpev_tbl IN bpev_tbl_type,
246: x_bpev_tbl OUT NOCOPY bpev_tbl_type,
247: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
248: PROCEDURE update_row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
246: x_bpev_tbl OUT NOCOPY bpev_tbl_type,
247: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
248: PROCEDURE update_row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_bpev_tbl IN bpev_tbl_type,
254: p_bpev_tbl IN bpev_tbl_type,
255: x_bpev_tbl OUT NOCOPY bpev_tbl_type);
256: PROCEDURE delete_row(
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_bpev_rec IN bpev_rec_type);
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_bpev_rec IN bpev_rec_type);
263: PROCEDURE delete_row(
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_bpev_tbl IN bpev_tbl_type,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_bpev_tbl IN bpev_tbl_type,
270: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
271: PROCEDURE delete_row(
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
274: x_return_status OUT NOCOPY VARCHAR2,
269: p_bpev_tbl IN bpev_tbl_type,
270: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
271: PROCEDURE delete_row(
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_bpev_tbl IN bpev_tbl_type);
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_bpev_tbl IN bpev_tbl_type);
278: PROCEDURE validate_row(
279: p_api_version IN NUMBER,
280: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_bpev_rec IN bpev_rec_type);
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_bpev_rec IN bpev_rec_type);
285: PROCEDURE validate_row(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_bpev_tbl IN bpev_tbl_type,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_bpev_tbl IN bpev_tbl_type,
292: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
293: PROCEDURE validate_row(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
291: p_bpev_tbl IN bpev_tbl_type,
292: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
293: PROCEDURE validate_row(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_bpev_tbl IN bpev_tbl_type);