APPS.BIS_BUCKET_CUSTOMIZATIONS_PKG dependencies on BIS_BUCKET_CUSTOMIZATIONS_TL

Line 129: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (

125: X_LAST_UPDATED_BY,
126: X_LAST_UPDATE_LOGIN
127: );
128:
129: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (
130: CREATED_BY,
131: CREATION_DATE,
132: LAST_UPDATED_BY,
133: LAST_UPDATE_DATE,

Line 171: from BIS_BUCKET_CUSTOMIZATIONS_TL T

167: from FND_LANGUAGES L
168: where L.INSTALLED_FLAG in ('I', 'B')
169: and not exists
170: (select NULL
171: from BIS_BUCKET_CUSTOMIZATIONS_TL T
172: where T.ID = X_ID
173: and T.LANGUAGE = L.LANGUAGE_CODE);
174:
175: open c;

Line 274: from BIS_BUCKET_CUSTOMIZATIONS_TL

270: RANGE8_NAME,
271: RANGE9_NAME,
272: RANGE10_NAME,
273: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
274: from BIS_BUCKET_CUSTOMIZATIONS_TL
275: where ID = X_ID
276: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
277: for update of ID nowait;
278: begin

Line 469: update BIS_BUCKET_CUSTOMIZATIONS_TL set

465: if (sql%notfound) then
466: raise no_data_found;
467: end if;
468:
469: update BIS_BUCKET_CUSTOMIZATIONS_TL set
470: RANGE1_NAME = X_RANGE1_NAME,
471: RANGE2_NAME = X_RANGE2_NAME,
472: RANGE3_NAME = X_RANGE3_NAME,
473: RANGE4_NAME = X_RANGE4_NAME,

Line 496: delete from BIS_BUCKET_CUSTOMIZATIONS_TL

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

Line 514: delete from BIS_BUCKET_CUSTOMIZATIONS_TL T

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

Line 521: update BIS_BUCKET_CUSTOMIZATIONS_TL T set (

517: from BIS_BUCKET_CUSTOMIZATIONS B
518: where B.ID = T.ID
519: );
520:
521: update BIS_BUCKET_CUSTOMIZATIONS_TL T set (
522: RANGE1_NAME,
523: RANGE2_NAME,
524: RANGE3_NAME,
525: RANGE4_NAME,

Line 543: from BIS_BUCKET_CUSTOMIZATIONS_TL B

539: B.RANGE7_NAME,
540: B.RANGE8_NAME,
541: B.RANGE9_NAME,
542: B.RANGE10_NAME
543: from BIS_BUCKET_CUSTOMIZATIONS_TL B
544: where B.ID = T.ID
545: and B.LANGUAGE = T.SOURCE_LANG)
546: where (
547: T.ID,

Line 552: from BIS_BUCKET_CUSTOMIZATIONS_TL SUBB, BIS_BUCKET_CUSTOMIZATIONS_TL SUBT

548: T.LANGUAGE
549: ) in (select
550: SUBT.ID,
551: SUBT.LANGUAGE
552: from BIS_BUCKET_CUSTOMIZATIONS_TL SUBB, BIS_BUCKET_CUSTOMIZATIONS_TL SUBT
553: where SUBB.ID = SUBT.ID
554: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
555: and (SUBB.RANGE1_NAME <> SUBT.RANGE1_NAME
556: or (SUBB.RANGE1_NAME is null and SUBT.RANGE1_NAME is not null)

Line 587: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (

583: or (SUBB.RANGE10_NAME is null and SUBT.RANGE10_NAME is not null)
584: or (SUBB.RANGE10_NAME is not null and SUBT.RANGE10_NAME is null)
585: ));
586:
587: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (
588: CREATED_BY,
589: CREATION_DATE,
590: LAST_UPDATED_BY,
591: LAST_UPDATE_DATE,

Line 625: from BIS_BUCKET_CUSTOMIZATIONS_TL B, FND_LANGUAGES L

621: B.RANGE5_NAME,
622: B.RANGE6_NAME,
623: L.LANGUAGE_CODE,
624: B.SOURCE_LANG
625: from BIS_BUCKET_CUSTOMIZATIONS_TL B, FND_LANGUAGES L
626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL

Line 630: from BIS_BUCKET_CUSTOMIZATIONS_TL T

626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL
630: from BIS_BUCKET_CUSTOMIZATIONS_TL T
631: where T.ID = B.ID
632: and T.LANGUAGE = L.LANGUAGE_CODE);
633: end ADD_LANGUAGE;
634: