APPS.CS_SR_TYPES_MAPPING_PKG dependencies on CS_SR_TYPE_MAPPING

Line 15: FROM CS_SR_TYPE_MAPPING

11:
12: l_rowid rowid;
13: CURSOR l_type_cur IS
14: SELECT nvl(1,0),rowid
15: FROM CS_SR_TYPE_MAPPING
16: WHERE incident_type_id = p_incident_type_id
17: AND responsibility_id = p_resp_id
18: AND type = p_template_type
19: AND application_id = p_application_id;

Line 23: FROM CS_SR_TYPE_MAPPING

19: AND application_id = p_application_id;
20:
21: CURSOR l_inc_cur IS
22: SELECT nvl(2,0),rowid
23: FROM CS_SR_TYPE_MAPPING
24: WHERE incident_type_id = p_incident_type_id
25: AND responsibility_id = p_resp_id
26: AND application_id = p_application_id;
27:

Line 112: cursor C is select ROWID from CS_SR_TYPE_MAPPING

108: X_STATUS_GROUP_ID in NUMBER,
109: -- for security
110: X_APPLICATION_ID in NUMBER,
111: X_BUSINESS_USAGE in VARCHAR2) is
112: cursor C is select ROWID from CS_SR_TYPE_MAPPING
113: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID and
114: RESPONSIBILITY_ID = X_RESPONSIBILITY_ID and
115: APPLICATION_ID = X_APPLICATION_ID;
116:

Line 127: insert into CS_SR_TYPE_MAPPING(

123: p_resp_id => x_responsibility_id,
124: p_template_type => x_type,
125: p_application_id => x_application_id)
126: then
127: insert into CS_SR_TYPE_MAPPING(
128: INCIDENT_TYPE_ID,
129: RESPONSIBILITY_ID,
130: TEMPLATE_ID,
131: TYPE,

Line 231: from CS_SR_TYPE_MAPPING

227: X_APPLICATION_ID in NUMBER
228: ) is
229: cursor c is select
230: ROWID,OBJECT_VERSION_NUMBER
231: from CS_SR_TYPE_MAPPING
232: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID
233: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
234: and APPLICATION_ID = X_APPLICATION_ID
235: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER

Line 308: update CS_SR_TYPE_MAPPING set

304: p_resp_id => x_responsibility_id,
305: p_template_type => x_type,
306: p_application_id => x_application_id)
307: then
308: update CS_SR_TYPE_MAPPING set
309: INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID ,
310: RESPONSIBILITY_ID = X_RESPONSIBILITY_ID,
311: TEMPLATE_ID = X_TEMPLATE_ID,
312: TYPE = X_TYPE,

Line 368: delete from CS_SR_TYPE_MAPPING

364: -- for security
365: X_APPLICATION_ID in NUMBER
366: ) is
367: begin
368: delete from CS_SR_TYPE_MAPPING
369: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID
370: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
371: and APPLICATION_ID = X_APPLICATION_ID;
372: