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 5: ra_customer_trx_lines.customer_trx_line_id%type

1: PACKAGE ARP_PROCESS_CREDIT AS
2: /* $Header: ARTECMRS.pls 120.2.12010000.1 2008/07/24 16:55:40 appldev ship $ */
3:
4: TYPE credit_lines_type IS TABLE OF
5: ra_customer_trx_lines.customer_trx_line_id%type
6: INDEX BY BINARY_INTEGER;
7:
8: pg_num_credit_lines number;
9: pg_credit_lines credit_lines_type;

Line 15: p_trx_rec IN ra_customer_trx%rowtype,

11:
12: PROCEDURE insert_header(
13: p_form_name IN varchar2,
14: p_form_version IN number,
15: p_trx_rec IN ra_customer_trx%rowtype,
16: p_trx_class IN ra_cust_trx_types.type%type,
17: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
18: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
19: p_currency_code IN fnd_currencies.currency_code%type,

Line 20: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

16: p_trx_class IN ra_cust_trx_types.type%type,
17: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
18: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
19: p_currency_code IN fnd_currencies.currency_code%type,
20: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
21: p_line_percent IN number,
22: p_freight_pecent IN number,
23: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
24: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 23: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

19: p_currency_code IN fnd_currencies.currency_code%type,
20: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
21: p_line_percent IN number,
22: p_freight_pecent IN number,
23: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
24: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
25: p_compute_tax IN varchar2,
26: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
27: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

Line 24: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

20: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
21: p_line_percent IN number,
22: p_freight_pecent IN number,
23: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
24: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
25: p_compute_tax IN varchar2,
26: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
27: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
28: p_tax_percent IN OUT NOCOPY number,

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

22: p_freight_pecent IN number,
23: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
24: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
25: p_compute_tax IN varchar2,
26: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
27: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
28: p_tax_percent IN OUT NOCOPY number,
29: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
30: p_status OUT NOCOPY varchar2,

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

23: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
24: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
25: p_compute_tax IN varchar2,
26: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
27: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
28: p_tax_percent IN OUT NOCOPY number,
29: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
30: p_status OUT NOCOPY varchar2,
31: p_submit_cm_dist IN varchar2 DEFAULT 'N');

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

25: p_compute_tax IN varchar2,
26: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
27: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
28: p_tax_percent IN OUT NOCOPY number,
29: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
30: p_status OUT NOCOPY varchar2,
31: p_submit_cm_dist IN varchar2 DEFAULT 'N');
32:
33: PROCEDURE update_header(

Line 36: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

32:
33: PROCEDURE update_header(
34: p_form_name IN varchar2,
35: p_form_version IN number,
36: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
37: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
38: p_trx_class IN ra_cust_trx_types.type%type,
39: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
40: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,

Line 37: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

33: PROCEDURE update_header(
34: p_form_name IN varchar2,
35: p_form_version IN number,
36: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
37: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
38: p_trx_class IN ra_cust_trx_types.type%type,
39: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
40: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
41: p_currency_code IN fnd_currencies.currency_code%type,

Line 42: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

38: p_trx_class IN ra_cust_trx_types.type%type,
39: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
40: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
41: p_currency_code IN fnd_currencies.currency_code%type,
42: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
43: p_line_percent IN number,
44: p_freight_pecent IN number,
45: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
46: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 45: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

41: p_currency_code IN fnd_currencies.currency_code%type,
42: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
43: p_line_percent IN number,
44: p_freight_pecent IN number,
45: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
46: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
47: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
48: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
49: p_rederive_credit_info IN varchar2,

Line 46: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

42: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
43: p_line_percent IN number,
44: p_freight_pecent IN number,
45: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
46: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
47: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
48: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
49: p_rederive_credit_info IN varchar2,
50: p_rerun_aa IN varchar2,

Line 47: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,

43: p_line_percent IN number,
44: p_freight_pecent IN number,
45: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
46: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
47: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
48: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
49: p_rederive_credit_info IN varchar2,
50: p_rerun_aa IN varchar2,
51: p_rerun_cm_module IN varchar2,

Line 48: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

44: p_freight_pecent IN number,
45: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
46: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
47: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
48: p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
49: p_rederive_credit_info IN varchar2,
50: p_rerun_aa IN varchar2,
51: p_rerun_cm_module IN varchar2,
52: p_compute_tax IN varchar2,

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

50: p_rerun_aa IN varchar2,
51: p_rerun_cm_module IN varchar2,
52: p_compute_tax IN varchar2,
53: p_tax_percent IN OUT NOCOPY number,
54: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
55: p_status OUT NOCOPY varchar2);
56:
57:
58: PROCEDURE insert_line(

Line 61: p_credit_rec IN ra_customer_trx_lines%rowtype,

57:
58: PROCEDURE insert_line(
59: p_form_name IN varchar2,
60: p_form_version IN number,
61: p_credit_rec IN ra_customer_trx_lines%rowtype,
62: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
63: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
64: p_line_percent IN number,
65: p_freight_percent IN number,

Line 62: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

58: PROCEDURE insert_line(
59: p_form_name IN varchar2,
60: p_form_version IN number,
61: p_credit_rec IN ra_customer_trx_lines%rowtype,
62: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
63: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
64: p_line_percent IN number,
65: p_freight_percent IN number,
66: p_memo_line_type IN ar_memo_lines.line_type%type,

Line 63: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

59: p_form_name IN varchar2,
60: p_form_version IN number,
61: p_credit_rec IN ra_customer_trx_lines%rowtype,
62: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
63: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
64: p_line_percent IN number,
65: p_freight_percent IN number,
66: p_memo_line_type IN ar_memo_lines.line_type%type,
67: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 71: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

67: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
68: p_currency_code IN fnd_currencies.currency_code%type,
69: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
70: p_compute_tax IN varchar2,
71: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
72: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
73: p_prev_customer_trx_line_id IN
74: ra_customer_trx_lines.customer_trx_line_id%type,
75: p_tax_percent IN OUT NOCOPY number,

Line 72: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

68: p_currency_code IN fnd_currencies.currency_code%type,
69: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
70: p_compute_tax IN varchar2,
71: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
72: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
73: p_prev_customer_trx_line_id IN
74: ra_customer_trx_lines.customer_trx_line_id%type,
75: p_tax_percent IN OUT NOCOPY number,
76: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 74: ra_customer_trx_lines.customer_trx_line_id%type,

70: p_compute_tax IN varchar2,
71: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
72: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
73: p_prev_customer_trx_line_id IN
74: ra_customer_trx_lines.customer_trx_line_id%type,
75: p_tax_percent IN OUT NOCOPY number,
76: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
77: p_customer_trx_line_id OUT NOCOPY
78: ra_customer_trx_lines.customer_trx_line_id%type,

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

72: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
73: p_prev_customer_trx_line_id IN
74: ra_customer_trx_lines.customer_trx_line_id%type,
75: p_tax_percent IN OUT NOCOPY number,
76: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
77: p_customer_trx_line_id OUT NOCOPY
78: ra_customer_trx_lines.customer_trx_line_id%type,
79: p_status OUT NOCOPY varchar2);
80:

Line 78: ra_customer_trx_lines.customer_trx_line_id%type,

74: ra_customer_trx_lines.customer_trx_line_id%type,
75: p_tax_percent IN OUT NOCOPY number,
76: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
77: p_customer_trx_line_id OUT NOCOPY
78: ra_customer_trx_lines.customer_trx_line_id%type,
79: p_status OUT NOCOPY varchar2);
80:
81: PROCEDURE update_line(
82: p_form_name IN varchar2,

Line 84: p_credit_rec IN ra_customer_trx_lines%rowtype,

80:
81: PROCEDURE update_line(
82: p_form_name IN varchar2,
83: p_form_version IN number,
84: p_credit_rec IN ra_customer_trx_lines%rowtype,
85: p_customer_trx_line_id IN
86: ra_customer_trx_lines.customer_trx_line_id%type,
87: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
88: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

Line 86: ra_customer_trx_lines.customer_trx_line_id%type,

82: p_form_name IN varchar2,
83: p_form_version IN number,
84: p_credit_rec IN ra_customer_trx_lines%rowtype,
85: p_customer_trx_line_id IN
86: ra_customer_trx_lines.customer_trx_line_id%type,
87: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
88: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
89: p_line_percent IN number,
90: p_freight_percent IN number,

Line 87: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

83: p_form_version IN number,
84: p_credit_rec IN ra_customer_trx_lines%rowtype,
85: p_customer_trx_line_id IN
86: ra_customer_trx_lines.customer_trx_line_id%type,
87: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
88: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
89: p_line_percent IN number,
90: p_freight_percent IN number,
91: p_memo_line_type IN ar_memo_lines.line_type%type,

Line 88: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

84: p_credit_rec IN ra_customer_trx_lines%rowtype,
85: p_customer_trx_line_id IN
86: ra_customer_trx_lines.customer_trx_line_id%type,
87: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
88: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
89: p_line_percent IN number,
90: p_freight_percent IN number,
91: p_memo_line_type IN ar_memo_lines.line_type%type,
92: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 95: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

91: p_memo_line_type IN ar_memo_lines.line_type%type,
92: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
93: p_currency_code IN fnd_currencies.currency_code%type,
94: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
95: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
96: p_rerun_aa IN varchar2,
97: p_recalculate_tax IN varchar2,
98: p_compute_tax IN varchar2,
99: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 99: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

95: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
96: p_rerun_aa IN varchar2,
97: p_recalculate_tax IN varchar2,
98: p_compute_tax IN varchar2,
99: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
100: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
101: p_prev_customer_trx_line_id IN
102: ra_customer_trx_lines.customer_trx_line_id%type,
103: p_tax_percent IN OUT NOCOPY number,

Line 100: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

96: p_rerun_aa IN varchar2,
97: p_recalculate_tax IN varchar2,
98: p_compute_tax IN varchar2,
99: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
100: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
101: p_prev_customer_trx_line_id IN
102: ra_customer_trx_lines.customer_trx_line_id%type,
103: p_tax_percent IN OUT NOCOPY number,
104: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 102: ra_customer_trx_lines.customer_trx_line_id%type,

98: p_compute_tax IN varchar2,
99: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
100: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
101: p_prev_customer_trx_line_id IN
102: ra_customer_trx_lines.customer_trx_line_id%type,
103: p_tax_percent IN OUT NOCOPY number,
104: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
105: p_status OUT NOCOPY varchar2);
106:

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

100: p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
101: p_prev_customer_trx_line_id IN
102: ra_customer_trx_lines.customer_trx_line_id%type,
103: p_tax_percent IN OUT NOCOPY number,
104: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
105: p_status OUT NOCOPY varchar2);
106:
107: PROCEDURE freight_post_update(
108: p_frt_rec IN ra_customer_trx_lines%rowtype,

Line 108: p_frt_rec IN ra_customer_trx_lines%rowtype,

104: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
105: p_status OUT NOCOPY varchar2);
106:
107: PROCEDURE freight_post_update(
108: p_frt_rec IN ra_customer_trx_lines%rowtype,
109: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
110: p_frt_ccid IN
111: ra_cust_trx_line_gl_dist.code_combination_id%type);
112: