DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 83: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;

79: all_rec_tbl all_rec_tbl_type;
80:
81: l_art_index NUMBER := 0;
82: l_commit_cnt NUMBER := 0;
83: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;
84: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
85: --Bug# 9690217
86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;
87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;

Line 84: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;

80:
81: l_art_index NUMBER := 0;
82: l_commit_cnt NUMBER := 0;
83: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;
84: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
85: --Bug# 9690217
86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;
87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;

Line 86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;

82: l_commit_cnt NUMBER := 0;
83: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;
84: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
85: --Bug# 9690217
86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;
87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
89: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
90: l_header_id okl_trx_ar_invoices_v.id%TYPE;

Line 88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;

84: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
85: --Bug# 9690217
86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;
87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
89: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
90: l_header_id okl_trx_ar_invoices_v.id%TYPE;
91: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
92:

Line 90: l_header_id okl_trx_ar_invoices_v.id%TYPE;

86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;
87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
89: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
90: l_header_id okl_trx_ar_invoices_v.id%TYPE;
91: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
92:
93: -- Bug 4524095 -- make break variables global
94: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

Line 1273: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;

1269: ------------------------------------------------------------
1270: -- Declare local variables used in the program
1271: ------------------------------------------------------------
1272:
1273: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1274: l_use_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1275: l_legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1276: l_x_legal_entity_id okl_ext_sell_invs_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1277:

Line 1274: l_use_trx_type okl_trx_ar_invoices_v.try_id%TYPE;

1270: -- Declare local variables used in the program
1271: ------------------------------------------------------------
1272:
1273: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1274: l_use_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1275: l_legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1276: l_x_legal_entity_id okl_ext_sell_invs_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1277:
1278: -- Bug 4524095

Line 1275: l_legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006

1271: ------------------------------------------------------------
1272:
1273: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1274: l_use_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1275: l_legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1276: l_x_legal_entity_id okl_ext_sell_invs_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1277:
1278: -- Bug 4524095
1279: --l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

Line 1299: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;

1295: ------------------------------------------------------------
1296:
1297: l_error_status VARCHAR2(1);
1298: l_error_message VARCHAR2(2000);
1299: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;
1300:
1301:
1302: -- For currecy precision rounded amount
1303: l_ste_amount OKL_STRM_ELEMENTS.amount%TYPE := 0;

Line 3260: FROM okl_trx_ar_invoices_v a,

3256: l_request_id NUMBER; --Bug 7584183
3257:
3258: CURSOR txd_cnt_succ_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3259: SELECT COUNT(*)
3260: FROM okl_trx_ar_invoices_v a,
3261: okl_txl_ar_inv_lns_v b,
3262: okl_txd_ar_ln_dtls_v c
3263: WHERE a.id = b.tai_id AND
3264: b.id = c.til_id_details AND

Line 3270: FROM okl_trx_ar_invoices_v a,

3266: a.request_id = p_req_id ;
3267:
3268: CURSOR txd_cnt_err_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3269: SELECT COUNT(*)
3270: FROM okl_trx_ar_invoices_v a,
3271: okl_txl_ar_inv_lns_v b,
3272: okl_txd_ar_ln_dtls_v c
3273: WHERE a.id = b.tai_id AND
3274: b.id = c.til_id_details AND

Line 3292: processed_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;

3288: l_err_cnt NUMBER;
3289: l_op_unit_name hr_operating_units.name%TYPE;
3290: lx_msg_data VARCHAR2(450);
3291: l_msg_index_out NUMBER :=0;
3292: processed_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;
3293: error_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;
3294: l_end_of_records VARCHAR2(1);
3295:
3296:

Line 3293: error_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;

3289: l_op_unit_name hr_operating_units.name%TYPE;
3290: lx_msg_data VARCHAR2(450);
3291: l_msg_index_out NUMBER :=0;
3292: processed_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;
3293: error_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;
3294: l_end_of_records VARCHAR2(1);
3295:
3296:
3297: BEGIN