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.ARP_PROCESS_CREDIT dependencies on RA_CUSTOMER_TRX

Line 16: -- ra_customer_trx_lines.customer_trx_line_id%type

12: pg_base_precision fnd_currencies.precision%type;
13: pg_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
14:
15: -- TYPE credit_lines_type IS TABLE OF
16: -- ra_customer_trx_lines.customer_trx_line_id%type
17: -- INDEX BY BINARY_INTEGER;
18: --
19: -- pg_num_credit_lines number;
20: -- pg_credit_lines credit_lines_type;

Line 57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

53: | |
54: +===========================================================================*/
55:
56: PROCEDURE create_salescredits(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_customer_trx_line_id IN
59: ra_customer_trx_lines.customer_trx_line_id%type,
60: p_memo_line_type IN ar_memo_lines.line_type%type,
61: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,

Line 59: ra_customer_trx_lines.customer_trx_line_id%type,

55:
56: PROCEDURE create_salescredits(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_customer_trx_line_id IN
59: ra_customer_trx_lines.customer_trx_line_id%type,
60: p_memo_line_type IN ar_memo_lines.line_type%type,
61: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
62: p_currency_code IN fnd_currencies.currency_code%type)
63: IS

Line 154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

150:
151: PROCEDURE credit_freight (
152: p_form_name IN varchar2,
153: p_form_version IN number,
154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
156: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

151: PROCEDURE credit_freight (
152: p_form_name IN varchar2,
153: p_form_version IN number,
154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
156: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 156: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,

152: p_form_name IN varchar2,
153: p_form_version IN number,
154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
156: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
160: p_freight_type IN varchar2,

Line 157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

153: p_form_version IN number,
154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
156: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
160: p_freight_type IN varchar2,
161: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,

Line 158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,

154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
156: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
160: p_freight_type IN varchar2,
161: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
162: p_mode IN varchar2,

Line 159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,

155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
156: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
160: p_freight_type IN varchar2,
161: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
162: p_mode IN varchar2,
163: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 161: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,

157: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
158: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
160: p_freight_type IN varchar2,
161: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
162: p_mode IN varchar2,
163: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
164: p_currency_code IN fnd_currencies.currency_code%type,
165: p_status OUT NOCOPY varchar2)

Line 167: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;

163: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
164: p_currency_code IN fnd_currencies.currency_code%type,
165: p_status OUT NOCOPY varchar2)
166: IS
167: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;
168: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
169: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
170: l_frt_rec ra_customer_trx_lines%rowtype;
171: BEGIN

Line 168: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

164: p_currency_code IN fnd_currencies.currency_code%type,
165: p_status OUT NOCOPY varchar2)
166: IS
167: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;
168: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
169: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
170: l_frt_rec ra_customer_trx_lines%rowtype;
171: BEGIN
172:

Line 169: l_sob_id ra_customer_trx_lines.set_of_books_id%type;

165: p_status OUT NOCOPY varchar2)
166: IS
167: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;
168: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
169: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
170: l_frt_rec ra_customer_trx_lines%rowtype;
171: BEGIN
172:
173: arp_util.debug('arp_process_credit.credit_freight()+');

Line 170: l_frt_rec ra_customer_trx_lines%rowtype;

166: IS
167: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;
168: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
169: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
170: l_frt_rec ra_customer_trx_lines%rowtype;
171: BEGIN
172:
173: arp_util.debug('arp_process_credit.credit_freight()+');
174:

Line 344: p_cm_rec IN ra_customer_trx%rowtype,

340: | |
341: +===========================================================================*/
342:
343: PROCEDURE default_credit_header(
344: p_cm_rec IN ra_customer_trx%rowtype,
345: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
346: p_new_cm_rec IN OUT NOCOPY ra_customer_trx%rowtype)
347: /* Modified IN to IN OUT NOCOPY in the line above - bug 460970 - Oracle 8 */
348: IS

Line 345: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

341: +===========================================================================*/
342:
343: PROCEDURE default_credit_header(
344: p_cm_rec IN ra_customer_trx%rowtype,
345: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
346: p_new_cm_rec IN OUT NOCOPY ra_customer_trx%rowtype)
347: /* Modified IN to IN OUT NOCOPY in the line above - bug 460970 - Oracle 8 */
348: IS
349: l_cr_txn_rec ra_customer_trx%rowtype;

Line 346: p_new_cm_rec IN OUT NOCOPY ra_customer_trx%rowtype)

342:
343: PROCEDURE default_credit_header(
344: p_cm_rec IN ra_customer_trx%rowtype,
345: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
346: p_new_cm_rec IN OUT NOCOPY ra_customer_trx%rowtype)
347: /* Modified IN to IN OUT NOCOPY in the line above - bug 460970 - Oracle 8 */
348: IS
349: l_cr_txn_rec ra_customer_trx%rowtype;
350: BEGIN

Line 349: l_cr_txn_rec ra_customer_trx%rowtype;

345: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
346: p_new_cm_rec IN OUT NOCOPY ra_customer_trx%rowtype)
347: /* Modified IN to IN OUT NOCOPY in the line above - bug 460970 - Oracle 8 */
348: IS
349: l_cr_txn_rec ra_customer_trx%rowtype;
350: BEGIN
351:
352: arp_util.debug('arp_process_credit.default_credit_header()+');
353:

Line 507: | ra_customer_trx_lines%rowtype |

503: | MODIFICATION HISTORY |
504: | 11-AUG-95 Subash Chadalavada Created |
505: | 03-SEP-97 Tasman Tang Fixed bug 547165: Change type |
506: | of p_line_rec to |
507: | ra_customer_trx_lines%rowtype |
508: | |
509: +===========================================================================*/
510: PROCEDURE validate_insert_line(
511: p_line_rec IN ra_customer_trx_lines%rowtype)

Line 511: p_line_rec IN ra_customer_trx_lines%rowtype)

507: | ra_customer_trx_lines%rowtype |
508: | |
509: +===========================================================================*/
510: PROCEDURE validate_insert_line(
511: p_line_rec IN ra_customer_trx_lines%rowtype)
512: IS
513: BEGIN
514: arp_util.debug('arp_process_credit.validate_insert_line()+');
515:

Line 596: p_cm_line IN ra_customer_trx_lines%rowtype,

592: | 16-DEC-04 VCrisostomo Bug 4072055 : retrieve UOM_CODE |
593: +===========================================================================*/
594:
595: PROCEDURE default_credit_line(
596: p_cm_line IN ra_customer_trx_lines%rowtype,
597: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
598: p_prev_customer_trx_line_id IN
599: ra_customer_trx_lines.customer_trx_line_id%type,
600: p_line_amount IN number,

Line 597: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

593: +===========================================================================*/
594:
595: PROCEDURE default_credit_line(
596: p_cm_line IN ra_customer_trx_lines%rowtype,
597: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
598: p_prev_customer_trx_line_id IN
599: ra_customer_trx_lines.customer_trx_line_id%type,
600: p_line_amount IN number,
601: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)

Line 599: ra_customer_trx_lines.customer_trx_line_id%type,

595: PROCEDURE default_credit_line(
596: p_cm_line IN ra_customer_trx_lines%rowtype,
597: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
598: p_prev_customer_trx_line_id IN
599: ra_customer_trx_lines.customer_trx_line_id%type,
600: p_line_amount IN number,
601: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)
602: /* Modified OUT NOCOPY to IN OUT NOCOPY in the line above - bug460970 - Oracle 8 */
603: IS

Line 601: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)

597: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
598: p_prev_customer_trx_line_id IN
599: ra_customer_trx_lines.customer_trx_line_id%type,
600: p_line_amount IN number,
601: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)
602: /* Modified OUT NOCOPY to IN OUT NOCOPY in the line above - bug460970 - Oracle 8 */
603: IS
604: l_cr_txn_line ra_customer_trx_lines%rowtype;
605: l_trx_rec ra_customer_trx%rowtype;

Line 604: l_cr_txn_line ra_customer_trx_lines%rowtype;

600: p_line_amount IN number,
601: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)
602: /* Modified OUT NOCOPY to IN OUT NOCOPY in the line above - bug460970 - Oracle 8 */
603: IS
604: l_cr_txn_line ra_customer_trx_lines%rowtype;
605: l_trx_rec ra_customer_trx%rowtype;
606: l_calc_unit_price VARCHAR2(1); --2880106
607: BEGIN
608:

Line 605: l_trx_rec ra_customer_trx%rowtype;

601: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)
602: /* Modified OUT NOCOPY to IN OUT NOCOPY in the line above - bug460970 - Oracle 8 */
603: IS
604: l_cr_txn_line ra_customer_trx_lines%rowtype;
605: l_trx_rec ra_customer_trx%rowtype;
606: l_calc_unit_price VARCHAR2(1); --2880106
607: BEGIN
608:
609: arp_util.debug('arp_process_credit.default_credit_line()+');

Line 777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

773: END;
774:
775:
776: PROCEDURE get_cm_amounts(
777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
778: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
779: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
780: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
781: p_cm_complete_flag OUT NOCOPY varchar2,

Line 778: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

774:
775:
776: PROCEDURE get_cm_amounts(
777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
778: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
779: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
780: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
781: p_cm_complete_flag OUT NOCOPY varchar2,
782: p_cr_line_amount OUT NOCOPY number,

Line 779: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,

775:
776: PROCEDURE get_cm_amounts(
777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
778: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
779: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
780: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
781: p_cm_complete_flag OUT NOCOPY varchar2,
782: p_cr_line_amount OUT NOCOPY number,
783: p_cr_tax_amount OUT NOCOPY number,

Line 780: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

776: PROCEDURE get_cm_amounts(
777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
778: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
779: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
780: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
781: p_cm_complete_flag OUT NOCOPY varchar2,
782: p_cr_line_amount OUT NOCOPY number,
783: p_cr_tax_amount OUT NOCOPY number,
784: p_cr_freight_amount OUT NOCOPY number)

Line 786: l_complete_flag ra_customer_trx.complete_flag%type;

782: p_cr_line_amount OUT NOCOPY number,
783: p_cr_tax_amount OUT NOCOPY number,
784: p_cr_freight_amount OUT NOCOPY number)
785: IS
786: l_complete_flag ra_customer_trx.complete_flag%type;
787: l_cr_line_amount number;
788: l_cr_tax_amount number;
789: l_cr_freight_amount number;
790: l_cr_frt_type varchar2(1);

Line 805: FROM ra_customer_trx

801: THEN
802:
803: SELECT max(complete_flag)
804: INTO l_complete_flag
805: FROM ra_customer_trx
806: WHERE customer_trx_id = p_customer_trx_id;
807:
808: SELECT count(ctl.customer_trx_line_id),
809: sum(extended_amount)

Line 812: FROM ra_customer_trx_lines ctl

808: SELECT count(ctl.customer_trx_line_id),
809: sum(extended_amount)
810: INTO l_line_count,
811: l_cr_line_amount
812: FROM ra_customer_trx_lines ctl
813: WHERE ctl.customer_trx_id = p_customer_trx_id
814: AND ctl.line_type IN ('CHARGES', 'LINE')
815: AND decode(p_customer_trx_line_id,
816: null, -99,

Line 828: FROM ra_customer_trx_lines ctl

824: SELECT count(ctl.customer_trx_line_id),
825: sum(extended_amount)
826: INTO l_tax_line_count,
827: l_cr_tax_amount
828: FROM ra_customer_trx_lines ctl
829: WHERE ctl.customer_trx_id = p_customer_trx_id
830: AND ctl.line_type = 'TAX'
831: AND decode(p_customer_trx_line_id,
832: null, -99,

Line 850: FROM ra_customer_trx_lines ctl

846: INTO l_freight_line_count,
847: l_cr_freight_amount,
848: l_cr_frt_type,
849: l_cr_frt_ctlid
850: FROM ra_customer_trx_lines ctl
851: WHERE ctl.customer_trx_id = p_customer_trx_id
852: AND ctl.line_type = 'FREIGHT'
853: AND decode(p_customer_trx_line_id,
854: null, -99,

Line 901: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

897: | |
898: +===========================================================================*/
899:
900: PROCEDURE get_uncredit_amounts(
901: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
902: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
903: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
904: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
905: p_mode IN varchar2,

Line 902: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

898: +===========================================================================*/
899:
900: PROCEDURE get_uncredit_amounts(
901: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
902: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
903: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
904: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
905: p_mode IN varchar2,
906: p_uncr_line_amount OUT NOCOPY number,

Line 903: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,

899:
900: PROCEDURE get_uncredit_amounts(
901: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
902: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
903: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
904: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
905: p_mode IN varchar2,
906: p_uncr_line_amount OUT NOCOPY number,
907: p_uncr_tax_amount OUT NOCOPY number,

Line 904: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

900: PROCEDURE get_uncredit_amounts(
901: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
902: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
903: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
904: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
905: p_mode IN varchar2,
906: p_uncr_line_amount OUT NOCOPY number,
907: p_uncr_tax_amount OUT NOCOPY number,
908: p_uncr_freight_amount OUT NOCOPY number,

Line 911: p_freight_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type)

907: p_uncr_tax_amount OUT NOCOPY number,
908: p_uncr_freight_amount OUT NOCOPY number,
909: p_memo_line_type OUT NOCOPY varchar2,
910: p_freight_type OUT NOCOPY varchar2,
911: p_freight_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type)
912: IS
913: l_uncr_line_amount number;
914: l_uncr_tax_amount number;
915: l_uncr_freight_amount number;

Line 921: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

917: l_memo_line_type ar_memo_lines.line_type%type;
918: l_tax_count number;
919: l_freight_count number;
920: l_freight_type varchar2(1);
921: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
922:
923: BEGIN
924:
925: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');

Line 928: count(nra.customer_trx_line_id),

924:
925: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');
926:
927: SELECT sum(nra.net_amount),
928: count(nra.customer_trx_line_id),
929: max(decode(p_prev_ctl_id,
930: null, null,
931: nvl(ml.line_type, 'LINE')))
932: INTO l_uncr_line_amount,

Line 936: ra_customer_trx_lines ctl,

932: INTO l_uncr_line_amount,
933: l_line_count,
934: l_memo_line_type
935: FROM ar_net_revenue_amount nra,
936: ra_customer_trx_lines ctl,
937: ar_memo_lines ml
938: WHERE nra.customer_trx_id = p_prev_ct_id
939: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
940: AND ctl.memo_line_id = ml.memo_line_id (+)

Line 938: WHERE nra.customer_trx_id = p_prev_ct_id

934: l_memo_line_type
935: FROM ar_net_revenue_amount nra,
936: ra_customer_trx_lines ctl,
937: ar_memo_lines ml
938: WHERE nra.customer_trx_id = p_prev_ct_id
939: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
940: AND ctl.memo_line_id = ml.memo_line_id (+)
941: AND decode(p_prev_ctl_id,
942: null, -99,

Line 939: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

935: FROM ar_net_revenue_amount nra,
936: ra_customer_trx_lines ctl,
937: ar_memo_lines ml
938: WHERE nra.customer_trx_id = p_prev_ct_id
939: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
940: AND ctl.memo_line_id = ml.memo_line_id (+)
941: AND decode(p_prev_ctl_id,
942: null, -99,
943: nra.customer_trx_line_id) = nvl(p_prev_ctl_id, -99)

Line 943: nra.customer_trx_line_id) = nvl(p_prev_ctl_id, -99)

939: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
940: AND ctl.memo_line_id = ml.memo_line_id (+)
941: AND decode(p_prev_ctl_id,
942: null, -99,
943: nra.customer_trx_line_id) = nvl(p_prev_ctl_id, -99)
944: AND nra.line_type in ('LINE', 'CB', 'CHARGES');
945:
946: SELECT sum(nra.net_amount),
947: count(nra.customer_trx_line_id)

Line 947: count(nra.customer_trx_line_id)

943: nra.customer_trx_line_id) = nvl(p_prev_ctl_id, -99)
944: AND nra.line_type in ('LINE', 'CB', 'CHARGES');
945:
946: SELECT sum(nra.net_amount),
947: count(nra.customer_trx_line_id)
948: INTO l_uncr_tax_amount,
949: l_tax_count
950: FROM ar_net_revenue_amount nra,
951: ra_customer_trx_lines ctl

Line 951: ra_customer_trx_lines ctl

947: count(nra.customer_trx_line_id)
948: INTO l_uncr_tax_amount,
949: l_tax_count
950: FROM ar_net_revenue_amount nra,
951: ra_customer_trx_lines ctl
952: WHERE nra.customer_trx_id = p_prev_ct_id
953: AND nra.line_type = 'TAX'
954: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
955: AND decode(p_prev_ctl_id,

Line 952: WHERE nra.customer_trx_id = p_prev_ct_id

948: INTO l_uncr_tax_amount,
949: l_tax_count
950: FROM ar_net_revenue_amount nra,
951: ra_customer_trx_lines ctl
952: WHERE nra.customer_trx_id = p_prev_ct_id
953: AND nra.line_type = 'TAX'
954: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
955: AND decode(p_prev_ctl_id,
956: null, -99,

Line 954: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

950: FROM ar_net_revenue_amount nra,
951: ra_customer_trx_lines ctl
952: WHERE nra.customer_trx_id = p_prev_ct_id
953: AND nra.line_type = 'TAX'
954: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
955: AND decode(p_prev_ctl_id,
956: null, -99,
957: ctl.link_to_cust_trx_line_id) = nvl(p_prev_ctl_id, -99);
958:

Line 964: count(nra.customer_trx_line_id)

960: null, 'H',
961: 'L')),
962: sum(nra.net_amount),
963: max(ctl.customer_trx_line_id),
964: count(nra.customer_trx_line_id)
965: INTO l_freight_type,
966: l_uncr_freight_amount,
967: l_freight_ctl_id,
968: l_freight_count

Line 970: ra_customer_trx_lines ctl

966: l_uncr_freight_amount,
967: l_freight_ctl_id,
968: l_freight_count
969: FROM ar_net_revenue_amount nra,
970: ra_customer_trx_lines ctl
971: WHERE nra.customer_trx_id = p_prev_ct_id
972: AND nra.line_type = 'FREIGHT'
973: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
974: AND decode(p_prev_ctl_id,

Line 971: WHERE nra.customer_trx_id = p_prev_ct_id

967: l_freight_ctl_id,
968: l_freight_count
969: FROM ar_net_revenue_amount nra,
970: ra_customer_trx_lines ctl
971: WHERE nra.customer_trx_id = p_prev_ct_id
972: AND nra.line_type = 'FREIGHT'
973: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
974: AND decode(p_prev_ctl_id,
975: null, -99,

Line 973: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

969: FROM ar_net_revenue_amount nra,
970: ra_customer_trx_lines ctl
971: WHERE nra.customer_trx_id = p_prev_ct_id
972: AND nra.line_type = 'FREIGHT'
973: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
974: AND decode(p_prev_ctl_id,
975: null, -99,
976: ctl.link_to_cust_trx_line_id) = nvl(p_prev_ctl_id, -99);
977:

Line 1030: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1026: | |
1027: +===========================================================================*/
1028:
1029: PROCEDURE get_credited_txn_balances(
1030: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1031: p_prev_customer_trx_line_id IN
1032: ra_customer_trx_lines.customer_trx_line_id%type,
1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 1032: ra_customer_trx_lines.customer_trx_line_id%type,

1028:
1029: PROCEDURE get_credited_txn_balances(
1030: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1031: p_prev_customer_trx_line_id IN
1032: ra_customer_trx_lines.customer_trx_line_id%type,
1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1029: PROCEDURE get_credited_txn_balances(
1030: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1031: p_prev_customer_trx_line_id IN
1032: ra_customer_trx_lines.customer_trx_line_id%type,
1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1030: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1031: p_prev_customer_trx_line_id IN
1032: ra_customer_trx_lines.customer_trx_line_id%type,
1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1031: p_prev_customer_trx_line_id IN
1032: ra_customer_trx_lines.customer_trx_line_id%type,
1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)

Line 1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1032: ra_customer_trx_lines.customer_trx_line_id%type,
1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1040: IS

Line 1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1033: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1040: IS
1041: l_count number;

Line 1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1034: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1040: IS
1041: l_count number;
1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;

Line 1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)

1035: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1036: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1037: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1040: IS
1041: l_count number;
1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;

Line 1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;

1038: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1040: IS
1041: l_count number;
1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;

Line 1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;

1039: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1040: IS
1041: l_count number;
1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;

Line 1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;

1040: IS
1041: l_count number;
1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;

Line 1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;

1041: l_count number;
1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1049: BEGIN

Line 1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;

1042: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1049: BEGIN
1050:

Line 1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;

1043: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1049: BEGIN
1050:
1051: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');

Line 1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;

1044: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1045: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1046: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1049: BEGIN
1050:
1051: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');
1052:

Line 1066: ra_customer_trx_lines ctl

1062: INTO l_total_uncr_line_amount,
1063: l_total_uncr_tax_amount,
1064: l_total_uncr_freight_amount
1065: FROM ar_net_revenue_amount nra,
1066: ra_customer_trx_lines ctl
1067: WHERE nra.customer_trx_id = p_prev_customer_trx_id
1068: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
1069: AND ctl.line_type = nra.line_type
1070: AND decode(p_prev_customer_trx_line_id,

Line 1067: WHERE nra.customer_trx_id = p_prev_customer_trx_id

1063: l_total_uncr_tax_amount,
1064: l_total_uncr_freight_amount
1065: FROM ar_net_revenue_amount nra,
1066: ra_customer_trx_lines ctl
1067: WHERE nra.customer_trx_id = p_prev_customer_trx_id
1068: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
1069: AND ctl.line_type = nra.line_type
1070: AND decode(p_prev_customer_trx_line_id,
1071: null, -99,

Line 1068: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

1064: l_total_uncr_freight_amount
1065: FROM ar_net_revenue_amount nra,
1066: ra_customer_trx_lines ctl
1067: WHERE nra.customer_trx_id = p_prev_customer_trx_id
1068: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
1069: AND ctl.line_type = nra.line_type
1070: AND decode(p_prev_customer_trx_line_id,
1071: null, -99,
1072: ctl.link_to_cust_trx_line_id) =

Line 1113: ra_customer_trx commit_trx,

1109: INTO l_trx_balance_due,
1110: l_line_balance_due
1111: FROM ar_adjustments adj,
1112: ra_cust_trx_types commit_ctt,
1113: ra_customer_trx commit_trx,
1114: ra_customer_trx credited_trx
1115: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
1116: AND commit_trx.customer_trx_id =
1117: credited_trx.initial_customer_trx_id

Line 1114: ra_customer_trx credited_trx

1110: l_line_balance_due
1111: FROM ar_adjustments adj,
1112: ra_cust_trx_types commit_ctt,
1113: ra_customer_trx commit_trx,
1114: ra_customer_trx credited_trx
1115: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
1116: AND commit_trx.customer_trx_id =
1117: credited_trx.initial_customer_trx_id
1118: AND credited_trx.customer_trx_id = p_prev_customer_trx_id

Line 1175: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1171: +===========================================================================*/
1172: PROCEDURE derive_credit_information(
1173: p_form_name IN varchar2,
1174: p_form_version IN number,
1175: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1176: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1177: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1178: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1179: p_currency_code IN fnd_currencies.currency_code%type,

Line 1176: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1172: PROCEDURE derive_credit_information(
1173: p_form_name IN varchar2,
1174: p_form_version IN number,
1175: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1176: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1177: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1178: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1179: p_currency_code IN fnd_currencies.currency_code%type,
1180: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 1177: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,

1173: p_form_name IN varchar2,
1174: p_form_version IN number,
1175: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1176: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1177: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1178: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1179: p_currency_code IN fnd_currencies.currency_code%type,
1180: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1181: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,

Line 1178: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,

1174: p_form_version IN number,
1175: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1176: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1177: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1178: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1179: p_currency_code IN fnd_currencies.currency_code%type,
1180: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1181: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1182: p_compute_tax IN varchar2,

Line 1184: p_credit_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1180: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1181: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1182: p_compute_tax IN varchar2,
1183: p_line_percent IN number,
1184: p_credit_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1185: p_status OUT NOCOPY varchar2,
1186: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1187:
1188: IS

Line 1190: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

1186: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1187:
1188: IS
1189:
1190: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
1191: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1192:
1193: l_line_rec ra_customer_trx_lines%rowtype;
1194:

Line 1191: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

1187:
1188: IS
1189:
1190: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
1191: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1192:
1193: l_line_rec ra_customer_trx_lines%rowtype;
1194:
1195: l_freight_type varchar2(1);

Line 1193: l_line_rec ra_customer_trx_lines%rowtype;

1189:
1190: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
1191: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1192:
1193: l_line_rec ra_customer_trx_lines%rowtype;
1194:
1195: l_freight_type varchar2(1);
1196: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
1197: l_memo_line_type ar_memo_lines.line_type%type;

Line 1196: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

1192:
1193: l_line_rec ra_customer_trx_lines%rowtype;
1194:
1195: l_freight_type varchar2(1);
1196: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
1197: l_memo_line_type ar_memo_lines.line_type%type;
1198:
1199: l_uncr_line_amount number;
1200: l_uncr_tax_amount number;

Line 1452: | Inserts a row into RA_CUSTOMER_TRX for Credit Memos |

1448: | PROCEDURE |
1449: | insert_header |
1450: | |
1451: | DESCRIPTION |
1452: | Inserts a row into RA_CUSTOMER_TRX for Credit Memos |
1453: | |
1454: | SCOPE - PRIVATE |
1455: | |
1456: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1486: p_trx_rec IN ra_customer_trx%rowtype,

1482:
1483: PROCEDURE insert_header(
1484: p_form_name IN varchar2,
1485: p_form_version IN number,
1486: p_trx_rec IN ra_customer_trx%rowtype,
1487: p_trx_class IN ra_cust_trx_types.type%type,
1488: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1489: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1490: p_currency_code IN fnd_currencies.currency_code%type,

Line 1491: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1487: p_trx_class IN ra_cust_trx_types.type%type,
1488: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1489: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1490: p_currency_code IN fnd_currencies.currency_code%type,
1491: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1492: p_line_percent IN number,
1493: p_freight_pecent IN number,
1494: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1495: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 1494: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

1490: p_currency_code IN fnd_currencies.currency_code%type,
1491: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1492: p_line_percent IN number,
1493: p_freight_pecent IN number,
1494: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1495: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1496: p_compute_tax IN varchar2,
1497: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1498: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

Line 1495: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

1491: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1492: p_line_percent IN number,
1493: p_freight_pecent IN number,
1494: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1495: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1496: p_compute_tax IN varchar2,
1497: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1498: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1499: p_tax_percent IN OUT NOCOPY number,

Line 1497: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,

1493: p_freight_pecent IN number,
1494: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1495: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1496: p_compute_tax IN varchar2,
1497: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1498: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1499: p_tax_percent IN OUT NOCOPY number,
1500: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1501: p_status OUT NOCOPY varchar2,

Line 1498: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

1494: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1495: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1496: p_compute_tax IN varchar2,
1497: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1498: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1499: p_tax_percent IN OUT NOCOPY number,
1500: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1501: p_status OUT NOCOPY varchar2,
1502: p_submit_cm_dist IN varchar2 DEFAULT 'N')

Line 1500: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1496: p_compute_tax IN varchar2,
1497: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1498: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1499: p_tax_percent IN OUT NOCOPY number,
1500: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1501: p_status OUT NOCOPY varchar2,
1502: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1503: IS
1504:

Line 1505: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

1501: p_status OUT NOCOPY varchar2,
1502: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1503: IS
1504:
1505: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1506: l_trx_rec ra_customer_trx%rowtype;
1507: l_total_credit_amount ra_customer_trx_lines.extended_amount%type;
1508:
1509: l_result number;

Line 1506: l_trx_rec ra_customer_trx%rowtype;

1502: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1503: IS
1504:
1505: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1506: l_trx_rec ra_customer_trx%rowtype;
1507: l_total_credit_amount ra_customer_trx_lines.extended_amount%type;
1508:
1509: l_result number;
1510: l_ccid number;

Line 1507: l_total_credit_amount ra_customer_trx_lines.extended_amount%type;

1503: IS
1504:
1505: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1506: l_trx_rec ra_customer_trx%rowtype;
1507: l_total_credit_amount ra_customer_trx_lines.extended_amount%type;
1508:
1509: l_result number;
1510: l_ccid number;
1511: l_concat_segments varchar2(2000);

Line 1687: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1683: | 11-APR-03 M Raymond Bug 2868648 - added delete of CMA rows
1684: | |
1685: +===========================================================================*/
1686: PROCEDURE delete_cm_records(
1687: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1688: p_trx_number_change_flag IN boolean)
1689: IS
1690: BEGIN
1691:

Line 1739: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1735: END;
1736:
1737:
1738: PROCEDURE rerun_aa(
1739: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1740: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
1741: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1742: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,
1743: p_status OUT NOCOPY varchar2)

Line 1740: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

1736:
1737:
1738: PROCEDURE rerun_aa(
1739: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1740: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
1741: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1742: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,
1743: p_status OUT NOCOPY varchar2)
1744: IS

Line 1862: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type

1858: | 10-May-04 Surendra Rajan Created |
1859: | |
1860: +===========================================================================*/
1861: PROCEDURE reverse_revrec_effect_cm (
1862: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
1863: ) IS
1864:
1865: l_line_rec ra_customer_trx_lines%rowtype;
1866: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 1865: l_line_rec ra_customer_trx_lines%rowtype;

1861: PROCEDURE reverse_revrec_effect_cm (
1862: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
1863: ) IS
1864:
1865: l_line_rec ra_customer_trx_lines%rowtype;
1866: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1867:
1868: BEGIN
1869:

Line 1964: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1960: | 11-AUG-95 Subash Chadalavada Created |
1961: | |
1962: +===========================================================================*/
1963: PROCEDURE set_header_flags(
1964: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1965: p_new_trx_rec IN ra_customer_trx%rowtype,
1966: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1967: p_exch_rate_changed_flag OUT NOCOPY boolean,
1968: p_gl_date_changed_flag OUT NOCOPY boolean,

Line 1965: p_new_trx_rec IN ra_customer_trx%rowtype,

1961: | |
1962: +===========================================================================*/
1963: PROCEDURE set_header_flags(
1964: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1965: p_new_trx_rec IN ra_customer_trx%rowtype,
1966: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1967: p_exch_rate_changed_flag OUT NOCOPY boolean,
1968: p_gl_date_changed_flag OUT NOCOPY boolean,
1969: p_complete_changed_flag OUT NOCOPY boolean,

Line 1970: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype)

1966: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1967: p_exch_rate_changed_flag OUT NOCOPY boolean,
1968: p_gl_date_changed_flag OUT NOCOPY boolean,
1969: p_complete_changed_flag OUT NOCOPY boolean,
1970: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype)
1971: IS
1972: l_old_trx_rec ra_customer_trx%rowtype;
1973: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1974: BEGIN

Line 1972: l_old_trx_rec ra_customer_trx%rowtype;

1968: p_gl_date_changed_flag OUT NOCOPY boolean,
1969: p_complete_changed_flag OUT NOCOPY boolean,
1970: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype)
1971: IS
1972: l_old_trx_rec ra_customer_trx%rowtype;
1973: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1974: BEGIN
1975: arp_util.debug('arp_process_credit.set_header_flags()+');
1976:

Line 2028: | Updates the row in RA_CUSTOMER_TRX for Credit Memos |

2024: | PROCEDURE |
2025: | update_header |
2026: | |
2027: | DESCRIPTION |
2028: | Updates the row in RA_CUSTOMER_TRX for Credit Memos |
2029: | |
2030: | SCOPE - PRIVATE |
2031: | |
2032: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2058: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

2054: +===========================================================================*/
2055: PROCEDURE update_header(
2056: p_form_name IN varchar2,
2057: p_form_version IN number,
2058: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2059: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
2060: p_trx_class IN ra_cust_trx_types.type%type,
2061: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2062: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,

Line 2059: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

2055: PROCEDURE update_header(
2056: p_form_name IN varchar2,
2057: p_form_version IN number,
2058: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2059: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
2060: p_trx_class IN ra_cust_trx_types.type%type,
2061: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2062: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2063: p_currency_code IN fnd_currencies.currency_code%type,

Line 2064: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

2060: p_trx_class IN ra_cust_trx_types.type%type,
2061: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2062: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2063: p_currency_code IN fnd_currencies.currency_code%type,
2064: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2065: p_line_percent IN number,
2066: p_freight_pecent IN number,
2067: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2068: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 2067: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

2063: p_currency_code IN fnd_currencies.currency_code%type,
2064: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2065: p_line_percent IN number,
2066: p_freight_pecent IN number,
2067: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2068: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2069: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
2070: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
2071: p_rederive_credit_info IN varchar2,

Line 2068: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

2064: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2065: p_line_percent IN number,
2066: p_freight_pecent IN number,
2067: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2068: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2069: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
2070: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
2071: p_rederive_credit_info IN varchar2,
2072: p_rerun_aa IN varchar2,

Line 2069: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,

2065: p_line_percent IN number,
2066: p_freight_pecent IN number,
2067: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2068: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2069: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
2070: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
2071: p_rederive_credit_info IN varchar2,
2072: p_rerun_aa IN varchar2,
2073: p_rerun_cm_module IN varchar2,

Line 2070: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

2066: p_freight_pecent IN number,
2067: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2068: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2069: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
2070: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
2071: p_rederive_credit_info IN varchar2,
2072: p_rerun_aa IN varchar2,
2073: p_rerun_cm_module IN varchar2,
2074: p_compute_tax IN varchar2,

Line 2076: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

2072: p_rerun_aa IN varchar2,
2073: p_rerun_cm_module IN varchar2,
2074: p_compute_tax IN varchar2,
2075: p_tax_percent IN OUT NOCOPY number,
2076: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2077: p_status OUT NOCOPY varchar2)
2078: IS
2079: l_old_trx_rec ra_customer_trx%rowtype;
2080: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 2079: l_old_trx_rec ra_customer_trx%rowtype;

2075: p_tax_percent IN OUT NOCOPY number,
2076: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2077: p_status OUT NOCOPY varchar2)
2078: IS
2079: l_old_trx_rec ra_customer_trx%rowtype;
2080: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
2081: l_exchange_rate ra_customer_trx.exchange_rate%type;
2082: l_exch_rate_changed_flag boolean;
2083: l_complete_changed_flag boolean;

Line 2081: l_exchange_rate ra_customer_trx.exchange_rate%type;

2077: p_status OUT NOCOPY varchar2)
2078: IS
2079: l_old_trx_rec ra_customer_trx%rowtype;
2080: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
2081: l_exchange_rate ra_customer_trx.exchange_rate%type;
2082: l_exch_rate_changed_flag boolean;
2083: l_complete_changed_flag boolean;
2084: l_gl_date_changed_flag boolean;
2085: l_frt_only_rules boolean;

Line 2090: orig_trx_number ra_customer_trx.trx_number%type;

2086: l_acct_set_change varchar2(10);
2087:
2088: l_recalc_tax_flag boolean := FALSE;
2089: l_trx_number_change_flag boolean := FALSE; --Bug2109490
2090: orig_trx_number ra_customer_trx.trx_number%type;
2091: l_failure_count number;
2092:
2093: l_tax_status varchar2(100) := 'OK';
2094: l_derive_status varchar2(100) := 'OK';

Line 2118: FROM ra_customer_trx trx,

2114: xet.entity_code entity_code,
2115: trx.trx_number trx_number,
2116: trx.customer_trx_id customer_trx_id,
2117: trx.org_id org_id
2118: FROM ra_customer_trx trx,
2119: ra_cust_trx_line_gl_dist gld,
2120: xla_transaction_entities_upg xet,
2121: xla_events ev
2122: WHERE trx.customer_trx_id = p_customer_trx_id

Line 2178: FROM ra_customer_trx

2174:
2175: BEGIN
2176: SELECT trx_number
2177: INTO orig_trx_number
2178: FROM ra_customer_trx
2179: WHERE customer_trx_id = p_customer_trx_id;
2180:
2181: arp_util.debug( 'orig_trx_number : ' || orig_trx_number);
2182:

Line 2568: | Inserts a row into RA_CUSTOMER_TRX_LINES for Credit Memos |

2564: | PROCEDURE |
2565: | insert_line |
2566: | |
2567: | DESCRIPTION |
2568: | Inserts a row into RA_CUSTOMER_TRX_LINES for Credit Memos |
2569: | |
2570: | SCOPE - PRIVATE |
2571: | |
2572: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2598: p_credit_rec IN ra_customer_trx_lines%rowtype,

2594:
2595: PROCEDURE insert_line(
2596: p_form_name IN varchar2,
2597: p_form_version IN number,
2598: p_credit_rec IN ra_customer_trx_lines%rowtype,
2599: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2600: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2601: p_line_percent IN number,
2602: p_freight_percent IN number,

Line 2599: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

2595: PROCEDURE insert_line(
2596: p_form_name IN varchar2,
2597: p_form_version IN number,
2598: p_credit_rec IN ra_customer_trx_lines%rowtype,
2599: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2600: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2601: p_line_percent IN number,
2602: p_freight_percent IN number,
2603: p_memo_line_type IN ar_memo_lines.line_type%type,

Line 2600: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

2596: p_form_name IN varchar2,
2597: p_form_version IN number,
2598: p_credit_rec IN ra_customer_trx_lines%rowtype,
2599: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2600: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2601: p_line_percent IN number,
2602: p_freight_percent IN number,
2603: p_memo_line_type IN ar_memo_lines.line_type%type,
2604: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 2608: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

2604: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2605: p_currency_code IN fnd_currencies.currency_code%type,
2606: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2607: p_compute_tax IN varchar2,
2608: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2609: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
2610: p_prev_customer_trx_line_id IN
2611: ra_customer_trx_lines.customer_trx_line_id%type,
2612: p_tax_percent IN OUT NOCOPY number,

Line 2609: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

2605: p_currency_code IN fnd_currencies.currency_code%type,
2606: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2607: p_compute_tax IN varchar2,
2608: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2609: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
2610: p_prev_customer_trx_line_id IN
2611: ra_customer_trx_lines.customer_trx_line_id%type,
2612: p_tax_percent IN OUT NOCOPY number,
2613: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 2611: ra_customer_trx_lines.customer_trx_line_id%type,

2607: p_compute_tax IN varchar2,
2608: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2609: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
2610: p_prev_customer_trx_line_id IN
2611: ra_customer_trx_lines.customer_trx_line_id%type,
2612: p_tax_percent IN OUT NOCOPY number,
2613: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2614: p_customer_trx_line_id OUT NOCOPY
2615: ra_customer_trx_lines.customer_trx_line_id%type,

Line 2613: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

2609: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
2610: p_prev_customer_trx_line_id IN
2611: ra_customer_trx_lines.customer_trx_line_id%type,
2612: p_tax_percent IN OUT NOCOPY number,
2613: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2614: p_customer_trx_line_id OUT NOCOPY
2615: ra_customer_trx_lines.customer_trx_line_id%type,
2616: p_status OUT NOCOPY varchar2)
2617: IS

Line 2615: ra_customer_trx_lines.customer_trx_line_id%type,

2611: ra_customer_trx_lines.customer_trx_line_id%type,
2612: p_tax_percent IN OUT NOCOPY number,
2613: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2614: p_customer_trx_line_id OUT NOCOPY
2615: ra_customer_trx_lines.customer_trx_line_id%type,
2616: p_status OUT NOCOPY varchar2)
2617: IS
2618:
2619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

Line 2619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

2615: ra_customer_trx_lines.customer_trx_line_id%type,
2616: p_status OUT NOCOPY varchar2)
2617: IS
2618:
2619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
2620: l_credit_rec ra_customer_trx_lines%rowtype;
2621: l_line_credit_flag boolean;
2622: l_tax_credit_flag boolean;
2623: l_freight_credit_flag boolean;

Line 2620: l_credit_rec ra_customer_trx_lines%rowtype;

2616: p_status OUT NOCOPY varchar2)
2617: IS
2618:
2619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
2620: l_credit_rec ra_customer_trx_lines%rowtype;
2621: l_line_credit_flag boolean;
2622: l_tax_credit_flag boolean;
2623: l_freight_credit_flag boolean;
2624:

Line 2625: l_account_class ra_customer_trx_lines.line_type%type;

2621: l_line_credit_flag boolean;
2622: l_tax_credit_flag boolean;
2623: l_freight_credit_flag boolean;
2624:
2625: l_account_class ra_customer_trx_lines.line_type%type;
2626:
2627: l_uncr_line_amount number;
2628: l_uncr_tax_amount number;
2629: l_uncr_freight_amount number;

Line 2636: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

2632: l_tax_balance_due number;
2633: l_freight_balance_due number;
2634: l_memo_line_type ar_memo_lines.line_type%type;
2635: l_freight_type varchar2(1);
2636: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
2637:
2638: l_result integer;
2639: l_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
2640: l_concat_segments varchar2(200);

Line 2961: p_line_rec IN ra_customer_trx_lines%rowtype,

2957: | 11-AUG-95 Subash Chadalavada Created |
2958: | |
2959: +===========================================================================*/
2960: PROCEDURE set_line_flags(
2961: p_line_rec IN ra_customer_trx_lines%rowtype,
2962: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2963: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2964: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
2965: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

Line 2962: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

2958: | |
2959: +===========================================================================*/
2960: PROCEDURE set_line_flags(
2961: p_line_rec IN ra_customer_trx_lines%rowtype,
2962: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2963: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2964: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
2965: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2966: p_line_amount IN number,

Line 2963: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

2959: +===========================================================================*/
2960: PROCEDURE set_line_flags(
2961: p_line_rec IN ra_customer_trx_lines%rowtype,
2962: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2963: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2964: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
2965: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2966: p_line_amount IN number,
2967: p_tax_amount IN number,

Line 2964: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,

2960: PROCEDURE set_line_flags(
2961: p_line_rec IN ra_customer_trx_lines%rowtype,
2962: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2963: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2964: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
2965: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2966: p_line_amount IN number,
2967: p_tax_amount IN number,
2968: p_frt_amount IN number,

Line 2965: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

2961: p_line_rec IN ra_customer_trx_lines%rowtype,
2962: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2963: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2964: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
2965: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
2966: p_line_amount IN number,
2967: p_tax_amount IN number,
2968: p_frt_amount IN number,
2969: p_cr_line_amount OUT NOCOPY number,

Line 2977: p_frt_ctlid OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,

2973: p_tax_amt_chng_flag OUT NOCOPY boolean,
2974: p_frt_amt_chng_flag OUT NOCOPY boolean,
2975: p_tax_mode OUT NOCOPY varchar2,
2976: p_frt_mode OUT NOCOPY varchar2,
2977: p_frt_ctlid OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
2978: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,
2979: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)
2980: IS
2981:

Line 2978: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,

2974: p_frt_amt_chng_flag OUT NOCOPY boolean,
2975: p_tax_mode OUT NOCOPY varchar2,
2976: p_frt_mode OUT NOCOPY varchar2,
2977: p_frt_ctlid OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
2978: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,
2979: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)
2980: IS
2981:
2982: l_old_line_rec ra_customer_trx_lines%rowtype;

Line 2979: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)

2975: p_tax_mode OUT NOCOPY varchar2,
2976: p_frt_mode OUT NOCOPY varchar2,
2977: p_frt_ctlid OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
2978: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,
2979: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)
2980: IS
2981:
2982: l_old_line_rec ra_customer_trx_lines%rowtype;
2983:

Line 2982: l_old_line_rec ra_customer_trx_lines%rowtype;

2978: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,
2979: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)
2980: IS
2981:
2982: l_old_line_rec ra_customer_trx_lines%rowtype;
2983:
2984: l_frt_amount ra_customer_trx_lines.extended_amount%type;
2985: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
2986:

Line 2984: l_frt_amount ra_customer_trx_lines.extended_amount%type;

2980: IS
2981:
2982: l_old_line_rec ra_customer_trx_lines%rowtype;
2983:
2984: l_frt_amount ra_customer_trx_lines.extended_amount%type;
2985: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
2986:
2987: l_cm_complete_flag ra_customer_trx.complete_flag%type;
2988: l_credited_line_amount number;

Line 2985: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

2981:
2982: l_old_line_rec ra_customer_trx_lines%rowtype;
2983:
2984: l_frt_amount ra_customer_trx_lines.extended_amount%type;
2985: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
2986:
2987: l_cm_complete_flag ra_customer_trx.complete_flag%type;
2988: l_credited_line_amount number;
2989: l_credited_tax_amount number;

Line 2987: l_cm_complete_flag ra_customer_trx.complete_flag%type;

2983:
2984: l_frt_amount ra_customer_trx_lines.extended_amount%type;
2985: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
2986:
2987: l_cm_complete_flag ra_customer_trx.complete_flag%type;
2988: l_credited_line_amount number;
2989: l_credited_tax_amount number;
2990: l_credited_frt_amount number;
2991:

Line 3103: | Updates the row in RA_CUSTOMER_TRX_LINES for Credit Memos |

3099: | PROCEDURE |
3100: | update_line |
3101: | |
3102: | DESCRIPTION |
3103: | Updates the row in RA_CUSTOMER_TRX_LINES for Credit Memos |
3104: | |
3105: | SCOPE - PRIVATE |
3106: | |
3107: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 3129: | ra_customer_trx_lines%rowtype |

3125: | MODIFICATION HISTORY |
3126: | 11-AUG-95 Subash Chadalavada Created |
3127: | 03-SEP-97 Tasman Tang Fixed bug 547165: Change type of |
3128: | l_old_line_rec to |
3129: | ra_customer_trx_lines%rowtype |
3130: | |
3131: +===========================================================================*/
3132:
3133: PROCEDURE update_line(

Line 3136: p_credit_rec IN ra_customer_trx_lines%rowtype,

3132:
3133: PROCEDURE update_line(
3134: p_form_name IN varchar2,
3135: p_form_version IN number,
3136: p_credit_rec IN ra_customer_trx_lines%rowtype,
3137: p_customer_trx_line_id IN
3138: ra_customer_trx_lines.customer_trx_line_id%type,
3139: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3140: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 3138: ra_customer_trx_lines.customer_trx_line_id%type,

3134: p_form_name IN varchar2,
3135: p_form_version IN number,
3136: p_credit_rec IN ra_customer_trx_lines%rowtype,
3137: p_customer_trx_line_id IN
3138: ra_customer_trx_lines.customer_trx_line_id%type,
3139: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3140: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3141: p_line_percent IN number,
3142: p_freight_percent IN number,

Line 3139: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

3135: p_form_version IN number,
3136: p_credit_rec IN ra_customer_trx_lines%rowtype,
3137: p_customer_trx_line_id IN
3138: ra_customer_trx_lines.customer_trx_line_id%type,
3139: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3140: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3141: p_line_percent IN number,
3142: p_freight_percent IN number,
3143: p_memo_line_type IN ar_memo_lines.line_type%type,

Line 3140: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

3136: p_credit_rec IN ra_customer_trx_lines%rowtype,
3137: p_customer_trx_line_id IN
3138: ra_customer_trx_lines.customer_trx_line_id%type,
3139: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3140: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3141: p_line_percent IN number,
3142: p_freight_percent IN number,
3143: p_memo_line_type IN ar_memo_lines.line_type%type,
3144: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 3147: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

3143: p_memo_line_type IN ar_memo_lines.line_type%type,
3144: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3145: p_currency_code IN fnd_currencies.currency_code%type,
3146: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
3147: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
3148: p_rerun_aa IN varchar2,
3149: p_recalculate_tax IN varchar2,
3150: p_compute_tax IN varchar2,
3151: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 3151: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

3147: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
3148: p_rerun_aa IN varchar2,
3149: p_recalculate_tax IN varchar2,
3150: p_compute_tax IN varchar2,
3151: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3152: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
3153: p_prev_customer_trx_line_id IN
3154: ra_customer_trx_lines.customer_trx_line_id%type,
3155: p_tax_percent IN OUT NOCOPY number,

Line 3152: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

3148: p_rerun_aa IN varchar2,
3149: p_recalculate_tax IN varchar2,
3150: p_compute_tax IN varchar2,
3151: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3152: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
3153: p_prev_customer_trx_line_id IN
3154: ra_customer_trx_lines.customer_trx_line_id%type,
3155: p_tax_percent IN OUT NOCOPY number,
3156: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 3154: ra_customer_trx_lines.customer_trx_line_id%type,

3150: p_compute_tax IN varchar2,
3151: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3152: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
3153: p_prev_customer_trx_line_id IN
3154: ra_customer_trx_lines.customer_trx_line_id%type,
3155: p_tax_percent IN OUT NOCOPY number,
3156: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
3157: p_status OUT NOCOPY varchar2)
3158: IS

Line 3156: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

3152: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
3153: p_prev_customer_trx_line_id IN
3154: ra_customer_trx_lines.customer_trx_line_id%type,
3155: p_tax_percent IN OUT NOCOPY number,
3156: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
3157: p_status OUT NOCOPY varchar2)
3158: IS
3159:
3160: l_frt_exists_flag boolean;

Line 3167: l_prev_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

3163: l_tax_amt_chng_flag boolean;
3164:
3165: l_memo_line_type ar_memo_lines.line_type%type;
3166: l_frt_type varchar2(1);
3167: l_prev_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3168:
3169: l_uncr_line_amount number;
3170: l_uncr_tax_amount number;
3171: l_uncr_frt_amount number;

Line 3182: l_cm_complete_flag ra_customer_trx.complete_flag%type;

3178:
3179: l_tax_mode varchar2(10);
3180: l_frt_mode varchar2(10);
3181:
3182: l_cm_complete_flag ra_customer_trx.complete_flag%type;
3183:
3184: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3185: l_old_line_rec ra_customer_trx_lines%rowtype;
3186: l_rerun_aa_status varchar2(30) := 'OK';

Line 3184: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

3180: l_frt_mode varchar2(10);
3181:
3182: l_cm_complete_flag ra_customer_trx.complete_flag%type;
3183:
3184: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3185: l_old_line_rec ra_customer_trx_lines%rowtype;
3186: l_rerun_aa_status varchar2(30) := 'OK';
3187: l_tax_status varchar2(30) := 'OK';
3188: l_frt_status varchar2(30) := 'OK';

Line 3185: l_old_line_rec ra_customer_trx_lines%rowtype;

3181:
3182: l_cm_complete_flag ra_customer_trx.complete_flag%type;
3183:
3184: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3185: l_old_line_rec ra_customer_trx_lines%rowtype;
3186: l_rerun_aa_status varchar2(30) := 'OK';
3187: l_tax_status varchar2(30) := 'OK';
3188: l_frt_status varchar2(30) := 'OK';
3189: l_recalculate_tax_flag BOOLEAN;

Line 3412: p_frt_rec IN ra_customer_trx_lines%rowtype,

3408: | |
3409: +===========================================================================*/
3410:
3411: PROCEDURE freight_post_update(
3412: p_frt_rec IN ra_customer_trx_lines%rowtype,
3413: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3414: p_frt_ccid IN
3415: ra_cust_trx_line_gl_dist.code_combination_id%type)
3416: IS