1: PACKAGE ARP_CTL_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARTICTLS.pls 120.6 2005/08/18 15:22:43 jbeckett ship $ */
3:
4: PROCEDURE set_to_dummy( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype);
5:
6:
7: PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,
8: p_customer_trx_line_id IN
3:
4: PROCEDURE set_to_dummy( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype);
5:
6:
7: PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,
8: p_customer_trx_line_id IN
9: ra_customer_trx_lines.customer_trx_line_id%type );
10:
11: PROCEDURE lock_p( p_customer_trx_line_id IN
5:
6:
7: PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,
8: p_customer_trx_line_id IN
9: ra_customer_trx_lines.customer_trx_line_id%type );
10:
11: PROCEDURE lock_p( p_customer_trx_line_id IN
12: ra_customer_trx_lines.customer_trx_line_id%type );
13:
8: p_customer_trx_line_id IN
9: ra_customer_trx_lines.customer_trx_line_id%type );
10:
11: PROCEDURE lock_p( p_customer_trx_line_id IN
12: ra_customer_trx_lines.customer_trx_line_id%type );
13:
14:
15: PROCEDURE lock_f_ct_id( p_customer_trx_id IN
16: ra_customer_trx.customer_trx_id%type );
12: ra_customer_trx_lines.customer_trx_line_id%type );
13:
14:
15: PROCEDURE lock_f_ct_id( p_customer_trx_id IN
16: ra_customer_trx.customer_trx_id%type );
17:
18: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
19: p_customer_trx_line_id IN
20: ra_customer_trx_lines.customer_trx_line_id%type );
14:
15: PROCEDURE lock_f_ct_id( p_customer_trx_id IN
16: ra_customer_trx.customer_trx_id%type );
17:
18: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
19: p_customer_trx_line_id IN
20: ra_customer_trx_lines.customer_trx_line_id%type );
21:
22: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,
16: ra_customer_trx.customer_trx_id%type );
17:
18: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
19: p_customer_trx_line_id IN
20: ra_customer_trx_lines.customer_trx_line_id%type );
21:
22: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,
23: p_customer_trx_line_id IN
24: ra_customer_trx_lines.customer_trx_line_id%type,
18: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
19: p_customer_trx_line_id IN
20: ra_customer_trx_lines.customer_trx_line_id%type );
21:
22: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,
23: p_customer_trx_line_id IN
24: ra_customer_trx_lines.customer_trx_line_id%type,
25: p_ignore_who_flag BOOLEAN DEFAULT FALSE );
26:
20: ra_customer_trx_lines.customer_trx_line_id%type );
21:
22: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,
23: p_customer_trx_line_id IN
24: ra_customer_trx_lines.customer_trx_line_id%type,
25: p_ignore_who_flag BOOLEAN DEFAULT FALSE );
26:
27: procedure delete_p( p_customer_trx_line_id IN
28: ra_customer_trx_lines.customer_trx_line_id%type);
24: ra_customer_trx_lines.customer_trx_line_id%type,
25: p_ignore_who_flag BOOLEAN DEFAULT FALSE );
26:
27: procedure delete_p( p_customer_trx_line_id IN
28: ra_customer_trx_lines.customer_trx_line_id%type);
29:
30: procedure delete_f_ct_id( p_customer_trx_id IN
31: ra_customer_trx.customer_trx_id%type);
32:
27: procedure delete_p( p_customer_trx_line_id IN
28: ra_customer_trx_lines.customer_trx_line_id%type);
29:
30: procedure delete_f_ct_id( p_customer_trx_id IN
31: ra_customer_trx.customer_trx_id%type);
32:
33: procedure delete_f_ltctl_id( p_link_to_cust_trx_line_id IN
34: ra_customer_trx_lines.link_to_cust_trx_line_id%type);
35:
30: procedure delete_f_ct_id( p_customer_trx_id IN
31: ra_customer_trx.customer_trx_id%type);
32:
33: procedure delete_f_ltctl_id( p_link_to_cust_trx_line_id IN
34: ra_customer_trx_lines.link_to_cust_trx_line_id%type);
35:
36: procedure delete_f_ct_ltctl_id_type(
37: p_customer_trx_id IN
38: ra_customer_trx.customer_trx_id%type,
34: ra_customer_trx_lines.link_to_cust_trx_line_id%type);
35:
36: procedure delete_f_ct_ltctl_id_type(
37: p_customer_trx_id IN
38: ra_customer_trx.customer_trx_id%type,
39: p_link_to_cust_trx_line_id IN
40: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
41: p_line_type IN
42: ra_customer_trx_lines.line_type%type DEFAULT NULL);
36: procedure delete_f_ct_ltctl_id_type(
37: p_customer_trx_id IN
38: ra_customer_trx.customer_trx_id%type,
39: p_link_to_cust_trx_line_id IN
40: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
41: p_line_type IN
42: ra_customer_trx_lines.line_type%type DEFAULT NULL);
43:
44: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
38: ra_customer_trx.customer_trx_id%type,
39: p_link_to_cust_trx_line_id IN
40: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
41: p_line_type IN
42: ra_customer_trx_lines.line_type%type DEFAULT NULL);
43:
44: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
45: p_customer_trx_line_id IN
46: ra_customer_trx_lines.customer_trx_line_id%type,
40: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
41: p_line_type IN
42: ra_customer_trx_lines.line_type%type DEFAULT NULL);
43:
44: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
45: p_customer_trx_line_id IN
46: ra_customer_trx_lines.customer_trx_line_id%type,
47: p_currency_code IN fnd_currencies.currency_code%type
48: DEFAULT NULL );
42: ra_customer_trx_lines.line_type%type DEFAULT NULL);
43:
44: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
45: p_customer_trx_line_id IN
46: ra_customer_trx_lines.customer_trx_line_id%type,
47: p_currency_code IN fnd_currencies.currency_code%type
48: DEFAULT NULL );
49:
50: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
46: ra_customer_trx_lines.customer_trx_line_id%type,
47: p_currency_code IN fnd_currencies.currency_code%type
48: DEFAULT NULL );
49:
50: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
51: p_customer_trx_id IN
52: ra_customer_trx_lines.customer_trx_id%type,
53: p_line_type IN
54: ra_customer_trx_lines.line_type%type default null,
48: DEFAULT NULL );
49:
50: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
51: p_customer_trx_id IN
52: ra_customer_trx_lines.customer_trx_id%type,
53: p_line_type IN
54: ra_customer_trx_lines.line_type%type default null,
55: p_currency_code IN fnd_currencies.currency_code%type
56: DEFAULT NULL);
50: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
51: p_customer_trx_id IN
52: ra_customer_trx_lines.customer_trx_id%type,
53: p_line_type IN
54: ra_customer_trx_lines.line_type%type default null,
55: p_currency_code IN fnd_currencies.currency_code%type
56: DEFAULT NULL);
57:
58: PROCEDURE update_amount_f_ctl_id(
72: p_min_acct_unit IN Number);
73:
74:
75: PROCEDURE insert_p(
76: p_line_rec IN ra_customer_trx_lines%rowtype,
77: p_customer_trx_line_id OUT NOCOPY
78: ra_customer_trx_lines.customer_trx_line_id%type
79: );
80:
74:
75: PROCEDURE insert_p(
76: p_line_rec IN ra_customer_trx_lines%rowtype,
77: p_customer_trx_line_id OUT NOCOPY
78: ra_customer_trx_lines.customer_trx_line_id%type
79: );
80:
81: PROCEDURE display_line_p(
82: p_customer_trx_line_id IN
79: );
80:
81: PROCEDURE display_line_p(
82: p_customer_trx_line_id IN
83: ra_customer_trx_lines.customer_trx_line_id%type
84: );
85:
86: PROCEDURE display_line_rec(
87: p_line_rec IN ra_customer_trx_lines%rowtype
83: ra_customer_trx_lines.customer_trx_line_id%type
84: );
85:
86: PROCEDURE display_line_rec(
87: p_line_rec IN ra_customer_trx_lines%rowtype
88: );
89:
90: PROCEDURE display_line_f_lctl_id( p_link_to_cust_trx_line_id IN
91: ra_customer_trx_lines.link_to_cust_trx_line_id%type);
87: p_line_rec IN ra_customer_trx_lines%rowtype
88: );
89:
90: PROCEDURE display_line_f_lctl_id( p_link_to_cust_trx_line_id IN
91: ra_customer_trx_lines.link_to_cust_trx_line_id%type);
92:
93: PROCEDURE display_line_f_ct_id( p_customer_trx_id IN
94: ra_customer_trx.customer_trx_id%type );
95:
90: PROCEDURE display_line_f_lctl_id( p_link_to_cust_trx_line_id IN
91: ra_customer_trx_lines.link_to_cust_trx_line_id%type);
92:
93: PROCEDURE display_line_f_ct_id( p_customer_trx_id IN
94: ra_customer_trx.customer_trx_id%type );
95:
96: PROCEDURE merge_line_recs(
97: p_old_line_rec IN ra_customer_trx_lines%rowtype,
98: p_new_line_rec IN
93: PROCEDURE display_line_f_ct_id( p_customer_trx_id IN
94: ra_customer_trx.customer_trx_id%type );
95:
96: PROCEDURE merge_line_recs(
97: p_old_line_rec IN ra_customer_trx_lines%rowtype,
98: p_new_line_rec IN
99: ra_customer_trx_lines%rowtype,
100: p_out_line_rec IN OUT NOCOPY
101: ra_customer_trx_lines%rowtype);
95:
96: PROCEDURE merge_line_recs(
97: p_old_line_rec IN ra_customer_trx_lines%rowtype,
98: p_new_line_rec IN
99: ra_customer_trx_lines%rowtype,
100: p_out_line_rec IN OUT NOCOPY
101: ra_customer_trx_lines%rowtype);
102:
103: PROCEDURE insert_line_f_cm_ct_ctl_id(
97: p_old_line_rec IN ra_customer_trx_lines%rowtype,
98: p_new_line_rec IN
99: ra_customer_trx_lines%rowtype,
100: p_out_line_rec IN OUT NOCOPY
101: ra_customer_trx_lines%rowtype);
102:
103: PROCEDURE insert_line_f_cm_ct_ctl_id(
104: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
105: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
100: p_out_line_rec IN OUT NOCOPY
101: ra_customer_trx_lines%rowtype);
102:
103: PROCEDURE insert_line_f_cm_ct_ctl_id(
104: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
105: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
106: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
107: p_line_type IN ra_customer_trx_lines.line_type%type,
108: p_line_percent IN number,
101: ra_customer_trx_lines%rowtype);
102:
103: PROCEDURE insert_line_f_cm_ct_ctl_id(
104: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
105: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
106: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
107: p_line_type IN ra_customer_trx_lines.line_type%type,
108: p_line_percent IN number,
109: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
102:
103: PROCEDURE insert_line_f_cm_ct_ctl_id(
104: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
105: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
106: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
107: p_line_type IN ra_customer_trx_lines.line_type%type,
108: p_line_percent IN number,
109: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
110: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
103: PROCEDURE insert_line_f_cm_ct_ctl_id(
104: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
105: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
106: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
107: p_line_type IN ra_customer_trx_lines.line_type%type,
108: p_line_percent IN number,
109: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
110: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
111: p_currency_code IN fnd_currencies.currency_code%type,
105: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
106: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
107: p_line_type IN ra_customer_trx_lines.line_type%type,
108: p_line_percent IN number,
109: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
110: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
111: p_currency_code IN fnd_currencies.currency_code%type,
112: p_tax_amount IN ra_customer_trx_lines.extended_amount%type DEFAULT NULL);
113:
106: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
107: p_line_type IN ra_customer_trx_lines.line_type%type,
108: p_line_percent IN number,
109: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
110: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
111: p_currency_code IN fnd_currencies.currency_code%type,
112: p_tax_amount IN ra_customer_trx_lines.extended_amount%type DEFAULT NULL);
113:
114: PROCEDURE update_line_f_cm_ctl_id(
108: p_line_percent IN number,
109: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
110: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
111: p_currency_code IN fnd_currencies.currency_code%type,
112: p_tax_amount IN ra_customer_trx_lines.extended_amount%type DEFAULT NULL);
113:
114: PROCEDURE update_line_f_cm_ctl_id(
115: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
111: p_currency_code IN fnd_currencies.currency_code%type,
112: p_tax_amount IN ra_customer_trx_lines.extended_amount%type DEFAULT NULL);
113:
114: PROCEDURE update_line_f_cm_ctl_id(
115: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
117: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
118: p_line_type IN ra_customer_trx_lines.line_type%type,
119: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
112: p_tax_amount IN ra_customer_trx_lines.extended_amount%type DEFAULT NULL);
113:
114: PROCEDURE update_line_f_cm_ctl_id(
115: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
117: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
118: p_line_type IN ra_customer_trx_lines.line_type%type,
119: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
120: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
113:
114: PROCEDURE update_line_f_cm_ctl_id(
115: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
117: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
118: p_line_type IN ra_customer_trx_lines.line_type%type,
119: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
120: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
121: p_currency_code IN fnd_currencies.currency_code%type);
114: PROCEDURE update_line_f_cm_ctl_id(
115: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
117: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
118: p_line_type IN ra_customer_trx_lines.line_type%type,
119: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
120: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
121: p_currency_code IN fnd_currencies.currency_code%type);
122:
115: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
117: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
118: p_line_type IN ra_customer_trx_lines.line_type%type,
119: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
120: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
121: p_currency_code IN fnd_currencies.currency_code%type);
122:
123: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;
116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
117: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
118: p_line_type IN ra_customer_trx_lines.line_type%type,
119: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
120: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
121: p_currency_code IN fnd_currencies.currency_code%type);
122:
123: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;
124: