eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_DEFCALP_UTIL_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 249: insert into fem_cal_periods_attr (

245: when dup_val_on_index then
246: v_dup_cal_period_flag := 'Y';
247: end;
248:
249: insert into fem_cal_periods_attr (
250: ATTRIBUTE_ID
251: ,VERSION_ID
252: ,CAL_PERIOD_ID
253: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 289: insert into fem_cal_periods_attr (

285: and A.dimension_id = 1
286: and V.default_version_flag = 'Y';
287:
288:
289: insert into fem_cal_periods_attr (
290: ATTRIBUTE_ID
291: ,VERSION_ID
292: ,CAL_PERIOD_ID
293: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 328: insert into fem_cal_periods_attr (

324: and A.attribute_id = V.attribute_id
325: and A.dimension_id = 1
326: and V.default_version_flag = 'Y';
327:
328: insert into fem_cal_periods_attr (
329: ATTRIBUTE_ID
330: ,VERSION_ID
331: ,CAL_PERIOD_ID
332: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 367: insert into fem_cal_periods_attr (

363: and A.attribute_id = V.attribute_id
364: and A.dimension_id = 1
365: and V.default_version_flag = 'Y';
366:
367: insert into fem_cal_periods_attr (
368: ATTRIBUTE_ID
369: ,VERSION_ID
370: ,CAL_PERIOD_ID
371: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 406: insert into fem_cal_periods_attr (

402: and A.attribute_id = V.attribute_id
403: and A.dimension_id = 1
404: and V.default_version_flag = 'Y';
405:
406: insert into fem_cal_periods_attr (
407: ATTRIBUTE_ID
408: ,VERSION_ID
409: ,CAL_PERIOD_ID
410: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 445: insert into fem_cal_periods_attr (

441: and A.attribute_id = V.attribute_id
442: and A.dimension_id = 1
443: and V.default_version_flag = 'Y';
444:
445: insert into fem_cal_periods_attr (
446: ATTRIBUTE_ID
447: ,VERSION_ID
448: ,CAL_PERIOD_ID
449: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 484: insert into fem_cal_periods_attr (

480: and A.attribute_id = V.attribute_id
481: and A.dimension_id = 1
482: and V.default_version_flag = 'Y';
483:
484: insert into fem_cal_periods_attr (
485: ATTRIBUTE_ID
486: ,VERSION_ID
487: ,CAL_PERIOD_ID
488: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 523: insert into fem_cal_periods_attr (

519: and A.attribute_id = V.attribute_id
520: and A.dimension_id = 1
521: and V.default_version_flag = 'Y';
522:
523: insert into fem_cal_periods_attr (
524: ATTRIBUTE_ID
525: ,VERSION_ID
526: ,CAL_PERIOD_ID
527: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 562: insert into fem_cal_periods_attr (

558: and A.attribute_id = V.attribute_id
559: and A.dimension_id = 1
560: and V.default_version_flag = 'Y';
561:
562: insert into fem_cal_periods_attr (
563: ATTRIBUTE_ID
564: ,VERSION_ID
565: ,CAL_PERIOD_ID
566: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 601: insert into fem_cal_periods_attr (

597: and A.attribute_id = V.attribute_id
598: and A.dimension_id = 1
599: and V.default_version_flag = 'Y';
600:
601: insert into fem_cal_periods_attr (
602: ATTRIBUTE_ID
603: ,VERSION_ID
604: ,CAL_PERIOD_ID
605: ,DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 971: FROM fem_cal_periods_attr C, fem_dim_attributes_b A, fem_dim_attr_versions_b V

967: -- accounting year of the BUDGET_LAST_PERIOD.
968: IF v_accounting_year IS NULL THEN
969: SELECT C.number_assign_value
970: INTO v_accounting_year
971: FROM fem_cal_periods_attr C, fem_dim_attributes_b A, fem_dim_attr_versions_b V
972: WHERE C.cal_period_id = v_cal_period_id
973: AND A.attribute_varchar_label = 'ACCOUNTING_YEAR'
974: AND C.attribute_id = V.attribute_id
975: AND C.version_id = V.version_id