APPS.FEM_DATA_LOADER_PKG dependencies on FEM_LD_DIM_REQUESTS_GT

Line 160: DELETE fem_ld_dim_requests_gt;

156: ,p_msg_text => 'Completed process_global_id');
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

Line 433: DELETE fem_ld_dim_requests_gt;

429: g_cal_period_rec.DELETE;
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

Line 849: FROM fem_ld_dim_requests_gt

845: CASE p_wait_for
846: WHEN c_dim_loader THEN
847: FOR dim_rec IN (SELECT DISTINCT
848: request_id
849: FROM fem_ld_dim_requests_gt
850: WHERE request_id > 0 )
851: LOOP
852: IF fnd_concurrent.wait_for_request(request_id=> dim_rec.request_id,
853: interval => c_interval,

Line 862: UPDATE fem_ld_dim_requests_gt

858: dev_status => l_dev_status,
859: message => l_message)
860: THEN
861: IF l_dev_phase || '.' || l_dev_status IN ('COMPLETE.NORMAL','COMPLETE.WARNING') THEN
862: UPDATE fem_ld_dim_requests_gt
863: SET status = 'Y'
864: WHERE request_id = dim_rec.request_id;
865: ELSE
866: UPDATE fem_ld_dim_requests_gt

Line 866: UPDATE fem_ld_dim_requests_gt

862: UPDATE fem_ld_dim_requests_gt
863: SET status = 'Y'
864: WHERE request_id = dim_rec.request_id;
865: ELSE
866: UPDATE fem_ld_dim_requests_gt
867: SET status = 'N'
868: WHERE request_id = dim_rec.request_id;
869: END IF;
870:

Line 980: FROM fem_ld_dim_requests_gt )

976:
977: FOR dim_rec IN (SELECT DISTINCT
978: dimension_id,
979: dim_intf_table_name
980: FROM fem_ld_dim_requests_gt )
981: LOOP
982:
983: BEGIN
984: EXECUTE IMMEDIATE 'SELECT 1 FROM ' || dim_rec.dim_intf_table_name || ' WHERE ROWNUM = 1' INTO l_dummy;

Line 1030: UPDATE fem_ld_dim_requests_gt

1026: END IF;
1027:
1028: l_dummy := 0.0;
1029:
1030: UPDATE fem_ld_dim_requests_gt
1031: SET request_id = l_request_id
1032: WHERE dimension_id = dim_rec.dimension_id;
1033:
1034: END LOOP;

Line 1543: FROM fem_ld_dim_requests_gt

1539: IF g_loader_type = 'CLIENT' THEN
1540: BEGIN
1541: SELECT 1.0
1542: INTO l_dummy
1543: FROM fem_ld_dim_requests_gt
1544: WHERE table_name = gs_table_name_tab(i)
1545: AND ROWNUM = 1;
1546: EXCEPTION
1547: WHEN NO_DATA_FOUND THEN

Line 1554: INSERT INTO fem_ld_dim_requests_gt(dimension_id,

1550: END IF; -- g_loader_type = 'CLIENT'
1551:
1552: IF l_dummy <> 1 THEN
1553: BEGIN
1554: INSERT INTO fem_ld_dim_requests_gt(dimension_id,
1555: dimension_varchar_label,
1556: table_name,
1557: dim_intf_table_name,
1558: request_id,

Line 1584: fem_ld_dim_requests_gt');

1580: WHEN OTHERS THEN
1581: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1582: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1583: ,p_msg_text => 'EXCEPTION in build_dim_stages - insert into
1584: fem_ld_dim_requests_gt');
1585: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);
1586: RAISE;
1587: END;
1588:

Line 1650: FROM fem_ld_dim_requests_gt drt,

1646: fht.hierarchy_object_name,
1647: fht.hier_obj_def_display_name,
1648: gs_table_name_tab(i),
1649: TO_NUMBER(NULL)
1650: FROM fem_ld_dim_requests_gt drt,
1651: fem_hierarchies_t fht
1652: WHERE table_name = gs_table_name_tab(i)
1653: AND drt.dimension_varchar_label = fht.dimension_varchar_label;
1654: EXCEPTION

Line 2959: FROM fem_ld_dim_requests_gt drt

2955: dimension_varchar_label,
2956: table_name,
2957: request_id,
2958: status
2959: FROM fem_ld_dim_requests_gt drt
2960: WHERE table_name = p_table_name )
2961: LOOP
2962: IF l_table_name IS NULL THEN
2963: l_table_name := dim_rec.table_name;