APPS.CS_SR_PROB_CODE_MAP_DETAIL_PKG dependencies on CS_SR_PROB_CODE_MAPPING_DETAIL

Line 54: insert into CS_SR_PROB_CODE_MAPPING_DETAIL (

50: fetch c1 into PX_PROBLEM_MAP_DETAIL_ID;
51: close c1;
52: end if;
53:
54: insert into CS_SR_PROB_CODE_MAPPING_DETAIL (
55: PROBLEM_MAP_DETAIL_ID,
56: PROBLEM_MAP_ID,
57: INCIDENT_TYPE_ID,
58: INVENTORY_ITEM_ID,

Line 183: from CS_SR_PROB_CODE_MAPPING_DETAIL

179: ATTRIBUTE13,
180: ATTRIBUTE14,
181: ATTRIBUTE15,
182: ATTRIBUTE_CATEGORY
183: from CS_SR_PROB_CODE_MAPPING_DETAIL
184: where PROBLEM_MAP_DETAIL_ID = P_PROBLEM_MAP_DETAIL_ID
185: for update of PROBLEM_MAP_DETAIL_ID nowait;
186: begin
187: for tlinfo in c1 loop

Line 288: update CS_SR_PROB_CODE_MAPPING_DETAIL set

284: X_MSG_COUNT OUT NOCOPY NUMBER,
285: X_MSG_DATA OUT NOCOPY VARCHAR2
286: ) is
287: begin
288: update CS_SR_PROB_CODE_MAPPING_DETAIL set
289: PROBLEM_MAP_ID = P_PROBLEM_MAP_ID,
290: INCIDENT_TYPE_ID = P_INCIDENT_TYPE_ID,
291: INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
292: ORGANIZATION_ID = P_ORGANIZATION_ID,

Line 331: delete from CS_SR_PROB_CODE_MAPPING_DETAIL

327: procedure DELETE_ROW (
328: P_PROBLEM_MAP_DETAIL_ID in NUMBER
329: ) is
330: begin
331: delete from CS_SR_PROB_CODE_MAPPING_DETAIL
332: where PROBLEM_MAP_DETAIL_ID = P_PROBLEM_MAP_DETAIL_ID;
333:
334: if (sql%notfound) then
335: raise no_data_found;