APPS.OKL_CONS_BILL dependencies on OKL_CNSLD_AR_HDRS_V

Line 16: -- in okl_cnsld_ar_hdrs_v

12: IS_DEBUG_PROCEDURE_ON BOOLEAN;
13: -- End of wraper code generated automatically by Debug code generator
14:
15: --This function checks for the existence of an consolidated invoice
16: -- in okl_cnsld_ar_hdrs_v
17:
18: --This procedure creates a new consolidated invoice header
19: --based on the parameters passed
20:

Line 30: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

26: IS
27:
28: l_old_cnr_id NUMBER;
29: l_old_lln_id NUMBER;
30: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
31: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
32:
33: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
34: SELECT SUM(lsm.amount)

Line 994: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;

990: l_stream_name VARCHAR2(150);
991: i NUMBER;
992: l_funct_return VARCHAR2(1);
993:
994: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
995: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
996: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
997: l_legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
998:

Line 995: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

991: i NUMBER;
992: l_funct_return VARCHAR2(1);
993:
994: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
995: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
996: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
997: l_legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
998:
999: l_update_tbl update_tbl_type;

Line 1897: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;

1893: l_update_tbl update_tbl_type;
1894:
1895: L_FETCH_SIZE NUMBER := 1000;
1896:
1897: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
1898: -- Billing performance fix
1899:
1900: CURSOR line_seq_csr(p_cnr_id NUMBER) IS
1901: SELECT *

Line 2049: FROM okl_cnsld_ar_hdrs_v

2045: -- Get distinct currencies processed in a run
2046: -- --------------------------------------------
2047: CURSOR curr_csr( p_request_id NUMBER ) IS
2048: SELECT DISTINCT CURRENCY_CODE
2049: FROM okl_cnsld_ar_hdrs_v
2050: WHERE request_id = p_request_id;
2051:
2052: CURSOR cnr_cnt_csr( p_request_id NUMBER, p_trx_sts VARCHAR2, p_curr_code VARCHAR2 ) IS
2053: SELECT count(*)

Line 2054: FROM okl_cnsld_ar_hdrs_v

2050: WHERE request_id = p_request_id;
2051:
2052: CURSOR cnr_cnt_csr( p_request_id NUMBER, p_trx_sts VARCHAR2, p_curr_code VARCHAR2 ) IS
2053: SELECT count(*)
2054: FROM okl_cnsld_ar_hdrs_v
2055: WHERE request_id = p_request_id
2056: AND TRX_STATUS_CODE = p_trx_sts
2057: AND CURRENCY_CODE = p_curr_code;
2058:

Line 2084: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;

2080: l_err_cnt NUMBER;
2081: l_op_unit_name hr_operating_units.name%TYPE;
2082: lx_msg_data VARCHAR2(450);
2083: l_msg_index_out NUMBER :=0;
2084: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
2085: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
2086:
2087: -- -----------------------------
2088: -- New fields

Line 2085: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;

2081: l_op_unit_name hr_operating_units.name%TYPE;
2082: lx_msg_data VARCHAR2(450);
2083: l_msg_index_out NUMBER :=0;
2084: processed_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
2085: error_sts okl_cnsld_ar_hdrs_v.trx_status_code%TYPE;
2086:
2087: -- -----------------------------
2088: -- New fields
2089: -- -----------------------------

Line 2092: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;

2088: -- New fields
2089: -- -----------------------------
2090: l_old_cnr_id NUMBER;
2091: l_old_lln_id NUMBER;
2092: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
2093: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
2094:
2095: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
2096: SELECT SUM(lsm.amount)

Line 2952: FROM okl_cnsld_ar_hdrs_v cnr,

2948: SELECT cnr.consolidated_invoice_number,
2949: inf.name
2950: INTO l_xsiv_rec.XTRX_CONS_INVOICE_NUMBER,
2951: l_xsiv_rec.XTRX_FORMAT_TYPE
2952: FROM okl_cnsld_ar_hdrs_v cnr,
2953: okl_invoice_formats_b infb,
2954: okl_invoice_formats_tl inf
2955: WHERE cnr.id = cnr_update_tbl(cnr_tab_idx).cnr_id
2956: AND cnr.inf_id = infb.id(+)