755: --- Get group id
756: ---
757: SELECT gl_interface_control_s.NEXTVAL
758: INTO g_group_id
759: FROM DUAL;
760:
761: ---
762: --- If we are running in full mode, and this period is before the
763: --- first period ever transferred, then make it the first period
1427:
1428: BEGIN
1429: SELECT 1
1430: INTO l_dummy
1431: FROM dual
1432: WHERE EXISTS
1433: (SELECT 'has errors'
1434: FROM gl_accts_map_int_gt
1435: WHERE error_code IS NOT NULL);
1640: gl_balances_delta_s.nextval,
1641: sysdate, g_user_id,
1642: sysdate, g_user_id,
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
1668: g_from_ledger_id, 'FUSIONTRANSFER', g_from_period, 'A',
1669: 'DTL', 'B',
1670: 'Y', sysdate, g_user_id,
1671: sysdate, g_user_id, g_login_id
1672: FROM dual
1673: WHERE NOT EXISTS (
1674: SELECT 'row exists'
1675: FROM gl_track_delta_balances t2
1676: WHERE t2.ledger_id = g_from_ledger_id