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.

[Home] [Help]

APPS.GCS_CONS_ENGINE_PKG dependencies on WF_ENGINE

Line 287: WF_ENGINE.CreateProcess(g_oper_item_type, l_childkey_list(counter), g_oper_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);

283: l_childkey_list.extend(1);
284: l_childkey_list(counter) := l_child_key;
285:
286: --Bugfix 5197891: Assign appropriate user rather than null value
287: WF_ENGINE.CreateProcess(g_oper_item_type, l_childkey_list(counter), g_oper_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
288: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'OPER_ENTITY', v_operating_entity.child_entity_id);
289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);
290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);
291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);

Line 288: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'OPER_ENTITY', v_operating_entity.child_entity_id);

284: l_childkey_list(counter) := l_child_key;
285:
286: --Bugfix 5197891: Assign appropriate user rather than null value
287: WF_ENGINE.CreateProcess(g_oper_item_type, l_childkey_list(counter), g_oper_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
288: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'OPER_ENTITY', v_operating_entity.child_entity_id);
289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);
290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);
291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);
292: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_operating_entity.translation_required);

Line 289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);

285:
286: --Bugfix 5197891: Assign appropriate user rather than null value
287: WF_ENGINE.CreateProcess(g_oper_item_type, l_childkey_list(counter), g_oper_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
288: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'OPER_ENTITY', v_operating_entity.child_entity_id);
289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);
290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);
291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);
292: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_operating_entity.translation_required);
293: WF_ENGINE.Set_Item_Parent(g_oper_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW');

Line 290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);

286: --Bugfix 5197891: Assign appropriate user rather than null value
287: WF_ENGINE.CreateProcess(g_oper_item_type, l_childkey_list(counter), g_oper_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
288: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'OPER_ENTITY', v_operating_entity.child_entity_id);
289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);
290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);
291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);
292: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_operating_entity.translation_required);
293: WF_ENGINE.Set_Item_Parent(g_oper_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW');
294: END LOOP;

Line 291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);

287: WF_ENGINE.CreateProcess(g_oper_item_type, l_childkey_list(counter), g_oper_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
288: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'OPER_ENTITY', v_operating_entity.child_entity_id);
289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);
290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);
291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);
292: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_operating_entity.translation_required);
293: WF_ENGINE.Set_Item_Parent(g_oper_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW');
294: END LOOP;
295:

Line 292: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_operating_entity.translation_required);

288: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'OPER_ENTITY', v_operating_entity.child_entity_id);
289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);
290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);
291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);
292: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_operating_entity.translation_required);
293: WF_ENGINE.Set_Item_Parent(g_oper_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW');
294: END LOOP;
295:
296: WHILE (counter > 0)

Line 293: WF_ENGINE.Set_Item_Parent(g_oper_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW');

289: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'RUN_DETAIL_ID', v_operating_entity.run_detail_id);
290: WF_ENGINE.SetItemAttrNumber(g_oper_item_type, l_childkey_list(counter), 'CONS_RELATIONSHIP_ID', v_operating_entity.cons_relationship_id);
291: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'PARENT_WORKFLOW_KEY', itemkey);
292: WF_ENGINE.SetItemAttrText(g_oper_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_operating_entity.translation_required);
293: WF_ENGINE.Set_Item_Parent(g_oper_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW');
294: END LOOP;
295:
296: WHILE (counter > 0)
297: LOOP

Line 299: WF_ENGINE.StartProcess(g_oper_item_type, l_childkey_list(counter));

295:
296: WHILE (counter > 0)
297: LOOP
298: l_entities_to_process := TRUE;
299: WF_ENGINE.StartProcess(g_oper_item_type, l_childkey_list(counter));
300:
301: counter := counter - 1;
302:
303: END LOOP;

Line 342: l_execution_mode := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'EXECUTION_MODE', FALSE);

338: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_DATA_PREPARATION', '<>');
339: END IF;
340:
341:
342: l_execution_mode := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'EXECUTION_MODE', FALSE);
343:
344:
345: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
346: itemkey,

Line 551: l_entity_id := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CONS_ENTITY', FALSE);

547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');
549: END IF;
550:
551: l_entity_id := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CONS_ENTITY', FALSE);
552: l_run_identifier := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'RUN_IDENTIFIER', FALSE);
553:
554: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
555:

Line 552: l_run_identifier := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'RUN_IDENTIFIER', FALSE);

548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');
549: END IF;
550:
551: l_entity_id := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CONS_ENTITY', FALSE);
552: l_run_identifier := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'RUN_IDENTIFIER', FALSE);
553:
554: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
555:
556: SELECT COUNT(entry_id)

Line 578: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);

574: p_cons_relationship_id => -1,
575: p_request_error_code => 'NOT_APPLICABLE',
576: p_run_detail_id => l_run_detail_id);
577:
578: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);
579:
580: END IF;
581:
582: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 657: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);

653: l_parameter_list.hierarchy_dataset_code := cons_entity_wf_info.hierarchy_dataset_code;
654:
655: gcs_cons_eng_utility_pkg.execute_module('AGGREGATION', l_parameter_list, itemkey);
656:
657: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);
658:
659: --Bugfix 4874306: Eliminate calls to XML Generation in order to leverage data templates
660: --gcs_cons_eng_utility_pkg.submit_xml_ntf_program(
661: -- p_run_name => cons_entity_wf_info.run_identifier,

Line 985: WF_ENGINE.CreateProcess(g_cons_item_type, l_childkey_list(counter), g_cons_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);

981: p_request_id => cons_entity_wf_info.request_id
982: );
983:
984: --Bugfix 5197891: Assign appropriate user rather than null value
985: WF_ENGINE.CreateProcess(g_cons_item_type, l_childkey_list(counter), g_cons_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
986: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_HIERARCHY', cons_entity_wf_info.consolidation_hierarchy);
987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);
988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);

Line 986: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_HIERARCHY', cons_entity_wf_info.consolidation_hierarchy);

982: );
983:
984: --Bugfix 5197891: Assign appropriate user rather than null value
985: WF_ENGINE.CreateProcess(g_cons_item_type, l_childkey_list(counter), g_cons_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
986: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_HIERARCHY', cons_entity_wf_info.consolidation_hierarchy);
987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);
988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);

Line 987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);

983:
984: --Bugfix 5197891: Assign appropriate user rather than null value
985: WF_ENGINE.CreateProcess(g_cons_item_type, l_childkey_list(counter), g_cons_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
986: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_HIERARCHY', cons_entity_wf_info.consolidation_hierarchy);
987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);
988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);

Line 988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);

984: --Bugfix 5197891: Assign appropriate user rather than null value
985: WF_ENGINE.CreateProcess(g_cons_item_type, l_childkey_list(counter), g_cons_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
986: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_HIERARCHY', cons_entity_wf_info.consolidation_hierarchy);
987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);
988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);
992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);

Line 989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);

985: WF_ENGINE.CreateProcess(g_cons_item_type, l_childkey_list(counter), g_cons_entity_process, l_childkey_list(counter), FND_GLOBAL.USER_NAME);
986: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_HIERARCHY', cons_entity_wf_info.consolidation_hierarchy);
987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);
988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);
992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);
993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);

Line 990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);

986: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_HIERARCHY', cons_entity_wf_info.consolidation_hierarchy);
987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);
988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);
992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);
993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);
994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);

Line 991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);

987: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONS_ENTITY', v_cons_entity.child_entity_id);
988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);
992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);
993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);
994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);
995: --Bugfix 5017120: Added support for additional data types

Line 992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);

988: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'RUN_IDENTIFIER', cons_entity_wf_info.run_identifier);
989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);
992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);
993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);
994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);
995: --Bugfix 5017120: Added support for additional data types
996: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'SOURCE_DATASET_CODE', cons_entity_wf_info.source_dataset_code);

Line 993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);

989: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD', cons_entity_wf_info.cal_period_id);
990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);
992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);
993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);
994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);
995: --Bugfix 5017120: Added support for additional data types
996: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'SOURCE_DATASET_CODE', cons_entity_wf_info.source_dataset_code);
997: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'HIERARCHY_DATASET_CODE', cons_entity_wf_info.hierarchy_dataset_code);

Line 994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);

990: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'PROCESS_METHOD', cons_entity_wf_info.process_method);
991: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'CAL_PERIOD_END_DATE', cons_entity_wf_info.cal_period_end_date);
992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);
993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);
994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);
995: --Bugfix 5017120: Added support for additional data types
996: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'SOURCE_DATASET_CODE', cons_entity_wf_info.source_dataset_code);
997: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'HIERARCHY_DATASET_CODE', cons_entity_wf_info.hierarchy_dataset_code);
998: WF_ENGINE.Set_Item_Parent(g_cons_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW-1');

Line 996: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'SOURCE_DATASET_CODE', cons_entity_wf_info.source_dataset_code);

992: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'BALANCE_TYPE_CODE', cons_entity_wf_info.balance_type_code);
993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);
994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);
995: --Bugfix 5017120: Added support for additional data types
996: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'SOURCE_DATASET_CODE', cons_entity_wf_info.source_dataset_code);
997: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'HIERARCHY_DATASET_CODE', cons_entity_wf_info.hierarchy_dataset_code);
998: WF_ENGINE.Set_Item_Parent(g_cons_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW-1');
999:
1000: l_entities_to_process := TRUE;

Line 997: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'HIERARCHY_DATASET_CODE', cons_entity_wf_info.hierarchy_dataset_code);

993: WF_ENGINE.SetItemAttrText(g_cons_item_type, l_childkey_list(counter), 'TRANSLATION_REQUIRED', v_cons_entity.translation_required);
994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);
995: --Bugfix 5017120: Added support for additional data types
996: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'SOURCE_DATASET_CODE', cons_entity_wf_info.source_dataset_code);
997: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'HIERARCHY_DATASET_CODE', cons_entity_wf_info.hierarchy_dataset_code);
998: WF_ENGINE.Set_Item_Parent(g_cons_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW-1');
999:
1000: l_entities_to_process := TRUE;
1001:

Line 998: WF_ENGINE.Set_Item_Parent(g_cons_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW-1');

994: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'CONC_REQUEST_ID', cons_entity_wf_info.request_id);
995: --Bugfix 5017120: Added support for additional data types
996: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'SOURCE_DATASET_CODE', cons_entity_wf_info.source_dataset_code);
997: WF_ENGINE.SetItemAttrNumber(g_cons_item_type, l_childkey_list(counter), 'HIERARCHY_DATASET_CODE', cons_entity_wf_info.hierarchy_dataset_code);
998: WF_ENGINE.Set_Item_Parent(g_cons_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW-1');
999:
1000: l_entities_to_process := TRUE;
1001:
1002: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns

Line 1011: WF_ENGINE.StartProcess(g_cons_item_type, l_childkey_list(counter));

1007:
1008: WHILE (counter > 0)
1009: LOOP
1010: l_entities_to_process := TRUE;
1011: WF_ENGINE.StartProcess(g_cons_item_type, l_childkey_list(counter));
1012: counter := counter - 1;
1013: END LOOP;
1014:
1015: IF (l_entities_to_process) THEN

Line 1108: WF_ENGINE.SetItemAttrText(itemtype, itemkey, 'PRIOR_RUN_NAME', l_prior_run_name);

1104: AND hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1105: AND most_recent_flag = 'X'
1106: AND cal_period_id = cons_entity_wf_info.cal_period_id;
1107:
1108: WF_ENGINE.SetItemAttrText(itemtype, itemkey, 'PRIOR_RUN_NAME', l_prior_run_name);
1109: result := 'COMPLETE:F';
1110:
1111: --Bugfix 3750740 : Update Prior Run To MOST_RECENT_FLAG = 'N'
1112: gcs_cons_eng_runs_pkg.update_status ( p_run_name => l_prior_run_name,

Line 1134: WF_ENGINE.SetItemAttrText(itemtype, itemkey, 'PRIOR_RUN_NAME', 'NO_PRIOR_RUN');

1130: END IF;
1131:
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
1134: WF_ENGINE.SetItemAttrText(itemtype, itemkey, 'PRIOR_RUN_NAME', 'NO_PRIOR_RUN');
1135:
1136: gcs_cons_eng_runs_pkg.update_status ( p_run_name => cons_entity_wf_info.run_identifier,
1137: p_most_recent_flag => 'Y',
1138: p_status_code => 'IN_PROGRESS',

Line 1251: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);

1247:
1248: update_run_information(cons_entity_wf_info,
1249: l_run_detail_id);
1250:
1251: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);
1252:
1253: result := 'COMPLETE';
1254:
1255: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN