APPS.PA_FIN_PLAN_TYPES_PKG dependencies on PA_FIN_PLAN_TYPES_TL

Line 188: insert into PA_FIN_PLAN_TYPES_TL (

184: NVL (X_EDIT_AFTER_BASELINE_FLAG,'N'),
185: NVL (X_USE_FOR_WORKPLAN_FLAG, 'N')
186: );
187:
188: insert into PA_FIN_PLAN_TYPES_TL (
189: LAST_UPDATE_LOGIN,
190: CREATION_DATE,
191: CREATED_BY,
192: LAST_UPDATE_DATE,

Line 214: from PA_FIN_PLAN_TYPES_TL T

210: from FND_LANGUAGES L
211: where L.INSTALLED_FLAG in ('I', 'B')
212: and not exists
213: (select NULL
214: from PA_FIN_PLAN_TYPES_TL T
215: where T.FIN_PLAN_TYPE_ID = L_FIN_PLAN_TYPE_ID
216: and T.LANGUAGE = L.LANGUAGE_CODE);
217:
218: open c;

Line 305: from PA_FIN_PLAN_TYPES_TL

301: cursor c1 is select
302: NAME,
303: DESCRIPTION,
304: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
305: from PA_FIN_PLAN_TYPES_TL
306: where FIN_PLAN_TYPE_ID = X_FIN_PLAN_TYPE_ID
307: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
308: for update of FIN_PLAN_TYPE_ID nowait;
309: begin

Line 500: update PA_FIN_PLAN_TYPES_TL set

496: if (sql%notfound) then
497: raise no_data_found;
498: end if;
499:
500: update PA_FIN_PLAN_TYPES_TL set
501: NAME = X_NAME,
502: DESCRIPTION = X_DESCRIPTION,
503: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
504: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 519: delete from PA_FIN_PLAN_TYPES_TL

515: procedure DELETE_ROW (
516: X_FIN_PLAN_TYPE_ID in NUMBER
517: ) is
518: begin
519: delete from PA_FIN_PLAN_TYPES_TL
520: where FIN_PLAN_TYPE_ID = X_FIN_PLAN_TYPE_ID;
521:
522: if (sql%notfound) then
523: raise no_data_found;

Line 537: delete from PA_FIN_PLAN_TYPES_TL T

533:
534: procedure ADD_LANGUAGE
535: is
536: begin
537: delete from PA_FIN_PLAN_TYPES_TL T
538: where not exists
539: (select NULL
540: from PA_FIN_PLAN_TYPES_B B
541: where B.FIN_PLAN_TYPE_ID = T.FIN_PLAN_TYPE_ID

Line 544: update PA_FIN_PLAN_TYPES_TL T set (

540: from PA_FIN_PLAN_TYPES_B B
541: where B.FIN_PLAN_TYPE_ID = T.FIN_PLAN_TYPE_ID
542: );
543:
544: update PA_FIN_PLAN_TYPES_TL T set (
545: NAME,
546: DESCRIPTION
547: ) = (select
548: B.NAME,

Line 550: from PA_FIN_PLAN_TYPES_TL B

546: DESCRIPTION
547: ) = (select
548: B.NAME,
549: B.DESCRIPTION
550: from PA_FIN_PLAN_TYPES_TL B
551: where B.FIN_PLAN_TYPE_ID = T.FIN_PLAN_TYPE_ID
552: and B.LANGUAGE = T.SOURCE_LANG)
553: where (
554: T.FIN_PLAN_TYPE_ID,

Line 559: from PA_FIN_PLAN_TYPES_TL SUBB, PA_FIN_PLAN_TYPES_TL SUBT

555: T.LANGUAGE
556: ) in (select
557: SUBT.FIN_PLAN_TYPE_ID,
558: SUBT.LANGUAGE
559: from PA_FIN_PLAN_TYPES_TL SUBB, PA_FIN_PLAN_TYPES_TL SUBT
560: where SUBB.FIN_PLAN_TYPE_ID = SUBT.FIN_PLAN_TYPE_ID
561: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
562: and (SUBB.NAME <> SUBT.NAME
563: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 568: insert into PA_FIN_PLAN_TYPES_TL (

564: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
565: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
566: ));
567:
568: insert into PA_FIN_PLAN_TYPES_TL (
569: LAST_UPDATE_LOGIN,
570: CREATION_DATE,
571: CREATED_BY,
572: LAST_UPDATE_DATE,

Line 590: from PA_FIN_PLAN_TYPES_TL B, FND_LANGUAGES L

586: B.NAME,
587: B.DESCRIPTION,
588: L.LANGUAGE_CODE,
589: B.SOURCE_LANG
590: from PA_FIN_PLAN_TYPES_TL B, FND_LANGUAGES L
591: where L.INSTALLED_FLAG in ('I', 'B')
592: and B.LANGUAGE = userenv('LANG')
593: and not exists
594: (select NULL

Line 595: from PA_FIN_PLAN_TYPES_TL T

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

Line 608: update PA_FIN_PLAN_TYPES_TL set

604: X_DESCRIPTION in VARCHAR2
605: ) is
606: begin
607:
608: update PA_FIN_PLAN_TYPES_TL set
609: NAME = X_NAME,
610: DESCRIPTION = X_DESCRIPTION,
611: LAST_UPDATE_DATE = sysdate,
612: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),