DBA Data[Home] [Help]

APPS.GCS_RAISE_EVENT_PKG dependencies on FND_GLOBAL

Line 227: WF_ENGINE.CreateProcess('GCSENGNE', l_event_key, 'CONS_ENTITY_PROCESS', l_event_key, FND_GLOBAL.USER_NAME);

223: l_threshold := WF_ENGINE.THRESHOLD;
224: WF_ENGINE.THRESHOLD := -1;
225:
226: --Bugfix 5197891: Assign the correct owner rather than null
227: WF_ENGINE.CreateProcess('GCSENGNE', l_event_key, 'CONS_ENTITY_PROCESS', l_event_key, FND_GLOBAL.USER_NAME);
228: WF_ENGINE.SetItemAttrNumber('GCSENGNE', l_event_key, 'CONS_HIERARCHY', p_consolidation_hierarchy);
229: WF_ENGINE.SetItemAttrNumber('GCSENGNE', l_event_key, 'CONS_ENTITY', p_consolidation_entity);
230: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'RUN_IDENTIFIER', p_run_identifier);
231: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'CAL_PERIOD', p_cal_period_id);

Line 444: SELECT entity_name || ' (' || FND_GLOBAL.CONC_REQUEST_ID || ')'

440: fnd_file.put_line(fnd_file.log, 'End of resetting consolidation status to IN_PROGRESS');
441: END IF;
442:
443:
444: SELECT entity_name || ' (' || FND_GLOBAL.CONC_REQUEST_ID || ')'
445: INTO l_event_key
446: FROM fem_entities_vl
447: WHERE entity_id = p_consolidation_entity;
448:

Line 461: p_request_id => FND_GLOBAL.CONC_REQUEST_ID

457: p_cal_period_id => p_cal_period_id,
458: p_balance_type_code => p_balance_type_code,
459: p_parent_entity_id => -1,
460: p_item_key => l_event_key,
461: p_request_id => FND_GLOBAL.CONC_REQUEST_ID
462: );
463:
464: --Bugfix 4928211: Inserting data into gcs_flattend_relns for performance purposes
465: INSERT INTO gcs_flattened_relns

Line 482: fnd_global.user_id,

478: SELECT p_run_identifier,
479: p_consolidation_entity,
480: gcr.child_entity_id,
481: sysdate,
482: fnd_global.user_id,
483: sysdate,
484: fnd_global.user_id,
485: fnd_global.login_id,
486: 1,

Line 484: fnd_global.user_id,

480: gcr.child_entity_id,
481: sysdate,
482: fnd_global.user_id,
483: sysdate,
484: fnd_global.user_id,
485: fnd_global.login_id,
486: 1,
487: gtb.consolidation_type_code
488: FROM gcs_cons_relationships gcr,

Line 485: fnd_global.login_id,

481: sysdate,
482: fnd_global.user_id,
483: sysdate,
484: fnd_global.user_id,
485: fnd_global.login_id,
486: 1,
487: gtb.consolidation_type_code
488: FROM gcs_cons_relationships gcr,
489: --Bugfix 5091093: Added join for consolidation type code

Line 509: WF_ENGINE.CreateProcess('GCSENGNE', l_event_key, 'CONS_ENTITY_PROCESS', l_event_key, FND_GLOBAL.USER_NAME);

505:
506: fnd_file.put_line(fnd_file.log, 'Submitting Workflow');
507:
508: --Bugfix 5197891: Assign the correct user rather than putting a null value
509: WF_ENGINE.CreateProcess('GCSENGNE', l_event_key, 'CONS_ENTITY_PROCESS', l_event_key, FND_GLOBAL.USER_NAME);
510: WF_ENGINE.SetItemAttrNumber('GCSENGNE', l_event_key, 'CONS_HIERARCHY', p_consolidation_hierarchy);
511: WF_ENGINE.SetItemAttrNumber('GCSENGNE', l_event_key, 'CONS_ENTITY', p_consolidation_entity);
512: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'RUN_IDENTIFIER', p_run_identifier);
513: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'CAL_PERIOD', p_cal_period_id);

Line 517: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'CONC_REQUEST_ID', FND_GLOBAL.CONC_REQUEST_ID);

513: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'CAL_PERIOD', p_cal_period_id);
514: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'PROCESS_METHOD', NVL(p_process_method, 'FULL'));
515: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'CAL_PERIOD_END_DATE', l_cal_period_end_date);
516: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'BALANCE_TYPE_CODE', p_balance_type_code);
517: WF_ENGINE.SetItemAttrText('GCSENGNE', l_event_key, 'CONC_REQUEST_ID', FND_GLOBAL.CONC_REQUEST_ID);
518: --Bugfix 5017120: Added support for multiple data types
519: WF_ENGINE.SetItemAttrNumber('GCSENGNE', l_event_key, 'SOURCE_DATASET_CODE', l_source_dataset_code);
520: WF_ENGINE.SetItemAttrNumber('GCSENGNE', l_event_key, 'HIERARCHY_DATASET_CODE', l_hierarchy_dataset_code);
521: -- Bugfix 5569522: Added Analysis ID as an attribute to the consolidation workflow.