APPS.FEM_DIM_HIER_LOADER_PKG dependencies on FEM_LD_HIER_REQUESTS_GT

Line 194: DELETE fem_ld_hier_requests_gt;

190: gs_hier_obj_def_id_tab.DELETE;
191:
192: DELETE fem_ld_dim_requests_gt;
193:
194: DELETE fem_ld_hier_requests_gt;
195:
196: fem_engines_pkg.tech_message (p_severity => g_log_level_2
197: ,p_module => g_block||'.cleanup(PROCEDURE)'
198: ,p_msg_text => 'END cleanup ');

Line 363: UPDATE fem_ld_hier_requests_gt

359: dev_status => l_dev_status,
360: message => l_message)
361: THEN
362: IF l_dev_phase || '.' || l_dev_status IN ('COMPLETE.NORMAL','COMPLETE.WARNING') THEN
363: UPDATE fem_ld_hier_requests_gt
364: SET status = 'Y'
365: WHERE request_id = hier_rec.request_id;
366: ELSE
367: UPDATE fem_ld_hier_requests_gt

Line 367: UPDATE fem_ld_hier_requests_gt

363: UPDATE fem_ld_hier_requests_gt
364: SET status = 'Y'
365: WHERE request_id = hier_rec.request_id;
366: ELSE
367: UPDATE fem_ld_hier_requests_gt
368: SET status = 'N'
369: WHERE request_id = hier_rec.request_id;
370: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);
371: END IF;

Line 549: FROM fem_ld_hier_requests_gt )

545: dimension_id,
546: dimension_varchar_label,
547: hierarchy_object_name,
548: hier_obj_def_display_name
549: FROM fem_ld_hier_requests_gt )
550: LOOP
551:
552: fem_loader_eng_util_pkg.get_hier_loader_exec_mode(c_api_version,
553: c_false,

Line 577: UPDATE fem_ld_hier_requests_gt

573: COMMIT;
574:
575: l_at_least_one := TRUE;
576:
577: UPDATE fem_ld_hier_requests_gt
578: SET request_id = l_request_id
579: WHERE dimension_id = hier_rec.dimension_id
580: AND dimension_varchar_label = hier_rec.dimension_varchar_label
581: AND hierarchy_object_name = hier_rec.hierarchy_object_name

Line 620: -- well, populates fem_ld_hier_requests_gt with the info.

616: --------------------------------------------------------------------------------
617: --
618: -- This procedure populates the list of all dimensions across all the unique
619: -- tables. If the user has selected the option of loading the hierarchies as
620: -- well, populates fem_ld_hier_requests_gt with the info.
621: --
622: --------------------------------------------------------------------------------
623:
624: PROCEDURE build_dim_stages IS

Line 674: -- This procedure populates the list of all hierarchies in fem_ld_hier_requests_gt

670: -----------------------
671:
672: --------------------------------------------------------------------------------
673: --
674: -- This procedure populates the list of all hierarchies in fem_ld_hier_requests_gt
675: --
676: --------------------------------------------------------------------------------
677:
678: PROCEDURE build_hier_stages IS

Line 708: INSERT INTO fem_ld_hier_requests_gt(dimension_id,

704:
705: END IF;
706:
707: FORALL i IN 1..gs_hier_dim_id_tab.COUNT
708: INSERT INTO fem_ld_hier_requests_gt(dimension_id,
709: dimension_varchar_label,
710: hierarchy_object_name,
711: hier_obj_def_display_name,
712: request_id,

Line 726: INSERT INTO fem_ld_hier_requests_gt(dimension_id,

722: AND gs_hier_obj_def_id_tab(i) = -1
723: AND gs_hier_obj_id_tab(i) = -1;
724:
725: FORALL i IN 1..gs_hier_dim_id_tab.COUNT
726: INSERT INTO fem_ld_hier_requests_gt(dimension_id,
727: dimension_varchar_label,
728: hierarchy_object_name,
729: hier_obj_def_display_name,
730: request_id,

Line 752: INSERT INTO fem_ld_hier_requests_gt(dimension_id,

748: AND gs_hier_obj_def_id_tab(i) <> -1
749: AND gs_hier_obj_id_tab(i) = -1;
750:
751: FORALL i IN 1..gs_hier_dim_id_tab.COUNT
752: INSERT INTO fem_ld_hier_requests_gt(dimension_id,
753: dimension_varchar_label,
754: hierarchy_object_name,
755: hier_obj_def_display_name,
756: request_id,

Line 782: FROM fem_ld_hier_requests_gt

778: AND focb.object_type_code = 'HIERARCHY';
779:
780: SELECT COUNT(1)
781: INTO l_hier_count
782: FROM fem_ld_hier_requests_gt
783: WHERE ROWNUM = 1;
784:
785: IF l_hier_count > 0.0 THEN
786: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 847: FROM fem_ld_hier_requests_gt )

843: dimension_varchar_label,
844: hierarchy_object_name,
845: hier_obj_def_display_name,
846: table_row
847: FROM fem_ld_hier_requests_gt )
848: LOOP
849: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || hier_rec.table_row);
850: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || hier_rec.dimension_id);
851: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || hier_rec.dimension_varchar_label);

Line 967: FROM fem_ld_hier_requests_gt

963: hierarchy_object_name,
964: hier_obj_def_display_name,
965: request_id,
966: status
967: FROM fem_ld_hier_requests_gt
968: WHERE table_row = gs_table_row_tab(i))
969: LOOP
970:
971: l_row_exists := TRUE;

Line 1070: DELETE fem_ld_hier_requests_gt;

1066:
1067:
1068: DELETE fem_ld_dim_requests_gt;
1069:
1070: DELETE fem_ld_hier_requests_gt;
1071:
1072: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1073: ,p_module => g_block||'.MAIN - end'
1074: ,p_msg_text => 'END MAIN PACKAGE SECTION');