APPS.CSD_SERVICE_CODES_PKG dependencies on CSD_SERVICE_CODES_B

Line 35: cursor C is select ROWID from CSD_SERVICE_CODES_B

31: P_ATTRIBUTE13 in VARCHAR2,
32: P_ATTRIBUTE14 in VARCHAR2,
33: P_ATTRIBUTE15 in VARCHAR2
34: ) is
35: cursor C is select ROWID from CSD_SERVICE_CODES_B
36: where SERVICE_CODE_ID = PX_SERVICE_CODE_ID;
37:
38: begin
39:

Line 46: insert into CSD_SERVICE_CODES_B (

42: into PX_SERVICE_CODE_ID
43: from dual;
44:
45:
46: insert into CSD_SERVICE_CODES_B (
47: SERVICE_CODE_ID,
48: OBJECT_VERSION_NUMBER,
49: CREATED_BY,
50: CREATION_DATE,

Line 199: from CSD_SERVICE_CODES_B

195: ATTRIBUTE14,
196: ATTRIBUTE15
197: */
198: --
199: from CSD_SERVICE_CODES_B
200: where SERVICE_CODE_ID = P_SERVICE_CODE_ID
201: for update of SERVICE_CODE_ID nowait;
202: recinfo c%rowtype;
203:

Line 335: update CSD_SERVICE_CODES_B set

331: P_ATTRIBUTE14 in VARCHAR2,
332: P_ATTRIBUTE15 in VARCHAR2
333: ) is
334: begin
335: update CSD_SERVICE_CODES_B set
336: OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
337: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
338: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
339: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)

Line 395: delete from CSD_SERVICE_CODES_B

391: if (sql%notfound) then
392: raise no_data_found;
393: end if;
394:
395: delete from CSD_SERVICE_CODES_B
396: where SERVICE_CODE_ID = P_SERVICE_CODE_ID;
397:
398: if (sql%notfound) then
399: raise no_data_found;

Line 409: from CSD_SERVICE_CODES_B B

405: begin
406: delete from CSD_SERVICE_CODES_TL T
407: where not exists
408: (select NULL
409: from CSD_SERVICE_CODES_B B
410: where B.SERVICE_CODE_ID = T.SERVICE_CODE_ID
411: );
412:
413: update CSD_SERVICE_CODES_TL T set (