APPS.CSM_SR_TYPE_MAP_EVENT_PKG dependencies on CS_SR_TYPE_MAPPING

Line 21: TYPE incident_type_id_tbl_typ IS TABLE OF CS_SR_TYPE_MAPPING.incident_type_id%TYPE INDEX BY BINARY_INTEGER;

17: p_message OUT NOCOPY VARCHAR2)
18: IS
19: PRAGMA AUTONOMOUS_TRANSACTION;
20: --variable declarations
21: TYPE incident_type_id_tbl_typ IS TABLE OF CS_SR_TYPE_MAPPING.incident_type_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE responsibility_id_tbl_typ IS TABLE OF CS_SR_TYPE_MAPPING.responsibility_id%TYPE INDEX BY BINARY_INTEGER;
23:
24: l_sqlerrno VARCHAR2(20);
25: l_sqlerrmsg varchar2(2000);

Line 22: TYPE responsibility_id_tbl_typ IS TABLE OF CS_SR_TYPE_MAPPING.responsibility_id%TYPE INDEX BY BINARY_INTEGER;

18: IS
19: PRAGMA AUTONOMOUS_TRANSACTION;
20: --variable declarations
21: TYPE incident_type_id_tbl_typ IS TABLE OF CS_SR_TYPE_MAPPING.incident_type_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE responsibility_id_tbl_typ IS TABLE OF CS_SR_TYPE_MAPPING.responsibility_id%TYPE INDEX BY BINARY_INTEGER;
23:
24: l_sqlerrno VARCHAR2(20);
25: l_sqlerrmsg varchar2(2000);
26: l_mark_dirty boolean;

Line 44: FROM CS_SR_TYPE_MAPPING b,

40: SELECT CSM_SR_TYPE_MAPPING_ACC_S.nextval,
41: usr.user_id,
42: b.incident_type_id,
43: b.responsibility_id
44: FROM CS_SR_TYPE_MAPPING b,
45: ASG_USER usr
46: WHERE usr.responsibility_id = b.responsibility_id
47: AND usr.user_id = usr.owner_id
48: AND NOT EXISTS

Line 61: CS_SR_TYPE_MAPPING b

57: CURSOR csr_sr_type_map_upd(p_lastrundate IN date)
58: IS
59: SELECT access_id,user_id
60: FROM CSM_SR_TYPE_MAPPING_ACC acc,
61: CS_SR_TYPE_MAPPING b
62: WHERE acc.incident_type_id = b.incident_type_id
63: AND acc.responsibility_id = b.responsibility_id
64: AND b.last_update_Date >= p_lastrundate;
65:

Line 73: FROM CS_SR_TYPE_MAPPING b

69: SELECT access_id,user_id
70: FROM CSM_SR_TYPE_MAPPING_ACC acc
71: WHERE NOT EXISTS
72: (SELECT 1
73: FROM CS_SR_TYPE_MAPPING b
74: WHERE b.incident_type_id = acc.incident_type_id
75: AND b.responsibility_id = acc.responsibility_id
76: );
77: --Cursor to get last run dateR12 change