APPS.GMD_HOLD_REASONS_PVT dependencies on GMD_HOLD_REASONS_B

Line 46: cursor C is select ROWID from GMD_HOLD_REASONS_B

42: X_LAST_UPDATE_DATE in DATE,
43: X_LAST_UPDATED_BY in NUMBER,
44: X_LAST_UPDATE_LOGIN in NUMBER
45: ) is
46: cursor C is select ROWID from GMD_HOLD_REASONS_B
47: where QCHOLD_RES_CODE = X_QCHOLD_RES_CODE
48: ;
49: begin
50: insert into GMD_HOLD_REASONS_B (

Line 50: insert into GMD_HOLD_REASONS_B (

46: cursor C is select ROWID from GMD_HOLD_REASONS_B
47: where QCHOLD_RES_CODE = X_QCHOLD_RES_CODE
48: ;
49: begin
50: insert into GMD_HOLD_REASONS_B (
51: QCHOLD_RES_CODE,
52: DELETE_MARK,
53: TEXT_CODE,
54: ATTRIBUTE1,

Line 241: from GMD_HOLD_REASONS_B

237: ATTRIBUTE28,
238: ATTRIBUTE29,
239: ATTRIBUTE30,
240: ATTRIBUTE_CATEGORY
241: from GMD_HOLD_REASONS_B
242: where QCHOLD_RES_CODE = X_QCHOLD_RES_CODE
243: for update of QCHOLD_RES_CODE nowait;
244: recinfo c%rowtype;
245:

Line 389: update GMD_HOLD_REASONS_B set

385: X_LAST_UPDATED_BY in NUMBER,
386: X_LAST_UPDATE_LOGIN in NUMBER
387: ) is
388: begin
389: update GMD_HOLD_REASONS_B set
390: DELETE_MARK = X_DELETE_MARK,
391: TEXT_CODE = X_TEXT_CODE,
392: ATTRIBUTE1 = X_ATTRIBUTE1,
393: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 457: delete from GMD_HOLD_REASONS_B

453: if (sql%notfound) then
454: raise no_data_found;
455: end if;
456:
457: delete from GMD_HOLD_REASONS_B
458: where QCHOLD_RES_CODE = X_QCHOLD_RES_CODE;
459:
460: if (sql%notfound) then
461: raise no_data_found;

Line 471: from GMD_HOLD_REASONS_B B

467: begin
468: delete from GMD_HOLD_REASONS_TL T
469: where not exists
470: (select NULL
471: from GMD_HOLD_REASONS_B B
472: where B.QCHOLD_RES_CODE = T.QCHOLD_RES_CODE
473: );
474:
475: update GMD_HOLD_REASONS_TL T set (