APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_TRX_BATCHES_S

Line 878: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;

874: l_running_total_dr := 0;
875: l_running_total_cr := 0;
876:
877: --Fecthing the New Batch_id
878: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;
879:
880: --Fetching the New Batch Number
881: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
882: 'LOCAL',

Line 1687: Update fun_trx_batches set gl_date =

1683: End If;
1684: close c_chk_open1;
1685: Print('Sweeping the transactions');
1686: /* Update the Periods */
1687: Update fun_trx_batches set gl_date =
1688: p_sweep_GL_date Where gl_date >= (select start_date from
1689: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1690: fps.trx_type_id = p_trx_type_id
1691: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')

Line 1735: Update fun_trx_batches set gl_date = p_sweep_GL_date

1731: Raise FND_API.G_EXC_ERROR;
1732: End If;
1733: close c_chk_open2;
1734: /* Sweep the transactions */
1735: Update fun_trx_batches set gl_date = p_sweep_GL_date
1736: Where gl_date >= (select distinct start_date from
1737: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1738: fps.trx_type_id = p_trx_type_id
1739: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')