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_LINES

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 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 73: ra_customer_trx_lines ctl

69: --Bug 12376682
70: SELECT count(*)
71: INTO l_line_salesrep_flag
72: FROM ra_cust_trx_line_salesreps sales,
73: ra_customer_trx_lines ctl
74: WHERE ctl.previous_customer_trx_id = sales.customer_trx_id
75: AND ctl.previous_customer_trx_line_id = sales.customer_trx_line_id
76: AND ctl.customer_trx_id = p_customer_trx_id
77: AND ctl.line_type = 'LINE'

Line 174: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

170: PROCEDURE credit_freight (
171: p_form_name IN varchar2,
172: p_form_version IN number,
173: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
174: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
175: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
176: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
177: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
178: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 176: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

172: p_form_version IN number,
173: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
174: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
175: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
176: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
177: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
178: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
179: p_freight_type IN varchar2,
180: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,

Line 177: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,

173: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
174: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
175: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
176: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
177: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
178: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
179: p_freight_type IN varchar2,
180: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
181: p_mode IN varchar2,

Line 178: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,

174: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
175: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
176: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
177: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
178: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
179: p_freight_type IN varchar2,
180: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
181: p_mode IN varchar2,
182: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 180: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,

176: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
177: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
178: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
179: p_freight_type IN varchar2,
180: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
181: p_mode IN varchar2,
182: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
183: p_currency_code IN fnd_currencies.currency_code%type,
184: p_status OUT NOCOPY varchar2)

Line 187: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

183: p_currency_code IN fnd_currencies.currency_code%type,
184: p_status OUT NOCOPY varchar2)
185: IS
186: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;
187: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
188: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
189: l_frt_rec ra_customer_trx_lines%rowtype;
190: BEGIN
191:

Line 188: l_sob_id ra_customer_trx_lines.set_of_books_id%type;

184: p_status OUT NOCOPY varchar2)
185: IS
186: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;
187: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
188: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
189: l_frt_rec ra_customer_trx_lines%rowtype;
190: BEGIN
191:
192: arp_util.debug('arp_process_credit.credit_freight()+');

Line 189: l_frt_rec ra_customer_trx_lines%rowtype;

185: IS
186: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;
187: l_freight_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
188: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
189: l_frt_rec ra_customer_trx_lines%rowtype;
190: BEGIN
191:
192: arp_util.debug('arp_process_credit.credit_freight()+');
193:

Line 526: | ra_customer_trx_lines%rowtype |

522: | MODIFICATION HISTORY |
523: | 11-AUG-95 Subash Chadalavada Created |
524: | 03-SEP-97 Tasman Tang Fixed bug 547165: Change type |
525: | of p_line_rec to |
526: | ra_customer_trx_lines%rowtype |
527: | |
528: +===========================================================================*/
529: PROCEDURE validate_insert_line(
530: p_line_rec IN ra_customer_trx_lines%rowtype)

Line 530: p_line_rec IN ra_customer_trx_lines%rowtype)

526: | ra_customer_trx_lines%rowtype |
527: | |
528: +===========================================================================*/
529: PROCEDURE validate_insert_line(
530: p_line_rec IN ra_customer_trx_lines%rowtype)
531: IS
532: BEGIN
533: arp_util.debug('arp_process_credit.validate_insert_line()+');
534:

Line 615: p_cm_line IN ra_customer_trx_lines%rowtype,

611: | 16-DEC-04 VCrisostomo Bug 4072055 : retrieve UOM_CODE |
612: +===========================================================================*/
613:
614: PROCEDURE default_credit_line(
615: p_cm_line IN ra_customer_trx_lines%rowtype,
616: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
617: p_prev_customer_trx_line_id IN
618: ra_customer_trx_lines.customer_trx_line_id%type,
619: p_line_amount IN number,

Line 618: ra_customer_trx_lines.customer_trx_line_id%type,

614: PROCEDURE default_credit_line(
615: p_cm_line IN ra_customer_trx_lines%rowtype,
616: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
617: p_prev_customer_trx_line_id IN
618: ra_customer_trx_lines.customer_trx_line_id%type,
619: p_line_amount IN number,
620: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)
621: /* Modified OUT NOCOPY to IN OUT NOCOPY in the line above - bug460970 - Oracle 8 */
622: IS

Line 620: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)

616: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
617: p_prev_customer_trx_line_id IN
618: ra_customer_trx_lines.customer_trx_line_id%type,
619: p_line_amount IN number,
620: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)
621: /* Modified OUT NOCOPY to IN OUT NOCOPY in the line above - bug460970 - Oracle 8 */
622: IS
623: l_cr_txn_line ra_customer_trx_lines%rowtype;
624: l_trx_rec ra_customer_trx%rowtype;

Line 623: l_cr_txn_line ra_customer_trx_lines%rowtype;

619: p_line_amount IN number,
620: p_new_cm_line IN OUT NOCOPY ra_customer_trx_lines%rowtype)
621: /* Modified OUT NOCOPY to IN OUT NOCOPY in the line above - bug460970 - Oracle 8 */
622: IS
623: l_cr_txn_line ra_customer_trx_lines%rowtype;
624: l_trx_rec ra_customer_trx%rowtype;
625: l_calc_unit_price VARCHAR2(1); --2880106
626: BEGIN
627:

Line 808: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

804:
805:
806: PROCEDURE get_cm_amounts(
807: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
808: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
809: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
810: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
811: p_cm_complete_flag OUT NOCOPY varchar2,
812: p_cr_line_amount OUT NOCOPY number,

Line 810: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

806: PROCEDURE get_cm_amounts(
807: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
808: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
809: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
810: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
811: p_cm_complete_flag OUT NOCOPY varchar2,
812: p_cr_line_amount OUT NOCOPY number,
813: p_cr_tax_amount OUT NOCOPY number,
814: p_cr_freight_amount OUT NOCOPY number)

Line 842: FROM ra_customer_trx_lines ctl

838: SELECT count(ctl.customer_trx_line_id),
839: sum(extended_amount)
840: INTO l_line_count,
841: l_cr_line_amount
842: FROM ra_customer_trx_lines ctl
843: WHERE ctl.customer_trx_id = p_customer_trx_id
844: AND ctl.line_type IN ('CHARGES', 'LINE')
845: AND decode(p_customer_trx_line_id,
846: null, -99,

Line 858: FROM ra_customer_trx_lines ctl

854: SELECT count(ctl.customer_trx_line_id),
855: sum(extended_amount)
856: INTO l_tax_line_count,
857: l_cr_tax_amount
858: FROM ra_customer_trx_lines ctl
859: WHERE ctl.customer_trx_id = p_customer_trx_id
860: AND ctl.line_type = 'TAX'
861: AND decode(p_customer_trx_line_id,
862: null, -99,

Line 880: FROM ra_customer_trx_lines ctl

876: INTO l_freight_line_count,
877: l_cr_freight_amount,
878: l_cr_frt_type,
879: l_cr_frt_ctlid
880: FROM ra_customer_trx_lines ctl
881: WHERE ctl.customer_trx_id = p_customer_trx_id
882: AND ctl.line_type = 'FREIGHT'
883: AND decode(p_customer_trx_line_id,
884: null, -99,

Line 932: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

928: +===========================================================================*/
929:
930: PROCEDURE get_uncredit_amounts(
931: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
932: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
933: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
934: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
935: p_mode IN varchar2,
936: p_uncr_line_amount OUT NOCOPY number,

Line 934: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

930: PROCEDURE get_uncredit_amounts(
931: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
932: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
933: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
934: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
935: p_mode IN varchar2,
936: p_uncr_line_amount OUT NOCOPY number,
937: p_uncr_tax_amount OUT NOCOPY number,
938: p_uncr_freight_amount OUT NOCOPY number,

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

937: p_uncr_tax_amount OUT NOCOPY number,
938: p_uncr_freight_amount OUT NOCOPY number,
939: p_memo_line_type OUT NOCOPY varchar2,
940: p_freight_type OUT NOCOPY varchar2,
941: p_freight_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type)
942: IS
943: l_uncr_line_amount number;
944: l_uncr_tax_amount number;
945: l_uncr_freight_amount number;

Line 951: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

947: l_memo_line_type ar_memo_lines.line_type%type;
948: l_tax_count number;
949: l_freight_count number;
950: l_freight_type varchar2(1);
951: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
952:
953: BEGIN
954:
955: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');

Line 966: ra_customer_trx_lines ctl,

962: INTO l_uncr_line_amount,
963: l_line_count,
964: l_memo_line_type
965: FROM ar_net_revenue_amount nra,
966: ra_customer_trx_lines ctl,
967: ar_memo_lines ml
968: WHERE nra.customer_trx_id = p_prev_ct_id
969: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
970: AND ctl.memo_line_id = ml.memo_line_id (+)

Line 981: ra_customer_trx_lines ctl

977: count(nra.customer_trx_line_id)
978: INTO l_uncr_tax_amount,
979: l_tax_count
980: FROM ar_net_revenue_amount nra,
981: ra_customer_trx_lines ctl
982: WHERE nra.customer_trx_id = p_prev_ct_id
983: AND nra.line_type = 'TAX'
984: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
985: AND decode(p_prev_ctl_id,

Line 1000: ra_customer_trx_lines ctl

996: l_uncr_freight_amount,
997: l_freight_ctl_id,
998: l_freight_count
999: FROM ar_net_revenue_amount nra,
1000: ra_customer_trx_lines ctl
1001: WHERE nra.customer_trx_id = p_prev_ct_id
1002: AND nra.line_type = 'FREIGHT'
1003: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
1004: AND decode(p_prev_ctl_id,

Line 1062: ra_customer_trx_lines.customer_trx_line_id%type,

1058:
1059: PROCEDURE get_credited_txn_balances(
1060: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1061: p_prev_customer_trx_line_id IN
1062: ra_customer_trx_lines.customer_trx_line_id%type,
1063: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1064: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

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

1059: PROCEDURE get_credited_txn_balances(
1060: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1061: p_prev_customer_trx_line_id IN
1062: ra_customer_trx_lines.customer_trx_line_id%type,
1063: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1064: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1067: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

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

1060: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1061: p_prev_customer_trx_line_id IN
1062: ra_customer_trx_lines.customer_trx_line_id%type,
1063: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1064: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1067: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1068: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

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

1061: p_prev_customer_trx_line_id IN
1062: ra_customer_trx_lines.customer_trx_line_id%type,
1063: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1064: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1067: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1068: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1069: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)

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

1062: ra_customer_trx_lines.customer_trx_line_id%type,
1063: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1064: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1067: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1068: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1069: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1070: IS

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

1063: p_total_uncr_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1064: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1067: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1068: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1069: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1070: IS
1071: l_count number;

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

1064: p_total_uncr_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1067: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1068: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1069: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1070: IS
1071: l_count number;
1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;

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

1065: p_total_uncr_freight_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1066: p_trx_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1067: p_line_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1068: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1069: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1070: IS
1071: l_count number;
1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;

Line 1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;

1068: p_tax_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1069: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1070: IS
1071: l_count number;
1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;

Line 1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;

1069: p_freight_balance_due OUT NOCOPY ra_customer_trx_lines.extended_amount%type)
1070: IS
1071: l_count number;
1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;

Line 1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;

1070: IS
1071: l_count number;
1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;

Line 1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;

1071: l_count number;
1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1079: BEGIN

Line 1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;

1072: l_total_uncr_line_amount ra_customer_trx_lines.extended_amount%type;
1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1079: BEGIN
1080:

Line 1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;

1073: l_total_uncr_tax_amount ra_customer_trx_lines.extended_amount%type;
1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1079: BEGIN
1080:
1081: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');

Line 1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;

1074: l_total_uncr_freight_amount ra_customer_trx_lines.extended_amount%type;
1075: l_trx_balance_due ra_customer_trx_lines.extended_amount%type;
1076: l_line_balance_due ra_customer_trx_lines.extended_amount%type;
1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1079: BEGIN
1080:
1081: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');
1082:

Line 1096: ra_customer_trx_lines ctl

1092: INTO l_total_uncr_line_amount,
1093: l_total_uncr_tax_amount,
1094: l_total_uncr_freight_amount
1095: FROM ar_net_revenue_amount nra,
1096: ra_customer_trx_lines ctl
1097: WHERE nra.customer_trx_id = p_prev_customer_trx_id
1098: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
1099: AND ctl.line_type = nra.line_type
1100: AND decode(p_prev_customer_trx_line_id,

Line 1207: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,

1203: p_form_name IN varchar2,
1204: p_form_version IN number,
1205: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1206: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1207: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1208: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1209: p_currency_code IN fnd_currencies.currency_code%type,
1210: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1211: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,

Line 1208: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,

1204: p_form_version IN number,
1205: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1206: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1207: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1208: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1209: p_currency_code IN fnd_currencies.currency_code%type,
1210: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1211: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1212: p_compute_tax IN varchar2,

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

1210: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1211: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1212: p_compute_tax IN varchar2,
1213: p_line_percent IN number,
1214: p_credit_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1215: p_status OUT NOCOPY varchar2,
1216: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1217:
1218: IS

Line 1220: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

1216: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1217:
1218: IS
1219:
1220: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
1221: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1222:
1223: l_line_rec ra_customer_trx_lines%rowtype;
1224:

Line 1221: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

1217:
1218: IS
1219:
1220: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
1221: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1222:
1223: l_line_rec ra_customer_trx_lines%rowtype;
1224:
1225: l_freight_type varchar2(1);

Line 1223: l_line_rec ra_customer_trx_lines%rowtype;

1219:
1220: l_credited_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
1221: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1222:
1223: l_line_rec ra_customer_trx_lines%rowtype;
1224:
1225: l_freight_type varchar2(1);
1226: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
1227: l_memo_line_type ar_memo_lines.line_type%type;

Line 1226: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

1222:
1223: l_line_rec ra_customer_trx_lines%rowtype;
1224:
1225: l_freight_type varchar2(1);
1226: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
1227: l_memo_line_type ar_memo_lines.line_type%type;
1228:
1229: l_uncr_line_amount number;
1230: l_uncr_tax_amount number;

Line 1524: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

1520: p_currency_code IN fnd_currencies.currency_code%type,
1521: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1522: p_line_percent IN number,
1523: p_freight_pecent IN number,
1524: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1525: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1526: p_compute_tax IN varchar2,
1527: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1528: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

Line 1525: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

1521: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1522: p_line_percent IN number,
1523: p_freight_pecent IN number,
1524: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1525: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1526: p_compute_tax IN varchar2,
1527: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1528: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1529: p_tax_percent IN OUT NOCOPY number,

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

1526: p_compute_tax IN varchar2,
1527: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
1528: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1529: p_tax_percent IN OUT NOCOPY number,
1530: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1531: p_status OUT NOCOPY varchar2,
1532: p_submit_cm_dist IN varchar2 DEFAULT 'N')
1533: IS
1534:

Line 1537: l_total_credit_amount ra_customer_trx_lines.extended_amount%type;

1533: IS
1534:
1535: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1536: l_trx_rec ra_customer_trx%rowtype;
1537: l_total_credit_amount ra_customer_trx_lines.extended_amount%type;
1538:
1539: l_result number;
1540: l_ccid number;
1541: l_concat_segments varchar2(2000);

Line 1770: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

1766:
1767:
1768: PROCEDURE rerun_aa(
1769: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1770: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
1771: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1772: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,
1773: p_status OUT NOCOPY varchar2)
1774: IS

Line 1895: l_line_rec ra_customer_trx_lines%rowtype;

1891: PROCEDURE reverse_revrec_effect_cm (
1892: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
1893: ) IS
1894:
1895: l_line_rec ra_customer_trx_lines%rowtype;
1896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1897:
1898: BEGIN
1899:

Line 2097: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

2093: p_currency_code IN fnd_currencies.currency_code%type,
2094: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2095: p_line_percent IN number,
2096: p_freight_pecent IN number,
2097: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2098: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2099: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
2100: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
2101: p_rederive_credit_info IN varchar2,

Line 2098: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

2094: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2095: p_line_percent IN number,
2096: p_freight_pecent IN number,
2097: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2098: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2099: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
2100: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
2101: p_rederive_credit_info IN varchar2,
2102: p_rerun_aa IN varchar2,

Line 2099: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,

2095: p_line_percent IN number,
2096: p_freight_pecent IN number,
2097: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2098: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2099: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
2100: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
2101: p_rederive_credit_info IN varchar2,
2102: p_rerun_aa IN varchar2,
2103: p_rerun_cm_module IN varchar2,

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

2102: p_rerun_aa IN varchar2,
2103: p_rerun_cm_module IN varchar2,
2104: p_compute_tax IN varchar2,
2105: p_tax_percent IN OUT NOCOPY number,
2106: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2107: p_status OUT NOCOPY varchar2)
2108: IS
2109: l_old_trx_rec ra_customer_trx%rowtype;
2110: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

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

2594: | PROCEDURE |
2595: | insert_line |
2596: | |
2597: | DESCRIPTION |
2598: | Inserts a row into RA_CUSTOMER_TRX_LINES for Credit Memos |
2599: | |
2600: | SCOPE - PRIVATE |
2601: | |
2602: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2628: p_credit_rec IN ra_customer_trx_lines%rowtype,

2624:
2625: PROCEDURE insert_line(
2626: p_form_name IN varchar2,
2627: p_form_version IN number,
2628: p_credit_rec IN ra_customer_trx_lines%rowtype,
2629: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2630: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2631: p_line_percent IN number,
2632: p_freight_percent IN number,

Line 2629: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

2625: PROCEDURE insert_line(
2626: p_form_name IN varchar2,
2627: p_form_version IN number,
2628: p_credit_rec IN ra_customer_trx_lines%rowtype,
2629: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2630: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2631: p_line_percent IN number,
2632: p_freight_percent IN number,
2633: p_memo_line_type IN ar_memo_lines.line_type%type,

Line 2630: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

2626: p_form_name IN varchar2,
2627: p_form_version IN number,
2628: p_credit_rec IN ra_customer_trx_lines%rowtype,
2629: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2630: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2631: p_line_percent IN number,
2632: p_freight_percent IN number,
2633: p_memo_line_type IN ar_memo_lines.line_type%type,
2634: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 2639: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

2635: p_currency_code IN fnd_currencies.currency_code%type,
2636: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2637: p_compute_tax IN varchar2,
2638: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2639: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
2640: p_prev_customer_trx_line_id IN
2641: ra_customer_trx_lines.customer_trx_line_id%type,
2642: p_tax_percent IN OUT NOCOPY number,
2643: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 2641: ra_customer_trx_lines.customer_trx_line_id%type,

2637: p_compute_tax IN varchar2,
2638: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2639: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
2640: p_prev_customer_trx_line_id IN
2641: ra_customer_trx_lines.customer_trx_line_id%type,
2642: p_tax_percent IN OUT NOCOPY number,
2643: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2644: p_customer_trx_line_id OUT NOCOPY
2645: ra_customer_trx_lines.customer_trx_line_id%type,

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

2639: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
2640: p_prev_customer_trx_line_id IN
2641: ra_customer_trx_lines.customer_trx_line_id%type,
2642: p_tax_percent IN OUT NOCOPY number,
2643: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2644: p_customer_trx_line_id OUT NOCOPY
2645: ra_customer_trx_lines.customer_trx_line_id%type,
2646: p_status OUT NOCOPY varchar2)
2647: IS

Line 2645: ra_customer_trx_lines.customer_trx_line_id%type,

2641: ra_customer_trx_lines.customer_trx_line_id%type,
2642: p_tax_percent IN OUT NOCOPY number,
2643: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2644: p_customer_trx_line_id OUT NOCOPY
2645: ra_customer_trx_lines.customer_trx_line_id%type,
2646: p_status OUT NOCOPY varchar2)
2647: IS
2648:
2649: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

Line 2649: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

2645: ra_customer_trx_lines.customer_trx_line_id%type,
2646: p_status OUT NOCOPY varchar2)
2647: IS
2648:
2649: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
2650: l_credit_rec ra_customer_trx_lines%rowtype;
2651: l_line_credit_flag boolean;
2652: l_tax_credit_flag boolean;
2653: l_freight_credit_flag boolean;

Line 2650: l_credit_rec ra_customer_trx_lines%rowtype;

2646: p_status OUT NOCOPY varchar2)
2647: IS
2648:
2649: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
2650: l_credit_rec ra_customer_trx_lines%rowtype;
2651: l_line_credit_flag boolean;
2652: l_tax_credit_flag boolean;
2653: l_freight_credit_flag boolean;
2654:

Line 2655: l_account_class ra_customer_trx_lines.line_type%type;

2651: l_line_credit_flag boolean;
2652: l_tax_credit_flag boolean;
2653: l_freight_credit_flag boolean;
2654:
2655: l_account_class ra_customer_trx_lines.line_type%type;
2656:
2657: l_uncr_line_amount number;
2658: l_uncr_tax_amount number;
2659: l_uncr_freight_amount number;

Line 2666: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

2662: l_tax_balance_due number;
2663: l_freight_balance_due number;
2664: l_memo_line_type ar_memo_lines.line_type%type;
2665: l_freight_type varchar2(1);
2666: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
2667:
2668: l_result integer;
2669: l_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
2670: l_concat_segments varchar2(200);

Line 3001: p_line_rec IN ra_customer_trx_lines%rowtype,

2997: | 11-AUG-95 Subash Chadalavada Created |
2998: | |
2999: +===========================================================================*/
3000: PROCEDURE set_line_flags(
3001: p_line_rec IN ra_customer_trx_lines%rowtype,
3002: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3003: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
3004: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
3005: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

Line 3003: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

2999: +===========================================================================*/
3000: PROCEDURE set_line_flags(
3001: p_line_rec IN ra_customer_trx_lines%rowtype,
3002: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3003: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
3004: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
3005: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
3006: p_line_amount IN number,
3007: p_tax_amount IN number,

Line 3005: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

3001: p_line_rec IN ra_customer_trx_lines%rowtype,
3002: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3003: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
3004: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
3005: p_prev_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
3006: p_line_amount IN number,
3007: p_tax_amount IN number,
3008: p_frt_amount IN number,
3009: p_cr_line_amount OUT NOCOPY number,

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

3013: p_tax_amt_chng_flag OUT NOCOPY boolean,
3014: p_frt_amt_chng_flag OUT NOCOPY boolean,
3015: p_tax_mode OUT NOCOPY varchar2,
3016: p_frt_mode OUT NOCOPY varchar2,
3017: p_frt_ctlid OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
3018: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,
3019: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)
3020: IS
3021:

Line 3019: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)

3015: p_tax_mode OUT NOCOPY varchar2,
3016: p_frt_mode OUT NOCOPY varchar2,
3017: p_frt_ctlid OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
3018: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,
3019: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)
3020: IS
3021:
3022: l_old_line_rec ra_customer_trx_lines%rowtype;
3023:

Line 3022: l_old_line_rec ra_customer_trx_lines%rowtype;

3018: p_cm_complete_flag OUT NOCOPY ra_customer_trx.complete_flag%type,
3019: p_old_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype)
3020: IS
3021:
3022: l_old_line_rec ra_customer_trx_lines%rowtype;
3023:
3024: l_frt_amount ra_customer_trx_lines.extended_amount%type;
3025: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3026:

Line 3024: l_frt_amount ra_customer_trx_lines.extended_amount%type;

3020: IS
3021:
3022: l_old_line_rec ra_customer_trx_lines%rowtype;
3023:
3024: l_frt_amount ra_customer_trx_lines.extended_amount%type;
3025: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3026:
3027: l_cm_complete_flag ra_customer_trx.complete_flag%type;
3028: l_credited_line_amount number;

Line 3025: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

3021:
3022: l_old_line_rec ra_customer_trx_lines%rowtype;
3023:
3024: l_frt_amount ra_customer_trx_lines.extended_amount%type;
3025: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3026:
3027: l_cm_complete_flag ra_customer_trx.complete_flag%type;
3028: l_credited_line_amount number;
3029: l_credited_tax_amount number;

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

3139: | PROCEDURE |
3140: | update_line |
3141: | |
3142: | DESCRIPTION |
3143: | Updates the row in RA_CUSTOMER_TRX_LINES for Credit Memos |
3144: | |
3145: | SCOPE - PRIVATE |
3146: | |
3147: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 3169: | ra_customer_trx_lines%rowtype |

3165: | MODIFICATION HISTORY |
3166: | 11-AUG-95 Subash Chadalavada Created |
3167: | 03-SEP-97 Tasman Tang Fixed bug 547165: Change type of |
3168: | l_old_line_rec to |
3169: | ra_customer_trx_lines%rowtype |
3170: | |
3171: +===========================================================================*/
3172:
3173: PROCEDURE update_line(

Line 3176: p_credit_rec IN ra_customer_trx_lines%rowtype,

3172:
3173: PROCEDURE update_line(
3174: p_form_name IN varchar2,
3175: p_form_version IN number,
3176: p_credit_rec IN ra_customer_trx_lines%rowtype,
3177: p_customer_trx_line_id IN
3178: ra_customer_trx_lines.customer_trx_line_id%type,
3179: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3180: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 3178: ra_customer_trx_lines.customer_trx_line_id%type,

3174: p_form_name IN varchar2,
3175: p_form_version IN number,
3176: p_credit_rec IN ra_customer_trx_lines%rowtype,
3177: p_customer_trx_line_id IN
3178: ra_customer_trx_lines.customer_trx_line_id%type,
3179: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3180: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3181: p_line_percent IN number,
3182: p_freight_percent IN number,

Line 3179: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

3175: p_form_version IN number,
3176: p_credit_rec IN ra_customer_trx_lines%rowtype,
3177: p_customer_trx_line_id IN
3178: ra_customer_trx_lines.customer_trx_line_id%type,
3179: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3180: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3181: p_line_percent IN number,
3182: p_freight_percent IN number,
3183: p_memo_line_type IN ar_memo_lines.line_type%type,

Line 3180: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

3176: p_credit_rec IN ra_customer_trx_lines%rowtype,
3177: p_customer_trx_line_id IN
3178: ra_customer_trx_lines.customer_trx_line_id%type,
3179: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3180: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3181: p_line_percent IN number,
3182: p_freight_percent IN number,
3183: p_memo_line_type IN ar_memo_lines.line_type%type,
3184: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 3192: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

3188: p_rerun_aa IN varchar2,
3189: p_recalculate_tax IN varchar2,
3190: p_compute_tax IN varchar2,
3191: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3192: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
3193: p_prev_customer_trx_line_id IN
3194: ra_customer_trx_lines.customer_trx_line_id%type,
3195: p_tax_percent IN OUT NOCOPY number,
3196: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 3194: ra_customer_trx_lines.customer_trx_line_id%type,

3190: p_compute_tax IN varchar2,
3191: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3192: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
3193: p_prev_customer_trx_line_id IN
3194: ra_customer_trx_lines.customer_trx_line_id%type,
3195: p_tax_percent IN OUT NOCOPY number,
3196: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
3197: p_status OUT NOCOPY varchar2)
3198: IS

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

3192: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
3193: p_prev_customer_trx_line_id IN
3194: ra_customer_trx_lines.customer_trx_line_id%type,
3195: p_tax_percent IN OUT NOCOPY number,
3196: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
3197: p_status OUT NOCOPY varchar2)
3198: IS
3199:
3200: l_frt_exists_flag boolean;

Line 3207: l_prev_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

3203: l_tax_amt_chng_flag boolean;
3204:
3205: l_memo_line_type ar_memo_lines.line_type%type;
3206: l_frt_type varchar2(1);
3207: l_prev_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3208:
3209: l_uncr_line_amount number;
3210: l_uncr_tax_amount number;
3211: l_uncr_frt_amount number;

Line 3224: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;

3220: l_frt_mode varchar2(10);
3221:
3222: l_cm_complete_flag ra_customer_trx.complete_flag%type;
3223:
3224: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3225: l_old_line_rec ra_customer_trx_lines%rowtype;
3226: l_rerun_aa_status varchar2(30) := 'OK';
3227: l_tax_status varchar2(30) := 'OK';
3228: l_frt_status varchar2(30) := 'OK';

Line 3225: l_old_line_rec ra_customer_trx_lines%rowtype;

3221:
3222: l_cm_complete_flag ra_customer_trx.complete_flag%type;
3223:
3224: l_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3225: l_old_line_rec ra_customer_trx_lines%rowtype;
3226: l_rerun_aa_status varchar2(30) := 'OK';
3227: l_tax_status varchar2(30) := 'OK';
3228: l_frt_status varchar2(30) := 'OK';
3229: l_recalculate_tax_flag BOOLEAN;

Line 3452: p_frt_rec IN ra_customer_trx_lines%rowtype,

3448: | |
3449: +===========================================================================*/
3450:
3451: PROCEDURE freight_post_update(
3452: p_frt_rec IN ra_customer_trx_lines%rowtype,
3453: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3454: p_frt_ccid IN
3455: ra_cust_trx_line_gl_dist.code_combination_id%type)
3456: IS