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_DATA_LOADER_PKG dependencies on FEM_LD_CAL_PERIODS_GT

Line 162: DELETE fem_ld_cal_periods_gt;

158:
159: DELETE fem_ld_interface_data_gt;
160: DELETE fem_ld_dim_requests_gt;
161: DELETE fem_ld_hier_requests_gt;
162: DELETE fem_ld_cal_periods_gt;
163:
164: fem_engines_pkg.tech_message (p_severity => g_log_level_1
165: ,p_module => g_block||'.process_request(PROCEDURE)'
166: ,p_msg_text => 'Completed deleting the object tables');

Line 435: DELETE fem_ld_cal_periods_gt;

431:
432: DELETE fem_ld_interface_data_gt;
433: DELETE fem_ld_dim_requests_gt;
434: DELETE fem_ld_hier_requests_gt;
435: DELETE fem_ld_cal_periods_gt;
436:
437: fem_engines_pkg.tech_message (p_severity => g_log_level_2
438: ,p_module => g_block||'.cleanup(PROCEDURE)'
439: ,p_msg_text => 'END cleanup ');

Line 2516: -- 4. Finally, if there are no records in fem_ld_cal_periods_gt there is no point in

2512: -- c. LEDGER = specific, LEVEL = specific
2513: -- d. LEDGER = specific, LEVEL = ALL
2514: -- 3. If there are no records that match the ledger/level combination the INSERT
2515: -- gs_valid_rows is updated to -3.0 for use in reporting
2516: -- 4. Finally, if there are no records in fem_ld_cal_periods_gt there is no point in
2517: -- proceeding. Signals the g_evaluate_parameters to FALSE
2518: --
2519: --------------------------------------------------------------------------------
2520:

Line 2536: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)

2532: FOR i IN 1..gs_ledger_tab.COUNT LOOP
2533:
2534: IF gs_ledger_tab(i) <> - 1 AND gs_cal_grp_tab(i) <> -1 AND gs_valid_rows(i) > 0.0 THEN
2535:
2536: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
2537: SELECT gs_table_name_tab(i), gs_table_row_tab(i), gs_ledger_tab(i), fcpb.cal_period_id,
2538: fcpb.dimension_group_id, 'VALID'
2539: FROM fem_calendars_b fcb,
2540: fem_dimension_grps_b fdgb,

Line 2565: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)

2561: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2562:
2563: ELSIF gs_ledger_tab(i) <> - 1 AND gs_cal_grp_tab(i) = -1 AND gs_valid_rows(i) > 0.0 THEN
2564:
2565: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
2566: SELECT gs_table_name_tab(i), gs_table_row_tab(i), gs_ledger_tab(i), fcpb.cal_period_id,
2567: fcpb.dimension_group_id, 'VALID'
2568: FROM fem_calendars_b fcb,
2569: fem_dimension_grps_b fdgb,

Line 2593: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)

2589: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2590:
2591: ELSIF gs_ledger_tab(i) = - 1 AND gs_cal_grp_tab(i) = -1 AND gs_valid_rows(i) > 0.0 THEN
2592:
2593: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
2594: SELECT gs_table_name_tab(i), gs_table_row_tab(i), idt.ledger_id, fcpb.cal_period_id,
2595: fcpb.dimension_group_id, 'VALID'
2596: FROM fem_calendars_b fcb,
2597: fem_dimension_grps_b fdgb,

Line 2623: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)

2619: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2620:
2621: ELSIF gs_ledger_tab(i) = - 1 AND gs_cal_grp_tab(i) <> -1 AND gs_valid_rows(i) > 0.0 THEN
2622:
2623: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
2624: SELECT gs_table_name_tab(i), gs_table_row_tab(i), idt.ledger_id, fcpb.cal_period_id,
2625: fcpb.dimension_group_id, 'VALID'
2626: FROM fem_calendars_b fcb,
2627: fem_dimension_grps_b fdgb,

Line 2660: FROM fem_ld_cal_periods_gt)

2656:
2657: END LOOP;
2658:
2659: FOR cal_rec IN (SELECT ledger_id, table_name, table_row, cal_period_id, valid
2660: FROM fem_ld_cal_periods_gt)
2661: LOOP
2662: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');
2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);

Line 2682: FROM fem_ld_cal_periods_gt

2678: END LOOP;
2679:
2680: SELECT COUNT(1)
2681: INTO l_dummy1
2682: FROM fem_ld_cal_periods_gt
2683: WHERE ROWNUM = 1;
2684:
2685: IF l_dummy1 = 0.0 THEN
2686: g_evaluate_parameters := FALSE;

Line 2748: fem_ld_cal_periods_gt cpt

2744: g_budget_id, g_enc_type_id,
2745: gs_ledger_code_tab, gs_ds_code_tab, gs_budget_code_tab,
2746: gs_enc_code_tab
2747: FROM fem_ld_interface_data_gt idt,
2748: fem_ld_cal_periods_gt cpt
2749: WHERE idt.table_name = gs_table_name_tab(i)
2750: AND idt.table_row = gs_table_row_tab(i)
2751: AND idt.table_name = cpt.table_name
2752: AND idt.table_row = cpt.table_row

Line 2857: fem_ld_cal_periods_gt cpt

2853: idt.source_system_display_code
2854: BULK COLLECT INTO g_ledger_id, g_cal_period_id, g_ss_code, g_ds_code,
2855: gs_ledger_code_tab, gs_ds_code_tab, gs_ss_code_tab
2856: FROM fem_ld_interface_data_gt idt,
2857: fem_ld_cal_periods_gt cpt
2858: WHERE idt.table_name = gs_table_name_tab(i)
2859: AND idt.table_row = gs_table_row_tab(i)
2860: AND idt.table_name = cpt.table_name
2861: AND idt.table_row = cpt.table_row