DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT dependencies on RA_CUSTOMER_TRX_LINES

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 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 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 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 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 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 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: