APPS.CSM_RESCODE_MAPPING_EVENT_PKG dependencies on CS_SR_RES_CODE_MAPPING_DETAIL

Line 21: TYPE res_map_id_tbl_typ IS TABLE OF CS_SR_RES_CODE_MAPPING_DETAIL.resolution_map_detail_id%TYPE INDEX BY BINARY_INTEGER;

17: p_message OUT NOCOPY VARCHAR2)
18: IS
19: PRAGMA AUTONOMOUS_TRANSACTION;
20: --variable declarations
21: TYPE res_map_id_tbl_typ IS TABLE OF CS_SR_RES_CODE_MAPPING_DETAIL.resolution_map_detail_id%TYPE INDEX BY BINARY_INTEGER;
22: l_sqlerrno VARCHAR2(20);
23: l_sqlerrmsg varchar2(2000);
24: l_mark_dirty boolean;
25: l_pub_item varchar2(30) := 'CSM_RESCODE_MAPPING';

Line 38: FROM CS_SR_RES_CODE_MAPPING_DETAIL b

34: CURSOR csr_rescode_map_ins
35: IS
36: SELECT csm_rescode_mapping_acc_s.nextval,
37: b.resolution_map_detail_id
38: FROM CS_SR_RES_CODE_MAPPING_DETAIL b
39: WHERE NOT EXISTS
40: (
41: SELECT 1
42: FROM CSM_RESCODE_MAPPING_ACC acc

Line 50: CS_SR_RES_CODE_MAPPING_DETAIL b

46: CURSOR csr_rescode_map_upd(p_lastrundate IN date)
47: IS
48: SELECT access_id
49: FROM CSM_RESCODE_MAPPING_ACC acc,
50: CS_SR_RES_CODE_MAPPING_DETAIL b
51: WHERE b.resolution_map_detail_id = acc.resolution_map_detail_id
52: AND b.last_update_Date >= p_lastrundate;
53: --Delete cursor
54: CURSOR csr_rescode_map_del

Line 60: FROM CS_SR_RES_CODE_MAPPING_DETAIL b

56: SELECT access_id
57: FROM CSM_RESCODE_MAPPING_ACC acc
58: WHERE NOT EXISTS
59: (SELECT 1
60: FROM CS_SR_RES_CODE_MAPPING_DETAIL b
61: WHERE b.resolution_map_detail_id = acc.resolution_map_detail_id
62: );
63: --Cursor to get last run date
64: CURSOR l_last_run_date_csr