APPS.PER_CAGR_ENTITLEMENT_ITEMS_PKG dependencies on PER_CAGR_ENTITLEMENT_ITEMS_TL

Line 233: insert into PER_CAGR_ENTITLEMENT_ITEMS_TL (

229: X_LAST_UPDATED_BY,
230: X_LAST_UPDATE_LOGIN
231: );
232:
233: insert into PER_CAGR_ENTITLEMENT_ITEMS_TL (
234: CREATED_BY,
235: CREATION_DATE,
236: LAST_UPDATE_LOGIN,
237: LAST_UPDATE_DATE,

Line 257: from PER_CAGR_ENTITLEMENT_ITEMS_TL T

253: from FND_LANGUAGES L
254: where L.INSTALLED_FLAG in ('I', 'B')
255: and not exists
256: (select NULL
257: from PER_CAGR_ENTITLEMENT_ITEMS_TL T
258: where T.CAGR_ENTITLEMENT_ITEM_ID = X_CAGR_ENTITLEMENT_ITEM_ID
259: and T.LANGUAGE = L.LANGUAGE_CODE);
260:
261: open c;

Line 331: from PER_CAGR_ENTITLEMENT_ITEMS_TL

327: -- Translate char last_update_date to date
328: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
329: select LAST_UPDATED_BY, LAST_UPDATE_DATE
330: into db_luby, db_ludate
331: from PER_CAGR_ENTITLEMENT_ITEMS_TL
332: where CAGR_ENTITLEMENT_ITEM_ID = TO_NUMBER(X_CAGR_ENTITLEMENT_ITEM_ID)
333: and LANGUAGE=userenv('LANG');
334: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
335: db_ludate,X_CUSTOM_MODE)) then

Line 336: update per_cagr_entitlement_items_tl set

332: where CAGR_ENTITLEMENT_ITEM_ID = TO_NUMBER(X_CAGR_ENTITLEMENT_ITEM_ID)
333: and LANGUAGE=userenv('LANG');
334: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
335: db_ludate,X_CUSTOM_MODE)) then
336: update per_cagr_entitlement_items_tl set
337: item_name = X_ITEM_NAME,
338: last_update_date = f_ludate,
339: last_updated_by = f_luby,
340: last_update_login = 0,

Line 529: from PER_CAGR_ENTITLEMENT_ITEMS_TL

525:
526: cursor c1 is select
527: ITEM_NAME,
528: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
529: from PER_CAGR_ENTITLEMENT_ITEMS_TL
530: where CAGR_ENTITLEMENT_ITEM_ID = X_CAGR_ENTITLEMENT_ITEM_ID
531: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
532: for update of CAGR_ENTITLEMENT_ITEM_ID nowait;
533: begin

Line 643: update PER_CAGR_ENTITLEMENT_ITEMS_TL set

639: if (sql%notfound) then
640: raise no_data_found;
641: end if;
642:
643: update PER_CAGR_ENTITLEMENT_ITEMS_TL set
644: ITEM_NAME = X_ITEM_NAME,
645: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
646: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
647: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 661: delete from PER_CAGR_ENTITLEMENT_ITEMS_TL

657: procedure DELETE_ROW (
658: X_CAGR_ENTITLEMENT_ITEM_ID in NUMBER
659: ) is
660: begin
661: delete from PER_CAGR_ENTITLEMENT_ITEMS_TL
662: where CAGR_ENTITLEMENT_ITEM_ID = X_CAGR_ENTITLEMENT_ITEM_ID;
663:
664: if (sql%notfound) then
665: raise no_data_found;

Line 679: delete from PER_CAGR_ENTITLEMENT_ITEMS_TL T

675:
676: procedure ADD_LANGUAGE
677: is
678: begin
679: delete from PER_CAGR_ENTITLEMENT_ITEMS_TL T
680: where not exists
681: (select NULL
682: from PER_CAGR_ENTITLEMENT_ITEMS B
683: where B.CAGR_ENTITLEMENT_ITEM_ID = T.CAGR_ENTITLEMENT_ITEM_ID

Line 686: update PER_CAGR_ENTITLEMENT_ITEMS_TL T set (

682: from PER_CAGR_ENTITLEMENT_ITEMS B
683: where B.CAGR_ENTITLEMENT_ITEM_ID = T.CAGR_ENTITLEMENT_ITEM_ID
684: );
685:
686: update PER_CAGR_ENTITLEMENT_ITEMS_TL T set (
687: ITEM_NAME
688: ) = (select
689: B.ITEM_NAME
690: from PER_CAGR_ENTITLEMENT_ITEMS_TL B

Line 690: from PER_CAGR_ENTITLEMENT_ITEMS_TL B

686: update PER_CAGR_ENTITLEMENT_ITEMS_TL T set (
687: ITEM_NAME
688: ) = (select
689: B.ITEM_NAME
690: from PER_CAGR_ENTITLEMENT_ITEMS_TL B
691: where B.CAGR_ENTITLEMENT_ITEM_ID = T.CAGR_ENTITLEMENT_ITEM_ID
692: and B.LANGUAGE = T.SOURCE_LANG)
693: where (
694: T.CAGR_ENTITLEMENT_ITEM_ID,

Line 699: from PER_CAGR_ENTITLEMENT_ITEMS_TL SUBB, PER_CAGR_ENTITLEMENT_ITEMS_TL SUBT

695: T.LANGUAGE
696: ) in (select
697: SUBT.CAGR_ENTITLEMENT_ITEM_ID,
698: SUBT.LANGUAGE
699: from PER_CAGR_ENTITLEMENT_ITEMS_TL SUBB, PER_CAGR_ENTITLEMENT_ITEMS_TL SUBT
700: where SUBB.CAGR_ENTITLEMENT_ITEM_ID = SUBT.CAGR_ENTITLEMENT_ITEM_ID
701: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
702: and (SUBB.ITEM_NAME <> SUBT.ITEM_NAME
703: ));

Line 705: insert into PER_CAGR_ENTITLEMENT_ITEMS_TL (

701: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
702: and (SUBB.ITEM_NAME <> SUBT.ITEM_NAME
703: ));
704:
705: insert into PER_CAGR_ENTITLEMENT_ITEMS_TL (
706: CREATED_BY,
707: CREATION_DATE,
708: LAST_UPDATE_LOGIN,
709: LAST_UPDATE_DATE,

Line 725: from PER_CAGR_ENTITLEMENT_ITEMS_TL B, FND_LANGUAGES L

721: B.CAGR_ENTITLEMENT_ITEM_ID,
722: B.ITEM_NAME,
723: L.LANGUAGE_CODE,
724: B.SOURCE_LANG
725: from PER_CAGR_ENTITLEMENT_ITEMS_TL B, FND_LANGUAGES L
726: where L.INSTALLED_FLAG in ('I', 'B')
727: and B.LANGUAGE = userenv('LANG')
728: and not exists
729: (select NULL

Line 730: from PER_CAGR_ENTITLEMENT_ITEMS_TL T

726: where L.INSTALLED_FLAG in ('I', 'B')
727: and B.LANGUAGE = userenv('LANG')
728: and not exists
729: (select NULL
730: from PER_CAGR_ENTITLEMENT_ITEMS_TL T
731: where T.CAGR_ENTITLEMENT_ITEM_ID = B.CAGR_ENTITLEMENT_ITEM_ID
732: and T.LANGUAGE = L.LANGUAGE_CODE);
733: end ADD_LANGUAGE;
734: