APPS.CS_SR_PROBLEM_CODE_MAPPING_PKG dependencies on CS_SR_PROB_CODE_MAPPING

Line 41: select cs_sr_prob_code_mapping_s.nextval

37: X_MSG_DATA OUT NOCOPY VARCHAR2)
38: is
39:
40: cursor c1 is
41: select cs_sr_prob_code_mapping_s.nextval
42: from dual;
43:
44: BEGIN
45: if ( PX_PROBLEM_MAP_ID IS NULL ) OR ( PX_PROBLEM_MAP_ID = FND_API.G_MISS_NUM) THEN

Line 51: insert into CS_SR_PROB_CODE_MAPPING (

47: fetch c1 into PX_PROBLEM_MAP_ID;
48: close c1;
49: end if;
50:
51: insert into CS_SR_PROB_CODE_MAPPING (
52: PROBLEM_MAP_ID,
53: INCIDENT_TYPE_ID,
54: INVENTORY_ITEM_ID,
55: ORGANIZATION_ID,

Line 169: from CS_SR_PROB_CODE_MAPPING

165: ATTRIBUTE13,
166: ATTRIBUTE14,
167: ATTRIBUTE15,
168: ATTRIBUTE_CATEGORY
169: from CS_SR_PROB_CODE_MAPPING
170: where PROBLEM_MAP_ID = P_PROBLEM_MAP_ID
171: for update of PROBLEM_MAP_ID nowait;
172: begin
173: for tlinfo in c1 loop

Line 267: update CS_SR_PROB_CODE_MAPPING set

263: X_MSG_COUNT OUT NOCOPY NUMBER,
264: X_MSG_DATA OUT NOCOPY VARCHAR2
265: ) is
266: begin
267: update CS_SR_PROB_CODE_MAPPING set
268: INCIDENT_TYPE_ID = P_INCIDENT_TYPE_ID,
269: INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
270: ORGANIZATION_ID = P_ORGANIZATION_ID,
271: CATEGORY_ID = P_CATEGORY_ID,

Line 306: delete from CS_SR_PROB_CODE_MAPPING

302: procedure DELETE_ROW (
303: P_PROBLEM_MAP_ID in NUMBER
304: ) is
305: begin
306: delete from CS_SR_PROB_CODE_MAPPING
307: where PROBLEM_MAP_ID = P_PROBLEM_MAP_ID;
308:
309: if (sql%notfound) then
310: raise no_data_found;