APPS.ARP_CTL_PKG dependencies on RA_CUSTOMER_TRX

Line 4: PROCEDURE set_to_dummy( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype);

1: PACKAGE ARP_CTL_PKG 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

Line 7: PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,

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

Line 9: ra_customer_trx_lines.customer_trx_line_id%type );

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:

Line 12: ra_customer_trx_lines.customer_trx_line_id%type );

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 );

Line 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 );

Line 18: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,

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,

Line 20: ra_customer_trx_lines.customer_trx_line_id%type );

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,

Line 22: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,

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:

Line 24: ra_customer_trx_lines.customer_trx_line_id%type,

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);

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

Line 31: ra_customer_trx.customer_trx_id%type);

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:

Line 34: ra_customer_trx_lines.link_to_cust_trx_line_id%type);

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,

Line 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);

Line 40: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

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,

Line 42: ra_customer_trx_lines.line_type%type DEFAULT NULL);

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,

Line 44: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,

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 );

Line 46: ra_customer_trx_lines.customer_trx_line_id%type,

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,

Line 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,

Line 52: ra_customer_trx_lines.customer_trx_id%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,
55: p_currency_code IN fnd_currencies.currency_code%type
56: DEFAULT NULL);

Line 54: ra_customer_trx_lines.line_type%type 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(

Line 76: p_line_rec IN ra_customer_trx_lines%rowtype,

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:

Line 78: ra_customer_trx_lines.customer_trx_line_id%type

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

Line 83: ra_customer_trx_lines.customer_trx_line_id%type

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

Line 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);

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

Line 94: ra_customer_trx.customer_trx_id%type );

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

Line 97: p_old_line_rec IN ra_customer_trx_lines%rowtype,

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);

Line 99: 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(

Line 101: ra_customer_trx_lines%rowtype);

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,

Line 104: p_customer_trx_id IN ra_customer_trx.customer_trx_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,

Line 105: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

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,

Line 106: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%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,

Line 107: p_line_type IN ra_customer_trx_lines.line_type%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,

Line 109: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%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:

Line 110: p_credit_amount IN ra_customer_trx_lines.extended_amount%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:
114: PROCEDURE update_line_f_cm_ctl_id(

Line 112: p_tax_amount IN ra_customer_trx_lines.extended_amount%type DEFAULT NULL);

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,

Line 115: p_customer_trx_id IN ra_customer_trx.customer_trx_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,

Line 116: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%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,

Line 117: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%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);

Line 118: p_line_type IN ra_customer_trx_lines.line_type%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:

Line 119: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,

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;

Line 120: p_credit_amount IN ra_customer_trx_lines.extended_amount%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;
124: