APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_EXT_AP_HEADER_SOURCES_B

Line 6404: FROM okl_ext_ap_header_sources_b hdr

6400: -- Cursor to fetch header_extension_id
6401: CURSOR c_header_extension_id_csr (p_header_source_id NUMBER, p_khr_id NUMBER)
6402: IS
6403: SELECT hdr.header_extension_id header_extension_id
6404: FROM okl_ext_ap_header_sources_b hdr
6405: WHERE hdr.source_id = p_header_source_id
6406: AND hdr.khr_id = p_khr_id;
6407: -- Cursor to fetch trans number
6408: CURSOR c_trans_number_csr (p_header_source_id NUMBER)

Line 7312: FROM okl_ext_ap_header_sources_b pxh

7308: -- Cursor Definitions
7309: CURSOR get_ap_ext_hdr_id( p_source_id NUMBER, p_source_table VARCHAR2)
7310: IS
7311: SELECT pxh.header_extension_id header_extension_id
7312: FROM okl_ext_ap_header_sources_b pxh
7313: WHERE pxh.source_id = p_source_id
7314: AND pxh.source_table = p_source_table;
7315:
7316: CURSOR get_ap_ext_lns_id( p_hdr_ext_id NUMBER)

Line 7387: -- Note that for a given Source ID and Source Table in OKL_EXT_AP_HEADER_SOURCES_B

7383: FOR t_rec IN get_ap_ext_hdr_id(
7384: p_source_id => l_pxhv_rec.source_id
7385: ,p_source_table => l_pxhv_rec.source_table)
7386: LOOP
7387: -- Note that for a given Source ID and Source Table in OKL_EXT_AP_HEADER_SOURCES_B
7388: -- there can be multiple records each having different KHR_ID ..
7389: l_pxhv_rec.header_extension_id := t_rec.header_extension_id;
7390: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7391: 'Extension Header ID To be Deleted=' || TO_CHAR(l_pxhv_rec.header_extension_id));