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_DATASUB_WF_PKG dependencies on GCS_DATA_SUB_DTLS

Line 101: FROM gcs_data_sub_dtls gdsd,

97: p_datasub_info.balances_rule_id,
98: p_datasub_info.source_system_code,
99: p_datasub_info.dataset_code,
100: p_datasub_info.ds_balance_type_code
101: FROM gcs_data_sub_dtls gdsd,
102: fem_entities_b feb,
103: fem_ledgers_b flb,
104: gcs_entities_attr gea,
105: gcs_data_type_codes_b gdtcb,

Line 194: FROM gcs_data_sub_dtls

190: WF_ENGINE.StartProcess('DATASUB', l_event_key);
191:
192: SELECT status_code
193: INTO l_status_code
194: FROM gcs_data_sub_dtls
195: WHERE load_id = p_load_id;
196:
197: fnd_file.put_line(fnd_file.log, 'Completed Workflow');
198:

Line 298: UPDATE gcs_data_sub_dtls

294: END IF;
295: fnd_file.put_line(fnd_file.log, '<<<<< End of Error >>>>>');
296:
297: -- Transformation or Validation Failed
298: UPDATE gcs_data_sub_dtls
299: SET status_code = 'ERROR',
300: end_time = sysdate,
301: last_updated_by = FND_GLOBAL.USER_ID,
302: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 362: FROM gcs_data_sub_dtls gdsd

358: l_request_id NUMBER(15);
359:
360: CURSOR c_generated_loads IS
361: SELECT gdsd.load_id
362: FROM gcs_data_sub_dtls gdsd
363: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID;
364:
365: --Bugfix 4507953: Rely on translated balances select, rather than REQUEST_ID select
366: CURSOR c_translated_balances(p_request_id NUMBER, p_object_id NUMBER, p_ledger_id NUMBER, p_cal_period_id NUMBER) IS

Line 418: UPDATE gcs_data_sub_dtls

414: AND fcpa.version_id = l_period_end_date_version
415: AND fcpa.date_assign_value BETWEEN fodb.effective_start_date AND
416: fodb.effective_end_date;
417:
418: UPDATE gcs_data_sub_dtls
419: SET currency_code = l_currency_code
420: WHERE load_id = p_datasub_info.load_id;
421:
422: --Check if ADB enabled

Line 428: INSERT INTO gcs_data_sub_dtls

424: 'Checking if Average Balances is Enabled');
425:
426: IF (l_enable_avg_bal_flag = 'Y') THEN
427: -- Bugfix 5630225: Added balances_rule_id to the insert statement
428: INSERT INTO gcs_data_sub_dtls
429: (load_id,
430: load_name,
431: entity_id,
432: cal_period_id,

Line 453: SELECT gcs_data_sub_dtls_s.nextval,

449: most_recent_flag,
450: associated_request_id,
451: status_code,
452: balances_rule_id)
453: SELECT gcs_data_sub_dtls_s.nextval,
454: gcs_data_sub_dtls_s.nextval,
455: gdsd.entity_id,
456: gdsd.cal_period_id,
457: gdsd.currency_code,

Line 454: gcs_data_sub_dtls_s.nextval,

450: associated_request_id,
451: status_code,
452: balances_rule_id)
453: SELECT gcs_data_sub_dtls_s.nextval,
454: gcs_data_sub_dtls_s.nextval,
455: gdsd.entity_id,
456: gdsd.cal_period_id,
457: gdsd.currency_code,
458: 'ADB',

Line 477: FROM gcs_data_sub_dtls gdsd

473: gdsd.most_recent_flag,
474: gdsd.associated_request_id,
475: gdsd.status_code,
476: gdsd.balances_rule_id
477: FROM gcs_data_sub_dtls gdsd
478: WHERE gdsd.load_id = p_datasub_info.load_id;
479: END IF;
480:
481: IF (p_datasub_info.load_method_code = 'SNAPSHOT') THEN

Line 486: INSERT INTO gcs_data_sub_dtls

482: fnd_file.put_line(fnd_file.log, 'Performing a snapshot load');
483: -- Submit Data for All Entities Associated to Balances Rules
484: -- Bugfix 5630225: Added balances_rule_id to the insert statement
485: -- BugFix 5843592 : Use gcs_entities_attr instead of fem_entities_attr
486: INSERT INTO gcs_data_sub_dtls
487: (load_id,
488: load_name,
489: entity_id,
490: cal_period_id,

Line 511: SELECT gcs_data_sub_dtls_s.nextval,

507: most_recent_flag,
508: associated_request_id,
509: status_code,
510: balances_rule_id)
511: SELECT gcs_data_sub_dtls_s.nextval,
512: gcs_data_sub_dtls_s.nextval,
513: gea.entity_id,
514: gdsd.cal_period_id,
515: gdsd.currency_code,

Line 512: gcs_data_sub_dtls_s.nextval,

508: associated_request_id,
509: status_code,
510: balances_rule_id)
511: SELECT gcs_data_sub_dtls_s.nextval,
512: gcs_data_sub_dtls_s.nextval,
513: gea.entity_id,
514: gdsd.cal_period_id,
515: gdsd.currency_code,
516: gdsd.balance_type_code,

Line 535: FROM gcs_data_sub_dtls gdsd,

531: gdsd.most_recent_flag,
532: gdsd.associated_request_id,
533: gdsd.status_code,
534: gdsd.balances_rule_id
535: FROM gcs_data_sub_dtls gdsd,
536: gcs_entities_attr gea,
537: fem_cal_periods_attr fcpa
538: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID
539: AND gea.entity_id <> p_datasub_info.entity_id

Line 719: INSERT INTO gcs_data_sub_dtls

715: FOR v_translated_balances IN c_translated_balances(FND_GLOBAL.CONC_REQUEST_ID,
716: p_datasub_info.balances_rule_id,
717: p_datasub_info.ledger_id,
718: p_datasub_info.cal_period_id) LOOP
719: INSERT INTO gcs_data_sub_dtls
720: (load_id,
721: load_name,
722: entity_id,
723: cal_period_id,

Line 744: SELECT gcs_data_sub_dtls_s.nextval,

740: most_recent_flag,
741: associated_request_id,
742: status_code,
743: balances_rule_id)
744: SELECT gcs_data_sub_dtls_s.nextval,
745: gcs_data_sub_dtls_s.nextval,
746: gdsd.entity_id,
747: gdsd.cal_period_id,
748: v_translated_balances.translated_currency,

Line 745: gcs_data_sub_dtls_s.nextval,

741: associated_request_id,
742: status_code,
743: balances_rule_id)
744: SELECT gcs_data_sub_dtls_s.nextval,
745: gcs_data_sub_dtls_s.nextval,
746: gdsd.entity_id,
747: gdsd.cal_period_id,
748: v_translated_balances.translated_currency,
749: gdsd.balance_type_code,

Line 768: FROM gcs_data_sub_dtls gdsd

764: gdsd.most_recent_flag,
765: gdsd.associated_request_id,
766: 'IN_PROGRESS',
767: gdsd.balances_rule_id
768: FROM gcs_data_sub_dtls gdsd
769: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID;
770:
771: END LOOP;
772:

Line 781: UPDATE gcs_data_sub_dtls

777: INTO l_status_code
778: FROM fnd_concurrent_requests
779: WHERE request_id = FND_GLOBAL.conc_request_id;
780:
781: UPDATE gcs_data_sub_dtls
782: SET status_code = DECODE(l_status_code,
783: 'C',
784: 'COMPLETED',
785: 'E',

Line 797: UPDATE gcs_data_sub_dtls prev_runs

793: last_update_date = SYSDATE
794: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
795:
796: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads
797: UPDATE gcs_data_sub_dtls prev_runs
798: SET most_recent_flag = 'N'
799: WHERE EXISTS (SELECT 'X'
800: FROM gcs_data_sub_dtls curr_run
801: WHERE curr_run.associated_request_id =

Line 800: FROM gcs_data_sub_dtls curr_run

796: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads
797: UPDATE gcs_data_sub_dtls prev_runs
798: SET most_recent_flag = 'N'
799: WHERE EXISTS (SELECT 'X'
800: FROM gcs_data_sub_dtls curr_run
801: WHERE curr_run.associated_request_id =
802: FND_GLOBAL.conc_request_id
803: AND curr_run.entity_id = prev_runs.entity_id
804: AND curr_run.cal_period_id = prev_runs.cal_period_id

Line 866: UPDATE gcs_data_sub_dtls

862:
863: END LOOP;
864:
865: ELSE
866: UPDATE gcs_data_sub_dtls
867: SET status_code = DECODE(l_status_code,
868: 'C',
869: 'COMPLETED',
870: 'E',

Line 906: UPDATE gcs_data_sub_dtls

902: fnd_file.put_line(fnd_file.log, 'An unexpected error occurred');
903: fnd_file.put_line(fnd_file.log,
904: 'The following SQL Error happened : ' || SQLERRM);
905:
906: UPDATE gcs_data_sub_dtls
907: SET status_code = DECODE(l_status_code,
908: 'C',
909: 'COMPLETED',
910: 'E',

Line 922: UPDATE gcs_data_sub_dtls prev_runs

918: last_update_date = SYSDATE
919: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
920:
921: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads
922: UPDATE gcs_data_sub_dtls prev_runs
923: SET most_recent_flag = 'N'
924: WHERE EXISTS (SELECT 'X'
925: FROM gcs_data_sub_dtls curr_run
926: WHERE curr_run.associated_request_id =

Line 925: FROM gcs_data_sub_dtls curr_run

921: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads
922: UPDATE gcs_data_sub_dtls prev_runs
923: SET most_recent_flag = 'N'
924: WHERE EXISTS (SELECT 'X'
925: FROM gcs_data_sub_dtls curr_run
926: WHERE curr_run.associated_request_id =
927: FND_GLOBAL.conc_request_id
928: AND curr_run.entity_id = prev_runs.entity_id
929: AND curr_run.cal_period_id = prev_runs.cal_period_id

Line 967: FROM gcs_data_sub_dtls gdsd

963:
964: BEGIN
965: SELECT gdsd.locked_flag
966: INTO l_locked_flag
967: FROM gcs_data_sub_dtls gdsd
968: WHERE gdsd.entity_id = l_datasub_info.entity_id
969: AND gdsd.cal_period_id = l_datasub_info.cal_period_id
970: AND gdsd.balance_type_code = l_datasub_info.balance_type_code
971: AND NVL(gdsd.currency_code, 'X') = l_datasub_info.currency_code

Line 981: UPDATE gcs_data_sub_dtls

977: END;
978:
979: IF (l_locked_flag = 'N') THEN
980:
981: UPDATE gcs_data_sub_dtls
982: SET most_recent_flag = 'N'
983: WHERE entity_id = l_datasub_info.entity_id
984: AND cal_period_id = l_datasub_info.cal_period_id
985: AND NVL(currency_code, 'X') = l_datasub_info.currency_code

Line 988: UPDATE gcs_data_sub_dtls

984: AND cal_period_id = l_datasub_info.cal_period_id
985: AND NVL(currency_code, 'X') = l_datasub_info.currency_code
986: AND balance_type_code = l_datasub_info.balance_type_code;
987:
988: UPDATE gcs_data_sub_dtls
989: SET most_recent_flag = 'Y',
990: associated_request_id = FND_GLOBAL.conc_request_id
991: WHERE load_id = p_load_id;
992:

Line 1014: --record from gcs_data_sub_dtls which is failed to submit.

1010: p_datasub_info => l_datasub_info);
1011: END IF;
1012:
1013: --Bugfix 6016288: If Locked, Put the message into log file, set the request status to warning and delete the
1014: --record from gcs_data_sub_dtls which is failed to submit.
1015: ElSE
1016: fnd_file.put_line(fnd_file.log,
1017: 'Recent Submission is locked, Unlock it and Resubmit');
1018:

Line 1019: DELETE gcs_data_sub_dtls

1015: ElSE
1016: fnd_file.put_line(fnd_file.log,
1017: 'Recent Submission is locked, Unlock it and Resubmit');
1018:
1019: DELETE gcs_data_sub_dtls
1020: WHERE load_id = l_datasub_info.load_id;
1021:
1022: x_retcode := 1;
1023:

Line 1469: UPDATE gcs_data_sub_dtls

1465:
1466: --Bugfix 5261560: Trap errors on transfer to inform the user on errors
1467: EXCEPTION
1468: WHEN DUP_VAL_ON_INDEX THEN
1469: UPDATE gcs_data_sub_dtls
1470: SET status_code = 'INVALID_FEM_INDEX'
1471: WHERE load_id = p_load_id;
1472:
1473: p_transfer_status := 'ERROR';

Line 1489: UPDATE gcs_data_sub_dtls

1485: END IF;
1486: COMMIT;
1487:
1488: WHEN OTHERS THEN
1489: UPDATE gcs_data_sub_dtls
1490: SET status_code = 'TRANSFER_ERROR'
1491: WHERE load_id = p_load_id;
1492:
1493: p_transfer_status := 'ERROR';

Line 1648: UPDATE gcs_data_sub_dtls

1644: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1645: p_result := 'COMPLETE:T';
1646: ELSE
1647: p_result := 'COMPLETE:F';
1648: UPDATE gcs_data_sub_dtls
1649: SET status_code = 'TRANSFORMATION_FAILED'
1650: WHERE load_id = l_datasub_info.load_id;
1651: END IF;
1652:

Line 1729: UPDATE gcs_data_sub_dtls

1725: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1726: p_result := 'COMPLETE:T';
1727: ELSE
1728: p_result := 'COMPLETE:F';
1729: UPDATE gcs_data_sub_dtls
1730: SET status_code = 'VALIDATION_FAILED'
1731: WHERE load_id = l_datasub_info.load_id;
1732: END IF;
1733:

Line 1793: FROM gcs_data_sub_dtls gdsd

1789: ('INITIAL_LOAD', 'UNDO_AND_REPLACE', 'REPLACE')) THEN
1790: BEGIN
1791: SELECT 'N'
1792: INTO l_first_ever_loaded
1793: FROM gcs_data_sub_dtls gdsd
1794: WHERE gdsd.entity_id = l_datasub_info.entity_id
1795: AND gdsd.balance_type_code = l_datasub_info.balance_type_code
1796: AND gdsd.cal_period_id < l_datasub_info.cal_period_id
1797: AND NVL(gdsd.currency_code, l_func_crncy_code) =

Line 2121: UPDATE gcs_data_sub_dtls

2117: INTO l_status_code
2118: FROM fnd_concurrent_requests
2119: WHERE request_id = FND_GLOBAL.conc_request_id;
2120:
2121: UPDATE gcs_data_sub_dtls
2122: SET status_code = DECODE(l_status_code,
2123: 'C',
2124: 'COMPLETED',
2125: 'E',

Line 2269: UPDATE gcs_data_sub_dtls

2265: FND_FILE.NEW_LINE(FND_FILE.LOG);
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< End of Error >>>>');
2267: FND_FILE.NEW_LINE(FND_FILE.LOG);
2268:
2269: UPDATE gcs_data_sub_dtls
2270: SET status_code = 'VALIDATION_MEMBERS_FAILED'
2271: WHERE load_id = l_datasub_info.load_id;
2272:
2273: p_result := 'COMPLETE:F';

Line 2418: FROM gcs_data_sub_dtls

2414: BEGIN
2415:
2416: SELECT 'Y'
2417: INTO l_data_sub_exists_via_ui
2418: FROM gcs_data_sub_dtls
2419: WHERE associated_request_id = l_base_request_id
2420: AND cal_period_id = l_cal_period_id
2421: AND ROWNUM < 2;
2422:

Line 2568: ' Updating gcs_data_sub_dtls for ACTUAL');

2564:
2565: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2567: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2568: ' Updating gcs_data_sub_dtls for ACTUAL');
2569: END IF;
2570:
2571: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2572: UPDATE gcs_data_sub_dtls

Line 2572: UPDATE gcs_data_sub_dtls

2568: ' Updating gcs_data_sub_dtls for ACTUAL');
2569: END IF;
2570:
2571: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2572: UPDATE gcs_data_sub_dtls
2573: SET most_recent_flag = 'N'
2574: WHERE most_recent_flag = 'Y'
2575: AND cal_period_id = l_cal_period_id
2576: AND balance_type_code = 'ACTUAL'

Line 2582: ' Inserting into gcs_data_sub_dtls for ACTUAL');

2578:
2579: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2580: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2581: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2582: ' Inserting into gcs_data_sub_dtls for ACTUAL');
2583: END IF;
2584:
2585: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2586: INSERT INTO gcs_data_sub_dtls

Line 2586: INSERT INTO gcs_data_sub_dtls

2582: ' Inserting into gcs_data_sub_dtls for ACTUAL');
2583: END IF;
2584:
2585: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2586: INSERT INTO gcs_data_sub_dtls
2587: (load_id,
2588: load_name,
2589: entity_id,
2590: cal_period_id,

Line 2613: (gcs_data_sub_dtls_s.nextval,

2609: associated_request_id,
2610: status_code,
2611: balances_rule_id)
2612: VALUES
2613: (gcs_data_sub_dtls_s.nextval,
2614: gcs_data_sub_dtls_s.nextval,
2615: l_entity_list(i),
2616: l_cal_period_id,
2617: l_curr_code,

Line 2614: gcs_data_sub_dtls_s.nextval,

2610: status_code,
2611: balances_rule_id)
2612: VALUES
2613: (gcs_data_sub_dtls_s.nextval,
2614: gcs_data_sub_dtls_s.nextval,
2615: l_entity_list(i),
2616: l_cal_period_id,
2617: l_curr_code,
2618: 'ACTUAL',

Line 2655: ' Updating gcs_data_sub_dtls for ADB');

2651:
2652: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2654: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2655: ' Updating gcs_data_sub_dtls for ADB');
2656: END IF;
2657:
2658: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2659: UPDATE gcs_data_sub_dtls

