APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_EXT_AR_HEADER_SOURCES_B

Line 4984: FROM okl_ext_ar_header_sources_b hdr

4980: ,p_header_source_table VARCHAR2
4981: ,p_khr_id NUMBER)
4982: IS
4983: SELECT hdr.header_extension_id header_extension_id
4984: FROM okl_ext_ar_header_sources_b hdr
4985: WHERE hdr.source_id = p_header_source_id
4986: AND hdr.khr_id = p_khr_id;
4987:
4988: -- Cursor to fetch trans number

Line 6071: FROM okl_ext_ar_header_sources_b rxh

6067: -- Cursor Definitions
6068: CURSOR get_ar_ext_hdr_id( p_source_id NUMBER, p_source_table VARCHAR2)
6069: IS
6070: SELECT rxh.header_extension_id header_extension_id
6071: FROM okl_ext_ar_header_sources_b rxh
6072: WHERE rxh.source_id = p_source_id
6073: AND rxh.source_table = p_source_table;
6074:
6075: CURSOR get_ar_ext_lns_id( p_hdr_ext_id NUMBER)

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

6142: FOR t_rec IN get_ar_ext_hdr_id(
6143: p_source_id => l_rxhv_rec.source_id
6144: ,p_source_table => l_rxhv_rec.source_table)
6145: LOOP
6146: -- Note that for a given Source ID and Source Table in OKL_EXT_AR_HEADER_SOURCES_B
6147: -- there can be multiple records each having different KHR_ID ..
6148: l_rxhv_rec.header_extension_id := t_rec.header_extension_id;
6149: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6150: 'Extension Header ID To be Deleted=' || TO_CHAR(l_rxhv_rec.header_extension_id));

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

8704: l_rxhl_tbl(tl_indx).contract_status := l_led_lang_tbl(tl_indx).contract_status;
8705: l_rxhl_tbl(tl_indx).inv_agrmnt_status := l_led_lang_tbl(tl_indx).inv_agrmnt_status;
8706: END LOOP;
8707:
8708: -- Now call the API to insert the Sources in the OKL_EXT_AR_HEADER_SOURCES_B/_TL table
8709: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8710: 'Calling the okl_ar_extension_pvt.create_rxh_extension ' || l_rxh_rec.source_id );
8711: okl_ar_extension_pvt.create_rxh_extension(
8712: p_api_version => l_api_version