APPS.ARP_PROCESS_APPLICATION dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 3634: -- Populate CC ID columns by selecting from ra_cust_trx_line_gl_dist and

3630: --------------------------------------------------------------------------
3631:
3632: /* END OF IF CASE THAT NEEDS TO BE REMOVED ONCE LLCA IS COMPLETE */
3633:
3634: -- Populate CC ID columns by selecting from ra_cust_trx_line_gl_dist and
3635: -- and payment schedule tables.
3636: --
3637:
3638: /* 14-APR-2000 jrautiai BR implementation

Line 3640: * instead of ra_cust_trx_line_gl_dist */

3636: --
3637:
3638: /* 14-APR-2000 jrautiai BR implementation
3639: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.
3640: * instead of ra_cust_trx_line_gl_dist */
3641:
3642: --for PS -2, it should go in side the if condition
3643:
3644: IF (p_invoice_ps_id not in (-4,-5)) THEN

Line 4513: -- Populate CC ID columns by selecting from ra_cust_trx_line_gl_dist table

4509: -- Process the Applied Transaction...
4510: --
4511: --------------------------------------------------------------------------
4512:
4513: -- Populate CC ID columns by selecting from ra_cust_trx_line_gl_dist table
4514: -- and Payment Schedule table.
4515: --
4516:
4517: /* 14-APR-2000 jrautiai BR implementation

Line 4519: * instead of ra_cust_trx_line_gl_dist */

4515: --
4516:
4517: /* 14-APR-2000 jrautiai BR implementation
4518: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.
4519: * instead of ra_cust_trx_line_gl_dist */
4520:
4521: ARP_PROCESS_APPLICATION.fetch_app_ccid(p_invoice_ps_id,
4522: l_inv_ra_rec.applied_customer_trx_id,
4523: l_inv_ra_rec.code_combination_id,

Line 6309: FROM ra_cust_trx_line_gl_dist dist

6305:
6306: /* Cursor to fetch normal transaction CCID, the old functionality */
6307: CURSOR trx_dist_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6308: SELECT dist.code_combination_id
6309: FROM ra_cust_trx_line_gl_dist dist
6310: WHERE dist.customer_trx_id = l_customer_trx_id
6311: AND dist.account_class = 'REC'
6312: AND dist.latest_rec_flag = 'Y';
6313:

Line 6420: /* Otherwise the accounting is stored in the ra_cust_trx_line_gl_dist table */

6416: p_source_type := br_dist_rec.source_type;
6417:
6418: ELSE
6419:
6420: /* Otherwise the accounting is stored in the ra_cust_trx_line_gl_dist table */
6421: OPEN trx_dist_cur(doc_rec.customer_trx_id);
6422: FETCH trx_dist_cur INTO trx_dist_rec;
6423:
6424: IF trx_dist_cur%NOTFOUND THEN

Line 8549: UPDATE ra_cust_trx_line_gl_dist

8545: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');
8546: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);
8547: l_message_text := fnd_message.get;
8548:
8549: UPDATE ra_cust_trx_line_gl_dist
8550: SET comments = comments || l_message_text
8551: WHERE customer_trx_id = p_cust_trx_id
8552: AND account_set_flag = 'N';
8553: