DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on GCS_DATA_SUB_DTLS_S

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 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 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 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 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 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 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 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 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: