APPS.GMD_QC_STATUS_PVT dependencies on GMD_QC_STATUS_B

Line 50: cursor C is select ROWID from GMD_QC_STATUS_B

46: X_LAST_UPDATE_DATE in DATE,
47: X_LAST_UPDATED_BY in NUMBER,
48: X_LAST_UPDATE_LOGIN in NUMBER
49: ) is
50: cursor C is select ROWID from GMD_QC_STATUS_B
51: where STATUS_CODE = X_STATUS_CODE
52: and ENTITY_TYPE = X_ENTITY_TYPE
53: ;
54: begin

Line 55: insert into GMD_QC_STATUS_B (

51: where STATUS_CODE = X_STATUS_CODE
52: and ENTITY_TYPE = X_ENTITY_TYPE
53: ;
54: begin
55: insert into GMD_QC_STATUS_B (
56: ATTRIBUTE4,
57: ATTRIBUTE5,
58: ATTRIBUTE3,
59: ATTRIBUTE15,

Line 263: from GMD_QC_STATUS_B

259: ATTRIBUTE6,
260: ATTRIBUTE7,
261: ATTRIBUTE14,
262: UPDATEABLE
263: from GMD_QC_STATUS_B
264: where STATUS_CODE = X_STATUS_CODE
265: and ENTITY_TYPE = X_ENTITY_TYPE
266: for update of STATUS_CODE nowait;
267: recinfo c%rowtype;

Line 420: update GMD_QC_STATUS_B set

416: X_LAST_UPDATED_BY in NUMBER,
417: X_LAST_UPDATE_LOGIN in NUMBER
418: ) is
419: begin
420: update GMD_QC_STATUS_B set
421: ATTRIBUTE4 = X_ATTRIBUTE4,
422: ATTRIBUTE5 = X_ATTRIBUTE5,
423: ATTRIBUTE3 = X_ATTRIBUTE3,
424: ATTRIBUTE15 = X_ATTRIBUTE15,

Line 495: delete from GMD_QC_STATUS_B

491: if (sql%notfound) then
492: raise no_data_found;
493: end if;
494:
495: delete from GMD_QC_STATUS_B
496: where STATUS_CODE = X_STATUS_CODE
497: and ENTITY_TYPE = X_ENTITY_TYPE;
498:
499: if (sql%notfound) then

Line 510: from GMD_QC_STATUS_B B

506: begin
507: delete from GMD_QC_STATUS_TL T
508: where not exists
509: (select NULL
510: from GMD_QC_STATUS_B B
511: where B.STATUS_CODE = T.STATUS_CODE
512: and B.ENTITY_TYPE = T.ENTITY_TYPE
513: );
514: