APPS.AHL_PRD_DISPOSITIONS_B_H_PKG dependencies on AHL_PRD_DISPOSITIONS_TL_H

Line 147: insert into AHL_PRD_DISPOSITIONS_TL_H (

143: X_LAST_UPDATED_BY,
144: X_LAST_UPDATE_LOGIN
145: );
146:
147: insert into AHL_PRD_DISPOSITIONS_TL_H (
148: DISPOSITION_H_ID,
149: DISPOSITION_ID,
150: LAST_UPDATE_DATE,
151: LAST_UPDATED_BY,

Line 173: from AHL_PRD_DISPOSITIONS_TL_H T

169: from FND_LANGUAGES L
170: where L.INSTALLED_FLAG in ('I', 'B')
171: and not exists
172: (select NULL
173: from AHL_PRD_DISPOSITIONS_TL_H T
174: where T.DISPOSITION_H_ID = X_DISPOSITION_H_ID
175: and T.LANGUAGE = L.LANGUAGE_CODE);
176:
177: open c;

Line 276: from AHL_PRD_DISPOSITIONS_TL_H

272:
273: cursor c1 is select
274: COMMENTS,
275: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
276: from AHL_PRD_DISPOSITIONS_TL_H
277: where DISPOSITION_H_ID = X_DISPOSITION_H_ID
278: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
279: for update of DISPOSITION_H_ID nowait;
280: begin

Line 478: update AHL_PRD_DISPOSITIONS_TL_H set

474: if (sql%notfound) then
475: raise no_data_found;
476: end if;
477:
478: update AHL_PRD_DISPOSITIONS_TL_H set
479: COMMENTS = X_COMMENTS,
480: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
481: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
482: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 496: delete from AHL_PRD_DISPOSITIONS_TL_H

492: procedure DELETE_ROW (
493: X_DISPOSITION_H_ID in NUMBER
494: ) is
495: begin
496: delete from AHL_PRD_DISPOSITIONS_TL_H
497: where DISPOSITION_H_ID = X_DISPOSITION_H_ID;
498:
499: if (sql%notfound) then
500: raise no_data_found;

Line 514: delete from AHL_PRD_DISPOSITIONS_TL_H T

510:
511: procedure ADD_LANGUAGE
512: is
513: begin
514: delete from AHL_PRD_DISPOSITIONS_TL_H T
515: where not exists
516: (select NULL
517: from AHL_PRD_DISPOSITIONS_B_H B
518: where B.DISPOSITION_H_ID = T.DISPOSITION_H_ID

Line 521: update AHL_PRD_DISPOSITIONS_TL_H T set (

517: from AHL_PRD_DISPOSITIONS_B_H B
518: where B.DISPOSITION_H_ID = T.DISPOSITION_H_ID
519: );
520:
521: update AHL_PRD_DISPOSITIONS_TL_H T set (
522: COMMENTS
523: ) = (select
524: B.COMMENTS
525: from AHL_PRD_DISPOSITIONS_TL_H B

Line 525: from AHL_PRD_DISPOSITIONS_TL_H B

521: update AHL_PRD_DISPOSITIONS_TL_H T set (
522: COMMENTS
523: ) = (select
524: B.COMMENTS
525: from AHL_PRD_DISPOSITIONS_TL_H B
526: where B.DISPOSITION_H_ID = T.DISPOSITION_H_ID
527: and B.LANGUAGE = T.SOURCE_LANG)
528: where (
529: T.DISPOSITION_H_ID,

Line 534: from AHL_PRD_DISPOSITIONS_TL_H SUBB, AHL_PRD_DISPOSITIONS_TL_H SUBT

530: T.LANGUAGE
531: ) in (select
532: SUBT.DISPOSITION_H_ID,
533: SUBT.LANGUAGE
534: from AHL_PRD_DISPOSITIONS_TL_H SUBB, AHL_PRD_DISPOSITIONS_TL_H SUBT
535: where SUBB.DISPOSITION_H_ID = SUBT.DISPOSITION_H_ID
536: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
537: and (SUBB.COMMENTS <> SUBT.COMMENTS
538: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)

Line 542: insert into AHL_PRD_DISPOSITIONS_TL_H (

538: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
539: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
540: ));
541:
542: insert into AHL_PRD_DISPOSITIONS_TL_H (
543: DISPOSITION_H_ID,
544: DISPOSITION_ID,
545: LAST_UPDATE_DATE,
546: LAST_UPDATED_BY,

Line 564: from AHL_PRD_DISPOSITIONS_TL_H B, FND_LANGUAGES L

560: B.LAST_UPDATE_LOGIN,
561: B.COMMENTS,
562: L.LANGUAGE_CODE,
563: B.SOURCE_LANG
564: from AHL_PRD_DISPOSITIONS_TL_H B, FND_LANGUAGES L
565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL

Line 569: from AHL_PRD_DISPOSITIONS_TL_H T

565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL
569: from AHL_PRD_DISPOSITIONS_TL_H T
570: where T.DISPOSITION_H_ID = B.DISPOSITION_H_ID
571: and T.LANGUAGE = L.LANGUAGE_CODE);
572: end ADD_LANGUAGE;
573: