APPS.ARP_PROCESS_SALESCREDIT dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 9: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

5: PROCEDURE insert_salescredit(
6: p_form_name IN varchar2,
7: p_form_version IN number,
8: p_run_auto_accounting_flag IN boolean,
9: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
10: p_cust_trx_line_salesrep_id OUT NOCOPY
11: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
12: p_status OUT NOCOPY varchar2);
13:

Line 11: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

7: p_form_version IN number,
8: p_run_auto_accounting_flag IN boolean,
9: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
10: p_cust_trx_line_salesrep_id OUT NOCOPY
11: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
12: p_status OUT NOCOPY varchar2);
13:
14: PROCEDURE create_line_salescredits(p_customer_trx_id IN
15: ra_customer_trx_lines.customer_trx_id%type,

Line 31: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

27: p_form_version IN number,
28: p_run_auto_accounting_flag IN boolean,
29: p_backout_flag IN boolean,
30: p_cust_trx_line_salesrep_id IN
31: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
32: p_customer_trx_id IN
33: ra_customer_trx.customer_trx_id%type,
34: p_customer_trx_line_id IN
35: ra_customer_trx_lines.customer_trx_line_id%type,

Line 36: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

32: p_customer_trx_id IN
33: ra_customer_trx.customer_trx_id%type,
34: p_customer_trx_line_id IN
35: ra_customer_trx_lines.customer_trx_line_id%type,
36: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
37: p_backout_done_flag OUT NOCOPY boolean,
38: p_status OUT NOCOPY varchar2 );
39:
40: PROCEDURE delete_salescredit(

Line 45: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

41: p_form_name IN varchar2,
42: p_form_version IN number,
43: p_run_auto_accounting_flag IN boolean,
44: p_cust_trx_line_salesrep_id IN
45: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
46: p_customer_trx_id IN
47: ra_customer_trx.customer_trx_id%type,
48: p_customer_trx_line_id IN
49: ra_customer_trx_lines.customer_trx_line_id%type,

Line 50: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

46: p_customer_trx_id IN
47: ra_customer_trx.customer_trx_id%type,
48: p_customer_trx_line_id IN
49: ra_customer_trx_lines.customer_trx_line_id%type,
50: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
51: p_backout_flag IN boolean DEFAULT FALSE,
52: p_backout_done_flag OUT NOCOPY boolean,
53: p_status OUT NOCOPY varchar2 );
54:

Line 61: ra_cust_trx_line_salesreps.customer_trx_id%type,

57: p_form_version IN number,
58: p_run_auto_accounting_flag IN boolean,
59:
60: p_customer_trx_id IN
61: ra_cust_trx_line_salesreps.customer_trx_id%type,
62: p_customer_trx_line_id IN
63: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
64: p_salesrep_id IN
65: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 63: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

59:
60: p_customer_trx_id IN
61: ra_cust_trx_line_salesreps.customer_trx_id%type,
62: p_customer_trx_line_id IN
63: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
64: p_salesrep_id IN
65: ra_cust_trx_line_salesreps.salesrep_id%type,
66: p_revenue_amount_split IN
67: ra_cust_trx_line_salesreps.revenue_amount_split%type,

Line 65: ra_cust_trx_line_salesreps.salesrep_id%type,

61: ra_cust_trx_line_salesreps.customer_trx_id%type,
62: p_customer_trx_line_id IN
63: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
64: p_salesrep_id IN
65: ra_cust_trx_line_salesreps.salesrep_id%type,
66: p_revenue_amount_split IN
67: ra_cust_trx_line_salesreps.revenue_amount_split%type,
68: p_non_revenue_amount_split IN
69: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

Line 67: ra_cust_trx_line_salesreps.revenue_amount_split%type,

63: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
64: p_salesrep_id IN
65: ra_cust_trx_line_salesreps.salesrep_id%type,
66: p_revenue_amount_split IN
67: ra_cust_trx_line_salesreps.revenue_amount_split%type,
68: p_non_revenue_amount_split IN
69: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
70: p_non_revenue_percent_split IN
71: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

Line 69: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

65: ra_cust_trx_line_salesreps.salesrep_id%type,
66: p_revenue_amount_split IN
67: ra_cust_trx_line_salesreps.revenue_amount_split%type,
68: p_non_revenue_amount_split IN
69: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
70: p_non_revenue_percent_split IN
71: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
72: p_revenue_percent_split IN
73: ra_cust_trx_line_salesreps.revenue_percent_split%type,

Line 71: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

67: ra_cust_trx_line_salesreps.revenue_amount_split%type,
68: p_non_revenue_amount_split IN
69: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
70: p_non_revenue_percent_split IN
71: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
72: p_revenue_percent_split IN
73: ra_cust_trx_line_salesreps.revenue_percent_split%type,
74: p_prev_cust_trx_line_srep_id IN
75: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

Line 73: ra_cust_trx_line_salesreps.revenue_percent_split%type,

69: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
70: p_non_revenue_percent_split IN
71: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
72: p_revenue_percent_split IN
73: ra_cust_trx_line_salesreps.revenue_percent_split%type,
74: p_prev_cust_trx_line_srep_id IN
75: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
76: p_attribute_category IN
77: ra_cust_trx_line_salesreps.attribute_category%type,

Line 75: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

71: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
72: p_revenue_percent_split IN
73: ra_cust_trx_line_salesreps.revenue_percent_split%type,
74: p_prev_cust_trx_line_srep_id IN
75: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
76: p_attribute_category IN
77: ra_cust_trx_line_salesreps.attribute_category%type,
78: p_attribute1 IN
79: ra_cust_trx_line_salesreps.attribute1%type,

Line 77: ra_cust_trx_line_salesreps.attribute_category%type,

73: ra_cust_trx_line_salesreps.revenue_percent_split%type,
74: p_prev_cust_trx_line_srep_id IN
75: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
76: p_attribute_category IN
77: ra_cust_trx_line_salesreps.attribute_category%type,
78: p_attribute1 IN
79: ra_cust_trx_line_salesreps.attribute1%type,
80: p_attribute2 IN
81: ra_cust_trx_line_salesreps.attribute2%type,

Line 79: ra_cust_trx_line_salesreps.attribute1%type,

75: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
76: p_attribute_category IN
77: ra_cust_trx_line_salesreps.attribute_category%type,
78: p_attribute1 IN
79: ra_cust_trx_line_salesreps.attribute1%type,
80: p_attribute2 IN
81: ra_cust_trx_line_salesreps.attribute2%type,
82: p_attribute3 IN
83: ra_cust_trx_line_salesreps.attribute3%type,

Line 81: ra_cust_trx_line_salesreps.attribute2%type,

77: ra_cust_trx_line_salesreps.attribute_category%type,
78: p_attribute1 IN
79: ra_cust_trx_line_salesreps.attribute1%type,
80: p_attribute2 IN
81: ra_cust_trx_line_salesreps.attribute2%type,
82: p_attribute3 IN
83: ra_cust_trx_line_salesreps.attribute3%type,
84: p_attribute4 IN
85: ra_cust_trx_line_salesreps.attribute4%type,

Line 83: ra_cust_trx_line_salesreps.attribute3%type,

79: ra_cust_trx_line_salesreps.attribute1%type,
80: p_attribute2 IN
81: ra_cust_trx_line_salesreps.attribute2%type,
82: p_attribute3 IN
83: ra_cust_trx_line_salesreps.attribute3%type,
84: p_attribute4 IN
85: ra_cust_trx_line_salesreps.attribute4%type,
86: p_attribute5 IN
87: ra_cust_trx_line_salesreps.attribute5%type,

Line 85: ra_cust_trx_line_salesreps.attribute4%type,

81: ra_cust_trx_line_salesreps.attribute2%type,
82: p_attribute3 IN
83: ra_cust_trx_line_salesreps.attribute3%type,
84: p_attribute4 IN
85: ra_cust_trx_line_salesreps.attribute4%type,
86: p_attribute5 IN
87: ra_cust_trx_line_salesreps.attribute5%type,
88: p_attribute6 IN
89: ra_cust_trx_line_salesreps.attribute6%type,

Line 87: ra_cust_trx_line_salesreps.attribute5%type,

83: ra_cust_trx_line_salesreps.attribute3%type,
84: p_attribute4 IN
85: ra_cust_trx_line_salesreps.attribute4%type,
86: p_attribute5 IN
87: ra_cust_trx_line_salesreps.attribute5%type,
88: p_attribute6 IN
89: ra_cust_trx_line_salesreps.attribute6%type,
90: p_attribute7 IN
91: ra_cust_trx_line_salesreps.attribute7%type,

Line 89: ra_cust_trx_line_salesreps.attribute6%type,

85: ra_cust_trx_line_salesreps.attribute4%type,
86: p_attribute5 IN
87: ra_cust_trx_line_salesreps.attribute5%type,
88: p_attribute6 IN
89: ra_cust_trx_line_salesreps.attribute6%type,
90: p_attribute7 IN
91: ra_cust_trx_line_salesreps.attribute7%type,
92: p_attribute8 IN
93: ra_cust_trx_line_salesreps.attribute8%type,

Line 91: ra_cust_trx_line_salesreps.attribute7%type,

87: ra_cust_trx_line_salesreps.attribute5%type,
88: p_attribute6 IN
89: ra_cust_trx_line_salesreps.attribute6%type,
90: p_attribute7 IN
91: ra_cust_trx_line_salesreps.attribute7%type,
92: p_attribute8 IN
93: ra_cust_trx_line_salesreps.attribute8%type,
94: p_attribute9 IN
95: ra_cust_trx_line_salesreps.attribute9%type,

Line 93: ra_cust_trx_line_salesreps.attribute8%type,

89: ra_cust_trx_line_salesreps.attribute6%type,
90: p_attribute7 IN
91: ra_cust_trx_line_salesreps.attribute7%type,
92: p_attribute8 IN
93: ra_cust_trx_line_salesreps.attribute8%type,
94: p_attribute9 IN
95: ra_cust_trx_line_salesreps.attribute9%type,
96: p_attribute10 IN
97: ra_cust_trx_line_salesreps.attribute10%type,

Line 95: ra_cust_trx_line_salesreps.attribute9%type,

91: ra_cust_trx_line_salesreps.attribute7%type,
92: p_attribute8 IN
93: ra_cust_trx_line_salesreps.attribute8%type,
94: p_attribute9 IN
95: ra_cust_trx_line_salesreps.attribute9%type,
96: p_attribute10 IN
97: ra_cust_trx_line_salesreps.attribute10%type,
98: p_attribute11 IN
99: ra_cust_trx_line_salesreps.attribute11%type,

Line 97: ra_cust_trx_line_salesreps.attribute10%type,

93: ra_cust_trx_line_salesreps.attribute8%type,
94: p_attribute9 IN
95: ra_cust_trx_line_salesreps.attribute9%type,
96: p_attribute10 IN
97: ra_cust_trx_line_salesreps.attribute10%type,
98: p_attribute11 IN
99: ra_cust_trx_line_salesreps.attribute11%type,
100: p_attribute12 IN
101: ra_cust_trx_line_salesreps.attribute12%type,

Line 99: ra_cust_trx_line_salesreps.attribute11%type,

95: ra_cust_trx_line_salesreps.attribute9%type,
96: p_attribute10 IN
97: ra_cust_trx_line_salesreps.attribute10%type,
98: p_attribute11 IN
99: ra_cust_trx_line_salesreps.attribute11%type,
100: p_attribute12 IN
101: ra_cust_trx_line_salesreps.attribute12%type,
102: p_attribute13 IN
103: ra_cust_trx_line_salesreps.attribute13%type,

Line 101: ra_cust_trx_line_salesreps.attribute12%type,

97: ra_cust_trx_line_salesreps.attribute10%type,
98: p_attribute11 IN
99: ra_cust_trx_line_salesreps.attribute11%type,
100: p_attribute12 IN
101: ra_cust_trx_line_salesreps.attribute12%type,
102: p_attribute13 IN
103: ra_cust_trx_line_salesreps.attribute13%type,
104: p_attribute14 IN
105: ra_cust_trx_line_salesreps.attribute14%type,

Line 103: ra_cust_trx_line_salesreps.attribute13%type,

99: ra_cust_trx_line_salesreps.attribute11%type,
100: p_attribute12 IN
101: ra_cust_trx_line_salesreps.attribute12%type,
102: p_attribute13 IN
103: ra_cust_trx_line_salesreps.attribute13%type,
104: p_attribute14 IN
105: ra_cust_trx_line_salesreps.attribute14%type,
106: p_attribute15 IN
107: ra_cust_trx_line_salesreps.attribute15%type,

Line 105: ra_cust_trx_line_salesreps.attribute14%type,

101: ra_cust_trx_line_salesreps.attribute12%type,
102: p_attribute13 IN
103: ra_cust_trx_line_salesreps.attribute13%type,
104: p_attribute14 IN
105: ra_cust_trx_line_salesreps.attribute14%type,
106: p_attribute15 IN
107: ra_cust_trx_line_salesreps.attribute15%type,
108: p_cust_trx_line_salesrep_id OUT NOCOPY
109: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

Line 107: ra_cust_trx_line_salesreps.attribute15%type,

103: ra_cust_trx_line_salesreps.attribute13%type,
104: p_attribute14 IN
105: ra_cust_trx_line_salesreps.attribute14%type,
106: p_attribute15 IN
107: ra_cust_trx_line_salesreps.attribute15%type,
108: p_cust_trx_line_salesrep_id OUT NOCOPY
109: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
110: p_status OUT NOCOPY varchar2,
111: p_revenue_salesgroup_id IN

Line 109: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

105: ra_cust_trx_line_salesreps.attribute14%type,
106: p_attribute15 IN
107: ra_cust_trx_line_salesreps.attribute15%type,
108: p_cust_trx_line_salesrep_id OUT NOCOPY
109: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
110: p_status OUT NOCOPY varchar2,
111: p_revenue_salesgroup_id IN
112: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
113: p_non_revenue_salesgroup_id IN

Line 112: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

108: p_cust_trx_line_salesrep_id OUT NOCOPY
109: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
110: p_status OUT NOCOPY varchar2,
111: p_revenue_salesgroup_id IN
112: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
113: p_non_revenue_salesgroup_id IN
114: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
115:
116: PROCEDURE update_salescredit_cover(

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

110: p_status OUT NOCOPY varchar2,
111: p_revenue_salesgroup_id IN
112: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
113: p_non_revenue_salesgroup_id IN
114: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
115:
116: PROCEDURE update_salescredit_cover(
117: p_form_name IN varchar2,
118: p_form_version IN number,

Line 122: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

118: p_form_version IN number,
119: p_run_auto_accounting_flag IN boolean,
120: p_backout_flag IN boolean,
121: p_cust_trx_line_salesrep_id IN
122: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
123: p_customer_trx_id IN
124: ra_cust_trx_line_salesreps.customer_trx_id%type,
125: p_customer_trx_line_id IN
126: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

Line 124: ra_cust_trx_line_salesreps.customer_trx_id%type,

120: p_backout_flag IN boolean,
121: p_cust_trx_line_salesrep_id IN
122: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
123: p_customer_trx_id IN
124: ra_cust_trx_line_salesreps.customer_trx_id%type,
125: p_customer_trx_line_id IN
126: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
127: p_salesrep_id IN
128: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 126: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

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

Line 128: ra_cust_trx_line_salesreps.salesrep_id%type,

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

Line 130: ra_cust_trx_line_salesreps.revenue_amount_split%type,

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

Line 132: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

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

Line 134: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

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

Line 136: ra_cust_trx_line_salesreps.revenue_percent_split%type,

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

Line 138: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

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

Line 140: ra_cust_trx_line_salesreps.attribute_category%type,

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

Line 142: ra_cust_trx_line_salesreps.attribute1%type,

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

Line 144: ra_cust_trx_line_salesreps.attribute2%type,

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

Line 146: ra_cust_trx_line_salesreps.attribute3%type,

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

Line 148: ra_cust_trx_line_salesreps.attribute4%type,

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

Line 150: ra_cust_trx_line_salesreps.attribute5%type,

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

Line 152: ra_cust_trx_line_salesreps.attribute6%type,

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

Line 154: ra_cust_trx_line_salesreps.attribute7%type,

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

Line 156: ra_cust_trx_line_salesreps.attribute8%type,

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

Line 158: ra_cust_trx_line_salesreps.attribute9%type,

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

Line 160: ra_cust_trx_line_salesreps.attribute10%type,

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

Line 162: ra_cust_trx_line_salesreps.attribute11%type,

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

Line 164: ra_cust_trx_line_salesreps.attribute12%type,

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

Line 166: ra_cust_trx_line_salesreps.attribute13%type,

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

Line 168: ra_cust_trx_line_salesreps.attribute14%type,

164: ra_cust_trx_line_salesreps.attribute12%type,
165: p_attribute13 IN
166: ra_cust_trx_line_salesreps.attribute13%type,
167: p_attribute14 IN
168: ra_cust_trx_line_salesreps.attribute14%type,
169: p_attribute15 IN
170: ra_cust_trx_line_salesreps.attribute15%type,
171: p_backout_done_flag OUT NOCOPY boolean,
172: p_status OUT NOCOPY varchar2,

Line 170: ra_cust_trx_line_salesreps.attribute15%type,

166: ra_cust_trx_line_salesreps.attribute13%type,
167: p_attribute14 IN
168: ra_cust_trx_line_salesreps.attribute14%type,
169: p_attribute15 IN
170: ra_cust_trx_line_salesreps.attribute15%type,
171: p_backout_done_flag OUT NOCOPY boolean,
172: p_status OUT NOCOPY varchar2,
173: p_revenue_salesgroup_id IN
174: ra_cust_trx_line_salesreps.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.attribute15%type,
171: p_backout_done_flag OUT NOCOPY boolean,
172: p_status OUT NOCOPY varchar2,
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 delete_salescredit_cover(

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

172: p_status OUT NOCOPY varchar2,
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 delete_salescredit_cover(
179: p_form_name IN varchar2,
180: p_form_version IN number,

Line 184: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

180: p_form_version IN number,
181: p_run_auto_accounting_flag IN boolean,
182: p_backout_flag IN boolean,
183: p_cust_trx_line_salesrep_id IN
184: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
185: p_customer_trx_id IN
186: ra_cust_trx_line_salesreps.customer_trx_id%type,
187: p_customer_trx_line_id IN
188: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

Line 186: ra_cust_trx_line_salesreps.customer_trx_id%type,

182: p_backout_flag IN boolean,
183: p_cust_trx_line_salesrep_id IN
184: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
185: p_customer_trx_id IN
186: ra_cust_trx_line_salesreps.customer_trx_id%type,
187: p_customer_trx_line_id IN
188: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
189: p_salesrep_id IN
190: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 188: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

184: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
185: p_customer_trx_id IN
186: ra_cust_trx_line_salesreps.customer_trx_id%type,
187: p_customer_trx_line_id IN
188: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
189: p_salesrep_id IN
190: ra_cust_trx_line_salesreps.salesrep_id%type,
191: p_revenue_amount_split IN
192: ra_cust_trx_line_salesreps.revenue_amount_split%type,

Line 190: ra_cust_trx_line_salesreps.salesrep_id%type,

186: ra_cust_trx_line_salesreps.customer_trx_id%type,
187: p_customer_trx_line_id IN
188: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
189: p_salesrep_id IN
190: ra_cust_trx_line_salesreps.salesrep_id%type,
191: p_revenue_amount_split IN
192: ra_cust_trx_line_salesreps.revenue_amount_split%type,
193: p_non_revenue_amount_split IN
194: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

Line 192: ra_cust_trx_line_salesreps.revenue_amount_split%type,

188: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
189: p_salesrep_id IN
190: ra_cust_trx_line_salesreps.salesrep_id%type,
191: p_revenue_amount_split IN
192: ra_cust_trx_line_salesreps.revenue_amount_split%type,
193: p_non_revenue_amount_split IN
194: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
195: p_non_revenue_percent_split IN
196: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

Line 194: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

190: ra_cust_trx_line_salesreps.salesrep_id%type,
191: p_revenue_amount_split IN
192: ra_cust_trx_line_salesreps.revenue_amount_split%type,
193: p_non_revenue_amount_split IN
194: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
195: p_non_revenue_percent_split IN
196: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
197: p_revenue_percent_split IN
198: ra_cust_trx_line_salesreps.revenue_percent_split%type,

Line 196: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

192: ra_cust_trx_line_salesreps.revenue_amount_split%type,
193: p_non_revenue_amount_split IN
194: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
195: p_non_revenue_percent_split IN
196: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
197: p_revenue_percent_split IN
198: ra_cust_trx_line_salesreps.revenue_percent_split%type,
199: p_prev_cust_trx_line_srep_id IN
200: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

Line 198: ra_cust_trx_line_salesreps.revenue_percent_split%type,

194: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
195: p_non_revenue_percent_split IN
196: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
197: p_revenue_percent_split IN
198: ra_cust_trx_line_salesreps.revenue_percent_split%type,
199: p_prev_cust_trx_line_srep_id IN
200: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
201: p_attribute_category IN
202: ra_cust_trx_line_salesreps.attribute_category%type,

Line 200: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

196: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
197: p_revenue_percent_split IN
198: ra_cust_trx_line_salesreps.revenue_percent_split%type,
199: p_prev_cust_trx_line_srep_id IN
200: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
201: p_attribute_category IN
202: ra_cust_trx_line_salesreps.attribute_category%type,
203: p_attribute1 IN
204: ra_cust_trx_line_salesreps.attribute1%type,

Line 202: ra_cust_trx_line_salesreps.attribute_category%type,

198: ra_cust_trx_line_salesreps.revenue_percent_split%type,
199: p_prev_cust_trx_line_srep_id IN
200: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
201: p_attribute_category IN
202: ra_cust_trx_line_salesreps.attribute_category%type,
203: p_attribute1 IN
204: ra_cust_trx_line_salesreps.attribute1%type,
205: p_attribute2 IN
206: ra_cust_trx_line_salesreps.attribute2%type,

Line 204: ra_cust_trx_line_salesreps.attribute1%type,

200: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
201: p_attribute_category IN
202: ra_cust_trx_line_salesreps.attribute_category%type,
203: p_attribute1 IN
204: ra_cust_trx_line_salesreps.attribute1%type,
205: p_attribute2 IN
206: ra_cust_trx_line_salesreps.attribute2%type,
207: p_attribute3 IN
208: ra_cust_trx_line_salesreps.attribute3%type,

Line 206: ra_cust_trx_line_salesreps.attribute2%type,

202: ra_cust_trx_line_salesreps.attribute_category%type,
203: p_attribute1 IN
204: ra_cust_trx_line_salesreps.attribute1%type,
205: p_attribute2 IN
206: ra_cust_trx_line_salesreps.attribute2%type,
207: p_attribute3 IN
208: ra_cust_trx_line_salesreps.attribute3%type,
209: p_attribute4 IN
210: ra_cust_trx_line_salesreps.attribute4%type,

Line 208: ra_cust_trx_line_salesreps.attribute3%type,

204: ra_cust_trx_line_salesreps.attribute1%type,
205: p_attribute2 IN
206: ra_cust_trx_line_salesreps.attribute2%type,
207: p_attribute3 IN
208: ra_cust_trx_line_salesreps.attribute3%type,
209: p_attribute4 IN
210: ra_cust_trx_line_salesreps.attribute4%type,
211: p_attribute5 IN
212: ra_cust_trx_line_salesreps.attribute5%type,

Line 210: ra_cust_trx_line_salesreps.attribute4%type,

206: ra_cust_trx_line_salesreps.attribute2%type,
207: p_attribute3 IN
208: ra_cust_trx_line_salesreps.attribute3%type,
209: p_attribute4 IN
210: ra_cust_trx_line_salesreps.attribute4%type,
211: p_attribute5 IN
212: ra_cust_trx_line_salesreps.attribute5%type,
213: p_attribute6 IN
214: ra_cust_trx_line_salesreps.attribute6%type,

Line 212: ra_cust_trx_line_salesreps.attribute5%type,

208: ra_cust_trx_line_salesreps.attribute3%type,
209: p_attribute4 IN
210: ra_cust_trx_line_salesreps.attribute4%type,
211: p_attribute5 IN
212: ra_cust_trx_line_salesreps.attribute5%type,
213: p_attribute6 IN
214: ra_cust_trx_line_salesreps.attribute6%type,
215: p_attribute7 IN
216: ra_cust_trx_line_salesreps.attribute7%type,

Line 214: ra_cust_trx_line_salesreps.attribute6%type,

210: ra_cust_trx_line_salesreps.attribute4%type,
211: p_attribute5 IN
212: ra_cust_trx_line_salesreps.attribute5%type,
213: p_attribute6 IN
214: ra_cust_trx_line_salesreps.attribute6%type,
215: p_attribute7 IN
216: ra_cust_trx_line_salesreps.attribute7%type,
217: p_attribute8 IN
218: ra_cust_trx_line_salesreps.attribute8%type,

Line 216: ra_cust_trx_line_salesreps.attribute7%type,

212: ra_cust_trx_line_salesreps.attribute5%type,
213: p_attribute6 IN
214: ra_cust_trx_line_salesreps.attribute6%type,
215: p_attribute7 IN
216: ra_cust_trx_line_salesreps.attribute7%type,
217: p_attribute8 IN
218: ra_cust_trx_line_salesreps.attribute8%type,
219: p_attribute9 IN
220: ra_cust_trx_line_salesreps.attribute9%type,

Line 218: ra_cust_trx_line_salesreps.attribute8%type,

214: ra_cust_trx_line_salesreps.attribute6%type,
215: p_attribute7 IN
216: ra_cust_trx_line_salesreps.attribute7%type,
217: p_attribute8 IN
218: ra_cust_trx_line_salesreps.attribute8%type,
219: p_attribute9 IN
220: ra_cust_trx_line_salesreps.attribute9%type,
221: p_attribute10 IN
222: ra_cust_trx_line_salesreps.attribute10%type,

Line 220: ra_cust_trx_line_salesreps.attribute9%type,

216: ra_cust_trx_line_salesreps.attribute7%type,
217: p_attribute8 IN
218: ra_cust_trx_line_salesreps.attribute8%type,
219: p_attribute9 IN
220: ra_cust_trx_line_salesreps.attribute9%type,
221: p_attribute10 IN
222: ra_cust_trx_line_salesreps.attribute10%type,
223: p_attribute11 IN
224: ra_cust_trx_line_salesreps.attribute11%type,

Line 222: ra_cust_trx_line_salesreps.attribute10%type,

218: ra_cust_trx_line_salesreps.attribute8%type,
219: p_attribute9 IN
220: ra_cust_trx_line_salesreps.attribute9%type,
221: p_attribute10 IN
222: ra_cust_trx_line_salesreps.attribute10%type,
223: p_attribute11 IN
224: ra_cust_trx_line_salesreps.attribute11%type,
225: p_attribute12 IN
226: ra_cust_trx_line_salesreps.attribute12%type,

Line 224: ra_cust_trx_line_salesreps.attribute11%type,

220: ra_cust_trx_line_salesreps.attribute9%type,
221: p_attribute10 IN
222: ra_cust_trx_line_salesreps.attribute10%type,
223: p_attribute11 IN
224: ra_cust_trx_line_salesreps.attribute11%type,
225: p_attribute12 IN
226: ra_cust_trx_line_salesreps.attribute12%type,
227: p_attribute13 IN
228: ra_cust_trx_line_salesreps.attribute13%type,

Line 226: ra_cust_trx_line_salesreps.attribute12%type,

222: ra_cust_trx_line_salesreps.attribute10%type,
223: p_attribute11 IN
224: ra_cust_trx_line_salesreps.attribute11%type,
225: p_attribute12 IN
226: ra_cust_trx_line_salesreps.attribute12%type,
227: p_attribute13 IN
228: ra_cust_trx_line_salesreps.attribute13%type,
229: p_attribute14 IN
230: ra_cust_trx_line_salesreps.attribute14%type,

Line 228: ra_cust_trx_line_salesreps.attribute13%type,

224: ra_cust_trx_line_salesreps.attribute11%type,
225: p_attribute12 IN
226: ra_cust_trx_line_salesreps.attribute12%type,
227: p_attribute13 IN
228: ra_cust_trx_line_salesreps.attribute13%type,
229: p_attribute14 IN
230: ra_cust_trx_line_salesreps.attribute14%type,
231: p_attribute15 IN
232: ra_cust_trx_line_salesreps.attribute15%type,

Line 230: ra_cust_trx_line_salesreps.attribute14%type,

226: ra_cust_trx_line_salesreps.attribute12%type,
227: p_attribute13 IN
228: ra_cust_trx_line_salesreps.attribute13%type,
229: p_attribute14 IN
230: ra_cust_trx_line_salesreps.attribute14%type,
231: p_attribute15 IN
232: ra_cust_trx_line_salesreps.attribute15%type,
233: p_backout_done_flag OUT NOCOPY boolean,
234: p_status OUT NOCOPY varchar2,

Line 232: ra_cust_trx_line_salesreps.attribute15%type,

228: ra_cust_trx_line_salesreps.attribute13%type,
229: p_attribute14 IN
230: ra_cust_trx_line_salesreps.attribute14%type,
231: p_attribute15 IN
232: ra_cust_trx_line_salesreps.attribute15%type,
233: p_backout_done_flag OUT NOCOPY boolean,
234: p_status OUT NOCOPY varchar2,
235: p_revenue_salesgroup_id IN
236: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

Line 236: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

232: ra_cust_trx_line_salesreps.attribute15%type,
233: p_backout_done_flag OUT NOCOPY boolean,
234: p_status OUT NOCOPY varchar2,
235: p_revenue_salesgroup_id IN
236: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
237: p_non_revenue_salesgroup_id IN
238: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
239:
240: END ARP_PROCESS_SALESCREDIT;

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

234: p_status OUT NOCOPY varchar2,
235: p_revenue_salesgroup_id IN
236: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
237: p_non_revenue_salesgroup_id IN
238: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
239:
240: END ARP_PROCESS_SALESCREDIT;