eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_AUTOREC_API dependencies on AR_RECEIPTS_GT

Line 81: from AR_RECEIPTS_GT

77: program_id = pg_program_id,
78: program_update_date = sysdate
79: WHERE cash_receipt_id in
80: ( select cash_receipt_id
81: from AR_RECEIPTS_GT
82: where gt_id = p_gt_id );
83:
84: IF PG_DEBUG in ('Y','C') THEN
85: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));

Line 100: from AR_RECEIPTS_GT

96: program_id = pg_program_id,
97: program_update_date = sysdate
98: WHERE cash_receipt_id in
99: ( select cash_receipt_id
100: from AR_RECEIPTS_GT
101: where gt_id = p_gt_id );
102:
103: IF PG_DEBUG in ('Y','C') THEN
104: arp_debug.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));

Line 118: from AR_RECEIPTS_GT

114: program_id = pg_program_id,
115: program_update_date = sysdate
116: WHERE cash_receipt_id in
117: ( select cash_receipt_id
118: from AR_RECEIPTS_GT
119: where gt_id = p_gt_id );
120:
121: IF PG_DEBUG in ('Y','C') THEN
122: arp_debug.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));

Line 136: from AR_RECEIPTS_GT

132: program_id = pg_program_id,
133: program_update_date = sysdate
134: WHERE cash_receipt_id in
135: ( select cash_receipt_id
136: from AR_RECEIPTS_GT
137: where gt_id = p_gt_id );
138:
139: /* UPDATING INVOICE PS 7271561*/
140: /* Bug 10137089 : Do not update receipt_batch_id

Line 146: from ar_receipts_gt r,

142: update ar_payment_schedules
143: set selected_for_receipt_batch_id = NULL
144: where payment_schedule_id in
145: ( select /*+ unnest */ r.payment_schedule_id
146: from ar_receipts_gt r,
147: ar_receivable_applications ra,
148: ra_customer_trx ct,
149: ar_receipt_methods rm,
150: ar_receipt_classes rc

Line 161: from ar_receipts_gt r,

157: and rm.receipt_class_id = rc.receipt_class_id
158: and rc.confirm_flag = 'N'
159: UNION ALL
160: select r.payment_schedule_id
161: from ar_receipts_gt r,
162: ra_customer_trx ct
163: where r.gt_id = p_gt_id
164: and ct.customer_trx_id = r.customer_trx_id
165: and ct.cc_error_flag = 'Y'

Line 180: from AR_RECEIPTS_GT gt,

176: into l_from_doc_id,
177: l_to_doc_id,
178: l_from_ra_doc_id,
179: l_to_ra_doc_id
180: from AR_RECEIPTS_GT gt,
181: ar_receivable_applications ra
182: where gt.cash_receipt_id = ra.cash_receipt_id
183: and gt_id = p_gt_id;
184:

Line 224: from AR_RECEIPTS_GT gt,

220: Select min(ra.receivable_application_id),
221: max(ra.receivable_application_id)
222: into l_from_ra_doc_id,
223: l_to_ra_doc_id
224: from AR_RECEIPTS_GT gt,
225: ar_receivable_applications ra
226: where gt.cash_receipt_id = ra.cash_receipt_id
227: and gt_id = p_gt_id
228: and ra.event_id is null ;

Line 266: PROCEDURE dump_ar_receipts_gt IS

262:
263: END process_events;
264:
265:
266: PROCEDURE dump_ar_receipts_gt IS
267: BEGIN
268: FOR rec IN (select * from ar_receipts_gt) LOOP
269: arp_debug.debug( '------------------------------------------------------');
270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );

Line 268: FOR rec IN (select * from ar_receipts_gt) LOOP

264:
265:
266: PROCEDURE dump_ar_receipts_gt IS
267: BEGIN
268: FOR rec IN (select * from ar_receipts_gt) LOOP
269: arp_debug.debug( '------------------------------------------------------');
270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );
271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);

Line 287: END dump_ar_receipts_gt;

283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);
284: arp_debug.debug( 'GT_ID :'|| rec.gt_id);
285: END LOOP;
286:
287: END dump_ar_receipts_gt;
288:
289:
290: PROCEDURE process_incomplete_receipts(p_batch_id NUMBER) IS
291: l_receipt_method_id ar_batches.receipt_method_id%type;

Line 318: from ar_receipts_gt;

314: AND status = 'CL';
315:
316: --cleanup gt table
317: delete
318: from ar_receipts_gt;
319:
320: IF PG_DEBUG in ('Y', 'C') THEN
321: arp_debug.debug('process_incomplete_receipts()-');
322: END IF;

Line 449: from AR_RECEIPTS_GT;

445: CURSOR c2 is
446: select payment_schedule_id,
447: receipt_number rec_num,
448: amount_due_remaining amt
449: from AR_RECEIPTS_GT;
450: /* apply variables */
451:
452:
453: /* reset variables */

Line 712: insert into ar_receipts_gt(

708: END IF;
709: END IF;
710:
711: --Populating the data allocated to current worker from interim table to GT
712: insert into ar_receipts_gt(
713: payment_schedule_id,
714: customer_trx_id,
715: cash_receipt_id,
716: paying_customer_id,

Line 749: arp_debug.debug ( 'NO of rows inserted into ar_receipts_gt :'|| to_char(SQL%ROWCOUNT));

745: l_current_worker_number)
746: and a.batch_id = o_batch_id;
747:
748: IF PG_DEBUG in ('Y', 'C') THEN
749: arp_debug.debug ( 'NO of rows inserted into ar_receipts_gt :'|| to_char(SQL%ROWCOUNT));
750: END IF;
751:
752: IF l_total_workers = 0 THEN
753: IF p_approve_flag = 'Y' THEN

Line 1545: | into the GT table AR_RECEIPTS_GT |

1541: | |
1542: | DESCRIPTION |
1543: | |
1544: | This procedure is used to select the valied invoices and insert them |
1545: | into the GT table AR_RECEIPTS_GT |
1546: | PSEUDO CODE/LOGIC |
1547: | |
1548: | PARAMETERS |
1549: | |

Line 2336: SELECT /+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) / r.customer_trx_id

2332: cc_error_code = null,
2333: cc_error_text = null
2334: WHERE customer_trx_id in
2335: (
2336: SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ r.customer_trx_id
2337: FROM ar_receipts_gt r,
2338: ar_cash_receipts cr,
2339: ar_cash_receipt_history crh,
2340: iby_fndcpt_tx_operations op,

Line 2337: FROM ar_receipts_gt r,

2333: cc_error_text = null
2334: WHERE customer_trx_id in
2335: (
2336: SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ r.customer_trx_id
2337: FROM ar_receipts_gt r,
2338: ar_cash_receipts cr,
2339: ar_cash_receipt_history crh,
2340: iby_fndcpt_tx_operations op,
2341: iby_trxn_summaries_all summ

Line 2368: ( SELECT /+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) / cr.cash_receipt_id

2364: END IF;
2365:
2366: delete from ar_autorec_exceptions
2367: where cash_receipt_id in
2368: ( SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ cr.cash_receipt_id
2369: FROM ar_receipts_gt r,
2370: ar_cash_receipts cr,
2371: ar_cash_receipt_history crh,
2372: iby_fndcpt_tx_operations op,

Line 2369: FROM ar_receipts_gt r,

2365:
2366: delete from ar_autorec_exceptions
2367: where cash_receipt_id in
2368: ( SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ cr.cash_receipt_id
2369: FROM ar_receipts_gt r,
2370: ar_cash_receipts cr,
2371: ar_cash_receipt_history crh,
2372: iby_fndcpt_tx_operations op,
2373: iby_trxn_summaries_all summ

Line 2420: ar_receipts_gt r

2416: r.cash_receipt_id cash_receipt_id,
2417: ps.org_id org_id
2418: from ar_payment_schedules ps,
2419: ra_customer_trx trx,
2420: ar_receipts_gt r
2421: where trx.customer_trx_id = ps.customer_trx_id
2422: and trx.cc_error_flag = 'Y'
2423: and r.payment_schedule_id = ps.payment_schedule_id
2424: and r.gt_id = p_gt_id;

Line 2589: ar_receipts_gt r

2585: where payment_schedule_id in
2586: ( select ps.payment_schedule_id
2587: from ar_payment_schedules ps,
2588: ra_customer_trx trx,
2589: ar_receipts_gt r
2590: where r.gt_id = p_gt_id
2591: AND r.payment_schedule_id = ps.payment_schedule_id
2592: AND trx.customer_trx_id = ps.customer_trx_id
2593: and trx.cc_error_flag = 'Y');

Line 2604: ar_receipts_gt r

2600: from ar_payment_schedules
2601: where cash_receipt_id
2602: in ( select distinct ex.cash_receipt_id
2603: from ar_autorec_exceptions ex,
2604: ar_receipts_gt r
2605: where r.gt_id = p_gt_id
2606: AND r.cash_receipt_id = ex.cash_receipt_id);
2607:
2608: IF PG_DEBUG in ('Y','C') THEN

Line 2621: ar_receipts_gt r

2617: from ar_cash_receipt_history
2618: where cash_receipt_id in
2619: ( select distinct ex.cash_receipt_id
2620: from ar_autorec_exceptions ex,
2621: ar_receipts_gt r
2622: where r.gt_id = p_gt_id
2623: AND r.cash_receipt_id = ex.cash_receipt_id
2624: )
2625: );

Line 2640: ar_receipts_gt r

2636: from ar_receivable_applications
2637: where cash_receipt_id in
2638: ( select distinct ex.cash_receipt_id
2639: from ar_autorec_exceptions ex,
2640: ar_receipts_gt r
2641: where r.gt_id = p_gt_id
2642: AND r.cash_receipt_id = ex.cash_receipt_id
2643: )
2644: );

Line 2655: ar_receipts_gt r

2651: from ar_receivable_applications
2652: where cash_receipt_id in
2653: ( select distinct ex.cash_receipt_id
2654: from ar_autorec_exceptions ex,
2655: ar_receipts_gt r
2656: where r.gt_id = p_gt_id
2657: AND r.cash_receipt_id = ex.cash_receipt_id);
2658:
2659: IF PG_DEBUG in ('Y','C') THEN

Line 2668: ar_receipts_gt r

2664: from ar_cash_receipt_history
2665: where cash_receipt_id in
2666: ( select distinct ex.cash_receipt_id
2667: from ar_autorec_exceptions ex,
2668: ar_receipts_gt r
2669: where r.gt_id = p_gt_id
2670: AND r.cash_receipt_id = ex.cash_receipt_id);
2671:
2672: IF PG_DEBUG in ('Y','C') THEN

Line 2680: ar_receipts_gt r

2676: delete from ar_cash_receipts
2677: where cash_receipt_id in
2678: ( select distinct ex.cash_receipt_id
2679: from ar_autorec_exceptions ex,
2680: ar_receipts_gt r
2681: where r.gt_id = p_gt_id
2682: AND r.cash_receipt_id = ex.cash_receipt_id);
2683:
2684: IF PG_DEBUG in ('Y','C') THEN

Line 3180: PROCEDURE update_ar_receipts_gt(p_creation_rule IN VARCHAR2,

3176: END process_payments;
3177:
3178:
3179:
3180: PROCEDURE update_ar_receipts_gt(p_creation_rule IN VARCHAR2,
3181: p_update_stmt IN VARCHAR2,
3182: p_cr_id_array IN DBMS_SQL.NUMBER_TABLE,
3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,
3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,

Line 3199: arp_debug.debug('update_ar_receipts_gt()+');

3195: l_dummy NUMBER;
3196:
3197: BEGIN
3198: IF PG_DEBUG in ('Y', 'C') THEN
3199: arp_debug.debug('update_ar_receipts_gt()+');
3200: arp_debug.debug('p_creation_rule '||p_creation_rule);
3201: arp_debug.debug('p_update_stmt '||p_update_stmt);
3202: END IF;
3203:

Line 3258: arp_debug.debug('update_ar_receipts_gt()-');

3254: dbms_sql.close_cursor(l_update_cursor);
3255:
3256: IF PG_DEBUG in ('Y', 'C') THEN
3257: arp_debug.debug('Rows updated :'||SQL%ROWCOUNT);
3258: arp_debug.debug('update_ar_receipts_gt()-');
3259: END IF;
3260:
3261: EXCEPTION
3262: WHEN OTHERS THEN

Line 3266: arp_debug.debug('update_ar_receipts_gt : error code() '|| to_char(SQLCODE));

3262: WHEN OTHERS THEN
3263: if dbms_sql.is_open(l_update_cursor) then
3264: dbms_sql.close_cursor(l_update_cursor);
3265: end if;
3266: arp_debug.debug('update_ar_receipts_gt : error code() '|| to_char(SQLCODE));
3267:
3268: insert_exceptions( p_batch_id => NVL(g_batch_id, -333),
3269: p_request_id => arp_standard.profile.request_id,
3270: p_exception_code => 'AUTORECERR',

Line 3271: p_additional_message => 'update_ar_receipts_gt() '|| SQLERRM );

3267:
3268: insert_exceptions( p_batch_id => NVL(g_batch_id, -333),
3269: p_request_id => arp_standard.profile.request_id,
3270: p_exception_code => 'AUTORECERR',
3271: p_additional_message => 'update_ar_receipts_gt() '|| SQLERRM );
3272:
3273: END update_ar_receipts_gt;
3274:
3275:

Line 3273: END update_ar_receipts_gt;

3269: p_request_id => arp_standard.profile.request_id,
3270: p_exception_code => 'AUTORECERR',
3271: p_additional_message => 'update_ar_receipts_gt() '|| SQLERRM );
3272:
3273: END update_ar_receipts_gt;
3274:
3275:
3276: PROCEDURE build_queries(p_creation_rule IN ar_receipt_methods.receipt_creation_rule_code%TYPE,
3277: p_approval_mode IN VARCHAR2,

Line 3291: p_update_stmt := 'UPDATE /+INDEX(ar_receipts_gt AR_RECEIPTS_GT_N2)/ '||

3287: arp_debug.debug('p_creation_rule '||p_creation_rule);
3288: arp_debug.debug('p_approval_mode '||p_approval_mode);
3289: END IF;
3290:
3291: p_update_stmt := 'UPDATE /*+INDEX(ar_receipts_gt AR_RECEIPTS_GT_N2)*/ '||
3292: ' ar_receipts_gt '||
3293: ' SET receipt_number = :l_receipt_num_array, '||
3294: ' cash_receipt_id = :l_receipt_id_array, '||
3295: ' gt_id = :l_gt_id_array ';

Line 3292: ' ar_receipts_gt '||

3288: arp_debug.debug('p_approval_mode '||p_approval_mode);
3289: END IF;
3290:
3291: p_update_stmt := 'UPDATE /*+INDEX(ar_receipts_gt AR_RECEIPTS_GT_N2)*/ '||
3292: ' ar_receipts_gt '||
3293: ' SET receipt_number = :l_receipt_num_array, '||
3294: ' cash_receipt_id = :l_receipt_id_array, '||
3295: ' gt_id = :l_gt_id_array ';
3296:

Line 3299: insert into ar_receipts_gt

3295: ' gt_id = :l_gt_id_array ';
3296:
3297: IF p_approval_mode = 'RE-APPROVAL' THEN
3298: p_inv_rct_mp_qry := '
3299: insert into ar_receipts_gt
3300: ( payment_schedule_id,
3301: customer_trx_id,
3302: cash_receipt_id,
3303: amount_due_remaining,

Line 3323: from ar_receipts_gt gt ';

3319: null party_id,
3320: null trx_number,
3321: null cust_min_amount,
3322: cash_receipt_id
3323: from ar_receipts_gt gt ';
3324:
3325: END IF;
3326:
3327: --set 1

Line 3367: from ar_receipts_gt gt,

3363: hca.party_id,
3364: trx_number||''-''||to_char(terms_sequence_number) trx_number,
3365: MAX(gt.cust_min_amount) cust_min_amount,
3366: null cash_receipt_id
3367: from ar_receipts_gt gt,
3368: iby_fndcpt_tx_extensions ext,
3369: hz_cust_accounts hca,
3370: ar_payment_schedules ps
3371: where ext.trxn_extension_id = gt.payment_trxn_extension_id

Line 3432: from ar_receipts_gt

3428: payment_instrument,
3429: MIN(payment_trxn_extension_id) payment_trxn_extension_id,
3430: sum(amount_due_remaining) amount,
3431: MAX(cust_min_amount) cust_min_amount
3432: from ar_receipts_gt
3433: group by paying_customer_id,
3434: payment_instrument ) gt
3435: where ext.trxn_extension_id = gt.payment_trxn_extension_id
3436: and hca.cust_account_id = gt.paying_customer_id ';

Line 3488: from AR_RECEIPTS_GT

3484: payment_instrument,
3485: MIN(payment_trxn_extension_id) payment_trxn_extension_id,
3486: sum(amount_due_remaining) amount,
3487: MAX(cust_min_amount) cust_min_amount
3488: from AR_RECEIPTS_GT
3489: group by paying_customer_id,
3490: paying_site_use_id,
3491: payment_instrument ) gt
3492: where ext.trxn_extension_id = gt.payment_trxn_extension_id

Line 3568: from AR_RECEIPTS_GT

3564: due_date,
3565: MIN(payment_trxn_extension_id) payment_trxn_extension_id,
3566: sum(amount_due_remaining) amount,
3567: MAX(cust_min_amount) cust_min_amount
3568: from AR_RECEIPTS_GT
3569: group by paying_customer_id,
3570: due_date,
3571: paying_site_use_id,
3572: payment_instrument ) gt

Line 3647: from AR_RECEIPTS_GT

3643: due_date,
3644: MIN(payment_trxn_extension_id) payment_trxn_extension_id,
3645: sum(amount_due_remaining) amount,
3646: MAX(cust_min_amount) cust_min_amount
3647: from AR_RECEIPTS_GT
3648: group by paying_customer_id,
3649: due_date,
3650: payment_instrument ) gt
3651: where ext.trxn_extension_id = gt.payment_trxn_extension_id

Line 3684: from AR_RECEIPTS_GT

3680: sum(amount_due_remaining) amount,
3681: customer_bank_account_id,
3682: payment_channel_code,
3683: MAX(cust_min_amount) cust_min_amount
3684: from AR_RECEIPTS_GT
3685: group by paying_customer_id,
3686: payment_trxn_extension_id,
3687: customer_bank_account_id,
3688: payment_channel_code) gt

Line 3721: from AR_RECEIPTS_GT

3717: payment_trxn_extension_id,
3718: sum(amount_due_remaining) amount,
3719: payment_instrument,
3720: MAX(cust_min_amount) cust_min_amount
3721: from AR_RECEIPTS_GT
3722: group by paying_customer_id,
3723: payment_trxn_extension_id,
3724: payment_instrument) gt
3725: where ext.trxn_extension_id = gt.payment_trxn_extension_id

Line 3756: from AR_RECEIPTS_GT

3752: payment_trxn_extension_id,
3753: sum(amount_due_remaining) amount,
3754: authorization_id,
3755: MAX(cust_min_amount) cust_min_amount
3756: from AR_RECEIPTS_GT
3757: group by paying_customer_id,
3758: payment_trxn_extension_id,
3759: authorization_id) gt
3760: where ext.trxn_extension_id = gt.payment_trxn_extension_id

Line 3964: ar_receipts_gt rgt

3960: ra.applied_customer_trx_id, ra.payment_schedule_id, ra.applied_payment_schedule_id
3961: FROM ar_receivable_applications ra,
3962: ar_distributions ard,
3963: ra_customer_trx trx,
3964: ar_receipts_gt rgt
3965: WHERE ra.cash_receipt_id = p_cr_id
3966: AND ra.applied_customer_trx_id IS NOT NULL
3967: AND ard.source_id_secondary = ra.receivable_application_id
3968: AND ard.source_table_secondary = 'RA'

Line 3976: SELECT /+INDEX(rgt AR_RECEIPTS_GT_N1) INDEX(inv_ps AR_PAYMENT_SCHEDULES_U1) INDEX(ps AR_PAYMENT_SCHEDULES_U2) /

3972: AND rgt.gt_id = p_gt_id;
3973:
3974:
3975: CURSOR appl_rec_cur( p_gt_id NUMBER) IS
3976: SELECT /*+INDEX(rgt AR_RECEIPTS_GT_N1) INDEX(inv_ps AR_PAYMENT_SCHEDULES_U1) INDEX(ps AR_PAYMENT_SCHEDULES_U2) */
3977: cr.pay_from_customer customer_id,
3978: crh.gl_date cr_gl_date,
3979: cr.amount cr_amount,
3980: cr.customer_site_use_id cust_site_use_id,

Line 4050: ar_receipts_gt rgt

4046: ar_receipt_method_accounts rma,
4047: ar_receivables_trx ed,
4048: ar_receivables_trx uned,
4049: ar_open_trx_v ot,
4050: ar_receipts_gt rgt
4051: WHERE rgt.cash_receipt_id IS NOT NULL
4052: AND rgt.cash_receipt_id = cr.cash_receipt_id
4053: AND cr.cash_receipt_id = crh.cash_receipt_id
4054: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 4073: FROM ar_receipts_gt

4069: SELECT payment_schedule_id,
4070: paying_customer_id,
4071: customer_trx_id,
4072: cash_receipt_id
4073: FROM ar_receipts_gt
4074: WHERE gt_id = l_gt_id
4075: AND receipt_number = l_rec_num;
4076:
4077: BEGIN

Line 4166: arp_debug.debug('ar_receipts_gt dump 1');

4162: END IF;
4163: END IF;
4164:
4165: IF PG_DEBUG in ('Y', 'C') THEN
4166: arp_debug.debug('ar_receipts_gt dump 1');
4167: dump_ar_receipts_gt;
4168: END IF;
4169:
4170: OPEN rcpt_info_cursor FOR l_create_stmt;

Line 4167: dump_ar_receipts_gt;

4163: END IF;
4164:
4165: IF PG_DEBUG in ('Y', 'C') THEN
4166: arp_debug.debug('ar_receipts_gt dump 1');
4167: dump_ar_receipts_gt;
4168: END IF;
4169:
4170: OPEN rcpt_info_cursor FOR l_create_stmt;
4171:

Line 4636: arp_debug.debug( 'Updating ar_receipts_gt with receipt number');

4632:
4633: END LOOP; -- end of process receipts loop
4634:
4635: IF PG_DEBUG in ('Y', 'C') THEN
4636: arp_debug.debug( 'Updating ar_receipts_gt with receipt number');
4637: END IF;
4638:
4639: /**Stamp receipt_id and receipt number to the gt table*/
4640: update_ar_receipts_gt ( p_creation_rule => l_rec_creation_rule_code,

Line 4640: update_ar_receipts_gt ( p_creation_rule => l_rec_creation_rule_code,

4636: arp_debug.debug( 'Updating ar_receipts_gt with receipt number');
4637: END IF;
4638:
4639: /**Stamp receipt_id and receipt number to the gt table*/
4640: update_ar_receipts_gt ( p_creation_rule => l_rec_creation_rule_code,
4641: p_update_stmt => l_update_stmt,
4642: p_cr_id_array => l_receipt_id_array,
4643: p_cr_number_array => l_receipt_num_array,
4644: p_gt_id_array => l_gt_id_array,

Line 4711: UPDATE ar_receipts_gt

4707: END LOOP;
4708: END LOOP;
4709: ELSE --flow related to Re-approval of receipt batch
4710: FOR i IN l_rcpt_info_tab.FIRST..l_rcpt_info_tab.LAST LOOP
4711: UPDATE ar_receipts_gt
4712: SET gt_id = l_gt_id
4713: WHERE cash_receipt_id = l_rcpt_info_tab(i).cash_receipt_id
4714: AND gt_id = -1 ;
4715:

Line 4759: arp_debug.debug('ar_receipts_gt dump 2');

4755:
4756: END IF;
4757:
4758: IF PG_DEBUG in ('Y', 'C') THEN
4759: arp_debug.debug('ar_receipts_gt dump 2');
4760: dump_ar_receipts_gt;
4761: END IF;
4762:
4763: /*--------------------------------------------------

Line 4760: dump_ar_receipts_gt;

4756: END IF;
4757:
4758: IF PG_DEBUG in ('Y', 'C') THEN
4759: arp_debug.debug('ar_receipts_gt dump 2');
4760: dump_ar_receipts_gt;
4761: END IF;
4762:
4763: /*--------------------------------------------------
4764: Set the variable so that ar_open_trx_v will NOT

Line 4829: from AR_RECEIPTS_GT gt

4825: select min(gt.cash_receipt_id),
4826: max(gt.cash_receipt_id)
4827: into l_from_cr_id,
4828: l_to_cr_id
4829: from AR_RECEIPTS_GT gt
4830: where gt.gt_id = l_gt_id;
4831:
4832: IF l_from_cr_id IS NOT NULL AND l_to_cr_id IS NOT NULL THEN
4833:

Line 5105: ar_receipts_gt arg

5101: NVL(SUBSTR(RECEIPT_NUMBER, 1, INSTR(RECEIPT_NUMBER,'-', -1) -1), RECEIPT_NUMBER)
5102: WHERE cash_receipt_id in
5103: ( select cr.cash_receipt_id
5104: from ar_cash_receipts cr,
5105: ar_receipts_gt arg
5106: where arg.gt_id = l_gt_id
5107: AND cr.cash_receipt_id = arg.cash_receipt_id
5108: );
5109: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));

Line 5117: ar_receipts_gt arg

5113: NVL(SUBSTR(TRX_NUMBER, 1, INSTR(TRX_NUMBER,'-', -1) -1), TRX_NUMBER)
5114: WHERE cash_receipt_id in
5115: ( select ps.cash_receipt_id
5116: from ar_payment_schedules ps,
5117: ar_receipts_gt arg
5118: where arg.gt_id = l_gt_id
5119: AND ps.cash_receipt_id = arg.cash_receipt_id
5120: );
5121: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));

Line 5193: FROM ar_receipts_gt r,

5189: program_update_date = sysdate
5190: WHERE customer_trx_id in
5191: (
5192: SELECT /*+ push_pred(trxn_ext) */ r.customer_trx_id
5193: FROM ar_receipts_gt r,
5194: ar_cash_receipts cr,
5195: ar_cash_receipt_history crh,
5196: (SELECT op.trxn_extension_id, summ.status
5197: FROM iby_trxn_summaries_all summ,

Line 5253: FROM ar_receipts_gt r,

5249: pg_last_update_login,
5250: pg_program_application_id,
5251: pg_program_id,
5252: sysdate
5253: FROM ar_receipts_gt r,
5254: ar_cash_receipts cr,
5255: ar_cash_receipt_history crh,
5256: (SELECT op.trxn_extension_id, summ.status
5257: FROM iby_trxn_summaries_all summ,