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_ENG_UTILITY_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 168: gcs_cons_eng_run_dtls_pkg.update_entry_headers(

164: IF (p_parameter_list.errbuf IS NOT NULL) THEN
165: p_parameter_list.xlate_entry_id := NULL;
166: END IF;
167:
168: gcs_cons_eng_run_dtls_pkg.update_entry_headers(
169: p_run_detail_id => p_parameter_list.run_detail_id,
170: p_entry_id => p_parameter_list.xlate_entry_id,
171: p_request_error_code => NVL(p_parameter_list.errbuf, 'COMPLETED'),
172: p_bp_request_error_code => NVL(p_parameter_list.errbuf, 'COMPLETED'));

Line 256: gcs_cons_eng_run_dtls_pkg.update_entry_headers(

252: p_errbuf => p_parameter_list.errbuf,
253: p_retcode => p_parameter_list.retcode,
254: p_hier_dataset_code => p_parameter_list.hierarchy_dataset_code);
255:
256: gcs_cons_eng_run_dtls_pkg.update_entry_headers(
257: p_run_detail_id => p_parameter_list.run_detail_id,
258: p_request_error_code => NVL(p_parameter_list.errbuf, 'COMPLETED'),
259: p_bp_request_error_code => NVL(p_parameter_list.errbuf, 'COMPLETED'));
260:

Line 426: FROM gcs_cons_eng_run_dtls

422: l_parameter_list.bp_undo_prior := 'N';
423:
424: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
425: INTO l_rows_to_process
426: FROM gcs_cons_eng_run_dtls
427: WHERE consolidation_entity_id = cons_entity_wf_info.consolidation_entity
428: AND run_name = cons_entity_wf_info.run_identifier
429: AND child_entity_id = oper_entity_wf_info.operating_entity
430: AND category_code = l_parameter_list.category_code;

Line 460: FROM gcs_cons_eng_run_dtls

456: l_parameter_list.bp_undo_prior := 'N';
457:
458: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
459: INTO l_rows_to_process
460: FROM gcs_cons_eng_run_dtls
461: WHERE consolidation_entity_id = cons_entity_wf_info.consolidation_entity
462: AND run_name = cons_entity_wf_info.run_identifier
463: AND child_entity_id IS NOT NULL
464: AND category_code = l_parameter_list.category_code;

Line 588: gcs_cons_eng_run_dtls_pkg.copy_prior_run_dtls(

584: EXCEPTION
585: WHEN NO_DATA_FOUND THEN
586: -- Need to copy run details for the prior run
587: result := 'COMPLETE:F';
588: gcs_cons_eng_run_dtls_pkg.copy_prior_run_dtls(
589: p_prior_run_name => cons_entity_wf_info.prior_run_identifier,
590: p_current_run_name => cons_entity_wf_info.run_identifier,
591: p_itemtype => itemtype,
592: p_entity_id => l_child_entity_id);

Line 711: -- Bugfix 4272275: Added fix to put correct child_entity_id in gcs_cons_eng_run_dtls

707: x_errbuf VARCHAR2(200);
708: x_retcode VARCHAR2(200);
709: l_run_detail_id NUMBER(15);
710:
711: -- Bugfix 4272275: Added fix to put correct child_entity_id in gcs_cons_eng_run_dtls
712: -- Bugfix 5763719: Modified to fetch even entries with disbled_flag 'Y' (for entries
713: -- which are disabled as of a period.
714:
715: CURSOR c_acqdisp_headers ( p_cal_period_id IN NUMBER,

Line 830: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

826: cons_entity_wf_info.consolidation_hierarchy,
827: l_entity_id,
828: cons_entity_wf_info.balance_type_code) LOOP
829:
830: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
831: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
832: p_category_code => 'ACQ_DISP',
833: p_child_entity_id => v_acqdisp_headers.child_entity_id,
834: p_entry_id => v_acqdisp_headers.entry_id,

Line 859: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

855: ELSE
856: l_stat_entry_id := v_adjustment_headers.entry_id;
857: END IF;
858:
859: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
860: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
861: p_category_code => l_category_code,
862: p_child_entity_id => l_entity_id,
863: p_entry_id => l_entry_id,

Line 997: FROM gcs_cons_eng_run_dtls

993:
994: --Bugfix 5287762: Check to see if any data has been posted for the operational entity
995: SELECT DECODE(count(run_detail_id), 0, 'N', 'Y')
996: INTO l_translation_req_flag
997: FROM gcs_cons_eng_run_dtls
998: WHERE run_name = cons_entity_wf_info.run_identifier
999: AND child_entity_id = oper_entity_wf_info.operating_entity
1000: AND consolidation_entity_id = cons_entity_wf_info.consolidation_entity
1001: AND entry_id IS NOT NULL;

Line 1006: FROM gcs_cons_eng_run_dtls

1002:
1003: ELSE
1004: SELECT cons_relationship_id
1005: INTO l_parameter_list.cons_relationship_id
1006: FROM gcs_cons_eng_run_dtls
1007: WHERE run_detail_id = l_parameter_list.run_detail_id;
1008: END IF;
1009:
1010: SELECT gcerd.run_detail_id,

Line 1014: FROM gcs_cons_eng_run_dtls gcerd

1010: SELECT gcerd.run_detail_id,
1011: gcs_entry_headers_s.nextval
1012: INTO l_parameter_list.run_detail_id,
1013: l_parameter_list.xlate_entry_id
1014: FROM gcs_cons_eng_run_dtls gcerd
1015: WHERE gcerd.run_name = cons_entity_wf_info.run_identifier
1016: AND gcerd.category_code = 'TRANSLATION'
1017: AND gcerd.child_entity_id = l_child_entity_id;
1018:

Line 1028: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async

1024: execute_module ( module_code => 'TRANSLATION',
1025: p_parameter_list => l_parameter_list,
1026: p_item_key => itemkey);
1027: ELSE
1028: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async
1029: ( p_run_detail_id => l_parameter_list.run_detail_id,
1030: p_request_error_code => 'NOT_APPLICABLE',
1031: p_bp_request_error_code => 'NOT_APPLICABLE');
1032: END IF;

Line 1088: gcs_cons_eng_run_dtls_pkg.update_category_status(

1084: END IF;
1085:
1086: IF (l_category_code = 'DATAPREPARATION') THEN
1087:
1088: gcs_cons_eng_run_dtls_pkg.update_category_status(
1089: p_run_name => cons_entity_wf_info.run_identifier,
1090: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
1091: p_category_code => l_category_code,
1092: p_status => l_status_code);

Line 1107: gcs_cons_eng_run_dtls_pkg.update_category_status(

1103: END IF;
1104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Actual Category Code : ' || l_category_code);
1106: END IF;
1107: gcs_cons_eng_run_dtls_pkg.update_category_status(
1108: p_run_name => cons_entity_wf_info.run_identifier,
1109: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
1110: p_category_code => l_category_code,
1111: p_status => l_status_code);

Line 1244: FROM gcs_cons_eng_run_dtls gcerd,

1240:
1241: SELECT gcerd.child_entity_id,
1242: gcerd.rule_id,
1243: geh.entry_id
1244: FROM gcs_cons_eng_run_dtls gcerd,
1245: gcs_entry_headers geh,
1246: gcs_cons_eng_runs gcer
1247: WHERE geh.hierarchy_id = p_hierarchy_id
1248: AND geh.entity_id = p_target_entity_id

Line 1363: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

1359: cons_entity_wf_info.balance_type_code)
1360: LOOP
1361: l_parameter_list.rp_parameters.parentEntity := v_oper_entity_rules.parent_entity_id;
1362:
1363: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
1364: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
1365: p_category_code => l_category_code,
1366: p_child_entity_id => v_oper_entity_rules.child_entity_id,
1367: p_rule_id => v_oper_entity_rules.rule_id,

Line 1432: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

1428: AND attribute_id = l_oper_entity_attr
1429: AND version_id = l_oper_entity_version;
1430: END IF;
1431:
1432: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
1433: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
1434: p_category_code => l_category_code,
1435: p_child_entity_id => v_cons_entity_rules.child_entity_id,
1436: p_rule_id => v_cons_entity_rules.rule_id,

Line 1500: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row( p_run_name => cons_entity_wf_info.run_identifier,

1496: cons_entity_wf_info.cal_period_id,
1497: l_tgt_entity_id)
1498: LOOP
1499:
1500: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row( p_run_name => cons_entity_wf_info.run_identifier,
1501: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
1502: p_category_code => l_category_code,
1503: p_child_entity_id => v_mp_entries.child_entity_id,
1504: p_rule_id => v_mp_entries.rule_id,

Line 1565: FROM gcs_cons_eng_run_dtls

1561: l_parameter_list.bp_post_xlate := 'N';
1562:
1563: SELECT 'Y'
1564: INTO l_init_required
1565: FROM gcs_cons_eng_run_dtls
1566: WHERE run_name = cons_entity_wf_info.run_identifier
1567: AND consolidation_entity_id = cons_entity_wf_info.consolidation_entity
1568: AND child_entity_id = l_entity_id
1569: AND category_code NOT IN ('DATAPREPARATION')

Line 1588: FROM gcs_cons_eng_run_dtls

1584: AND version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1585:
1586: SELECT 'Y'
1587: INTO l_init_required
1588: FROM gcs_cons_eng_run_dtls
1589: WHERE run_name = cons_entity_wf_info.run_identifier
1590: AND consolidation_entity_id = cons_entity_wf_info.consolidation_entity
1591: AND child_entity_id IS NOT NULL
1592: AND category_code NOT IN ('AGGREGATION')