APPS.FEM_DATA_LOADER_PKG dependencies on FEM_LD_HIER_REQUESTS_GT

Line 161: DELETE fem_ld_hier_requests_gt;

157:
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)'

Line 434: DELETE fem_ld_hier_requests_gt;

430: g_interface_data_rec.DELETE;
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)'

Line 901: FROM fem_ld_hier_requests_gt

897: END LOOP; -- dim_rec
898: ELSE -- 'Hierarchy'
899: FOR hier_rec IN (SELECT DISTINCT
900: request_id
901: FROM fem_ld_hier_requests_gt
902: WHERE request_id > 0 )
903: LOOP
904: IF fnd_concurrent.wait_for_request(request_id=> hier_rec.request_id,
905: interval => c_interval,

Line 914: UPDATE fem_ld_hier_requests_gt

910: dev_status => l_dev_status,
911: message => l_message)
912: THEN
913: IF l_dev_phase || '.' || l_dev_status IN ('COMPLETE.NORMAL','COMPLETE.WARNING') THEN
914: UPDATE fem_ld_hier_requests_gt
915: SET status = 'Y'
916: WHERE request_id = hier_rec.request_id;
917: ELSE
918: UPDATE fem_ld_hier_requests_gt

Line 918: UPDATE fem_ld_hier_requests_gt

914: UPDATE fem_ld_hier_requests_gt
915: SET status = 'Y'
916: WHERE request_id = hier_rec.request_id;
917: ELSE
918: UPDATE fem_ld_hier_requests_gt
919: SET status = 'N'
920: WHERE request_id = hier_rec.request_id;
921: END IF;
922:

Line 1440: FROM fem_ld_hier_requests_gt )

1436: dimension_id,
1437: dimension_varchar_label,
1438: hierarchy_object_name,
1439: hier_obj_def_display_name
1440: FROM fem_ld_hier_requests_gt )
1441: LOOP
1442:
1443: fem_loader_eng_util_pkg.get_hier_loader_exec_mode(c_api_version,
1444: c_false,

Line 1469: UPDATE fem_ld_hier_requests_gt

1465: COMMIT;
1466:
1467: l_at_least_one := TRUE;
1468:
1469: UPDATE fem_ld_hier_requests_gt
1470: SET request_id = l_request_id
1471: WHERE hier_obj_def_display_name = hier_rec.hier_obj_def_display_name
1472: AND dimension_id = hier_rec.dimension_id;
1473:

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

1508: --------------------------------------------------------------------------------
1509: --
1510: -- This procedure populates the list of all dimensions across all the unique
1511: -- tables. If the user has selected the option of loading the hierarchies as
1512: -- well, populates fem_ld_hier_requests_gt with the info.
1513: --
1514: --------------------------------------------------------------------------------
1515:
1516: PROCEDURE build_dim_stages IS

Line 1627: FROM fem_ld_hier_requests_gt

1623: IF g_loader_type = 'CLIENT' THEN
1624: BEGIN
1625: SELECT 1.0
1626: INTO l_dummy
1627: FROM fem_ld_hier_requests_gt
1628: WHERE table_name = gs_table_name_tab(i)
1629: AND ROWNUM = 1 ;
1630: EXCEPTION
1631: WHEN NO_DATA_FOUND THEN

Line 1638: INSERT INTO fem_ld_hier_requests_gt(dimension_id,

1634: END IF; -- g_loader_type = 'CLIENT'
1635:
1636: IF l_dummy <> 1.0 THEN
1637: BEGIN
1638: INSERT INTO fem_ld_hier_requests_gt(dimension_id,
1639: dimension_varchar_label,
1640: hierarchy_object_name,
1641: hier_obj_def_display_name,
1642: table_name,

Line 1659: fem_ld_hier_requests_gt');

1655: WHEN OTHERS THEN
1656: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1657: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1658: ,p_msg_text => 'EXCEPTION in build_dim_stages - insert into
1659: fem_ld_hier_requests_gt');
1660: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);
1661: RAISE;
1662: END;
1663:

Line 3042: FROM fem_ld_hier_requests_gt

3038: hier_obj_def_display_name,
3039: table_name,
3040: request_id,
3041: status
3042: FROM fem_ld_hier_requests_gt
3043: WHERE table_name = p_table_name )
3044: LOOP
3045: IF l_table_name IS NULL THEN
3046: l_table_name := hier_rec.table_name;