Line 2659: UPDATE gcs_data_sub_dtls

2655: ' Updating gcs_data_sub_dtls for ADB');
2656: END IF;
2657:
2658: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2659: UPDATE gcs_data_sub_dtls
2660: SET most_recent_flag = 'N'
2661: WHERE most_recent_flag = 'Y'
2662: AND cal_period_id = l_cal_period_id
2663: AND balance_type_code = 'ADB'

Line 2669: ' Inserting into gcs_data_sub_dtls for ADB');

2665:
2666: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2668: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2669: ' Inserting into gcs_data_sub_dtls for ADB');
2670: END IF;
2671:
2672: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2673: INSERT INTO gcs_data_sub_dtls

Line 2673: INSERT INTO gcs_data_sub_dtls

2669: ' Inserting into gcs_data_sub_dtls for ADB');
2670: END IF;
2671:
2672: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2673: INSERT INTO gcs_data_sub_dtls
2674: (load_id,
2675: load_name,
2676: entity_id,
2677: cal_period_id,

Line 2700: (gcs_data_sub_dtls_s.nextval,

2696: associated_request_id,
2697: status_code,
2698: balances_rule_id)
2699: VALUES
2700: (gcs_data_sub_dtls_s.nextval,
2701: gcs_data_sub_dtls_s.nextval,
2702: l_entity_list(i),
2703: l_cal_period_id,
2704: l_curr_code,

Line 2701: gcs_data_sub_dtls_s.nextval,

2697: status_code,
2698: balances_rule_id)
2699: VALUES
2700: (gcs_data_sub_dtls_s.nextval,
2701: gcs_data_sub_dtls_s.nextval,
2702: l_entity_list(i),
2703: l_cal_period_id,
2704: l_curr_code,
2705: 'ADB',

Line 2894: ' Updating gcs_data_sub_dtls for ACTUAL');

2890:
2891: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2893: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2894: ' Updating gcs_data_sub_dtls for ACTUAL');
2895: END IF;
2896:
2897: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2898: UPDATE gcs_data_sub_dtls

Line 2898: UPDATE gcs_data_sub_dtls

2894: ' Updating gcs_data_sub_dtls for ACTUAL');
2895: END IF;
2896:
2897: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2898: UPDATE gcs_data_sub_dtls
2899: SET most_recent_flag = 'N'
2900: WHERE most_recent_flag = 'Y'
2901: AND cal_period_id = l_cal_period_id
2902: AND balance_type_code = 'ACTUAL'

Line 2908: ' Inserting gcs_data_sub_dtls for ACTUAL');

2904:
2905: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2906: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2907: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2908: ' Inserting gcs_data_sub_dtls for ACTUAL');
2909: END IF;
2910:
2911: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2912: INSERT INTO gcs_data_sub_dtls

Line 2912: INSERT INTO gcs_data_sub_dtls

2908: ' Inserting gcs_data_sub_dtls for ACTUAL');
2909: END IF;
2910:
2911: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2912: INSERT INTO gcs_data_sub_dtls
2913: (load_id,
2914: load_name,
2915: entity_id,
2916: cal_period_id,

Line 2939: (gcs_data_sub_dtls_s.nextval,

2935: associated_request_id,
2936: status_code,
2937: balances_rule_id)
2938: VALUES
2939: (gcs_data_sub_dtls_s.nextval,
2940: gcs_data_sub_dtls_s.nextval,
2941: l_entity_list(i),
2942: l_cal_period_id,
2943: l_curr_code,

Line 2940: gcs_data_sub_dtls_s.nextval,

2936: status_code,
2937: balances_rule_id)
2938: VALUES
2939: (gcs_data_sub_dtls_s.nextval,
2940: gcs_data_sub_dtls_s.nextval,
2941: l_entity_list(i),
2942: l_cal_period_id,
2943: l_curr_code,
2944: 'ACTUAL',

Line 2981: ' Updating gcs_data_sub_dtls for ADB');

2977:
2978: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2980: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2981: ' Updating gcs_data_sub_dtls for ADB');
2982: END IF;
2983:
2984: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2985: UPDATE gcs_data_sub_dtls

Line 2985: UPDATE gcs_data_sub_dtls

2981: ' Updating gcs_data_sub_dtls for ADB');
2982: END IF;
2983:
2984: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2985: UPDATE gcs_data_sub_dtls
2986: SET most_recent_flag = 'N'
2987: WHERE most_recent_flag = 'Y'
2988: AND cal_period_id = l_cal_period_id
2989: AND balance_type_code = 'ADB'

Line 2995: ' Inserting into gcs_data_sub_dtls for ADB');

2991:
2992: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2993: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2994: g_api || '.POPULATE_OGL_DATASUB_DTLS',
2995: ' Inserting into gcs_data_sub_dtls for ADB');
2996: END IF;
2997:
2998: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2999: INSERT INTO gcs_data_sub_dtls

Line 2999: INSERT INTO gcs_data_sub_dtls

2995: ' Inserting into gcs_data_sub_dtls for ADB');
2996: END IF;
2997:
2998: FORALL i IN l_entity_list.FIRST .. l_entity_list.LAST
2999: INSERT INTO gcs_data_sub_dtls
3000: (load_id,
3001: load_name,
3002: entity_id,
3003: cal_period_id,

Line 3026: (gcs_data_sub_dtls_s.nextval,

3022: associated_request_id,
3023: status_code,
3024: balances_rule_id)
3025: VALUES
3026: (gcs_data_sub_dtls_s.nextval,
3027: gcs_data_sub_dtls_s.nextval,
3028: l_entity_list(i),
3029: l_cal_period_id,
3030: l_curr_code,

Line 3027: gcs_data_sub_dtls_s.nextval,

3023: status_code,
3024: balances_rule_id)
3025: VALUES
3026: (gcs_data_sub_dtls_s.nextval,
3027: gcs_data_sub_dtls_s.nextval,
3028: l_entity_list(i),
3029: l_cal_period_id,
3030: l_curr_code,
3031: 'ADB',

Line 3092: INSERT INTO gcs_data_sub_dtls

3088: '<< Processing Translated Currencies >>');
3089: END IF;
3090:
3091: FORALL i IN l_xlated_curr_list.FIRST .. l_xlated_curr_list.LAST
3092: INSERT INTO gcs_data_sub_dtls
3093: (load_id,
3094: load_name,
3095: entity_id,
3096: cal_period_id,

Line 3118: SELECT gcs_data_sub_dtls_s.nextval,

3114: most_recent_flag,
3115: associated_request_id,
3116: status_code,
3117: balances_rule_id)
3118: SELECT gcs_data_sub_dtls_s.nextval,
3119: gcs_data_sub_dtls_s.nextval,
3120: gdsd.entity_id,
3121: gdsd.cal_period_id,
3122: l_xlated_curr_list(i),

Line 3119: gcs_data_sub_dtls_s.nextval,

3115: associated_request_id,
3116: status_code,
3117: balances_rule_id)
3118: SELECT gcs_data_sub_dtls_s.nextval,
3119: gcs_data_sub_dtls_s.nextval,
3120: gdsd.entity_id,
3121: gdsd.cal_period_id,
3122: l_xlated_curr_list(i),
3123: gdsd.balance_type_code,

Line 3143: FROM gcs_data_sub_dtls gdsd

3139: gdsd.most_recent_flag,
3140: gdsd.associated_request_id,
3141: gdsd.status_code,
3142: gdsd.balances_rule_id
3143: FROM gcs_data_sub_dtls gdsd
3144: WHERE gdsd.associated_request_id = l_base_request_id
3145: AND gdsd.cal_period_id = l_cal_period_id;
3146: ELSE
3147:

Line 3160: FROM gcs_data_sub_dtls gdsd

3156: COMMIT;
3157:
3158: SELECT gdsd.load_id BULK COLLECT
3159: INTO l_generated_load_list
3160: FROM gcs_data_sub_dtls gdsd
3161: WHERE gdsd.associated_request_id = l_base_request_id
3162: AND gdsd.cal_period_id = l_cal_period_id;
3163:
3164: IF l_generated_load_list.FIRST IS NOT NULL AND

Line 3373: gcs_data_sub_dtls gdsd,

3369: SELECT gdsd.load_id,
3370: gdsd.most_recent_flag
3371: BULK COLLECT INTO l_load_list
3372: FROM gcs_entities_attr gea,
3373: gcs_data_sub_dtls gdsd,
3374: fem_cal_periods_attr fcpa
3375: WHERE gea.ledger_id = l_ledger_id
3376: AND gdsd.cal_period_id = l_cal_period_id
3377: AND gdsd.balance_type_code IN ('ACTUAL', 'ADB')

Line 3392: gcs_data_sub_dtls gdsd,

3388: SELECT gdsd.load_id,
3389: gdsd.most_recent_flag
3390: BULK COLLECT INTO l_load_list
3391: FROM gcs_entities_attr gea,
3392: gcs_data_sub_dtls gdsd,
3393: fem_cal_periods_attr fcpa
3394: WHERE gea.ledger_id = l_ledger_id
3395: AND gdsd.cal_period_id = l_cal_period_id
3396: AND gdsd.balance_type_code = l_data_type_code

Line 3424: '<< Update gcs_data_sub_dtls status and >>');

3420:
3421: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3422: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3423: g_api || '.HANDLE_UNDO_EVENT',
3424: '<< Update gcs_data_sub_dtls status and >>');
3425: END IF;
3426: -- Bugfix 5664023 :Start
3427: FOR k IN l_load_list.FIRST .. l_load_list.LAST LOOP
3428:

Line 3429: UPDATE gcs_data_sub_dtls

3425: END IF;
3426: -- Bugfix 5664023 :Start
3427: FOR k IN l_load_list.FIRST .. l_load_list.LAST LOOP
3428:
3429: UPDATE gcs_data_sub_dtls
3430: SET status_code = 'UNDONE'
3431: WHERE load_id = l_load_list(k).load_id;
3432:
3433: IF (l_load_list(k).most_recent_flag = 'Y') THEN