APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_TRX_BATCHES_S

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

705: l_running_total_dr := 0;
706: l_running_total_cr := 0;
707:
708: --Fecthing the New Batch_id
709: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;
710:
711: --Fetching the New Batch Number
712: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
713: 'LOCAL',

Line 1179: Update fun_trx_batches set gl_date =

1175: End If;
1176: close c_chk_open1;
1177: Print('Sweeping the transactions');
1178: /* Update the Periods */
1179: Update fun_trx_batches set gl_date =
1180: p_sweep_GL_date Where gl_date >= (select start_date from
1181: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1182: fps.trx_type_id = p_trx_type_id
1183: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')

Line 1227: Update fun_trx_batches set gl_date = p_sweep_GL_date

1223: Raise FND_API.G_EXC_ERROR;
1224: End If;
1225: close c_chk_open2;
1226: /* Sweep the transactions */
1227: Update fun_trx_batches set gl_date = p_sweep_GL_date
1228: Where gl_date >= (select distinct start_date from
1229: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1230: fps.trx_type_id = p_trx_type_id
1231: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')