DBA Data[Home] [Help]

APPS.ARP_DELETE_DIST_COVER dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 82: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

78: PROCEDURE delete_dist_cover(
79: p_form_name IN varchar2,
80: p_form_version IN number,
81: p_cust_trx_line_gl_dist_id IN
82: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
83: p_customer_trx_id IN
84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,

Line 84: ra_cust_trx_line_gl_dist.customer_trx_id%type,

80: p_form_version IN number,
81: p_cust_trx_line_gl_dist_id IN
82: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
83: p_customer_trx_id IN
84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

Line 86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,

82: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
83: p_customer_trx_id IN
84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,

Line 88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,

Line 90: ra_cust_trx_line_gl_dist.account_class%type,

86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,

Line 92: ra_cust_trx_line_gl_dist.percent%type,

88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,

Line 94: ra_cust_trx_line_gl_dist.amount%type,

90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,

Line 96: ra_cust_trx_line_gl_dist.gl_date%type,

92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,

Line 98: ra_cust_trx_line_gl_dist.original_gl_date%type,

94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 100: ra_cust_trx_line_gl_dist.gl_posted_date%type,

96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,

Line 102: ra_cust_trx_line_gl_dist.code_combination_id%type,

98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

Line 104: ra_cust_trx_line_gl_dist.concatenated_segments%type,

100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

Line 106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,

Line 108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 110: ra_cust_trx_line_gl_dist.comments%type,

106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,

Line 112: ra_cust_trx_line_gl_dist.account_set_flag%type,

108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

Line 114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,

110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

Line 116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,

Line 118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,

Line 120: ra_cust_trx_line_gl_dist.attribute_category%type,

116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,

Line 122: ra_cust_trx_line_gl_dist.attribute1%type,

118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,

Line 124: ra_cust_trx_line_gl_dist.attribute2%type,

120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,

Line 126: ra_cust_trx_line_gl_dist.attribute3%type,

122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,

Line 128: ra_cust_trx_line_gl_dist.attribute4%type,

124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,

Line 130: ra_cust_trx_line_gl_dist.attribute5%type,

126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,

Line 132: ra_cust_trx_line_gl_dist.attribute6%type,

128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,

Line 134: ra_cust_trx_line_gl_dist.attribute7%type,

130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,

Line 136: ra_cust_trx_line_gl_dist.attribute8%type,

132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,

Line 138: ra_cust_trx_line_gl_dist.attribute9%type,

134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,

Line 140: ra_cust_trx_line_gl_dist.attribute10%type,

136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,

Line 142: ra_cust_trx_line_gl_dist.attribute11%type,

138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,

Line 144: ra_cust_trx_line_gl_dist.attribute12%type,

140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,

Line 146: ra_cust_trx_line_gl_dist.attribute13%type,

142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,

Line 148: ra_cust_trx_line_gl_dist.attribute14%type,

144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,
151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )

Line 150: ra_cust_trx_line_gl_dist.attribute15%type,

146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,
151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )
153: IS
154:

Line 152: ra_cust_trx_line_gl_dist.posting_control_id%type )

148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,
151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )
153: IS
154:
155: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
156:

Line 155: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )
153: IS
154:
155: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
156:
157: BEGIN
158:
159: IF PG_DEBUG in ('Y', 'C') THEN