APPS.FEM_DIM_HIER_LOADER_PKG dependencies on FEM_LD_DIM_REQUESTS_GT

Line 192: DELETE fem_ld_dim_requests_gt;

188: gs_hier_dim_id_tab.DELETE;
189: gs_hier_obj_id_tab.DELETE;
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

Line 321: FROM fem_ld_dim_requests_gt

317:
318: CASE p_wait_for
319: WHEN c_dim_loader THEN
320: FOR dim_rec IN (SELECT request_id
321: FROM fem_ld_dim_requests_gt
322: WHERE request_id > 0)
323: LOOP
324: IF fnd_concurrent.wait_for_request(request_id=> dim_rec.request_id,
325: interval => c_interval,

Line 334: UPDATE fem_ld_dim_requests_gt

330: dev_status => l_dev_status,
331: message => l_message)
332: THEN
333: IF l_dev_phase || '.' || l_dev_status IN ('COMPLETE.NORMAL','COMPLETE.WARNING') THEN
334: UPDATE fem_ld_dim_requests_gt
335: SET status = 'Y'
336: WHERE request_id = dim_rec.request_id;
337: ELSE
338: UPDATE fem_ld_dim_requests_gt

Line 338: UPDATE fem_ld_dim_requests_gt

334: UPDATE fem_ld_dim_requests_gt
335: SET status = 'Y'
336: WHERE request_id = dim_rec.request_id;
337: ELSE
338: UPDATE fem_ld_dim_requests_gt
339: SET status = 'N'
340: WHERE request_id = dim_rec.request_id;
341: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);
342: END IF;

Line 350: FROM fem_ld_dim_requests_gt

346: END LOOP; -- dim_rec
347:
348: ELSE -- 'Hierarchy'
349: FOR hier_rec IN (SELECT DISTINCT request_id
350: FROM fem_ld_dim_requests_gt
351: WHERE request_id > 0)
352: LOOP
353: IF fnd_concurrent.wait_for_request(request_id=> hier_rec.request_id,
354: interval => c_interval,

Line 431: FROM fem_ld_dim_requests_gt )

427: l_at_least_one := FALSE;
428:
429: FOR dim_rec IN (SELECT dimension_id,
430: dim_intf_table_name
431: FROM fem_ld_dim_requests_gt )
432: LOOP
433:
434: BEGIN
435: EXECUTE IMMEDIATE 'SELECT 1 FROM ' || dim_rec.dim_intf_table_name || ' WHERE ROWNUM = 1' INTO l_dummy;

Line 479: UPDATE fem_ld_dim_requests_gt

475: END IF;
476:
477: l_dummy := 0.0;
478:
479: UPDATE fem_ld_dim_requests_gt
480: SET request_id = l_request_id
481: WHERE dimension_id = dim_rec.dimension_id;
482:
483: END LOOP;

Line 633: INSERT INTO fem_ld_dim_requests_gt(dimension_id,

629: ,p_msg_text => 'BEGIN..for build_dim_stages');
630:
631:
632: FORALL i IN 1..gs_dim_id_tab.COUNT
633: INSERT INTO fem_ld_dim_requests_gt(dimension_id,
634: dimension_varchar_label,
635: dim_intf_table_name,
636: request_id,
637: status)

Line 650: UPDATE fem_ld_dim_requests_gt

646:
647: IF SQL%ROWCOUNT > 0.0 THEN
648: submit_dimension_loaders;
649: ELSE
650: UPDATE fem_ld_dim_requests_gt
651: SET request_id = -10000;
652: END IF;
653:
654: fem_engines_pkg.tech_message (p_severity => g_log_level_2

Line 833: FROM fem_ld_dim_requests_gt )

829:
830: FOR dim_rec IN (SELECT dimension_id,
831: dim_intf_table_name,
832: dimension_varchar_label
833: FROM fem_ld_dim_requests_gt )
834: LOOP
835: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || dim_rec.dimension_id);
836: fnd_file.put_line(FND_FILE.log, ' Interface TB :: ' || dim_rec.dim_intf_table_name);
837: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || dim_rec.dimension_varchar_label);

Line 887: FROM fem_ld_dim_requests_gt)

883:
884: FOR dim_rec IN ( SELECT dimension_varchar_label,
885: request_id,
886: status
887: FROM fem_ld_dim_requests_gt)
888: LOOP
889: IF dim_rec.request_id > 0 THEN
890: IF dim_rec.status = 'Y' THEN
891: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');

Line 1068: DELETE fem_ld_dim_requests_gt;

1064: fnd_message.set_name('FEM', 'FEM_ALL_TXT');
1065: g_all_str := fnd_message.get;
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