APPS.AR_POSTBATCH_PARALLEL dependencies on AR_BATCHES

Line 54: l_batch_applied_status ar_batches.batch_applied_status%TYPE := 'POSTBATCH_WAITING';

50: p_total_workers IN NUMBER DEFAULT 1 ) AS
51:
52: l_worker_number NUMBER ;
53: l_complete BOOLEAN := FALSE;
54: l_batch_applied_status ar_batches.batch_applied_status%TYPE := 'POSTBATCH_WAITING';
55: l_ct_cnt NUMBER;
56: l_ct_amt NUMBER;
57: l_locked_status VARCHAR2(10);
58: l_batch_id ar_batches.batch_id%TYPE;

Line 58: l_batch_id ar_batches.batch_id%TYPE;

54: l_batch_applied_status ar_batches.batch_applied_status%TYPE := 'POSTBATCH_WAITING';
55: l_ct_cnt NUMBER;
56: l_ct_amt NUMBER;
57: l_locked_status VARCHAR2(10);
58: l_batch_id ar_batches.batch_id%TYPE;
59: l_excep_code NUMBER(2);
60: l_matched_claim_creation VARCHAR2(2);
61: l_matched_claim_excl_cm VARCHAR2(2);
62: l_return_status VARCHAR2(1);

Line 63: l_status ar_batches.status%TYPE;

59: l_excep_code NUMBER(2);
60: l_matched_claim_creation VARCHAR2(2);
61: l_matched_claim_excl_cm VARCHAR2(2);
62: l_return_status VARCHAR2(1);
63: l_status ar_batches.status%TYPE;
64: l_allow_unearn_disc VARCHAR2(1);
65: l_app_unearn_disc VARCHAR2(1);
66:
67: CURSOR qcbatch IS

Line 83: FROM ar_batches ab,

79: cba.bank_account_num,
80: ab.currency_code,
81: to_number(to_char(ab.gl_date, 'J')),
82: to_number(to_char(ab.deposit_date, 'J'))
83: FROM ar_batches ab,
84: ar_batch_sources abs,
85: ce_bank_accounts cba,
86: ce_bank_acct_uses_all ba
87: WHERE ab.batch_source_id = abs.batch_source_id

Line 112: FROM ar_batches ab,

108: ab.currency_code,
109: to_number(to_char(ab.gl_date, 'J')),
110: to_number(to_char(ab.deposit_date, 'J')),
111: ab.batch_id
112: FROM ar_batches ab,
113: ar_batch_sources abs,
114: ce_bank_accounts cba,
115: ce_bank_acct_uses_all ba
116: WHERE ab.batch_source_id = abs.batch_source_id

Line 226: PROCEDURE update_batch_after_process( p_batch_id ar_batches.batch_id%TYPE,

222: | MODIFICATION HISTORY - 09/01/2008 - Created by AGHORAKA |
223: +===========================================================================*/
224:
225:
226: PROCEDURE update_batch_after_process( p_batch_id ar_batches.batch_id%TYPE,
227: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
228: p_ct_cnt NUMBER,
229: p_ct_amt NUMBER
230: ) AS

Line 227: p_batch_applied_status ar_batches.batch_applied_status%TYPE,

223: +===========================================================================*/
224:
225:
226: PROCEDURE update_batch_after_process( p_batch_id ar_batches.batch_id%TYPE,
227: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
228: p_ct_cnt NUMBER,
229: p_ct_amt NUMBER
230: ) AS
231: l_act_app_cnt NUMBER;

Line 266: UPDATE ar_batches

262: WHERE batch_id = p_batch_id;
263:
264: IF ( l_err_receipt_cnt = 0) THEN
265: fnd_file.put_line( FND_FILE.LOG, 'Updating batch_applied_status to PROCESSED.' );
266: UPDATE ar_batches
267: SET batch_applied_status = 'PROCESSED',
268: status = l_status,
269: last_updated_by = G_USER_ID,
270: last_update_date = sysdate,

Line 349: FROM ar_batches

345: fnd_file.put_line( FND_FILE.OUTPUT, fnd_message.get_string('AR', 'ARCABP_NOT_VALID_BATCH'));
346: ELSE
347: SELECT 'locked'
348: INTO l_locked_status
349: FROM ar_batches
350: WHERE batch_id = lbr.batch_id
351: FOR UPDATE OF batch_applied_status, status,
352: last_update_date, last_updated_by;
353: UPDATE ar_batches

Line 353: UPDATE ar_batches

349: FROM ar_batches
350: WHERE batch_id = lbr.batch_id
351: FOR UPDATE OF batch_applied_status, status,
352: last_update_date, last_updated_by;
353: UPDATE ar_batches
354: SET batch_applied_status = 'IN_PROCESS',
355: last_update_date = sysdate,
356: last_updated_by = G_USER_ID,
357: program_id = G_CONC_PROGRAM_ID,

Line 383: FROM ar_batches

379: goto leave_program;
380: ELSE
381: SELECT 'locked'
382: INTO l_locked_status
383: FROM ar_batches
384: WHERE batch_id = p_batch_id
385: FOR UPDATE OF batch_applied_status, status,
386: last_update_date, last_updated_by;
387: UPDATE ar_batches

Line 387: UPDATE ar_batches

383: FROM ar_batches
384: WHERE batch_id = p_batch_id
385: FOR UPDATE OF batch_applied_status, status,
386: last_update_date, last_updated_by;
387: UPDATE ar_batches
388: SET batch_applied_status = 'IN_PROCESS',
389: last_update_date = sysdate,
390: last_updated_by = G_USER_ID,
391: program_id = G_CONC_PROGRAM_ID,

Line 506: FROM ar_batches b

502: last_updated_by = G_USER_ID,
503: last_update_date = trunc(sysdate)
504: WHERE transmission_id = p_transmission_id
505: AND NOT EXISTS ( SELECT 'pending post'
506: FROM ar_batches b
507: WHERE b.transmission_id =
508: t.transmission_id
509: AND batch_applied_status
510: = 'POSTBATCH_WAITING' )

Line 554: PROCEDURE update_batch_for_rerun( p_status IN ar_batches.status%TYPE,

550: | MODIFICATION HISTORY - 09/01/2008 - Created by AGHORAKA |
551: +===========================================================================*/
552:
553:
554: PROCEDURE update_batch_for_rerun( p_status IN ar_batches.status%TYPE,
555: p_batch_id IN NUMBER) AS
556: BEGIN
557: fnd_file.put_line( FND_FILE.LOG, 'update_batch_for_rerun()+');
558:

Line 559: UPDATE ar_batches

555: p_batch_id IN NUMBER) AS
556: BEGIN
557: fnd_file.put_line( FND_FILE.LOG, 'update_batch_for_rerun()+');
558:
559: UPDATE ar_batches
560: SET batch_applied_status = 'POSTBATCH_WAITING',
561: status = p_status,
562: last_updated_by = G_USER_ID,
563: last_update_date = sysdate,