APPS.ARP_PROCESS_APPLICATION dependencies on RA_CUST_TRX_LINE_GL_DIST

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

3907: --------------------------------------------------------------------------
3908:
3909: /* END OF IF CASE THAT NEEDS TO BE REMOVED ONCE LLCA IS COMPLETE */
3910:
3911: -- Populate CC ID columns by selecting from ra_cust_trx_line_gl_dist and
3912: -- and payment schedule tables.
3913: --
3914:
3915: /* 14-APR-2000 jrautiai BR implementation

Line 3917: * instead of ra_cust_trx_line_gl_dist */

3913: --
3914:
3915: /* 14-APR-2000 jrautiai BR implementation
3916: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.
3917: * instead of ra_cust_trx_line_gl_dist */
3918:
3919: --for PS -2, it should go in side the if condition
3920:
3921: IF (p_invoice_ps_id not in (-4,-5)) THEN

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

4807: -- Process the Applied Transaction...
4808: --
4809: --------------------------------------------------------------------------
4810:
4811: -- Populate CC ID columns by selecting from ra_cust_trx_line_gl_dist table
4812: -- and Payment Schedule table.
4813: --
4814:
4815: /* 14-APR-2000 jrautiai BR implementation

Line 4817: * instead of ra_cust_trx_line_gl_dist */

4813: --
4814:
4815: /* 14-APR-2000 jrautiai BR implementation
4816: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.
4817: * instead of ra_cust_trx_line_gl_dist */
4818:
4819: ARP_PROCESS_APPLICATION.fetch_app_ccid(p_invoice_ps_id,
4820: l_inv_ra_rec.applied_customer_trx_id,
4821: l_inv_ra_rec.code_combination_id,

Line 6661: FROM ra_cust_trx_line_gl_dist dist

6657:
6658: /* Cursor to fetch normal transaction CCID, the old functionality */
6659: CURSOR trx_dist_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6660: SELECT dist.code_combination_id
6661: FROM ra_cust_trx_line_gl_dist dist
6662: WHERE dist.customer_trx_id = l_customer_trx_id
6663: AND dist.account_class = 'REC'
6664: AND dist.latest_rec_flag = 'Y';
6665:

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

6768: p_source_type := br_dist_rec.source_type;
6769:
6770: ELSE
6771:
6772: /* Otherwise the accounting is stored in the ra_cust_trx_line_gl_dist table */
6773: OPEN trx_dist_cur(doc_rec.customer_trx_id);
6774: FETCH trx_dist_cur INTO trx_dist_rec;
6775:
6776: IF trx_dist_cur%NOTFOUND THEN

Line 8752: l_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;

8748:
8749: l_receivable_application_id NUMBER;
8750:
8751:
8752: l_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
8753: l_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
8754:
8755: API_exception EXCEPTION;
8756: --Bug#2750340

Line 8753: l_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;

8749: l_receivable_application_id NUMBER;
8750:
8751:
8752: l_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
8753: l_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
8754:
8755: API_exception EXCEPTION;
8756: --Bug#2750340
8757: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 8951: select code_combination_id into l_rec_ccid from ra_Cust_trx_line_gl_dist

8947: l_inv_ra_rec.comments := p_comments;
8948:
8949: /*bug 9488876 substitute BS for refund*/
8950: IF p_application_ps_id = -8 THEN
8951: select code_combination_id into l_rec_ccid from ra_Cust_trx_line_gl_dist
8952: where customer_trx_id=l_cm_ps_rec.customer_trx_id
8953: and account_class='REC'
8954: and latest_rec_flag='Y';
8955:

Line 9184: UPDATE ra_cust_trx_line_gl_dist

9180: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');
9181: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);
9182: l_message_text := fnd_message.get;
9183:
9184: UPDATE ra_cust_trx_line_gl_dist
9185: SET comments = comments || l_message_text
9186: WHERE customer_trx_id = p_cust_trx_id
9187: AND account_set_flag = 'N';
9188: