APPS.CSM_PROBCODE_MAPPING_EVENT_PKG dependencies on CS_SR_PROB_CODE_MAPPING_DETAIL

Line 18: TYPE problem_map_detail_id_tbl_typ IS TABLE OF cs_sr_prob_code_mapping_detail.problem_map_detail_id%TYPE INDEX BY BINARY_INTEGER;

14: PROCEDURE Refresh_probcode_mapping_acc(p_status OUT NOCOPY VARCHAR2,
15: p_message OUT NOCOPY VARCHAR2)
16: IS
17: PRAGMA AUTONOMOUS_TRANSACTION;
18: TYPE problem_map_detail_id_tbl_typ IS TABLE OF cs_sr_prob_code_mapping_detail.problem_map_detail_id%TYPE INDEX BY BINARY_INTEGER;
19:
20: l_run_date date;
21: l_sqlerrno VARCHAR2(20);
22: l_sqlerrmsg varchar2(2000);

Line 38: FROM CS_SR_PROB_CODE_MAPPING_DETAIL b

34: CURSOR csr_probcode_map_ins
35: IS
36: SELECT csm_probcode_mapping_acc_s.nextval,
37: b.problem_map_detail_id
38: FROM CS_SR_PROB_CODE_MAPPING_DETAIL b
39: WHERE NOT EXISTS
40: (
41: SELECT 1
42: FROM CSM_PROBCODE_MAPPING_ACC acc

Line 51: CS_SR_PROB_CODE_MAPPING_DETAIL b

47: CURSOR csr_probcode_map_upd(p_lastrundate IN date)
48: IS
49: SELECT access_id
50: FROM CSM_PROBCODE_MAPPING_ACC acc,
51: CS_SR_PROB_CODE_MAPPING_DETAIL b
52: WHERE acc.problem_map_detail_id = b.problem_map_detail_id
53: AND b.last_update_date >= p_lastrundate;
54:
55: --Delete Cursor

Line 62: FROM CS_SR_PROB_CODE_MAPPING_DETAIL b

58: SELECT access_id
59: FROM CSM_PROBCODE_MAPPING_ACC acc
60: WHERE NOT EXISTS
61: (SELECT 1
62: FROM CS_SR_PROB_CODE_MAPPING_DETAIL b
63: WHERE b.problem_map_detail_id = acc.problem_map_detail_id
64: );
65:
66: CURSOR l_last_run_date_csr