APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_EXT_AR_HEADER_SOURCES_B

Line 5093: FROM okl_ext_ar_header_sources_b hdr

5089: ,p_header_source_table VARCHAR2
5090: ,p_khr_id NUMBER)
5091: IS
5092: SELECT hdr.header_extension_id header_extension_id
5093: FROM okl_ext_ar_header_sources_b hdr
5094: WHERE hdr.source_id = p_header_source_id
5095: AND hdr.khr_id = p_khr_id;
5096:
5097: -- Cursor to fetch trans number

Line 6186: FROM okl_ext_ar_header_sources_b rxh

6182: -- Cursor Definitions
6183: CURSOR get_ar_ext_hdr_id( p_source_id NUMBER, p_source_table VARCHAR2)
6184: IS
6185: SELECT rxh.header_extension_id header_extension_id
6186: FROM okl_ext_ar_header_sources_b rxh
6187: WHERE rxh.source_id = p_source_id
6188: AND rxh.source_table = p_source_table;
6189:
6190: CURSOR get_ar_ext_lns_id( p_hdr_ext_id NUMBER)

Line 6261: -- Note that for a given Source ID and Source Table in OKL_EXT_AR_HEADER_SOURCES_B

6257: FOR t_rec IN get_ar_ext_hdr_id(
6258: p_source_id => l_rxhv_rec.source_id
6259: ,p_source_table => l_rxhv_rec.source_table)
6260: LOOP
6261: -- Note that for a given Source ID and Source Table in OKL_EXT_AR_HEADER_SOURCES_B
6262: -- there can be multiple records each having different KHR_ID ..
6263: l_rxhv_rec.header_extension_id := t_rec.header_extension_id;
6264: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6265: 'Extension Header ID To be Deleted=' || TO_CHAR(l_rxhv_rec.header_extension_id));

Line 8823: -- Now call the API to insert the Sources in the OKL_EXT_AR_HEADER_SOURCES_B/_TL table

8819: l_rxhl_tbl(tl_indx).contract_status := l_led_lang_tbl(tl_indx).contract_status;
8820: l_rxhl_tbl(tl_indx).inv_agrmnt_status := l_led_lang_tbl(tl_indx).inv_agrmnt_status;
8821: END LOOP;
8822:
8823: -- Now call the API to insert the Sources in the OKL_EXT_AR_HEADER_SOURCES_B/_TL table
8824: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8825: 'Calling the okl_ar_extension_pvt.create_rxh_extension ' || l_rxh_rec.source_id );
8826: okl_ar_extension_pvt.create_rxh_extension(
8827: p_api_version => l_api_version