APPS.AR_POSTBATCH_PARALLEL dependencies on AR_BATCHES

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

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

Line 55: l_batch_id ar_batches.batch_id%TYPE;

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

Line 60: l_status ar_batches.status%TYPE;

56: l_excep_code NUMBER(2);
57: l_matched_claim_creation VARCHAR2(2);
58: l_matched_claim_excl_cm VARCHAR2(2);
59: l_return_status VARCHAR2(1);
60: l_status ar_batches.status%TYPE;
61:
62: CURSOR qcbatch IS
63: SELECT ab.name batch_name,
64: abs.name batch_source_name,

Line 78: FROM ar_batches ab,

74: cba.bank_account_num,
75: ab.currency_code,
76: to_number(to_char(ab.gl_date, 'J')),
77: to_number(to_char(ab.deposit_date, 'J'))
78: FROM ar_batches ab,
79: ar_batch_sources abs,
80: ce_bank_accounts cba,
81: ce_bank_acct_uses_all ba
82: WHERE ab.batch_source_id = abs.batch_source_id

Line 107: FROM ar_batches ab,

103: ab.currency_code,
104: to_number(to_char(ab.gl_date, 'J')),
105: to_number(to_char(ab.deposit_date, 'J')),
106: ab.batch_id
107: FROM ar_batches ab,
108: ar_batch_sources abs,
109: ce_bank_accounts cba,
110: ce_bank_acct_uses_all ba
111: WHERE ab.batch_source_id = abs.batch_source_id

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

215: | MODIFICATION HISTORY - 09/01/2008 - Created by AGHORAKA |
216: +===========================================================================*/
217:
218:
219: PROCEDURE update_batch_after_process( p_batch_id ar_batches.batch_id%TYPE,
220: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
221: p_ct_cnt NUMBER,
222: p_ct_amt NUMBER
223: ) AS

Line 220: p_batch_applied_status ar_batches.batch_applied_status%TYPE,

216: +===========================================================================*/
217:
218:
219: PROCEDURE update_batch_after_process( p_batch_id ar_batches.batch_id%TYPE,
220: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
221: p_ct_cnt NUMBER,
222: p_ct_amt NUMBER
223: ) AS
224: l_act_app_cnt NUMBER;

Line 259: UPDATE ar_batches

255: WHERE batch_id = p_batch_id;
256:
257: IF ( l_err_receipt_cnt = 0) THEN
258: fnd_file.put_line( FND_FILE.LOG, 'Updating batch_applied_status to PROCESSED.' );
259: UPDATE ar_batches
260: SET batch_applied_status = 'PROCESSED',
261: status = l_status,
262: last_updated_by = G_USER_ID,
263: last_update_date = sysdate,

Line 320: FROM ar_batches

316: fnd_file.put_line( FND_FILE.OUTPUT, fnd_message.get_string('AR', 'ARCABP_NOT_VALID_BATCH'));
317: ELSE
318: SELECT 'locked'
319: INTO l_locked_status
320: FROM ar_batches
321: WHERE batch_id = lbr.batch_id
322: FOR UPDATE OF batch_applied_status, status,
323: last_update_date, last_updated_by;
324: UPDATE ar_batches

Line 324: UPDATE ar_batches

320: FROM ar_batches
321: WHERE batch_id = lbr.batch_id
322: FOR UPDATE OF batch_applied_status, status,
323: last_update_date, last_updated_by;
324: UPDATE ar_batches
325: SET batch_applied_status = 'IN_PROCESS',
326: last_update_date = sysdate,
327: last_updated_by = G_USER_ID,
328: program_id = G_CONC_PROGRAM_ID,

Line 354: FROM ar_batches

350: goto leave_program;
351: ELSE
352: SELECT 'locked'
353: INTO l_locked_status
354: FROM ar_batches
355: WHERE batch_id = p_batch_id
356: FOR UPDATE OF batch_applied_status, status,
357: last_update_date, last_updated_by;
358: UPDATE ar_batches

Line 358: UPDATE ar_batches

354: FROM ar_batches
355: WHERE batch_id = p_batch_id
356: FOR UPDATE OF batch_applied_status, status,
357: last_update_date, last_updated_by;
358: UPDATE ar_batches
359: SET batch_applied_status = 'IN_PROCESS',
360: last_update_date = sysdate,
361: last_updated_by = G_USER_ID,
362: program_id = G_CONC_PROGRAM_ID,

Line 477: FROM ar_batches b

473: last_updated_by = G_USER_ID,
474: last_update_date = trunc(sysdate)
475: WHERE transmission_id = p_transmission_id
476: AND NOT EXISTS ( SELECT 'pending post'
477: FROM ar_batches b
478: WHERE b.transmission_id =
479: t.transmission_id
480: AND batch_applied_status
481: = 'POSTBATCH_WAITING' )

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

521: | MODIFICATION HISTORY - 09/01/2008 - Created by AGHORAKA |
522: +===========================================================================*/
523:
524:
525: PROCEDURE update_batch_for_rerun( p_status IN ar_batches.status%TYPE,
526: p_batch_id IN NUMBER) AS
527: BEGIN
528: fnd_file.put_line( FND_FILE.LOG, 'update_batch_for_rerun()+');
529:

Line 530: UPDATE ar_batches

526: p_batch_id IN NUMBER) AS
527: BEGIN
528: fnd_file.put_line( FND_FILE.LOG, 'update_batch_for_rerun()+');
529:
530: UPDATE ar_batches
531: SET batch_applied_status = 'POSTBATCH_WAITING',
532: status = p_status,
533: last_updated_by = G_USER_ID,
534: last_update_date = sysdate,