APPS.AHL_PRD_DISPOSITIONS_PKG dependencies on AHL_PRD_DISPOSITIONS_TL

Line 144: insert into AHL_PRD_DISPOSITIONS_TL (

140: X_LAST_UPDATED_BY,
141: X_LAST_UPDATE_LOGIN
142: );
143:
144: insert into AHL_PRD_DISPOSITIONS_TL (
145: DISPOSITION_ID,
146: LAST_UPDATE_DATE,
147: LAST_UPDATED_BY,
148: CREATION_DATE,

Line 168: from AHL_PRD_DISPOSITIONS_TL T

164: from FND_LANGUAGES L
165: where L.INSTALLED_FLAG in ('I', 'B')
166: and not exists
167: (select NULL
168: from AHL_PRD_DISPOSITIONS_TL T
169: where T.DISPOSITION_ID = X_DISPOSITION_ID
170: and T.LANGUAGE = L.LANGUAGE_CODE);
171:
172: open c;

Line 269: from AHL_PRD_DISPOSITIONS_TL

265:
266: cursor c1 is select
267: COMMENTS,
268: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
269: from AHL_PRD_DISPOSITIONS_TL
270: where DISPOSITION_ID = X_DISPOSITION_ID
271: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
272: for update of DISPOSITION_ID nowait;
273: begin

Line 468: update AHL_PRD_DISPOSITIONS_TL set

464: if (sql%notfound) then
465: raise no_data_found;
466: end if;
467:
468: update AHL_PRD_DISPOSITIONS_TL set
469: COMMENTS = X_COMMENTS,
470: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
471: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
472: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 486: delete from AHL_PRD_DISPOSITIONS_TL

482: procedure DELETE_ROW (
483: X_DISPOSITION_ID in NUMBER
484: ) is
485: begin
486: delete from AHL_PRD_DISPOSITIONS_TL
487: where DISPOSITION_ID = X_DISPOSITION_ID;
488:
489: if (sql%notfound) then
490: raise no_data_found;

Line 504: delete from AHL_PRD_DISPOSITIONS_TL T

500:
501: procedure ADD_LANGUAGE
502: is
503: begin
504: delete from AHL_PRD_DISPOSITIONS_TL T
505: where not exists
506: (select NULL
507: from AHL_PRD_DISPOSITIONS_B B
508: where B.DISPOSITION_ID = T.DISPOSITION_ID

Line 511: update AHL_PRD_DISPOSITIONS_TL T set (

507: from AHL_PRD_DISPOSITIONS_B B
508: where B.DISPOSITION_ID = T.DISPOSITION_ID
509: );
510:
511: update AHL_PRD_DISPOSITIONS_TL T set (
512: COMMENTS
513: ) = (select
514: B.COMMENTS
515: from AHL_PRD_DISPOSITIONS_TL B

Line 515: from AHL_PRD_DISPOSITIONS_TL B

511: update AHL_PRD_DISPOSITIONS_TL T set (
512: COMMENTS
513: ) = (select
514: B.COMMENTS
515: from AHL_PRD_DISPOSITIONS_TL B
516: where B.DISPOSITION_ID = T.DISPOSITION_ID
517: and B.LANGUAGE = T.SOURCE_LANG)
518: where (
519: T.DISPOSITION_ID,

Line 524: from AHL_PRD_DISPOSITIONS_TL SUBB, AHL_PRD_DISPOSITIONS_TL SUBT

520: T.LANGUAGE
521: ) in (select
522: SUBT.DISPOSITION_ID,
523: SUBT.LANGUAGE
524: from AHL_PRD_DISPOSITIONS_TL SUBB, AHL_PRD_DISPOSITIONS_TL SUBT
525: where SUBB.DISPOSITION_ID = SUBT.DISPOSITION_ID
526: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
527: and (SUBB.COMMENTS <> SUBT.COMMENTS
528: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)

Line 532: insert into AHL_PRD_DISPOSITIONS_TL (

528: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
529: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
530: ));
531:
532: insert into AHL_PRD_DISPOSITIONS_TL (
533: DISPOSITION_ID,
534: LAST_UPDATE_DATE,
535: LAST_UPDATED_BY,
536: CREATION_DATE,

Line 552: from AHL_PRD_DISPOSITIONS_TL B, FND_LANGUAGES L

548: B.LAST_UPDATE_LOGIN,
549: B.COMMENTS,
550: L.LANGUAGE_CODE,
551: B.SOURCE_LANG
552: from AHL_PRD_DISPOSITIONS_TL B, FND_LANGUAGES L
553: where L.INSTALLED_FLAG in ('I', 'B')
554: and B.LANGUAGE = userenv('LANG')
555: and not exists
556: (select NULL

Line 557: from AHL_PRD_DISPOSITIONS_TL T

553: where L.INSTALLED_FLAG in ('I', 'B')
554: and B.LANGUAGE = userenv('LANG')
555: and not exists
556: (select NULL
557: from AHL_PRD_DISPOSITIONS_TL T
558: where T.DISPOSITION_ID = B.DISPOSITION_ID
559: and T.LANGUAGE = L.LANGUAGE_CODE);
560: end ADD_LANGUAGE;
561: