DBA Data[Home] [Help]

APPS.ARP_CTLS_PKG dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 13: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);

9: p_percent_total IN OUT NOCOPY number,
10: p_percent_total_rtot_db IN OUT NOCOPY number );
11:
12: PROCEDURE display_salescredit( p_cust_trx_line_salesrep_id IN
13: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
14:
15: PROCEDURE display_salescredit_rec( p_srep_rec IN
16: ra_cust_trx_line_salesreps%rowtype);
17:

Line 16: ra_cust_trx_line_salesreps%rowtype);

12: PROCEDURE display_salescredit( p_cust_trx_line_salesrep_id IN
13: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
14:
15: PROCEDURE display_salescredit_rec( p_srep_rec IN
16: ra_cust_trx_line_salesreps%rowtype);
17:
18: PROCEDURE display_salescredit_f_ctl_id( p_customer_trx_line_id IN
19: ra_customer_trx_lines.customer_trx_line_id%type);
20:

Line 21: PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype);

17:
18: PROCEDURE display_salescredit_f_ctl_id( p_customer_trx_line_id IN
19: ra_customer_trx_lines.customer_trx_line_id%type);
20:
21: PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype);
22:
23: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;
24:
25: PROCEDURE lock_p( p_cust_trx_line_salesrep_id

Line 26: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);

22:
23: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;
24:
25: PROCEDURE lock_p( p_cust_trx_line_salesrep_id
26: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
27:
28: PROCEDURE lock_f_ct_id( p_customer_trx_id
29: IN ra_customer_trx.customer_trx_id%type );
30:

Line 34: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,

30:
31: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
32: IN ra_customer_trx_lines.customer_trx_line_id%type);
33:
34: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
35: p_cust_trx_line_salesrep_id IN
36: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
37:
38: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

Line 36: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);

32: IN ra_customer_trx_lines.customer_trx_line_id%type);
33:
34: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
35: p_cust_trx_line_salesrep_id IN
36: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
37:
38: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
39: p_cust_trx_line_salesrep_id IN
40: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

Line 38: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

34: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
35: p_cust_trx_line_salesrep_id IN
36: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
37:
38: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
39: p_cust_trx_line_salesrep_id IN
40: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
41: p_ignore_who_flag BOOLEAN DEFAULT FALSE);
42:

Line 40: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

36: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
37:
38: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
39: p_cust_trx_line_salesrep_id IN
40: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
41: p_ignore_who_flag BOOLEAN DEFAULT FALSE);
42:
43: PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
44: p_cust_trx_line_salesrep_id IN

Line 43: PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,

39: p_cust_trx_line_salesrep_id IN
40: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
41: p_ignore_who_flag BOOLEAN DEFAULT FALSE);
42:
43: PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
44: p_cust_trx_line_salesrep_id IN
45: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
46:
47: procedure delete_p( p_cust_trx_line_salesrep_id

Line 45: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);

41: p_ignore_who_flag BOOLEAN DEFAULT FALSE);
42:
43: PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
44: p_cust_trx_line_salesrep_id IN
45: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
46:
47: procedure delete_p( p_cust_trx_line_salesrep_id
48: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
49: p_customer_trx_line_id

Line 48: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

44: p_cust_trx_line_salesrep_id IN
45: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
46:
47: procedure delete_p( p_cust_trx_line_salesrep_id
48: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
49: p_customer_trx_line_id
50: IN ra_customer_trx_lines.customer_trx_line_id%type );
51:
52: procedure delete_f_ct_id( p_customer_trx_id

Line 59: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

55:
56: procedure delete_f_ctl_id( p_customer_trx_line_id
57: IN ra_customer_trx_lines.customer_trx_line_id%type);
58:
59: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
60: p_cust_trx_line_salesrep_id IN
61: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
62:
63: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

Line 61: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);

57: IN ra_customer_trx_lines.customer_trx_line_id%type);
58:
59: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
60: p_cust_trx_line_salesrep_id IN
61: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
62:
63: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
64: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
65:

Line 63: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

59: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
60: p_cust_trx_line_salesrep_id IN
61: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
62:
63: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
64: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
65:
66: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
67: p_customer_trx_line_id IN

Line 66: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

62:
63: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
64: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
65:
66: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
67: p_customer_trx_line_id IN
68: ra_customer_trx_lines.customer_trx_line_id%type);
69:
70: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

Line 70: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

66: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
67: p_customer_trx_line_id IN
68: ra_customer_trx_lines.customer_trx_line_id%type);
69:
70: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
71: p_prev_cust_trx_line_srep_id
72: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type);
73:
74: PROCEDURE update_amounts_f_ctl_id(

Line 72: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type);

68: ra_customer_trx_lines.customer_trx_line_id%type);
69:
70: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
71: p_prev_cust_trx_line_srep_id
72: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type);
73:
74: PROCEDURE update_amounts_f_ctl_id(
75: p_customer_trx_line_id IN
76: ra_customer_trx_lines.customer_trx_line_id%type,

Line 83: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

79: p_foreign_currency_code IN
80: fnd_currencies.currency_code%type);
81:
82: PROCEDURE insert_p(
83: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
84: p_cust_trx_line_salesrep_id
85: OUT NOCOPY ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
86: );
87:

Line 85: OUT NOCOPY ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type

81:
82: PROCEDURE insert_p(
83: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
84: p_cust_trx_line_salesrep_id
85: OUT NOCOPY ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
86: );
87:
88: PROCEDURE insert_f_ct_ctl_id(
89: p_customer_trx_id IN

Line 109: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

105: p_customer_trx_line_id IN
106: ra_customer_trx_lines.customer_trx_line_id%type
107: );
108: PROCEDURE merge_srep_recs(
109: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
110: p_new_srep_rec IN
111: ra_cust_trx_line_salesreps%rowtype,
112: p_out_srep_rec IN OUT NOCOPY
113: ra_cust_trx_line_salesreps%rowtype);

Line 111: ra_cust_trx_line_salesreps%rowtype,

107: );
108: PROCEDURE merge_srep_recs(
109: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
110: p_new_srep_rec IN
111: ra_cust_trx_line_salesreps%rowtype,
112: p_out_srep_rec IN OUT NOCOPY
113: ra_cust_trx_line_salesreps%rowtype);
114:
115: PROCEDURE erase_foreign_key_references( p_cust_trx_line_salesrep_id IN

Line 113: ra_cust_trx_line_salesreps%rowtype);

109: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
110: p_new_srep_rec IN
111: ra_cust_trx_line_salesreps%rowtype,
112: p_out_srep_rec IN OUT NOCOPY
113: ra_cust_trx_line_salesreps%rowtype);
114:
115: PROCEDURE erase_foreign_key_references( p_cust_trx_line_salesrep_id IN
116: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
117: p_customer_trx_id IN

Line 116: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

112: p_out_srep_rec IN OUT NOCOPY
113: ra_cust_trx_line_salesreps%rowtype);
114:
115: PROCEDURE erase_foreign_key_references( p_cust_trx_line_salesrep_id IN
116: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
117: p_customer_trx_id IN
118: ra_customer_trx.customer_trx_id%type,
119: p_customer_trx_line_id IN
120: ra_customer_trx_lines.customer_trx_line_id%type);

Line 124: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

120: ra_customer_trx_lines.customer_trx_line_id%type);
121:
122: PROCEDURE lock_compare_cover(
123: p_cust_trx_line_salesrep_id IN
124: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
125: p_customer_trx_id IN
126: ra_cust_trx_line_salesreps.customer_trx_id%type,
127: p_customer_trx_line_id IN
128: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

Line 126: ra_cust_trx_line_salesreps.customer_trx_id%type,

122: PROCEDURE lock_compare_cover(
123: p_cust_trx_line_salesrep_id IN
124: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
125: p_customer_trx_id IN
126: ra_cust_trx_line_salesreps.customer_trx_id%type,
127: p_customer_trx_line_id IN
128: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
129: p_salesrep_id IN
130: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 128: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

124: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
125: p_customer_trx_id IN
126: ra_cust_trx_line_salesreps.customer_trx_id%type,
127: p_customer_trx_line_id IN
128: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
129: p_salesrep_id IN
130: ra_cust_trx_line_salesreps.salesrep_id%type,
131: p_revenue_amount_split IN
132: ra_cust_trx_line_salesreps.revenue_amount_split%type,

Line 130: ra_cust_trx_line_salesreps.salesrep_id%type,

126: ra_cust_trx_line_salesreps.customer_trx_id%type,
127: p_customer_trx_line_id IN
128: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
129: p_salesrep_id IN
130: ra_cust_trx_line_salesreps.salesrep_id%type,
131: p_revenue_amount_split IN
132: ra_cust_trx_line_salesreps.revenue_amount_split%type,
133: p_non_revenue_amount_split IN
134: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

Line 132: ra_cust_trx_line_salesreps.revenue_amount_split%type,

128: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
129: p_salesrep_id IN
130: ra_cust_trx_line_salesreps.salesrep_id%type,
131: p_revenue_amount_split IN
132: ra_cust_trx_line_salesreps.revenue_amount_split%type,
133: p_non_revenue_amount_split IN
134: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
135: p_non_revenue_percent_split IN
136: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

Line 134: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

130: ra_cust_trx_line_salesreps.salesrep_id%type,
131: p_revenue_amount_split IN
132: ra_cust_trx_line_salesreps.revenue_amount_split%type,
133: p_non_revenue_amount_split IN
134: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
135: p_non_revenue_percent_split IN
136: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
137: p_revenue_percent_split IN
138: ra_cust_trx_line_salesreps.revenue_percent_split%type,

Line 136: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

132: ra_cust_trx_line_salesreps.revenue_amount_split%type,
133: p_non_revenue_amount_split IN
134: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
135: p_non_revenue_percent_split IN
136: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
137: p_revenue_percent_split IN
138: ra_cust_trx_line_salesreps.revenue_percent_split%type,
139: p_prev_cust_trx_line_srep_id IN
140: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

Line 138: ra_cust_trx_line_salesreps.revenue_percent_split%type,

134: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
135: p_non_revenue_percent_split IN
136: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
137: p_revenue_percent_split IN
138: ra_cust_trx_line_salesreps.revenue_percent_split%type,
139: p_prev_cust_trx_line_srep_id IN
140: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
141: p_attribute_category IN
142: ra_cust_trx_line_salesreps.attribute_category%type,

Line 140: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

136: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
137: p_revenue_percent_split IN
138: ra_cust_trx_line_salesreps.revenue_percent_split%type,
139: p_prev_cust_trx_line_srep_id IN
140: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
141: p_attribute_category IN
142: ra_cust_trx_line_salesreps.attribute_category%type,
143: p_attribute1 IN
144: ra_cust_trx_line_salesreps.attribute1%type,

Line 142: ra_cust_trx_line_salesreps.attribute_category%type,

138: ra_cust_trx_line_salesreps.revenue_percent_split%type,
139: p_prev_cust_trx_line_srep_id IN
140: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
141: p_attribute_category IN
142: ra_cust_trx_line_salesreps.attribute_category%type,
143: p_attribute1 IN
144: ra_cust_trx_line_salesreps.attribute1%type,
145: p_attribute2 IN
146: ra_cust_trx_line_salesreps.attribute2%type,

Line 144: ra_cust_trx_line_salesreps.attribute1%type,

140: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
141: p_attribute_category IN
142: ra_cust_trx_line_salesreps.attribute_category%type,
143: p_attribute1 IN
144: ra_cust_trx_line_salesreps.attribute1%type,
145: p_attribute2 IN
146: ra_cust_trx_line_salesreps.attribute2%type,
147: p_attribute3 IN
148: ra_cust_trx_line_salesreps.attribute3%type,

Line 146: ra_cust_trx_line_salesreps.attribute2%type,

142: ra_cust_trx_line_salesreps.attribute_category%type,
143: p_attribute1 IN
144: ra_cust_trx_line_salesreps.attribute1%type,
145: p_attribute2 IN
146: ra_cust_trx_line_salesreps.attribute2%type,
147: p_attribute3 IN
148: ra_cust_trx_line_salesreps.attribute3%type,
149: p_attribute4 IN
150: ra_cust_trx_line_salesreps.attribute4%type,

Line 148: ra_cust_trx_line_salesreps.attribute3%type,

144: ra_cust_trx_line_salesreps.attribute1%type,
145: p_attribute2 IN
146: ra_cust_trx_line_salesreps.attribute2%type,
147: p_attribute3 IN
148: ra_cust_trx_line_salesreps.attribute3%type,
149: p_attribute4 IN
150: ra_cust_trx_line_salesreps.attribute4%type,
151: p_attribute5 IN
152: ra_cust_trx_line_salesreps.attribute5%type,

Line 150: ra_cust_trx_line_salesreps.attribute4%type,

146: ra_cust_trx_line_salesreps.attribute2%type,
147: p_attribute3 IN
148: ra_cust_trx_line_salesreps.attribute3%type,
149: p_attribute4 IN
150: ra_cust_trx_line_salesreps.attribute4%type,
151: p_attribute5 IN
152: ra_cust_trx_line_salesreps.attribute5%type,
153: p_attribute6 IN
154: ra_cust_trx_line_salesreps.attribute6%type,

Line 152: ra_cust_trx_line_salesreps.attribute5%type,

148: ra_cust_trx_line_salesreps.attribute3%type,
149: p_attribute4 IN
150: ra_cust_trx_line_salesreps.attribute4%type,
151: p_attribute5 IN
152: ra_cust_trx_line_salesreps.attribute5%type,
153: p_attribute6 IN
154: ra_cust_trx_line_salesreps.attribute6%type,
155: p_attribute7 IN
156: ra_cust_trx_line_salesreps.attribute7%type,

Line 154: ra_cust_trx_line_salesreps.attribute6%type,

150: ra_cust_trx_line_salesreps.attribute4%type,
151: p_attribute5 IN
152: ra_cust_trx_line_salesreps.attribute5%type,
153: p_attribute6 IN
154: ra_cust_trx_line_salesreps.attribute6%type,
155: p_attribute7 IN
156: ra_cust_trx_line_salesreps.attribute7%type,
157: p_attribute8 IN
158: ra_cust_trx_line_salesreps.attribute8%type,

Line 156: ra_cust_trx_line_salesreps.attribute7%type,

152: ra_cust_trx_line_salesreps.attribute5%type,
153: p_attribute6 IN
154: ra_cust_trx_line_salesreps.attribute6%type,
155: p_attribute7 IN
156: ra_cust_trx_line_salesreps.attribute7%type,
157: p_attribute8 IN
158: ra_cust_trx_line_salesreps.attribute8%type,
159: p_attribute9 IN
160: ra_cust_trx_line_salesreps.attribute9%type,

Line 158: ra_cust_trx_line_salesreps.attribute8%type,

154: ra_cust_trx_line_salesreps.attribute6%type,
155: p_attribute7 IN
156: ra_cust_trx_line_salesreps.attribute7%type,
157: p_attribute8 IN
158: ra_cust_trx_line_salesreps.attribute8%type,
159: p_attribute9 IN
160: ra_cust_trx_line_salesreps.attribute9%type,
161: p_attribute10 IN
162: ra_cust_trx_line_salesreps.attribute10%type,

Line 160: ra_cust_trx_line_salesreps.attribute9%type,

156: ra_cust_trx_line_salesreps.attribute7%type,
157: p_attribute8 IN
158: ra_cust_trx_line_salesreps.attribute8%type,
159: p_attribute9 IN
160: ra_cust_trx_line_salesreps.attribute9%type,
161: p_attribute10 IN
162: ra_cust_trx_line_salesreps.attribute10%type,
163: p_attribute11 IN
164: ra_cust_trx_line_salesreps.attribute11%type,

Line 162: ra_cust_trx_line_salesreps.attribute10%type,

158: ra_cust_trx_line_salesreps.attribute8%type,
159: p_attribute9 IN
160: ra_cust_trx_line_salesreps.attribute9%type,
161: p_attribute10 IN
162: ra_cust_trx_line_salesreps.attribute10%type,
163: p_attribute11 IN
164: ra_cust_trx_line_salesreps.attribute11%type,
165: p_attribute12 IN
166: ra_cust_trx_line_salesreps.attribute12%type,

Line 164: ra_cust_trx_line_salesreps.attribute11%type,

160: ra_cust_trx_line_salesreps.attribute9%type,
161: p_attribute10 IN
162: ra_cust_trx_line_salesreps.attribute10%type,
163: p_attribute11 IN
164: ra_cust_trx_line_salesreps.attribute11%type,
165: p_attribute12 IN
166: ra_cust_trx_line_salesreps.attribute12%type,
167: p_attribute13 IN
168: ra_cust_trx_line_salesreps.attribute13%type,

Line 166: ra_cust_trx_line_salesreps.attribute12%type,

162: ra_cust_trx_line_salesreps.attribute10%type,
163: p_attribute11 IN
164: ra_cust_trx_line_salesreps.attribute11%type,
165: p_attribute12 IN
166: ra_cust_trx_line_salesreps.attribute12%type,
167: p_attribute13 IN
168: ra_cust_trx_line_salesreps.attribute13%type,
169: p_attribute14 IN
170: ra_cust_trx_line_salesreps.attribute14%type,

Line 168: ra_cust_trx_line_salesreps.attribute13%type,

164: ra_cust_trx_line_salesreps.attribute11%type,
165: p_attribute12 IN
166: ra_cust_trx_line_salesreps.attribute12%type,
167: p_attribute13 IN
168: ra_cust_trx_line_salesreps.attribute13%type,
169: p_attribute14 IN
170: ra_cust_trx_line_salesreps.attribute14%type,
171: p_attribute15 IN
172: ra_cust_trx_line_salesreps.attribute15%type,

Line 170: ra_cust_trx_line_salesreps.attribute14%type,

166: ra_cust_trx_line_salesreps.attribute12%type,
167: p_attribute13 IN
168: ra_cust_trx_line_salesreps.attribute13%type,
169: p_attribute14 IN
170: ra_cust_trx_line_salesreps.attribute14%type,
171: p_attribute15 IN
172: ra_cust_trx_line_salesreps.attribute15%type,
173: p_revenue_salesgroup_id IN
174: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

Line 172: ra_cust_trx_line_salesreps.attribute15%type,

168: ra_cust_trx_line_salesreps.attribute13%type,
169: p_attribute14 IN
170: ra_cust_trx_line_salesreps.attribute14%type,
171: p_attribute15 IN
172: ra_cust_trx_line_salesreps.attribute15%type,
173: p_revenue_salesgroup_id IN
174: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
175: p_non_revenue_salesgroup_id IN
176: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);

Line 174: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

170: ra_cust_trx_line_salesreps.attribute14%type,
171: p_attribute15 IN
172: ra_cust_trx_line_salesreps.attribute15%type,
173: p_revenue_salesgroup_id IN
174: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
175: p_non_revenue_salesgroup_id IN
176: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
177:
178: PROCEDURE init;

Line 176: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);

172: ra_cust_trx_line_salesreps.attribute15%type,
173: p_revenue_salesgroup_id IN
174: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
175: p_non_revenue_salesgroup_id IN
176: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
177:
178: PROCEDURE init;
179:
180: END ARP_CTLS_PKG;