DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_EXT_SELL_INVS_V

Line 102: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;

98: -- To enforce commit frequency
99: -- Bug 4540379
100: l_max_commit_cnt NUMBER := 500;
101:
102: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
103: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;
105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;

Line 103: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;

99: -- Bug 4540379
100: l_max_commit_cnt NUMBER := 500;
101:
102: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
103: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;
105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
107: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;

Line 104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;

100: l_max_commit_cnt NUMBER := 500;
101:
102: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
103: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;
105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
107: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
108: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;

Line 105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;

101:
102: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
103: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;
105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
107: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
108: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;
109: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

Line 106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;

102: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
103: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;
105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
107: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
108: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;
109: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

Line 107: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;

103: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;
105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
107: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
108: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;
109: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
111: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

Line 108: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;

104: l_ext_term_id Okl_Ext_Sell_Invs_V.term_id%TYPE;
105: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
106: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
107: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
108: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;
109: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
111: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
112: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;

Line 1282: l_xsi_id okl_ext_sell_invs_v.id%TYPE;

1278: -- Bug 4524095
1279: --l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1280: --l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1281: l_tld_id okl_txd_ar_ln_dtls_v.id%TYPE;
1282: l_xsi_id okl_ext_sell_invs_v.id%TYPE;
1283: l_xls_id okl_xtl_sell_invs_v.id%TYPE;
1284:
1285: ------------------------------------------------------------
1286: -- Declare variables required by APIs