APPS.GMD_ITEM_SUBSTITUTION_HDR_PKG dependencies on GMD_ITEM_SUBSTITUTION_HDR_TL

Line 159: insert into GMD_ITEM_SUBSTITUTION_HDR_TL (

155: X_LAST_UPDATED_BY,
156: X_LAST_UPDATE_LOGIN
157: );
158:
159: insert into GMD_ITEM_SUBSTITUTION_HDR_TL (
160: LAST_UPDATE_LOGIN,
161: LAST_UPDATE_DATE,
162: LAST_UPDATED_BY,
163: CREATED_BY,

Line 183: from GMD_ITEM_SUBSTITUTION_HDR_TL T

179: from FND_LANGUAGES L
180: where L.INSTALLED_FLAG in ('I', 'B')
181: and not exists
182: (select NULL
183: from GMD_ITEM_SUBSTITUTION_HDR_TL T
184: where T.SUBSTITUTION_ID = X_SUBSTITUTION_ID
185: and T.LANGUAGE = L.LANGUAGE_CODE);
186:
187: open c;

Line 294: from GMD_ITEM_SUBSTITUTION_HDR_TL

290:
291: cursor c1 is select
292: SUBSTITUTION_DESCRIPTION,
293: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
294: from GMD_ITEM_SUBSTITUTION_HDR_TL
295: where SUBSTITUTION_ID = X_SUBSTITUTION_ID
296: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
297: for update of SUBSTITUTION_ID nowait;
298: begin

Line 506: update GMD_ITEM_SUBSTITUTION_HDR_TL set

502: if (sql%notfound) then
503: raise no_data_found;
504: end if;
505:
506: update GMD_ITEM_SUBSTITUTION_HDR_TL set
507: SUBSTITUTION_DESCRIPTION = X_SUBSTITUTION_DESCRIPTION,
508: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
509: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
510: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 524: delete from GMD_ITEM_SUBSTITUTION_HDR_TL

520: procedure DELETE_ROW (
521: X_SUBSTITUTION_ID in NUMBER
522: ) is
523: begin
524: delete from GMD_ITEM_SUBSTITUTION_HDR_TL
525: where SUBSTITUTION_ID = X_SUBSTITUTION_ID;
526:
527: if (sql%notfound) then
528: raise no_data_found;

Line 542: delete from GMD_ITEM_SUBSTITUTION_HDR_TL T

538:
539: procedure ADD_LANGUAGE
540: is
541: begin
542: delete from GMD_ITEM_SUBSTITUTION_HDR_TL T
543: where not exists
544: (select NULL
545: from GMD_ITEM_SUBSTITUTION_HDR_B B
546: where B.SUBSTITUTION_ID = T.SUBSTITUTION_ID

Line 549: update GMD_ITEM_SUBSTITUTION_HDR_TL T set (

545: from GMD_ITEM_SUBSTITUTION_HDR_B B
546: where B.SUBSTITUTION_ID = T.SUBSTITUTION_ID
547: );
548:
549: update GMD_ITEM_SUBSTITUTION_HDR_TL T set (
550: SUBSTITUTION_DESCRIPTION
551: ) = (select
552: B.SUBSTITUTION_DESCRIPTION
553: from GMD_ITEM_SUBSTITUTION_HDR_TL B

Line 553: from GMD_ITEM_SUBSTITUTION_HDR_TL B

549: update GMD_ITEM_SUBSTITUTION_HDR_TL T set (
550: SUBSTITUTION_DESCRIPTION
551: ) = (select
552: B.SUBSTITUTION_DESCRIPTION
553: from GMD_ITEM_SUBSTITUTION_HDR_TL B
554: where B.SUBSTITUTION_ID = T.SUBSTITUTION_ID
555: and B.LANGUAGE = T.SOURCE_LANG)
556: where (
557: T.SUBSTITUTION_ID,

Line 562: from GMD_ITEM_SUBSTITUTION_HDR_TL SUBB, GMD_ITEM_SUBSTITUTION_HDR_TL SUBT

558: T.LANGUAGE
559: ) in (select
560: SUBT.SUBSTITUTION_ID,
561: SUBT.LANGUAGE
562: from GMD_ITEM_SUBSTITUTION_HDR_TL SUBB, GMD_ITEM_SUBSTITUTION_HDR_TL SUBT
563: where SUBB.SUBSTITUTION_ID = SUBT.SUBSTITUTION_ID
564: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
565: and (SUBB.SUBSTITUTION_DESCRIPTION <> SUBT.SUBSTITUTION_DESCRIPTION
566: ));

Line 568: insert into GMD_ITEM_SUBSTITUTION_HDR_TL (

564: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
565: and (SUBB.SUBSTITUTION_DESCRIPTION <> SUBT.SUBSTITUTION_DESCRIPTION
566: ));
567:
568: insert into GMD_ITEM_SUBSTITUTION_HDR_TL (
569: LAST_UPDATE_LOGIN,
570: LAST_UPDATE_DATE,
571: LAST_UPDATED_BY,
572: CREATED_BY,

Line 588: from GMD_ITEM_SUBSTITUTION_HDR_TL B, FND_LANGUAGES L

584: B.SUBSTITUTION_ID,
585: B.SUBSTITUTION_DESCRIPTION,
586: L.LANGUAGE_CODE,
587: B.SOURCE_LANG
588: from GMD_ITEM_SUBSTITUTION_HDR_TL B, FND_LANGUAGES L
589: where L.INSTALLED_FLAG in ('I', 'B')
590: and B.LANGUAGE = userenv('LANG')
591: and not exists
592: (select NULL

Line 593: from GMD_ITEM_SUBSTITUTION_HDR_TL T

589: where L.INSTALLED_FLAG in ('I', 'B')
590: and B.LANGUAGE = userenv('LANG')
591: and not exists
592: (select NULL
593: from GMD_ITEM_SUBSTITUTION_HDR_TL T
594: where T.SUBSTITUTION_ID = B.SUBSTITUTION_ID
595: and T.LANGUAGE = L.LANGUAGE_CODE);
596: end ADD_LANGUAGE;
597: