APPS.ARP_PROCESS_HEADER_UPDTE_COVER dependencies on RA_CUSTOMER_TRX

Line 11: | Updates a record in ra_customer_trx. |

7: | PROCEDURE |
8: | update_header_cover |
9: | |
10: | DESCRIPTION |
11: | Updates a record in ra_customer_trx. |
12: | |
13: | SCOPE - PUBLIC |
14: | |
15: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 363: FROM ra_customer_trx t,

359: t.exchange_rate,
360: t.exchange_date,
361: t.exchange_rate_type,
362: t.complete_flag -- Bug 8936486
363: FROM ra_customer_trx t,
364: ra_cust_trx_line_gl_dist d
365: WHERE t.customer_trx_id = p_customer_trx_id
366: AND t.customer_trx_id = d.customer_trx_id
367: AND d.account_class = 'REC' ;

Line 371: FROM ra_customer_trx_lines_all

367: AND d.account_class = 'REC' ;
368:
369: CURSOR c_line (p_trx_id NUMBER) IS
370: SELECT customer_trx_line_id
371: FROM ra_customer_trx_lines_all
372: WHERE customer_trx_id = p_trx_id
373: AND line_type = 'LINE';
374:
375: /* manishri, 07-Jun-2010. Bug 9693686 */

Line 376: CURSOR c_get_old_complete_flag (p_customer_trx_id ra_customer_trx_all.customer_trx_id%type) IS

372: WHERE customer_trx_id = p_trx_id
373: AND line_type = 'LINE';
374:
375: /* manishri, 07-Jun-2010. Bug 9693686 */
376: CURSOR c_get_old_complete_flag (p_customer_trx_id ra_customer_trx_all.customer_trx_id%type) IS
377: SELECT complete_flag
378: FROM ra_customer_trx_all
379: WHERE customer_trx_id = p_customer_trx_id;
380: /* end of change, manishri, 07-Jun-2010. Bug 9693686 */

Line 378: FROM ra_customer_trx_all

374:
375: /* manishri, 07-Jun-2010. Bug 9693686 */
376: CURSOR c_get_old_complete_flag (p_customer_trx_id ra_customer_trx_all.customer_trx_id%type) IS
377: SELECT complete_flag
378: FROM ra_customer_trx_all
379: WHERE customer_trx_id = p_customer_trx_id;
380: /* end of change, manishri, 07-Jun-2010. Bug 9693686 */
381:
382: l_trx_date DATE;

Line 395: l_trx_rec ra_customer_trx%rowtype;

391: l_exch_type VARCHAR2(30);
392: --}
393:
394: l_commit_rec arp_process_commitment.commitment_rec_type;
395: l_trx_rec ra_customer_trx%rowtype;
396: l_recalc_tax_flag boolean;
397: l_rerun_autoacc_flag boolean;
398: l_return_status NUMBER;
399: