APPS.CS_SR_RES_CODE_MAP_DETAIL_PKG dependencies on CS_SR_RES_CODE_MAPPING_DETAIL

Line 55: insert into CS_SR_RES_CODE_MAPPING_DETAIL (

51: fetch c1 into PX_RESOLUTION_MAP_DETAIL_ID;
52: close c1;
53: end if;
54:
55: insert into CS_SR_RES_CODE_MAPPING_DETAIL (
56: RESOLUTION_MAP_DETAIL_ID,
57: RESOLUTION_MAP_ID,
58: INCIDENT_TYPE_ID,
59: INVENTORY_ITEM_ID,

Line 189: from CS_SR_RES_CODE_MAPPING_DETAIL

185: ATTRIBUTE13,
186: ATTRIBUTE14,
187: ATTRIBUTE15,
188: ATTRIBUTE_CATEGORY
189: from CS_SR_RES_CODE_MAPPING_DETAIL
190: where RESOLUTION_MAP_DETAIL_ID = P_RESOLUTION_MAP_DETAIL_ID
191: for update of RESOLUTION_MAP_DETAIL_ID nowait;
192: begin
193: for tlinfo in c1 loop

Line 297: update CS_SR_RES_CODE_MAPPING_DETAIL set

293: X_MSG_COUNT OUT NOCOPY NUMBER,
294: X_MSG_DATA OUT NOCOPY VARCHAR2
295: ) is
296: begin
297: update CS_SR_RES_CODE_MAPPING_DETAIL set
298: RESOLUTION_MAP_ID = P_RESOLUTION_MAP_ID,
299: INCIDENT_TYPE_ID = P_INCIDENT_TYPE_ID,
300: INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
301: ORGANIZATION_ID = P_ORGANIZATION_ID,

Line 340: delete from CS_SR_RES_CODE_MAPPING_DETAIL

336: procedure DELETE_ROW (
337: P_RESOLUTION_MAP_DETAIL_ID in NUMBER
338: ) is
339: begin
340: delete from CS_SR_RES_CODE_MAPPING_DETAIL
341: where RESOLUTION_MAP_DETAIL_ID = P_RESOLUTION_MAP_DETAIL_ID;
342:
343: if (sql%notfound) then
344: raise no_data_found;