APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_BATCHES

Line 686: l_batch_id XTR_BATCHES.BATCH_ID%TYPE;

682: l_amount_to_accrue_amort NUMBER;
683: l_amount_type VARCHAR2(7);
684: l_back_end_interest NUMBER;
685: l_balance_out NUMBER;
686: l_batch_id XTR_BATCHES.BATCH_ID%TYPE;
687: l_batch_start VARCHAR2(30);
688: l_bond_issue VARCHAR2(7);
689: l_calc_period_end DATE;
690: l_calc_period_accrl_int NUMBER;

Line 762: select XTR_BATCHES_S.NEXTVAL

758: /*-----------------------------------------------------*/
759: /* If batch start from Accruals, generate new Batch_id */
760: /*-----------------------------------------------------*/
761: cursor GEN_BATCH is
762: select XTR_BATCHES_S.NEXTVAL
763: from DUAL;
764:
765: /*-----------------------*/
766: /* Generate new Event_id */

Line 1408: Insert into XTR_BATCHES(batch_id, company_code, period_start, period_end,

1404: Fetch GEN_BATCH into l_batch_id;
1405: Close GEN_BATCH;
1406:
1407: -- Insert new row to XTR_BATCH when new batch process staring from accrual
1408: Insert into XTR_BATCHES(batch_id, company_code, period_start, period_end,
1409: gl_group_id, upgrade_batch, created_by, creation_date,
1410: last_updated_by, last_update_date, last_update_login)
1411: values (l_batch_id, p_company, p_start_date, p_end_date,
1412: null, nvl(p_upgrade_batch,'N'), fnd_global.user_id, l_sysdate,