APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_XFR_LED_MAP_PERIODS

Line 712: UPDATE gl_xfr_led_map_periods lmper

708: --- Figure out the effective date to be used
709: ---
710: IF (g_transfer_mode = C_INCREMENTAL) THEN
711: IF (g_cal_mapping_id IS NULL) THEN
712: UPDATE gl_xfr_led_map_periods lmper
713: SET temp_date = (SELECT least(greatest(trunc(sysdate),ps.start_date),ps.end_date)
714: FROM gl_period_statuses ps
715: WHERE ps.application_id = 101
716: AND ps.ledger_id = g_from_ledger_id

Line 720: UPDATE gl_xfr_led_map_periods lmper

716: AND ps.ledger_id = g_from_ledger_id
717: AND ps.period_name = lmper.from_period_name)
718: WHERE ledger_mapping_id = g_lgr_mapping_id;
719: ELSE
720: UPDATE gl_xfr_led_map_periods lmper
721: SET temp_date = (SELECT least(greatest(trunc(sysdate),per.start_date),per.end_date)
722: FROM gl_xfr_period_mappings map,
723: gl_xfr_ledgers lgr,
724: gl_xfr_periods per

Line 1137: gl_xfr_led_map_periods lmper, gl_row_multipliers mult, ';

1133:
1134: IF (g_transfer_mode = C_INCREMENTAL) THEN
1135: l_sqlbuf := l_sqlbuf || '
1136: FROM gl_balances_delta bal,
1137: gl_xfr_led_map_periods lmper, gl_row_multipliers mult, ';
1138:
1139: IF (g_coa_mapping_id IS NOT NULL) THEN
1140: l_sqlbuf := l_sqlbuf || '
1141: gl_xfr_ccid_mappings map,

Line 1596: -- and gl_xfr_led_map_periods

1592: --
1593: -- Name: update_transfer_tables
1594: -- Description:
1595: -- This routine does any necessary maintenance on gl_xfr_ledger_mappings
1596: -- and gl_xfr_led_map_periods
1597: --
1598: -- Parameters:
1599: -- *** NONE ***
1600: --=============================================================================

Line 1632: INSERT INTO gl_xfr_led_map_periods

1628: last_update_login = g_login_id
1629: WHERE ledger_mapping_id = g_lgr_mapping_id;
1630: END IF;
1631:
1632: INSERT INTO gl_xfr_led_map_periods
1633: (ledger_mapping_id, from_period_name,
1634: from_eff_per_num, full_transfer_done_flag,
1635: max_delta_run_id,
1636: creation_date, created_by, last_update_date,

Line 1647: FROM gl_xfr_led_map_periods

1643: g_login_id
1644: FROM dual
1645: WHERE NOT EXISTS
1646: (SELECT 1
1647: FROM gl_xfr_led_map_periods
1648: WHERE ledger_mapping_id = g_lgr_mapping_id
1649: AND from_period_name = g_from_period);
1650:
1651: IF (SQL%ROWCOUNT = 0) THEN

Line 1652: UPDATE gl_xfr_led_map_periods

1648: WHERE ledger_mapping_id = g_lgr_mapping_id
1649: AND from_period_name = g_from_period);
1650:
1651: IF (SQL%ROWCOUNT = 0) THEN
1652: UPDATE gl_xfr_led_map_periods
1653: SET full_transfer_done_flag = 'Y',
1654: max_delta_run_id = gl_balances_delta_s.nextval,
1655: last_update_date = sysdate,
1656: last_updated_by = g_user_id,