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.

APPS.GCS_CONS_ENGINE_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 154: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

150: IF (v_immediate_children.parent_currency_code = v_immediate_children.child_currency_code) THEN
151: l_xlate_request_error_code := 'NOT_APPLICABLE';
152: END IF;
153:
154: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
155: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
156: p_category_code => 'DATAPREPARATION',
157: p_child_entity_id => v_immediate_children.child_entity_id,
158: p_entry_id => NULL,

Line 166: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

162: p_request_error_code => 'NOT_STARTED',
163: p_bp_request_error_code => 'NOT_STARTED');
164:
165: IF (l_xlate_request_error_code = 'NOT_STARTED') THEN
166: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
167: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
168: p_category_code => 'TRANSLATION',
169: p_child_entity_id => v_immediate_children.child_entity_id,
170: p_entry_id => NULL,

Line 191: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

187: IF (v_oper_entity.child_currency_code = v_immediate_children.child_currency_code) THEN
188: l_xlate_request_error_code := 'NOT_APPLICABLE';
189: END IF;
190:
191: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
192: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
193: p_category_code => 'DATAPREPARATION',
194: p_child_entity_id => v_oper_entity.child_entity_id,
195: p_cons_relationship_id => v_oper_entity.cons_relationship_id,

Line 201: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,

197: p_request_error_code => 'NOT_STARTED',
198: p_bp_request_error_code => 'NOT_STARTED');
199:
200: IF (l_xlate_request_error_code = 'NOT_STARTED') THEN
201: gcs_cons_eng_run_dtls_pkg.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
202: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
203: p_category_code => 'TRANSLATION',
204: p_child_entity_id => v_oper_entity.child_entity_id,
205: p_cons_relationship_id => v_oper_entity.cons_relationship_id,

Line 248: FROM gcs_cons_eng_run_dtls gcerd,

244: gcerd.cons_relationship_id,
245: gcerd.run_detail_id,
246: fev.entity_name,
247: DECODE(geca_parent.currency_code, geca_child.currency_code, 'N', 'Y') translation_required
248: FROM gcs_cons_eng_run_dtls gcerd,
249: fem_entities_attr fea,
250: fem_entities_vl fev,
251: gcs_entity_cons_attrs geca_parent,
252: gcs_entity_cons_attrs geca_child,

Line 370: FROM gcs_cons_eng_run_dtls

366:
367:
368: SELECT entry_id, stat_entry_id
369: INTO l_entry_id, l_stat_entry_id
370: FROM gcs_cons_eng_run_dtls
371: WHERE run_detail_id = oper_entity_wf_info.run_detail_id;
372:
373: --Bugfix 3666700: Added code to insert into intercompany temporary table
374: gcs_interco_dynamic_pkg.insert_interco_trx( p_entry_id => l_entry_id,

Line 419: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async( p_run_detail_id => oper_entity_wf_info.run_detail_id,

415: p_period_end_date => cons_entity_wf_info.cal_period_end_date,
416: x_errbuf => l_parameter_list.errbuf,
417: x_retcode => l_parameter_list.retcode);
418:
419: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async( p_run_detail_id => oper_entity_wf_info.run_detail_id,
420: p_entry_id => l_entry_id,
421: p_stat_entry_id => l_stat_entry_id,
422: p_request_error_code => 'COMPLETED',
423: p_bp_request_error_code => 'COMPLETED');

Line 481: FROM gcs_cons_eng_run_dtls gcerd,

477: INTO result,
478: l_entry_id,
479: l_stat_entry_id,
480: l_request_error_code
481: FROM gcs_cons_eng_run_dtls gcerd,
482: gcs_cons_eng_runs gcer
483: WHERE gcer.run_entity_id = cons_entity_wf_info.consolidation_entity
484: AND gcerd.category_code = 'DATAPREPARATION'
485: AND gcer.run_name = gcerd.run_name

Line 512: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async( p_run_detail_id => oper_entity_wf_info.run_detail_id,

508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
510: result := 'COMPLETE:NONE';
511:
512: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async( p_run_detail_id => oper_entity_wf_info.run_detail_id,
513: p_entry_id => l_entry_id,
514: p_stat_entry_id => l_stat_entry_id,
515: p_request_error_code => l_request_error_code,
516: p_bp_request_error_code => l_request_error_code

Line 558: FROM gcs_cons_eng_run_dtls

554: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
555:
556: SELECT COUNT(entry_id)
557: INTO l_entry_count
558: FROM gcs_cons_eng_run_dtls
559: WHERE run_name = l_run_identifier
560: AND NVL(entry_id,-1) > 0
561: AND consolidation_entity_id = l_entity_id
562: AND category_code <> 'AGGREGATION';

Line 569: --Bugfix 5288100: If aggregation is not required then insert not applicable into gcs_cons_eng_run_dtls

565: result := 'COMPLETE:T';
566: ELSE
567: result := 'COMPLETE:F';
568:
569: --Bugfix 5288100: If aggregation is not required then insert not applicable into gcs_cons_eng_run_dtls
570: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
571: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
572: p_category_code => 'AGGREGATION',
573: p_child_entity_id => cons_entity_wf_info.consolidation_entity,

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

566: ELSE
567: result := 'COMPLETE:F';
568:
569: --Bugfix 5288100: If aggregation is not required then insert not applicable into gcs_cons_eng_run_dtls
570: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
571: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
572: p_category_code => 'AGGREGATION',
573: p_child_entity_id => cons_entity_wf_info.consolidation_entity,
574: p_cons_relationship_id => -1,

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

625: l_cons_relationship_id := -1;
626: END;
627:
628:
629: GCS_CONS_ENG_RUN_DTLS_PKG.insert_row(p_run_name => cons_entity_wf_info.run_identifier,
630: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
631: p_category_code => 'AGGREGATION',
632: p_child_entity_id => cons_entity_wf_info.consolidation_entity,
633: p_cons_relationship_id => l_cons_relationship_id,

Line 640: FROM gcs_cons_eng_run_dtls

636:
637:
638: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
639: INTO l_parameter_list.stat_required
640: FROM gcs_cons_eng_run_dtls
641: WHERE run_name = cons_entity_wf_info.run_identifier
642: AND consolidation_entity_id = cons_entity_wf_info.consolidation_entity
643: AND NVL(stat_entry_id,0) > 0;
644:

Line 730: FROM gcs_cons_eng_run_dtls

726:
727: BEGIN
728: SELECT 'Y'
729: INTO l_warning_exists
730: FROM gcs_cons_eng_run_dtls
731: WHERE run_name = cons_entity_wf_info.run_identifier
732: AND consolidation_entity_id = cons_entity_wf_info.consolidation_entity
733: AND child_entity_id IS NULL
734: AND request_error_code NOT IN ('COMPLETED', 'NOT_APPLICABLE')

Line 763: gcs_cons_eng_run_dtls_pkg.update_category_status(

759: WHERE hierarchy_id = cons_entity_wf_info.consolidation_hierarchy;
760:
761:
762: BEGIN
763: gcs_cons_eng_run_dtls_pkg.update_category_status(
764: p_run_name => cons_entity_wf_info.run_identifier,
765: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
766: p_category_code => 'AGGREGATION',
767: p_status => l_status_code);

Line 799: FROM gcs_cons_eng_run_dtls

795: SELECT entry_id,
796: stat_entry_id
797: INTO l_entry_id,
798: l_stat_entry_id
799: FROM gcs_cons_eng_run_dtls
800: WHERE run_detail_id = cons_entity_wf_info.run_detail_id;
801:
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN

Line 817: FROM gcs_cons_eng_run_dtls gcerd

813: p_balance_type_code => cons_entity_wf_info.balance_type_code);
814:
815: SELECT gcerd.run_detail_id
816: INTO l_run_detail_id
817: FROM gcs_cons_eng_run_dtls gcerd
818: WHERE gcerd.category_code = 'DATAPREPARATION'
819: AND gcerd.child_entity_id = cons_entity_wf_info.consolidation_entity
820: AND gcerd.run_name = cons_entity_wf_info.run_identifier;
821:

Line 822: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async( p_run_detail_id => l_run_detail_id,

818: WHERE gcerd.category_code = 'DATAPREPARATION'
819: AND gcerd.child_entity_id = cons_entity_wf_info.consolidation_entity
820: AND gcerd.run_name = cons_entity_wf_info.run_identifier;
821:
822: gcs_cons_eng_run_dtls_pkg.update_entry_headers_async( p_run_detail_id => l_run_detail_id,
823: p_entry_id => l_entry_id,
824: p_stat_entry_id => l_stat_entry_id,
825: p_request_error_code => l_status_code,
826: p_bp_request_error_code => l_status_code);

Line 926: FROM gcs_cons_eng_run_dtls gcerd,

922: gcerd.cons_relationship_id,
923: gcerd.run_detail_id,
924: fev.entity_name,
925: DECODE(geca_parent.currency_code, geca_child.currency_code, 'N', 'Y') translation_required
926: FROM gcs_cons_eng_run_dtls gcerd,
927: fem_entities_attr fea,
928: fem_entities_vl fev,
929: gcs_entity_cons_attrs geca_parent,
930: gcs_entity_cons_attrs geca_child,

Line 1055: gcs_cons_eng_run_dtls_pkg.insert_row(

1051:
1052: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
1053:
1054: FOR v_categories_to_process IN c_categories_to_process LOOP
1055: gcs_cons_eng_run_dtls_pkg.insert_row(
1056: p_run_name => cons_entity_wf_info.run_identifier,
1057: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
1058: p_category_code => v_categories_to_process.category_code,
1059: p_request_error_code => v_categories_to_process.request_error_code,

Line 1199: UPDATE gcs_cons_eng_run_dtls gcerd

1195: BETWEEN gcr.start_date AND NVL(gcr.end_date,
1196: cons_entity_wf_info.cal_period_end_date));
1197:
1198:
1199: UPDATE gcs_cons_eng_run_dtls gcerd
1200: SET (entry_id,
1201: stat_entry_id,
1202: request_error_code,
1203: bp_request_error_code

Line 1209: FROM gcs_cons_eng_run_dtls gcerd_inner

1205: (SELECT gcerd_inner.entry_id,
1206: gcerd_inner.stat_entry_id,
1207: gcerd_inner.request_error_code,
1208: gcerd_inner.bp_request_error_code
1209: FROM gcs_cons_eng_run_dtls gcerd_inner
1210: WHERE gcerd_inner.run_name = cons_entity_wf_info.prior_run_identifier
1211: AND gcerd_inner.consolidation_entity_id = cons_entity_wf_info.consolidation_entity
1212: AND gcerd_inner.category_code = 'AGGREGATION'
1213: AND gcerd_inner.child_entity_id = cons_entity_wf_info.consolidation_entity)