eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_INSERT_DIST_COVER dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 9: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE

5:
6: FUNCTION set_original_gl_date(
7: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
9: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
10: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
11: RETURN DATE;
12:
13: /*===========================================================================+

Line 10: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)

6: FUNCTION set_original_gl_date(
7: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
9: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
10: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
11: RETURN DATE;
12:
13: /*===========================================================================+
14: | PROCEDURE |

Line 101: ra_cust_trx_line_gl_dist.customer_trx_id%type,

97: fnd_currencies.precision%type,
98: p_base_mau IN
99: fnd_currencies.minimum_accountable_unit%type,
100: p_customer_trx_id IN
101: ra_cust_trx_line_gl_dist.customer_trx_id%type,
102: p_customer_trx_line_id IN
103: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
104: p_cust_trx_line_salesrep_id IN
105: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

Line 103: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,

99: fnd_currencies.minimum_accountable_unit%type,
100: p_customer_trx_id IN
101: ra_cust_trx_line_gl_dist.customer_trx_id%type,
102: p_customer_trx_line_id IN
103: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
104: p_cust_trx_line_salesrep_id IN
105: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
106: p_account_class IN
107: ra_cust_trx_line_gl_dist.account_class%type,

Line 105: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

101: ra_cust_trx_line_gl_dist.customer_trx_id%type,
102: p_customer_trx_line_id IN
103: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
104: p_cust_trx_line_salesrep_id IN
105: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
106: p_account_class IN
107: ra_cust_trx_line_gl_dist.account_class%type,
108: p_percent IN
109: ra_cust_trx_line_gl_dist.percent%type,

Line 107: ra_cust_trx_line_gl_dist.account_class%type,

103: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
104: p_cust_trx_line_salesrep_id IN
105: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
106: p_account_class IN
107: ra_cust_trx_line_gl_dist.account_class%type,
108: p_percent IN
109: ra_cust_trx_line_gl_dist.percent%type,
110: p_amount IN
111: ra_cust_trx_line_gl_dist.amount%type,

Line 109: ra_cust_trx_line_gl_dist.percent%type,

105: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
106: p_account_class IN
107: ra_cust_trx_line_gl_dist.account_class%type,
108: p_percent IN
109: ra_cust_trx_line_gl_dist.percent%type,
110: p_amount IN
111: ra_cust_trx_line_gl_dist.amount%type,
112: p_acctd_amount IN
113: ra_cust_trx_line_gl_dist.acctd_amount%type,

Line 111: ra_cust_trx_line_gl_dist.amount%type,

107: ra_cust_trx_line_gl_dist.account_class%type,
108: p_percent IN
109: ra_cust_trx_line_gl_dist.percent%type,
110: p_amount IN
111: ra_cust_trx_line_gl_dist.amount%type,
112: p_acctd_amount IN
113: ra_cust_trx_line_gl_dist.acctd_amount%type,
114: p_gl_date IN
115: ra_cust_trx_line_gl_dist.gl_date%type,

Line 113: ra_cust_trx_line_gl_dist.acctd_amount%type,

109: ra_cust_trx_line_gl_dist.percent%type,
110: p_amount IN
111: ra_cust_trx_line_gl_dist.amount%type,
112: p_acctd_amount IN
113: ra_cust_trx_line_gl_dist.acctd_amount%type,
114: p_gl_date IN
115: ra_cust_trx_line_gl_dist.gl_date%type,
116: p_original_gl_date IN
117: ra_cust_trx_line_gl_dist.original_gl_date%type,

Line 115: ra_cust_trx_line_gl_dist.gl_date%type,

111: ra_cust_trx_line_gl_dist.amount%type,
112: p_acctd_amount IN
113: ra_cust_trx_line_gl_dist.acctd_amount%type,
114: p_gl_date IN
115: ra_cust_trx_line_gl_dist.gl_date%type,
116: p_original_gl_date IN
117: ra_cust_trx_line_gl_dist.original_gl_date%type,
118: p_code_combination_id IN
119: ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 117: ra_cust_trx_line_gl_dist.original_gl_date%type,

113: ra_cust_trx_line_gl_dist.acctd_amount%type,
114: p_gl_date IN
115: ra_cust_trx_line_gl_dist.gl_date%type,
116: p_original_gl_date IN
117: ra_cust_trx_line_gl_dist.original_gl_date%type,
118: p_code_combination_id IN
119: ra_cust_trx_line_gl_dist.code_combination_id%type,
120: p_concatenated_segments IN
121: ra_cust_trx_line_gl_dist.concatenated_segments%type,

Line 119: ra_cust_trx_line_gl_dist.code_combination_id%type,

115: ra_cust_trx_line_gl_dist.gl_date%type,
116: p_original_gl_date IN
117: ra_cust_trx_line_gl_dist.original_gl_date%type,
118: p_code_combination_id IN
119: ra_cust_trx_line_gl_dist.code_combination_id%type,
120: p_concatenated_segments IN
121: ra_cust_trx_line_gl_dist.concatenated_segments%type,
122: p_collected_tax_ccid IN
123: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

Line 121: ra_cust_trx_line_gl_dist.concatenated_segments%type,

117: ra_cust_trx_line_gl_dist.original_gl_date%type,
118: p_code_combination_id IN
119: ra_cust_trx_line_gl_dist.code_combination_id%type,
120: p_concatenated_segments IN
121: ra_cust_trx_line_gl_dist.concatenated_segments%type,
122: p_collected_tax_ccid IN
123: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
124: p_collected_tax_concat_seg IN
125: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

Line 123: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

119: ra_cust_trx_line_gl_dist.code_combination_id%type,
120: p_concatenated_segments IN
121: ra_cust_trx_line_gl_dist.concatenated_segments%type,
122: p_collected_tax_ccid IN
123: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
124: p_collected_tax_concat_seg IN
125: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
126: p_comments IN
127: ra_cust_trx_line_gl_dist.comments%type,

Line 125: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

121: ra_cust_trx_line_gl_dist.concatenated_segments%type,
122: p_collected_tax_ccid IN
123: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
124: p_collected_tax_concat_seg IN
125: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
126: p_comments IN
127: ra_cust_trx_line_gl_dist.comments%type,
128: p_account_set_flag IN
129: ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 127: ra_cust_trx_line_gl_dist.comments%type,

123: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
124: p_collected_tax_concat_seg IN
125: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
126: p_comments IN
127: ra_cust_trx_line_gl_dist.comments%type,
128: p_account_set_flag IN
129: ra_cust_trx_line_gl_dist.account_set_flag%type,
130: p_ussgl_transaction_code IN
131: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

Line 129: ra_cust_trx_line_gl_dist.account_set_flag%type,

125: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
126: p_comments IN
127: ra_cust_trx_line_gl_dist.comments%type,
128: p_account_set_flag IN
129: ra_cust_trx_line_gl_dist.account_set_flag%type,
130: p_ussgl_transaction_code IN
131: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
132: p_ussgl_trx_code_context IN
133: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

Line 131: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

127: ra_cust_trx_line_gl_dist.comments%type,
128: p_account_set_flag IN
129: ra_cust_trx_line_gl_dist.account_set_flag%type,
130: p_ussgl_transaction_code IN
131: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
132: p_ussgl_trx_code_context IN
133: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
134: p_attribute_category IN
135: ra_cust_trx_line_gl_dist.attribute_category%type,

Line 133: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

129: ra_cust_trx_line_gl_dist.account_set_flag%type,
130: p_ussgl_transaction_code IN
131: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
132: p_ussgl_trx_code_context IN
133: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
134: p_attribute_category IN
135: ra_cust_trx_line_gl_dist.attribute_category%type,
136: p_attribute1 IN
137: ra_cust_trx_line_gl_dist.attribute1%type,

Line 135: ra_cust_trx_line_gl_dist.attribute_category%type,

131: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
132: p_ussgl_trx_code_context IN
133: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
134: p_attribute_category IN
135: ra_cust_trx_line_gl_dist.attribute_category%type,
136: p_attribute1 IN
137: ra_cust_trx_line_gl_dist.attribute1%type,
138: p_attribute2 IN
139: ra_cust_trx_line_gl_dist.attribute2%type,

Line 137: ra_cust_trx_line_gl_dist.attribute1%type,

133: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
134: p_attribute_category IN
135: ra_cust_trx_line_gl_dist.attribute_category%type,
136: p_attribute1 IN
137: ra_cust_trx_line_gl_dist.attribute1%type,
138: p_attribute2 IN
139: ra_cust_trx_line_gl_dist.attribute2%type,
140: p_attribute3 IN
141: ra_cust_trx_line_gl_dist.attribute3%type,

Line 139: ra_cust_trx_line_gl_dist.attribute2%type,

135: ra_cust_trx_line_gl_dist.attribute_category%type,
136: p_attribute1 IN
137: ra_cust_trx_line_gl_dist.attribute1%type,
138: p_attribute2 IN
139: ra_cust_trx_line_gl_dist.attribute2%type,
140: p_attribute3 IN
141: ra_cust_trx_line_gl_dist.attribute3%type,
142: p_attribute4 IN
143: ra_cust_trx_line_gl_dist.attribute4%type,

Line 141: ra_cust_trx_line_gl_dist.attribute3%type,

137: ra_cust_trx_line_gl_dist.attribute1%type,
138: p_attribute2 IN
139: ra_cust_trx_line_gl_dist.attribute2%type,
140: p_attribute3 IN
141: ra_cust_trx_line_gl_dist.attribute3%type,
142: p_attribute4 IN
143: ra_cust_trx_line_gl_dist.attribute4%type,
144: p_attribute5 IN
145: ra_cust_trx_line_gl_dist.attribute5%type,

Line 143: ra_cust_trx_line_gl_dist.attribute4%type,

139: ra_cust_trx_line_gl_dist.attribute2%type,
140: p_attribute3 IN
141: ra_cust_trx_line_gl_dist.attribute3%type,
142: p_attribute4 IN
143: ra_cust_trx_line_gl_dist.attribute4%type,
144: p_attribute5 IN
145: ra_cust_trx_line_gl_dist.attribute5%type,
146: p_attribute6 IN
147: ra_cust_trx_line_gl_dist.attribute6%type,

Line 145: ra_cust_trx_line_gl_dist.attribute5%type,

141: ra_cust_trx_line_gl_dist.attribute3%type,
142: p_attribute4 IN
143: ra_cust_trx_line_gl_dist.attribute4%type,
144: p_attribute5 IN
145: ra_cust_trx_line_gl_dist.attribute5%type,
146: p_attribute6 IN
147: ra_cust_trx_line_gl_dist.attribute6%type,
148: p_attribute7 IN
149: ra_cust_trx_line_gl_dist.attribute7%type,

Line 147: ra_cust_trx_line_gl_dist.attribute6%type,

143: ra_cust_trx_line_gl_dist.attribute4%type,
144: p_attribute5 IN
145: ra_cust_trx_line_gl_dist.attribute5%type,
146: p_attribute6 IN
147: ra_cust_trx_line_gl_dist.attribute6%type,
148: p_attribute7 IN
149: ra_cust_trx_line_gl_dist.attribute7%type,
150: p_attribute8 IN
151: ra_cust_trx_line_gl_dist.attribute8%type,

Line 149: ra_cust_trx_line_gl_dist.attribute7%type,

145: ra_cust_trx_line_gl_dist.attribute5%type,
146: p_attribute6 IN
147: ra_cust_trx_line_gl_dist.attribute6%type,
148: p_attribute7 IN
149: ra_cust_trx_line_gl_dist.attribute7%type,
150: p_attribute8 IN
151: ra_cust_trx_line_gl_dist.attribute8%type,
152: p_attribute9 IN
153: ra_cust_trx_line_gl_dist.attribute9%type,

Line 151: ra_cust_trx_line_gl_dist.attribute8%type,

147: ra_cust_trx_line_gl_dist.attribute6%type,
148: p_attribute7 IN
149: ra_cust_trx_line_gl_dist.attribute7%type,
150: p_attribute8 IN
151: ra_cust_trx_line_gl_dist.attribute8%type,
152: p_attribute9 IN
153: ra_cust_trx_line_gl_dist.attribute9%type,
154: p_attribute10 IN
155: ra_cust_trx_line_gl_dist.attribute10%type,

Line 153: ra_cust_trx_line_gl_dist.attribute9%type,

149: ra_cust_trx_line_gl_dist.attribute7%type,
150: p_attribute8 IN
151: ra_cust_trx_line_gl_dist.attribute8%type,
152: p_attribute9 IN
153: ra_cust_trx_line_gl_dist.attribute9%type,
154: p_attribute10 IN
155: ra_cust_trx_line_gl_dist.attribute10%type,
156: p_attribute11 IN
157: ra_cust_trx_line_gl_dist.attribute11%type,

Line 155: ra_cust_trx_line_gl_dist.attribute10%type,

151: ra_cust_trx_line_gl_dist.attribute8%type,
152: p_attribute9 IN
153: ra_cust_trx_line_gl_dist.attribute9%type,
154: p_attribute10 IN
155: ra_cust_trx_line_gl_dist.attribute10%type,
156: p_attribute11 IN
157: ra_cust_trx_line_gl_dist.attribute11%type,
158: p_attribute12 IN
159: ra_cust_trx_line_gl_dist.attribute12%type,

Line 157: ra_cust_trx_line_gl_dist.attribute11%type,

153: ra_cust_trx_line_gl_dist.attribute9%type,
154: p_attribute10 IN
155: ra_cust_trx_line_gl_dist.attribute10%type,
156: p_attribute11 IN
157: ra_cust_trx_line_gl_dist.attribute11%type,
158: p_attribute12 IN
159: ra_cust_trx_line_gl_dist.attribute12%type,
160: p_attribute13 IN
161: ra_cust_trx_line_gl_dist.attribute13%type,

Line 159: ra_cust_trx_line_gl_dist.attribute12%type,

155: ra_cust_trx_line_gl_dist.attribute10%type,
156: p_attribute11 IN
157: ra_cust_trx_line_gl_dist.attribute11%type,
158: p_attribute12 IN
159: ra_cust_trx_line_gl_dist.attribute12%type,
160: p_attribute13 IN
161: ra_cust_trx_line_gl_dist.attribute13%type,
162: p_attribute14 IN
163: ra_cust_trx_line_gl_dist.attribute14%type,

Line 161: ra_cust_trx_line_gl_dist.attribute13%type,

157: ra_cust_trx_line_gl_dist.attribute11%type,
158: p_attribute12 IN
159: ra_cust_trx_line_gl_dist.attribute12%type,
160: p_attribute13 IN
161: ra_cust_trx_line_gl_dist.attribute13%type,
162: p_attribute14 IN
163: ra_cust_trx_line_gl_dist.attribute14%type,
164: p_attribute15 IN
165: ra_cust_trx_line_gl_dist.attribute15%type,

Line 163: ra_cust_trx_line_gl_dist.attribute14%type,

159: ra_cust_trx_line_gl_dist.attribute12%type,
160: p_attribute13 IN
161: ra_cust_trx_line_gl_dist.attribute13%type,
162: p_attribute14 IN
163: ra_cust_trx_line_gl_dist.attribute14%type,
164: p_attribute15 IN
165: ra_cust_trx_line_gl_dist.attribute15%type,
166: p_cust_trx_line_gl_dist_id OUT NOCOPY
167: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)

Line 165: ra_cust_trx_line_gl_dist.attribute15%type,

161: ra_cust_trx_line_gl_dist.attribute13%type,
162: p_attribute14 IN
163: ra_cust_trx_line_gl_dist.attribute14%type,
164: p_attribute15 IN
165: ra_cust_trx_line_gl_dist.attribute15%type,
166: p_cust_trx_line_gl_dist_id OUT NOCOPY
167: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
168: IS
169:

Line 167: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)

163: ra_cust_trx_line_gl_dist.attribute14%type,
164: p_attribute15 IN
165: ra_cust_trx_line_gl_dist.attribute15%type,
166: p_cust_trx_line_gl_dist_id OUT NOCOPY
167: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
168: IS
169:
170: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
171:

Line 170: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

166: p_cust_trx_line_gl_dist_id OUT NOCOPY
167: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
168: IS
169:
170: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
171:
172: BEGIN
173:
174: IF PG_DEBUG in ('Y', 'C') THEN

Line 373: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE

369:
370: FUNCTION set_original_gl_date(
371: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
372: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
373: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
374: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
375: RETURN DATE
376: IS
377: CURSOR c_rule_based_inv IS

Line 374: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)

370: FUNCTION set_original_gl_date(
371: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
372: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
373: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
374: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
375: RETURN DATE
376: IS
377: CURSOR c_rule_based_inv IS
378: SELECT ctl.accounting_rule_id, ctt.type