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,
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',
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,
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,
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,
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,
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,
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',
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,
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',
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,
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',
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,
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',
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),
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,
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: