APPS.GMD_HOLD_REASONS_PVT dependencies on GMD_HOLD_REASONS_TL

Line 132: insert into GMD_HOLD_REASONS_TL (

128: X_LAST_UPDATED_BY,
129: X_LAST_UPDATE_LOGIN
130: );
131:
132: insert into GMD_HOLD_REASONS_TL (
133: QCHOLD_RES_CODE,
134: QCHOLD_RES_DESC,
135: CREATION_DATE,
136: CREATED_BY,

Line 156: from GMD_HOLD_REASONS_TL T

152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from GMD_HOLD_REASONS_TL T
157: where T.QCHOLD_RES_CODE = X_QCHOLD_RES_CODE
158: and T.LANGUAGE = L.LANGUAGE_CODE);
159:
160: open c;

Line 249: from GMD_HOLD_REASONS_TL

245:
246: cursor c1 is select
247: QCHOLD_RES_DESC,
248: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
249: from GMD_HOLD_REASONS_TL
250: where QCHOLD_RES_CODE = X_QCHOLD_RES_CODE
251: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
252: for update of QCHOLD_RES_CODE nowait;
253: begin

Line 432: update GMD_HOLD_REASONS_TL set

428: if (sql%notfound) then
429: raise no_data_found;
430: end if;
431:
432: update GMD_HOLD_REASONS_TL set
433: QCHOLD_RES_DESC = X_QCHOLD_RES_DESC,
434: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
435: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
436: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 450: delete from GMD_HOLD_REASONS_TL

446: procedure DELETE_ROW (
447: X_QCHOLD_RES_CODE in VARCHAR2
448: ) is
449: begin
450: delete from GMD_HOLD_REASONS_TL
451: where QCHOLD_RES_CODE = X_QCHOLD_RES_CODE;
452:
453: if (sql%notfound) then
454: raise no_data_found;

Line 468: delete from GMD_HOLD_REASONS_TL T

464:
465: procedure ADD_LANGUAGE
466: is
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

Line 475: update GMD_HOLD_REASONS_TL T set (

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 (
476: QCHOLD_RES_DESC
477: ) = (select
478: B.QCHOLD_RES_DESC
479: from GMD_HOLD_REASONS_TL B

Line 479: from GMD_HOLD_REASONS_TL B

475: update GMD_HOLD_REASONS_TL T set (
476: QCHOLD_RES_DESC
477: ) = (select
478: B.QCHOLD_RES_DESC
479: from GMD_HOLD_REASONS_TL B
480: where B.QCHOLD_RES_CODE = T.QCHOLD_RES_CODE
481: and B.LANGUAGE = T.SOURCE_LANG)
482: where (
483: T.QCHOLD_RES_CODE,

Line 488: from GMD_HOLD_REASONS_TL SUBB, GMD_HOLD_REASONS_TL SUBT

484: T.LANGUAGE
485: ) in (select
486: SUBT.QCHOLD_RES_CODE,
487: SUBT.LANGUAGE
488: from GMD_HOLD_REASONS_TL SUBB, GMD_HOLD_REASONS_TL SUBT
489: where SUBB.QCHOLD_RES_CODE = SUBT.QCHOLD_RES_CODE
490: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
491: and (SUBB.QCHOLD_RES_DESC <> SUBT.QCHOLD_RES_DESC
492: ));

Line 494: insert into GMD_HOLD_REASONS_TL (

490: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
491: and (SUBB.QCHOLD_RES_DESC <> SUBT.QCHOLD_RES_DESC
492: ));
493:
494: insert into GMD_HOLD_REASONS_TL (
495: QCHOLD_RES_CODE,
496: QCHOLD_RES_DESC,
497: CREATION_DATE,
498: CREATED_BY,

Line 514: from GMD_HOLD_REASONS_TL B, FND_LANGUAGES L

510: B.LAST_UPDATED_BY,
511: B.LAST_UPDATE_LOGIN,
512: L.LANGUAGE_CODE,
513: B.SOURCE_LANG
514: from GMD_HOLD_REASONS_TL B, FND_LANGUAGES L
515: where L.INSTALLED_FLAG in ('I', 'B')
516: and B.LANGUAGE = userenv('LANG')
517: and not exists
518: (select NULL

Line 519: from GMD_HOLD_REASONS_TL T

515: where L.INSTALLED_FLAG in ('I', 'B')
516: and B.LANGUAGE = userenv('LANG')
517: and not exists
518: (select NULL
519: from GMD_HOLD_REASONS_TL T
520: where T.QCHOLD_RES_CODE = B.QCHOLD_RES_CODE
521: and T.LANGUAGE = L.LANGUAGE_CODE);
522: end ADD_LANGUAGE;
523: