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_CT_PKG dependencies on DBMS_SQL

Line 41: | dbms_sql.bind_variable |

37: | |
38: | SCOPE - PRIVATE |
39: | |
40: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
41: | dbms_sql.bind_variable |
42: | arp_util.debug |
43: | |
44: | ARGUMENTS : IN: |
45: | p_update_cursor - ID of the update cursor |

Line 94: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

90: /*------------------+
91: | Dummy constants |
92: +------------------*/
93:
94: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
95: AR_TEXT_DUMMY);
96:
97: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
98: AR_FLAG_DUMMY);

Line 97: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

93:
94: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
95: AR_TEXT_DUMMY);
96:
97: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
98: AR_FLAG_DUMMY);
99:
100: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
101: AR_NUMBER_DUMMY);

Line 100: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

96:
97: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
98: AR_FLAG_DUMMY);
99:
100: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
101: AR_NUMBER_DUMMY);
102:
103: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
104: AR_DATE_DUMMY);

Line 103: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

99:
100: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
101: AR_NUMBER_DUMMY);
102:
103: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
104: AR_DATE_DUMMY);
105:
106:
107: /*------------------+

Line 111: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',

107: /*------------------+
108: | WHO variables |
109: +------------------*/
110:
111: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
112: pg_user_id);
113:
114: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
115: pg_login_id);

Line 114: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',

110:
111: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
112: pg_user_id);
113:
114: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
115: pg_login_id);
116:
117: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
118: pg_conc_login_id);

Line 117: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',

113:
114: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
115: pg_login_id);
116:
117: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
118: pg_conc_login_id);
119:
120:
121: /*----------------------------------------------+

Line 126: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',

122: | Bind variables for all columns in the table |
123: +----------------------------------------------*/
124:
125:
126: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
127: p_trx_rec.customer_trx_id);
128:
129: dbms_sql.bind_variable(p_update_cursor, ':trx_number',
130: p_trx_rec.trx_number);

Line 129: dbms_sql.bind_variable(p_update_cursor, ':trx_number',

125:
126: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
127: p_trx_rec.customer_trx_id);
128:
129: dbms_sql.bind_variable(p_update_cursor, ':trx_number',
130: p_trx_rec.trx_number);
131:
132: dbms_sql.bind_variable(p_update_cursor, ':created_by',
133: p_trx_rec.created_by);

Line 132: dbms_sql.bind_variable(p_update_cursor, ':created_by',

128:
129: dbms_sql.bind_variable(p_update_cursor, ':trx_number',
130: p_trx_rec.trx_number);
131:
132: dbms_sql.bind_variable(p_update_cursor, ':created_by',
133: p_trx_rec.created_by);
134:
135: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
136: p_trx_rec.creation_date);

Line 135: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

131:
132: dbms_sql.bind_variable(p_update_cursor, ':created_by',
133: p_trx_rec.created_by);
134:
135: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
136: p_trx_rec.creation_date);
137:
138: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
139: p_trx_rec.last_updated_by);

Line 138: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',

134:
135: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
136: p_trx_rec.creation_date);
137:
138: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
139: p_trx_rec.last_updated_by);
140:
141: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
142: p_trx_rec.last_update_date);

Line 141: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',

137:
138: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
139: p_trx_rec.last_updated_by);
140:
141: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
142: p_trx_rec.last_update_date);
143:
144: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
145: p_trx_rec.last_update_login);

Line 144: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

140:
141: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
142: p_trx_rec.last_update_date);
143:
144: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
145: p_trx_rec.last_update_login);
146:
147: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
148: p_trx_rec.set_of_books_id);

Line 147: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',

143:
144: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
145: p_trx_rec.last_update_login);
146:
147: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
148: p_trx_rec.set_of_books_id);
149:
150: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
151: p_trx_rec.program_application_id);

Line 150: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',

146:
147: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
148: p_trx_rec.set_of_books_id);
149:
150: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
151: p_trx_rec.program_application_id);
152:
153: dbms_sql.bind_variable(p_update_cursor, ':program_id',
154: p_trx_rec.program_id);

Line 153: dbms_sql.bind_variable(p_update_cursor, ':program_id',

149:
150: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
151: p_trx_rec.program_application_id);
152:
153: dbms_sql.bind_variable(p_update_cursor, ':program_id',
154: p_trx_rec.program_id);
155:
156: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
157: p_trx_rec.program_update_date);

Line 156: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',

152:
153: dbms_sql.bind_variable(p_update_cursor, ':program_id',
154: p_trx_rec.program_id);
155:
156: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
157: p_trx_rec.program_update_date);
158:
159: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
160: p_trx_rec.posting_control_id);

Line 159: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',

155:
156: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
157: p_trx_rec.program_update_date);
158:
159: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
160: p_trx_rec.posting_control_id);
161:
162: dbms_sql.bind_variable(p_update_cursor, ':ra_post_loop_number',
163: p_trx_rec.ra_post_loop_number);

Line 162: dbms_sql.bind_variable(p_update_cursor, ':ra_post_loop_number',

158:
159: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
160: p_trx_rec.posting_control_id);
161:
162: dbms_sql.bind_variable(p_update_cursor, ':ra_post_loop_number',
163: p_trx_rec.ra_post_loop_number);
164:
165: dbms_sql.bind_variable(p_update_cursor, ':complete_flag',
166: p_trx_rec.complete_flag);

Line 165: dbms_sql.bind_variable(p_update_cursor, ':complete_flag',

161:
162: dbms_sql.bind_variable(p_update_cursor, ':ra_post_loop_number',
163: p_trx_rec.ra_post_loop_number);
164:
165: dbms_sql.bind_variable(p_update_cursor, ':complete_flag',
166: p_trx_rec.complete_flag);
167:
168: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_id',
169: p_trx_rec.initial_customer_trx_id);

Line 168: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_id',

164:
165: dbms_sql.bind_variable(p_update_cursor, ':complete_flag',
166: p_trx_rec.complete_flag);
167:
168: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_id',
169: p_trx_rec.initial_customer_trx_id);
170:
171: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',
172: p_trx_rec.previous_customer_trx_id);

Line 171: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',

167:
168: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_id',
169: p_trx_rec.initial_customer_trx_id);
170:
171: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',
172: p_trx_rec.previous_customer_trx_id);
173:
174: dbms_sql.bind_variable(p_update_cursor, ':related_customer_trx_id',
175: p_trx_rec.related_customer_trx_id);

Line 174: dbms_sql.bind_variable(p_update_cursor, ':related_customer_trx_id',

170:
171: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',
172: p_trx_rec.previous_customer_trx_id);
173:
174: dbms_sql.bind_variable(p_update_cursor, ':related_customer_trx_id',
175: p_trx_rec.related_customer_trx_id);
176:
177: dbms_sql.bind_variable(p_update_cursor, ':recurred_from_trx_number',
178: p_trx_rec.recurred_from_trx_number);

Line 177: dbms_sql.bind_variable(p_update_cursor, ':recurred_from_trx_number',

173:
174: dbms_sql.bind_variable(p_update_cursor, ':related_customer_trx_id',
175: p_trx_rec.related_customer_trx_id);
176:
177: dbms_sql.bind_variable(p_update_cursor, ':recurred_from_trx_number',
178: p_trx_rec.recurred_from_trx_number);
179:
180: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_type_id',
181: p_trx_rec.cust_trx_type_id);

Line 180: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_type_id',

176:
177: dbms_sql.bind_variable(p_update_cursor, ':recurred_from_trx_number',
178: p_trx_rec.recurred_from_trx_number);
179:
180: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_type_id',
181: p_trx_rec.cust_trx_type_id);
182:
183: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
184: p_trx_rec.batch_id);

Line 183: dbms_sql.bind_variable(p_update_cursor, ':batch_id',

179:
180: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_type_id',
181: p_trx_rec.cust_trx_type_id);
182:
183: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
184: p_trx_rec.batch_id);
185:
186: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
187: p_trx_rec.batch_source_id);

Line 186: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',

182:
183: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
184: p_trx_rec.batch_id);
185:
186: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
187: p_trx_rec.batch_source_id);
188:
189: dbms_sql.bind_variable(p_update_cursor, ':agreement_id',
190: p_trx_rec.agreement_id);

Line 189: dbms_sql.bind_variable(p_update_cursor, ':agreement_id',

185:
186: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
187: p_trx_rec.batch_source_id);
188:
189: dbms_sql.bind_variable(p_update_cursor, ':agreement_id',
190: p_trx_rec.agreement_id);
191:
192: dbms_sql.bind_variable(p_update_cursor, ':trx_date',
193: p_trx_rec.trx_date);

Line 192: dbms_sql.bind_variable(p_update_cursor, ':trx_date',

188:
189: dbms_sql.bind_variable(p_update_cursor, ':agreement_id',
190: p_trx_rec.agreement_id);
191:
192: dbms_sql.bind_variable(p_update_cursor, ':trx_date',
193: p_trx_rec.trx_date);
194:
195: dbms_sql.bind_variable(p_update_cursor, ':bill_to_customer_id',
196: p_trx_rec.bill_to_customer_id);

Line 195: dbms_sql.bind_variable(p_update_cursor, ':bill_to_customer_id',

191:
192: dbms_sql.bind_variable(p_update_cursor, ':trx_date',
193: p_trx_rec.trx_date);
194:
195: dbms_sql.bind_variable(p_update_cursor, ':bill_to_customer_id',
196: p_trx_rec.bill_to_customer_id);
197:
198: dbms_sql.bind_variable(p_update_cursor, ':bill_to_contact_id',
199: p_trx_rec.bill_to_contact_id);

Line 198: dbms_sql.bind_variable(p_update_cursor, ':bill_to_contact_id',

194:
195: dbms_sql.bind_variable(p_update_cursor, ':bill_to_customer_id',
196: p_trx_rec.bill_to_customer_id);
197:
198: dbms_sql.bind_variable(p_update_cursor, ':bill_to_contact_id',
199: p_trx_rec.bill_to_contact_id);
200:
201: dbms_sql.bind_variable(p_update_cursor, ':bill_to_site_use_id',
202: p_trx_rec.bill_to_site_use_id);

Line 201: dbms_sql.bind_variable(p_update_cursor, ':bill_to_site_use_id',

197:
198: dbms_sql.bind_variable(p_update_cursor, ':bill_to_contact_id',
199: p_trx_rec.bill_to_contact_id);
200:
201: dbms_sql.bind_variable(p_update_cursor, ':bill_to_site_use_id',
202: p_trx_rec.bill_to_site_use_id);
203:
204: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',
205: p_trx_rec.ship_to_customer_id);

Line 204: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',

200:
201: dbms_sql.bind_variable(p_update_cursor, ':bill_to_site_use_id',
202: p_trx_rec.bill_to_site_use_id);
203:
204: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',
205: p_trx_rec.ship_to_customer_id);
206:
207: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',
208: p_trx_rec.ship_to_contact_id);

Line 207: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',

203:
204: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',
205: p_trx_rec.ship_to_customer_id);
206:
207: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',
208: p_trx_rec.ship_to_contact_id);
209:
210: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',
211: p_trx_rec.ship_to_site_use_id);

Line 210: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',

206:
207: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',
208: p_trx_rec.ship_to_contact_id);
209:
210: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',
211: p_trx_rec.ship_to_site_use_id);
212:
213: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer_id',
214: p_trx_rec.sold_to_customer_id);

Line 213: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer_id',

209:
210: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',
211: p_trx_rec.ship_to_site_use_id);
212:
213: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer_id',
214: p_trx_rec.sold_to_customer_id);
215:
216: dbms_sql.bind_variable(p_update_cursor, ':sold_to_site_use_id',
217: p_trx_rec.sold_to_site_use_id);

Line 216: dbms_sql.bind_variable(p_update_cursor, ':sold_to_site_use_id',

212:
213: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer_id',
214: p_trx_rec.sold_to_customer_id);
215:
216: dbms_sql.bind_variable(p_update_cursor, ':sold_to_site_use_id',
217: p_trx_rec.sold_to_site_use_id);
218:
219: dbms_sql.bind_variable(p_update_cursor, ':sold_to_contact_id',
220: p_trx_rec.sold_to_contact_id);

Line 219: dbms_sql.bind_variable(p_update_cursor, ':sold_to_contact_id',

215:
216: dbms_sql.bind_variable(p_update_cursor, ':sold_to_site_use_id',
217: p_trx_rec.sold_to_site_use_id);
218:
219: dbms_sql.bind_variable(p_update_cursor, ':sold_to_contact_id',
220: p_trx_rec.sold_to_contact_id);
221:
222: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
223: p_trx_rec.customer_reference);

Line 222: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',

218:
219: dbms_sql.bind_variable(p_update_cursor, ':sold_to_contact_id',
220: p_trx_rec.sold_to_contact_id);
221:
222: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
223: p_trx_rec.customer_reference);
224:
225: dbms_sql.bind_variable(p_update_cursor, ':customer_reference_date',
226: p_trx_rec.customer_reference_date);

Line 225: dbms_sql.bind_variable(p_update_cursor, ':customer_reference_date',

221:
222: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
223: p_trx_rec.customer_reference);
224:
225: dbms_sql.bind_variable(p_update_cursor, ':customer_reference_date',
226: p_trx_rec.customer_reference_date);
227:
228: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_installments',
229: p_trx_rec.credit_method_for_installments);

Line 228: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_installments',

224:
225: dbms_sql.bind_variable(p_update_cursor, ':customer_reference_date',
226: p_trx_rec.customer_reference_date);
227:
228: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_installments',
229: p_trx_rec.credit_method_for_installments);
230:
231: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_rules',
232: p_trx_rec.credit_method_for_rules);

Line 231: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_rules',

227:
228: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_installments',
229: p_trx_rec.credit_method_for_installments);
230:
231: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_rules',
232: p_trx_rec.credit_method_for_rules);
233:
234: dbms_sql.bind_variable(p_update_cursor, ':start_date_commitment',
235: p_trx_rec.start_date_commitment);

Line 234: dbms_sql.bind_variable(p_update_cursor, ':start_date_commitment',

230:
231: dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_rules',
232: p_trx_rec.credit_method_for_rules);
233:
234: dbms_sql.bind_variable(p_update_cursor, ':start_date_commitment',
235: p_trx_rec.start_date_commitment);
236:
237: dbms_sql.bind_variable(p_update_cursor, ':end_date_commitment',
238: p_trx_rec.end_date_commitment);

Line 237: dbms_sql.bind_variable(p_update_cursor, ':end_date_commitment',

233:
234: dbms_sql.bind_variable(p_update_cursor, ':start_date_commitment',
235: p_trx_rec.start_date_commitment);
236:
237: dbms_sql.bind_variable(p_update_cursor, ':end_date_commitment',
238: p_trx_rec.end_date_commitment);
239:
240: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
241: p_trx_rec.exchange_date);

Line 240: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',

236:
237: dbms_sql.bind_variable(p_update_cursor, ':end_date_commitment',
238: p_trx_rec.end_date_commitment);
239:
240: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
241: p_trx_rec.exchange_date);
242:
243: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
244: p_trx_rec.exchange_rate);

Line 243: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',

239:
240: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
241: p_trx_rec.exchange_date);
242:
243: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
244: p_trx_rec.exchange_rate);
245:
246: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
247: p_trx_rec.exchange_rate_type);

Line 246: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',

242:
243: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
244: p_trx_rec.exchange_rate);
245:
246: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
247: p_trx_rec.exchange_rate_type);
248:
249: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
250: p_trx_rec.customer_bank_account_id);

Line 249: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',

245:
246: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
247: p_trx_rec.exchange_rate_type);
248:
249: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
250: p_trx_rec.customer_bank_account_id);
251:
252: dbms_sql.bind_variable(p_update_cursor, ':finance_charges',
253: p_trx_rec.finance_charges);

Line 252: dbms_sql.bind_variable(p_update_cursor, ':finance_charges',

248:
249: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
250: p_trx_rec.customer_bank_account_id);
251:
252: dbms_sql.bind_variable(p_update_cursor, ':finance_charges',
253: p_trx_rec.finance_charges);
254:
255: dbms_sql.bind_variable(p_update_cursor, ':fob_point',
256: p_trx_rec.fob_point);

Line 255: dbms_sql.bind_variable(p_update_cursor, ':fob_point',

251:
252: dbms_sql.bind_variable(p_update_cursor, ':finance_charges',
253: p_trx_rec.finance_charges);
254:
255: dbms_sql.bind_variable(p_update_cursor, ':fob_point',
256: p_trx_rec.fob_point);
257:
258: dbms_sql.bind_variable(p_update_cursor, ':comments',
259: p_trx_rec.comments);

Line 258: dbms_sql.bind_variable(p_update_cursor, ':comments',

254:
255: dbms_sql.bind_variable(p_update_cursor, ':fob_point',
256: p_trx_rec.fob_point);
257:
258: dbms_sql.bind_variable(p_update_cursor, ':comments',
259: p_trx_rec.comments);
260:
261: dbms_sql.bind_variable(p_update_cursor, ':internal_notes',
262: p_trx_rec.internal_notes);

Line 261: dbms_sql.bind_variable(p_update_cursor, ':internal_notes',

257:
258: dbms_sql.bind_variable(p_update_cursor, ':comments',
259: p_trx_rec.comments);
260:
261: dbms_sql.bind_variable(p_update_cursor, ':internal_notes',
262: p_trx_rec.internal_notes);
263:
264: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',
265: p_trx_rec.invoice_currency_code);

Line 264: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',

260:
261: dbms_sql.bind_variable(p_update_cursor, ':internal_notes',
262: p_trx_rec.internal_notes);
263:
264: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',
265: p_trx_rec.invoice_currency_code);
266:
267: dbms_sql.bind_variable(p_update_cursor, ':invoicing_rule_id',
268: p_trx_rec.invoicing_rule_id);

Line 267: dbms_sql.bind_variable(p_update_cursor, ':invoicing_rule_id',

263:
264: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',
265: p_trx_rec.invoice_currency_code);
266:
267: dbms_sql.bind_variable(p_update_cursor, ':invoicing_rule_id',
268: p_trx_rec.invoicing_rule_id);
269:
270: dbms_sql.bind_variable(p_update_cursor, ':last_printed_sequence_num',
271: p_trx_rec.last_printed_sequence_num);

Line 270: dbms_sql.bind_variable(p_update_cursor, ':last_printed_sequence_num',

266:
267: dbms_sql.bind_variable(p_update_cursor, ':invoicing_rule_id',
268: p_trx_rec.invoicing_rule_id);
269:
270: dbms_sql.bind_variable(p_update_cursor, ':last_printed_sequence_num',
271: p_trx_rec.last_printed_sequence_num);
272:
273: dbms_sql.bind_variable(p_update_cursor, ':orig_system_batch_name',
274: p_trx_rec.orig_system_batch_name);

Line 273: dbms_sql.bind_variable(p_update_cursor, ':orig_system_batch_name',

269:
270: dbms_sql.bind_variable(p_update_cursor, ':last_printed_sequence_num',
271: p_trx_rec.last_printed_sequence_num);
272:
273: dbms_sql.bind_variable(p_update_cursor, ':orig_system_batch_name',
274: p_trx_rec.orig_system_batch_name);
275:
276: dbms_sql.bind_variable(p_update_cursor, ':primary_salesrep_id',
277: p_trx_rec.primary_salesrep_id);

Line 276: dbms_sql.bind_variable(p_update_cursor, ':primary_salesrep_id',

272:
273: dbms_sql.bind_variable(p_update_cursor, ':orig_system_batch_name',
274: p_trx_rec.orig_system_batch_name);
275:
276: dbms_sql.bind_variable(p_update_cursor, ':primary_salesrep_id',
277: p_trx_rec.primary_salesrep_id);
278:
279: dbms_sql.bind_variable(p_update_cursor, ':printing_count',
280: p_trx_rec.printing_count);

Line 279: dbms_sql.bind_variable(p_update_cursor, ':printing_count',

275:
276: dbms_sql.bind_variable(p_update_cursor, ':primary_salesrep_id',
277: p_trx_rec.primary_salesrep_id);
278:
279: dbms_sql.bind_variable(p_update_cursor, ':printing_count',
280: p_trx_rec.printing_count);
281:
282: dbms_sql.bind_variable(p_update_cursor, ':printing_last_printed',
283: p_trx_rec.printing_last_printed);

Line 282: dbms_sql.bind_variable(p_update_cursor, ':printing_last_printed',

278:
279: dbms_sql.bind_variable(p_update_cursor, ':printing_count',
280: p_trx_rec.printing_count);
281:
282: dbms_sql.bind_variable(p_update_cursor, ':printing_last_printed',
283: p_trx_rec.printing_last_printed);
284:
285: dbms_sql.bind_variable(p_update_cursor, ':printing_option',
286: p_trx_rec.printing_option);

Line 285: dbms_sql.bind_variable(p_update_cursor, ':printing_option',

281:
282: dbms_sql.bind_variable(p_update_cursor, ':printing_last_printed',
283: p_trx_rec.printing_last_printed);
284:
285: dbms_sql.bind_variable(p_update_cursor, ':printing_option',
286: p_trx_rec.printing_option);
287:
288: dbms_sql.bind_variable(p_update_cursor, ':printing_original_date',
289: p_trx_rec.printing_original_date);

Line 288: dbms_sql.bind_variable(p_update_cursor, ':printing_original_date',

284:
285: dbms_sql.bind_variable(p_update_cursor, ':printing_option',
286: p_trx_rec.printing_option);
287:
288: dbms_sql.bind_variable(p_update_cursor, ':printing_original_date',
289: p_trx_rec.printing_original_date);
290:
291: dbms_sql.bind_variable(p_update_cursor, ':printing_pending',
292: p_trx_rec.printing_pending);

Line 291: dbms_sql.bind_variable(p_update_cursor, ':printing_pending',

287:
288: dbms_sql.bind_variable(p_update_cursor, ':printing_original_date',
289: p_trx_rec.printing_original_date);
290:
291: dbms_sql.bind_variable(p_update_cursor, ':printing_pending',
292: p_trx_rec.printing_pending);
293:
294: dbms_sql.bind_variable(p_update_cursor, ':purchase_order',
295: p_trx_rec.purchase_order);

Line 294: dbms_sql.bind_variable(p_update_cursor, ':purchase_order',

290:
291: dbms_sql.bind_variable(p_update_cursor, ':printing_pending',
292: p_trx_rec.printing_pending);
293:
294: dbms_sql.bind_variable(p_update_cursor, ':purchase_order',
295: p_trx_rec.purchase_order);
296:
297: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_date',
298: p_trx_rec.purchase_order_date);

Line 297: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_date',

293:
294: dbms_sql.bind_variable(p_update_cursor, ':purchase_order',
295: p_trx_rec.purchase_order);
296:
297: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_date',
298: p_trx_rec.purchase_order_date);
299:
300: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_revision',
301: p_trx_rec.purchase_order_revision);

Line 300: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_revision',

296:
297: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_date',
298: p_trx_rec.purchase_order_date);
299:
300: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_revision',
301: p_trx_rec.purchase_order_revision);
302:
303: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
304: p_trx_rec.receipt_method_id);

Line 303: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',

299:
300: dbms_sql.bind_variable(p_update_cursor, ':purchase_order_revision',
301: p_trx_rec.purchase_order_revision);
302:
303: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
304: p_trx_rec.receipt_method_id);
305:
306: dbms_sql.bind_variable(p_update_cursor, ':remit_to_address_id',
307: p_trx_rec.remit_to_address_id);

Line 306: dbms_sql.bind_variable(p_update_cursor, ':remit_to_address_id',

302:
303: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
304: p_trx_rec.receipt_method_id);
305:
306: dbms_sql.bind_variable(p_update_cursor, ':remit_to_address_id',
307: p_trx_rec.remit_to_address_id);
308:
309: dbms_sql.bind_variable(p_update_cursor, ':shipment_id',
310: p_trx_rec.shipment_id);

Line 309: dbms_sql.bind_variable(p_update_cursor, ':shipment_id',

305:
306: dbms_sql.bind_variable(p_update_cursor, ':remit_to_address_id',
307: p_trx_rec.remit_to_address_id);
308:
309: dbms_sql.bind_variable(p_update_cursor, ':shipment_id',
310: p_trx_rec.shipment_id);
311:
312: dbms_sql.bind_variable(p_update_cursor, ':ship_date_actual',
313: p_trx_rec.ship_date_actual);

Line 312: dbms_sql.bind_variable(p_update_cursor, ':ship_date_actual',

308:
309: dbms_sql.bind_variable(p_update_cursor, ':shipment_id',
310: p_trx_rec.shipment_id);
311:
312: dbms_sql.bind_variable(p_update_cursor, ':ship_date_actual',
313: p_trx_rec.ship_date_actual);
314:
315: dbms_sql.bind_variable(p_update_cursor, ':ship_via',
316: p_trx_rec.ship_via);

Line 315: dbms_sql.bind_variable(p_update_cursor, ':ship_via',

311:
312: dbms_sql.bind_variable(p_update_cursor, ':ship_date_actual',
313: p_trx_rec.ship_date_actual);
314:
315: dbms_sql.bind_variable(p_update_cursor, ':ship_via',
316: p_trx_rec.ship_via);
317:
318: dbms_sql.bind_variable(p_update_cursor, ':term_due_date',
319: p_trx_rec.term_due_date);

Line 318: dbms_sql.bind_variable(p_update_cursor, ':term_due_date',

314:
315: dbms_sql.bind_variable(p_update_cursor, ':ship_via',
316: p_trx_rec.ship_via);
317:
318: dbms_sql.bind_variable(p_update_cursor, ':term_due_date',
319: p_trx_rec.term_due_date);
320:
321: dbms_sql.bind_variable(p_update_cursor, ':term_id',
322: p_trx_rec.term_id);

Line 321: dbms_sql.bind_variable(p_update_cursor, ':term_id',

317:
318: dbms_sql.bind_variable(p_update_cursor, ':term_due_date',
319: p_trx_rec.term_due_date);
320:
321: dbms_sql.bind_variable(p_update_cursor, ':term_id',
322: p_trx_rec.term_id);
323:
324: dbms_sql.bind_variable(p_update_cursor, ':territory_id',
325: p_trx_rec.territory_id);

Line 324: dbms_sql.bind_variable(p_update_cursor, ':territory_id',

320:
321: dbms_sql.bind_variable(p_update_cursor, ':term_id',
322: p_trx_rec.term_id);
323:
324: dbms_sql.bind_variable(p_update_cursor, ':territory_id',
325: p_trx_rec.territory_id);
326:
327: dbms_sql.bind_variable(p_update_cursor, ':waybill_number',
328: p_trx_rec.waybill_number);

Line 327: dbms_sql.bind_variable(p_update_cursor, ':waybill_number',

323:
324: dbms_sql.bind_variable(p_update_cursor, ':territory_id',
325: p_trx_rec.territory_id);
326:
327: dbms_sql.bind_variable(p_update_cursor, ':waybill_number',
328: p_trx_rec.waybill_number);
329:
330: dbms_sql.bind_variable(p_update_cursor, ':status_trx',
331: p_trx_rec.status_trx);

Line 330: dbms_sql.bind_variable(p_update_cursor, ':status_trx',

326:
327: dbms_sql.bind_variable(p_update_cursor, ':waybill_number',
328: p_trx_rec.waybill_number);
329:
330: dbms_sql.bind_variable(p_update_cursor, ':status_trx',
331: p_trx_rec.status_trx);
332:
333: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
334: p_trx_rec.reason_code);

Line 333: dbms_sql.bind_variable(p_update_cursor, ':reason_code',

329:
330: dbms_sql.bind_variable(p_update_cursor, ':status_trx',
331: p_trx_rec.status_trx);
332:
333: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
334: p_trx_rec.reason_code);
335:
336: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
337: p_trx_rec.doc_sequence_id);

Line 336: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',

332:
333: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
334: p_trx_rec.reason_code);
335:
336: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
337: p_trx_rec.doc_sequence_id);
338:
339: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
340: p_trx_rec.doc_sequence_value);

Line 339: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',

335:
336: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
337: p_trx_rec.doc_sequence_id);
338:
339: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
340: p_trx_rec.doc_sequence_value);
341:
342: dbms_sql.bind_variable(p_update_cursor, ':paying_customer_id',
343: p_trx_rec.paying_customer_id);

Line 342: dbms_sql.bind_variable(p_update_cursor, ':paying_customer_id',

338:
339: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
340: p_trx_rec.doc_sequence_value);
341:
342: dbms_sql.bind_variable(p_update_cursor, ':paying_customer_id',
343: p_trx_rec.paying_customer_id);
344:
345: dbms_sql.bind_variable(p_update_cursor, ':paying_site_use_id',
346: p_trx_rec.paying_site_use_id);

Line 345: dbms_sql.bind_variable(p_update_cursor, ':paying_site_use_id',

341:
342: dbms_sql.bind_variable(p_update_cursor, ':paying_customer_id',
343: p_trx_rec.paying_customer_id);
344:
345: dbms_sql.bind_variable(p_update_cursor, ':paying_site_use_id',
346: p_trx_rec.paying_site_use_id);
347:
348: dbms_sql.bind_variable(p_update_cursor, ':related_batch_source_id',
349: p_trx_rec.related_batch_source_id);

Line 348: dbms_sql.bind_variable(p_update_cursor, ':related_batch_source_id',

344:
345: dbms_sql.bind_variable(p_update_cursor, ':paying_site_use_id',
346: p_trx_rec.paying_site_use_id);
347:
348: dbms_sql.bind_variable(p_update_cursor, ':related_batch_source_id',
349: p_trx_rec.related_batch_source_id);
350:
351: dbms_sql.bind_variable(p_update_cursor, ':default_tax_exempt_flag',
352: p_trx_rec.default_tax_exempt_flag);

Line 351: dbms_sql.bind_variable(p_update_cursor, ':default_tax_exempt_flag',

347:
348: dbms_sql.bind_variable(p_update_cursor, ':related_batch_source_id',
349: p_trx_rec.related_batch_source_id);
350:
351: dbms_sql.bind_variable(p_update_cursor, ':default_tax_exempt_flag',
352: p_trx_rec.default_tax_exempt_flag);
353:
354: dbms_sql.bind_variable(p_update_cursor, ':created_from',
355: p_trx_rec.created_from);

Line 354: dbms_sql.bind_variable(p_update_cursor, ':created_from',

350:
351: dbms_sql.bind_variable(p_update_cursor, ':default_tax_exempt_flag',
352: p_trx_rec.default_tax_exempt_flag);
353:
354: dbms_sql.bind_variable(p_update_cursor, ':created_from',
355: p_trx_rec.created_from);
356:
357: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',
358: p_trx_rec.default_ussgl_trx_code_context);

Line 357: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',

353:
354: dbms_sql.bind_variable(p_update_cursor, ':created_from',
355: p_trx_rec.created_from);
356:
357: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',
358: p_trx_rec.default_ussgl_trx_code_context);
359:
360: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',
361: p_trx_rec.default_ussgl_transaction_code);

Line 360: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',

356:
357: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',
358: p_trx_rec.default_ussgl_trx_code_context);
359:
360: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',
361: p_trx_rec.default_ussgl_transaction_code);
362:
363: dbms_sql.bind_variable(p_update_cursor, ':old_trx_number',
364: p_trx_rec.old_trx_number);

Line 363: dbms_sql.bind_variable(p_update_cursor, ':old_trx_number',

359:
360: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',
361: p_trx_rec.default_ussgl_transaction_code);
362:
363: dbms_sql.bind_variable(p_update_cursor, ':old_trx_number',
364: p_trx_rec.old_trx_number);
365:
366: dbms_sql.bind_variable(p_update_cursor, ':interface_header_context',
367: p_trx_rec.interface_header_context);

Line 366: dbms_sql.bind_variable(p_update_cursor, ':interface_header_context',

362:
363: dbms_sql.bind_variable(p_update_cursor, ':old_trx_number',
364: p_trx_rec.old_trx_number);
365:
366: dbms_sql.bind_variable(p_update_cursor, ':interface_header_context',
367: p_trx_rec.interface_header_context);
368:
369: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute1',
370: p_trx_rec.interface_header_attribute1);

Line 369: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute1',

365:
366: dbms_sql.bind_variable(p_update_cursor, ':interface_header_context',
367: p_trx_rec.interface_header_context);
368:
369: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute1',
370: p_trx_rec.interface_header_attribute1);
371:
372: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute2',
373: p_trx_rec.interface_header_attribute2);

Line 372: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute2',

368:
369: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute1',
370: p_trx_rec.interface_header_attribute1);
371:
372: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute2',
373: p_trx_rec.interface_header_attribute2);
374:
375: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute3',
376: p_trx_rec.interface_header_attribute3);

Line 375: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute3',

371:
372: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute2',
373: p_trx_rec.interface_header_attribute2);
374:
375: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute3',
376: p_trx_rec.interface_header_attribute3);
377:
378: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute4',
379: p_trx_rec.interface_header_attribute4);

Line 378: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute4',

374:
375: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute3',
376: p_trx_rec.interface_header_attribute3);
377:
378: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute4',
379: p_trx_rec.interface_header_attribute4);
380:
381: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute5',
382: p_trx_rec.interface_header_attribute5);

Line 381: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute5',

377:
378: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute4',
379: p_trx_rec.interface_header_attribute4);
380:
381: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute5',
382: p_trx_rec.interface_header_attribute5);
383:
384: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute6',
385: p_trx_rec.interface_header_attribute6);

Line 384: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute6',

380:
381: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute5',
382: p_trx_rec.interface_header_attribute5);
383:
384: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute6',
385: p_trx_rec.interface_header_attribute6);
386:
387: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute7',
388: p_trx_rec.interface_header_attribute7);

Line 387: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute7',

383:
384: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute6',
385: p_trx_rec.interface_header_attribute6);
386:
387: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute7',
388: p_trx_rec.interface_header_attribute7);
389:
390: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute8',
391: p_trx_rec.interface_header_attribute8);

Line 390: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute8',

386:
387: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute7',
388: p_trx_rec.interface_header_attribute7);
389:
390: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute8',
391: p_trx_rec.interface_header_attribute8);
392:
393: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute9',
394: p_trx_rec.interface_header_attribute9);

Line 393: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute9',

389:
390: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute8',
391: p_trx_rec.interface_header_attribute8);
392:
393: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute9',
394: p_trx_rec.interface_header_attribute9);
395:
396: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute10',
397: p_trx_rec.interface_header_attribute10);

Line 396: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute10',

392:
393: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute9',
394: p_trx_rec.interface_header_attribute9);
395:
396: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute10',
397: p_trx_rec.interface_header_attribute10);
398:
399: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute11',
400: p_trx_rec.interface_header_attribute11);

Line 399: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute11',

395:
396: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute10',
397: p_trx_rec.interface_header_attribute10);
398:
399: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute11',
400: p_trx_rec.interface_header_attribute11);
401:
402: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute12',
403: p_trx_rec.interface_header_attribute12);

Line 402: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute12',

398:
399: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute11',
400: p_trx_rec.interface_header_attribute11);
401:
402: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute12',
403: p_trx_rec.interface_header_attribute12);
404:
405: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute13',
406: p_trx_rec.interface_header_attribute13);

Line 405: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute13',

401:
402: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute12',
403: p_trx_rec.interface_header_attribute12);
404:
405: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute13',
406: p_trx_rec.interface_header_attribute13);
407:
408: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute14',
409: p_trx_rec.interface_header_attribute14);

Line 408: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute14',

404:
405: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute13',
406: p_trx_rec.interface_header_attribute13);
407:
408: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute14',
409: p_trx_rec.interface_header_attribute14);
410:
411: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute15',
412: p_trx_rec.interface_header_attribute15);

Line 411: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute15',

407:
408: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute14',
409: p_trx_rec.interface_header_attribute14);
410:
411: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute15',
412: p_trx_rec.interface_header_attribute15);
413:
414: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
415: p_trx_rec.attribute_category);

Line 414: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

410:
411: dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute15',
412: p_trx_rec.interface_header_attribute15);
413:
414: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
415: p_trx_rec.attribute_category);
416:
417: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
418: p_trx_rec.attribute1);

Line 417: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

413:
414: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
415: p_trx_rec.attribute_category);
416:
417: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
418: p_trx_rec.attribute1);
419:
420: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
421: p_trx_rec.attribute2);

Line 420: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

416:
417: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
418: p_trx_rec.attribute1);
419:
420: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
421: p_trx_rec.attribute2);
422:
423: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
424: p_trx_rec.attribute3);

Line 423: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

419:
420: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
421: p_trx_rec.attribute2);
422:
423: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
424: p_trx_rec.attribute3);
425:
426: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
427: p_trx_rec.attribute4);

Line 426: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

422:
423: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
424: p_trx_rec.attribute3);
425:
426: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
427: p_trx_rec.attribute4);
428:
429: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
430: p_trx_rec.attribute5);

Line 429: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

425:
426: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
427: p_trx_rec.attribute4);
428:
429: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
430: p_trx_rec.attribute5);
431:
432: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
433: p_trx_rec.attribute6);

Line 432: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

428:
429: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
430: p_trx_rec.attribute5);
431:
432: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
433: p_trx_rec.attribute6);
434:
435: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
436: p_trx_rec.attribute7);

Line 435: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

431:
432: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
433: p_trx_rec.attribute6);
434:
435: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
436: p_trx_rec.attribute7);
437:
438: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
439: p_trx_rec.attribute8);

Line 438: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

434:
435: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
436: p_trx_rec.attribute7);
437:
438: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
439: p_trx_rec.attribute8);
440:
441: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
442: p_trx_rec.attribute9);

Line 441: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

437:
438: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
439: p_trx_rec.attribute8);
440:
441: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
442: p_trx_rec.attribute9);
443:
444: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
445: p_trx_rec.attribute10);

Line 444: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

440:
441: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
442: p_trx_rec.attribute9);
443:
444: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
445: p_trx_rec.attribute10);
446:
447: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
448: p_trx_rec.attribute11);

Line 447: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

443:
444: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
445: p_trx_rec.attribute10);
446:
447: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
448: p_trx_rec.attribute11);
449:
450: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
451: p_trx_rec.attribute12);

Line 450: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

446:
447: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
448: p_trx_rec.attribute11);
449:
450: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
451: p_trx_rec.attribute12);
452:
453: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
454: p_trx_rec.attribute13);

Line 453: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

449:
450: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
451: p_trx_rec.attribute12);
452:
453: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
454: p_trx_rec.attribute13);
455:
456: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
457: p_trx_rec.attribute14);

Line 456: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

452:
453: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
454: p_trx_rec.attribute13);
455:
456: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
457: p_trx_rec.attribute14);
458:
459: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
460: p_trx_rec.attribute15);

Line 459: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

455:
456: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
457: p_trx_rec.attribute14);
458:
459: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
460: p_trx_rec.attribute15);
461:
462: dbms_sql.bind_variable(p_update_cursor, ':br_amount',
463: p_trx_rec.br_amount);

Line 462: dbms_sql.bind_variable(p_update_cursor, ':br_amount',

458:
459: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
460: p_trx_rec.attribute15);
461:
462: dbms_sql.bind_variable(p_update_cursor, ':br_amount',
463: p_trx_rec.br_amount);
464:
465: dbms_sql.bind_variable(p_update_cursor, ':br_unpaid_flag',
466: p_trx_rec.br_unpaid_flag);

Line 465: dbms_sql.bind_variable(p_update_cursor, ':br_unpaid_flag',

461:
462: dbms_sql.bind_variable(p_update_cursor, ':br_amount',
463: p_trx_rec.br_amount);
464:
465: dbms_sql.bind_variable(p_update_cursor, ':br_unpaid_flag',
466: p_trx_rec.br_unpaid_flag);
467:
468: dbms_sql.bind_variable(p_update_cursor, ':br_on_hold_flag',
469: p_trx_rec.br_on_hold_flag);

Line 468: dbms_sql.bind_variable(p_update_cursor, ':br_on_hold_flag',

464:
465: dbms_sql.bind_variable(p_update_cursor, ':br_unpaid_flag',
466: p_trx_rec.br_unpaid_flag);
467:
468: dbms_sql.bind_variable(p_update_cursor, ':br_on_hold_flag',
469: p_trx_rec.br_on_hold_flag);
470:
471: dbms_sql.bind_variable(p_update_cursor, ':drawee_id',
472: p_trx_rec.drawee_id);

Line 471: dbms_sql.bind_variable(p_update_cursor, ':drawee_id',

467:
468: dbms_sql.bind_variable(p_update_cursor, ':br_on_hold_flag',
469: p_trx_rec.br_on_hold_flag);
470:
471: dbms_sql.bind_variable(p_update_cursor, ':drawee_id',
472: p_trx_rec.drawee_id);
473:
474: dbms_sql.bind_variable(p_update_cursor, ':drawee_contact_id',
475: p_trx_rec.drawee_contact_id);

Line 474: dbms_sql.bind_variable(p_update_cursor, ':drawee_contact_id',

470:
471: dbms_sql.bind_variable(p_update_cursor, ':drawee_id',
472: p_trx_rec.drawee_id);
473:
474: dbms_sql.bind_variable(p_update_cursor, ':drawee_contact_id',
475: p_trx_rec.drawee_contact_id);
476:
477: dbms_sql.bind_variable(p_update_cursor, ':drawee_site_use_id',
478: p_trx_rec.drawee_site_use_id);

Line 477: dbms_sql.bind_variable(p_update_cursor, ':drawee_site_use_id',

473:
474: dbms_sql.bind_variable(p_update_cursor, ':drawee_contact_id',
475: p_trx_rec.drawee_contact_id);
476:
477: dbms_sql.bind_variable(p_update_cursor, ':drawee_site_use_id',
478: p_trx_rec.drawee_site_use_id);
479:
480: dbms_sql.bind_variable(p_update_cursor, ':drawee_bank_account_id',
481: p_trx_rec.drawee_bank_account_id);

Line 480: dbms_sql.bind_variable(p_update_cursor, ':drawee_bank_account_id',

476:
477: dbms_sql.bind_variable(p_update_cursor, ':drawee_site_use_id',
478: p_trx_rec.drawee_site_use_id);
479:
480: dbms_sql.bind_variable(p_update_cursor, ':drawee_bank_account_id',
481: p_trx_rec.drawee_bank_account_id);
482:
483: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_account_id',
484: p_trx_rec.remit_bank_acct_use_id);

Line 483: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_account_id',

479:
480: dbms_sql.bind_variable(p_update_cursor, ':drawee_bank_account_id',
481: p_trx_rec.drawee_bank_account_id);
482:
483: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_account_id',
484: p_trx_rec.remit_bank_acct_use_id);
485:
486: dbms_sql.bind_variable(p_update_cursor, ':override_remit_account_flag',
487: p_trx_rec.override_remit_account_flag);

Line 486: dbms_sql.bind_variable(p_update_cursor, ':override_remit_account_flag',

482:
483: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_account_id',
484: p_trx_rec.remit_bank_acct_use_id);
485:
486: dbms_sql.bind_variable(p_update_cursor, ':override_remit_account_flag',
487: p_trx_rec.override_remit_account_flag);
488:
489: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
490: p_trx_rec.special_instructions);

Line 489: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',

485:
486: dbms_sql.bind_variable(p_update_cursor, ':override_remit_account_flag',
487: p_trx_rec.override_remit_account_flag);
488:
489: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
490: p_trx_rec.special_instructions);
491:
492: dbms_sql.bind_variable(p_update_cursor, ':remittance_batch_id',
493: p_trx_rec.remittance_batch_id);

Line 492: dbms_sql.bind_variable(p_update_cursor, ':remittance_batch_id',

488:
489: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
490: p_trx_rec.special_instructions);
491:
492: dbms_sql.bind_variable(p_update_cursor, ':remittance_batch_id',
493: p_trx_rec.remittance_batch_id);
494:
495: dbms_sql.bind_variable(p_update_cursor, ':address_verification_code',
496: p_trx_rec.address_verification_code);

Line 495: dbms_sql.bind_variable(p_update_cursor, ':address_verification_code',

491:
492: dbms_sql.bind_variable(p_update_cursor, ':remittance_batch_id',
493: p_trx_rec.remittance_batch_id);
494:
495: dbms_sql.bind_variable(p_update_cursor, ':address_verification_code',
496: p_trx_rec.address_verification_code);
497:
498: dbms_sql.bind_variable(p_update_cursor, ':approval_code',
499: p_trx_rec.approval_code);

Line 498: dbms_sql.bind_variable(p_update_cursor, ':approval_code',

494:
495: dbms_sql.bind_variable(p_update_cursor, ':address_verification_code',
496: p_trx_rec.address_verification_code);
497:
498: dbms_sql.bind_variable(p_update_cursor, ':approval_code',
499: p_trx_rec.approval_code);
500:
501: dbms_sql.bind_variable(p_update_cursor, ':bill_to_address_id',
502: p_trx_rec.bill_to_address_id);

Line 501: dbms_sql.bind_variable(p_update_cursor, ':bill_to_address_id',

497:
498: dbms_sql.bind_variable(p_update_cursor, ':approval_code',
499: p_trx_rec.approval_code);
500:
501: dbms_sql.bind_variable(p_update_cursor, ':bill_to_address_id',
502: p_trx_rec.bill_to_address_id);
503:
504: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_flag',
505: p_trx_rec.edi_processed_flag);

Line 504: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_flag',

500:
501: dbms_sql.bind_variable(p_update_cursor, ':bill_to_address_id',
502: p_trx_rec.bill_to_address_id);
503:
504: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_flag',
505: p_trx_rec.edi_processed_flag);
506:
507: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_status',
508: p_trx_rec.edi_processed_status);

Line 507: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_status',

503:
504: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_flag',
505: p_trx_rec.edi_processed_flag);
506:
507: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_status',
508: p_trx_rec.edi_processed_status);
509:
510: dbms_sql.bind_variable(p_update_cursor, ':payment_server_order_num',
511: p_trx_rec.payment_server_order_num);

Line 510: dbms_sql.bind_variable(p_update_cursor, ':payment_server_order_num',

506:
507: dbms_sql.bind_variable(p_update_cursor, ':edi_processed_status',
508: p_trx_rec.edi_processed_status);
509:
510: dbms_sql.bind_variable(p_update_cursor, ':payment_server_order_num',
511: p_trx_rec.payment_server_order_num);
512:
513: dbms_sql.bind_variable(p_update_cursor, ':post_request_id',
514: p_trx_rec.post_request_id);

Line 513: dbms_sql.bind_variable(p_update_cursor, ':post_request_id',

509:
510: dbms_sql.bind_variable(p_update_cursor, ':payment_server_order_num',
511: p_trx_rec.payment_server_order_num);
512:
513: dbms_sql.bind_variable(p_update_cursor, ':post_request_id',
514: p_trx_rec.post_request_id);
515:
516: dbms_sql.bind_variable(p_update_cursor, ':request_id',
517: p_trx_rec.request_id);

Line 516: dbms_sql.bind_variable(p_update_cursor, ':request_id',

512:
513: dbms_sql.bind_variable(p_update_cursor, ':post_request_id',
514: p_trx_rec.post_request_id);
515:
516: dbms_sql.bind_variable(p_update_cursor, ':request_id',
517: p_trx_rec.request_id);
518:
519: dbms_sql.bind_variable(p_update_cursor, ':ship_to_address_id',
520: p_trx_rec.ship_to_address_id);

Line 519: dbms_sql.bind_variable(p_update_cursor, ':ship_to_address_id',

515:
516: dbms_sql.bind_variable(p_update_cursor, ':request_id',
517: p_trx_rec.request_id);
518:
519: dbms_sql.bind_variable(p_update_cursor, ':ship_to_address_id',
520: p_trx_rec.ship_to_address_id);
521:
522: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',
523: p_trx_rec.wh_update_date);

Line 522: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',

518:
519: dbms_sql.bind_variable(p_update_cursor, ':ship_to_address_id',
520: p_trx_rec.ship_to_address_id);
521:
522: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',
523: p_trx_rec.wh_update_date);
524:
525: dbms_sql.bind_variable(p_update_cursor, ':legal_entity_id',
526: p_trx_rec.legal_entity_id);

Line 525: dbms_sql.bind_variable(p_update_cursor, ':legal_entity_id',

521:
522: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',
523: p_trx_rec.wh_update_date);
524:
525: dbms_sql.bind_variable(p_update_cursor, ':legal_entity_id',
526: p_trx_rec.legal_entity_id);
527: /* PAYMENT_UPTAKE */
528: dbms_sql.bind_variable(p_update_cursor, ':payment_trxn_extension_id',
529: p_trx_rec.payment_trxn_extension_id);

Line 528: dbms_sql.bind_variable(p_update_cursor, ':payment_trxn_extension_id',

524:
525: dbms_sql.bind_variable(p_update_cursor, ':legal_entity_id',
526: p_trx_rec.legal_entity_id);
527: /* PAYMENT_UPTAKE */
528: dbms_sql.bind_variable(p_update_cursor, ':payment_trxn_extension_id',
529: p_trx_rec.payment_trxn_extension_id);
530:
531: dbms_sql.bind_variable(p_update_cursor, ':billing_date',
532: p_trx_rec.billing_date);

Line 531: dbms_sql.bind_variable(p_update_cursor, ':billing_date',

527: /* PAYMENT_UPTAKE */
528: dbms_sql.bind_variable(p_update_cursor, ':payment_trxn_extension_id',
529: p_trx_rec.payment_trxn_extension_id);
530:
531: dbms_sql.bind_variable(p_update_cursor, ':billing_date',
532: p_trx_rec.billing_date);
533: /*Start of Bug2427456*/
534: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
535: p_trx_rec.global_attribute_category);

Line 534: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',

530:
531: dbms_sql.bind_variable(p_update_cursor, ':billing_date',
532: p_trx_rec.billing_date);
533: /*Start of Bug2427456*/
534: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
535: p_trx_rec.global_attribute_category);
536:
537: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
538: p_trx_rec.global_attribute1);

Line 537: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',

533: /*Start of Bug2427456*/
534: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
535: p_trx_rec.global_attribute_category);
536:
537: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
538: p_trx_rec.global_attribute1);
539:
540: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
541: p_trx_rec.global_attribute2);

Line 540: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',

536:
537: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
538: p_trx_rec.global_attribute1);
539:
540: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
541: p_trx_rec.global_attribute2);
542:
543: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
544: p_trx_rec.global_attribute3);

Line 543: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',

539:
540: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
541: p_trx_rec.global_attribute2);
542:
543: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
544: p_trx_rec.global_attribute3);
545:
546: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
547: p_trx_rec.global_attribute4);

Line 546: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',

542:
543: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
544: p_trx_rec.global_attribute3);
545:
546: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
547: p_trx_rec.global_attribute4);
548:
549: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
550: p_trx_rec.global_attribute5);

Line 549: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',

545:
546: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
547: p_trx_rec.global_attribute4);
548:
549: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
550: p_trx_rec.global_attribute5);
551:
552: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
553: p_trx_rec.global_attribute6);

Line 552: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',

548:
549: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
550: p_trx_rec.global_attribute5);
551:
552: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
553: p_trx_rec.global_attribute6);
554:
555: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
556: p_trx_rec.global_attribute7);

Line 555: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',

551:
552: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
553: p_trx_rec.global_attribute6);
554:
555: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
556: p_trx_rec.global_attribute7);
557:
558:
559: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',

Line 559: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',

555: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
556: p_trx_rec.global_attribute7);
557:
558:
559: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
560: p_trx_rec.global_attribute8);
561:
562: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
563: p_trx_rec.global_attribute9);

Line 562: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',

558:
559: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
560: p_trx_rec.global_attribute8);
561:
562: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
563: p_trx_rec.global_attribute9);
564:
565: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
566: p_trx_rec.global_attribute10);

Line 565: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',

561:
562: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
563: p_trx_rec.global_attribute9);
564:
565: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
566: p_trx_rec.global_attribute10);
567:
568: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
569: p_trx_rec.global_attribute11);

Line 568: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',

564:
565: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
566: p_trx_rec.global_attribute10);
567:
568: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
569: p_trx_rec.global_attribute11);
570:
571: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
572: p_trx_rec.global_attribute12);

Line 571: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',

567:
568: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
569: p_trx_rec.global_attribute11);
570:
571: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
572: p_trx_rec.global_attribute12);
573:
574: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
575: p_trx_rec.global_attribute13);

Line 574: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',

570:
571: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
572: p_trx_rec.global_attribute12);
573:
574: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
575: p_trx_rec.global_attribute13);
576:
577: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
578: p_trx_rec.global_attribute14);

Line 577: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',

573:
574: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
575: p_trx_rec.global_attribute13);
576:
577: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
578: p_trx_rec.global_attribute14);
579:
580: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
581: p_trx_rec.global_attribute15);

Line 580: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',

576:
577: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
578: p_trx_rec.global_attribute14);
579:
580: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
581: p_trx_rec.global_attribute15);
582:
583: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
584: p_trx_rec.global_attribute16);

Line 583: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',

579:
580: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
581: p_trx_rec.global_attribute15);
582:
583: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
584: p_trx_rec.global_attribute16);
585:
586: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
587: p_trx_rec.global_attribute17);

Line 586: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',

582:
583: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
584: p_trx_rec.global_attribute16);
585:
586: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
587: p_trx_rec.global_attribute17);
588:
589: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
590: p_trx_rec.global_attribute18);

Line 589: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',

585:
586: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
587: p_trx_rec.global_attribute17);
588:
589: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
590: p_trx_rec.global_attribute18);
591:
592: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
593: p_trx_rec.global_attribute19);

Line 592: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',

588:
589: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
590: p_trx_rec.global_attribute18);
591:
592: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
593: p_trx_rec.global_attribute19);
594:
595: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
596: p_trx_rec.global_attribute20);

Line 595: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',

591:
592: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
593: p_trx_rec.global_attribute19);
594:
595: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
596: p_trx_rec.global_attribute20);
597:
598: dbms_sql.bind_variable(p_update_cursor, ':global_attribute21',
599: p_trx_rec.global_attribute21);

Line 598: dbms_sql.bind_variable(p_update_cursor, ':global_attribute21',

594:
595: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
596: p_trx_rec.global_attribute20);
597:
598: dbms_sql.bind_variable(p_update_cursor, ':global_attribute21',
599: p_trx_rec.global_attribute21);
600:
601: dbms_sql.bind_variable(p_update_cursor, ':global_attribute22',
602: p_trx_rec.global_attribute22);

Line 601: dbms_sql.bind_variable(p_update_cursor, ':global_attribute22',

597:
598: dbms_sql.bind_variable(p_update_cursor, ':global_attribute21',
599: p_trx_rec.global_attribute21);
600:
601: dbms_sql.bind_variable(p_update_cursor, ':global_attribute22',
602: p_trx_rec.global_attribute22);
603:
604: dbms_sql.bind_variable(p_update_cursor, ':global_attribute23',
605: p_trx_rec.global_attribute23);

Line 604: dbms_sql.bind_variable(p_update_cursor, ':global_attribute23',

600:
601: dbms_sql.bind_variable(p_update_cursor, ':global_attribute22',
602: p_trx_rec.global_attribute22);
603:
604: dbms_sql.bind_variable(p_update_cursor, ':global_attribute23',
605: p_trx_rec.global_attribute23);
606:
607: dbms_sql.bind_variable(p_update_cursor, ':global_attribute24',
608: p_trx_rec.global_attribute24);

Line 607: dbms_sql.bind_variable(p_update_cursor, ':global_attribute24',

603:
604: dbms_sql.bind_variable(p_update_cursor, ':global_attribute23',
605: p_trx_rec.global_attribute23);
606:
607: dbms_sql.bind_variable(p_update_cursor, ':global_attribute24',
608: p_trx_rec.global_attribute24);
609:
610: dbms_sql.bind_variable(p_update_cursor, ':global_attribute25',
611: p_trx_rec.global_attribute25);

Line 610: dbms_sql.bind_variable(p_update_cursor, ':global_attribute25',

606:
607: dbms_sql.bind_variable(p_update_cursor, ':global_attribute24',
608: p_trx_rec.global_attribute24);
609:
610: dbms_sql.bind_variable(p_update_cursor, ':global_attribute25',
611: p_trx_rec.global_attribute25);
612:
613: dbms_sql.bind_variable(p_update_cursor, ':global_attribute26',
614: p_trx_rec.global_attribute26);

Line 613: dbms_sql.bind_variable(p_update_cursor, ':global_attribute26',

609:
610: dbms_sql.bind_variable(p_update_cursor, ':global_attribute25',
611: p_trx_rec.global_attribute25);
612:
613: dbms_sql.bind_variable(p_update_cursor, ':global_attribute26',
614: p_trx_rec.global_attribute26);
615:
616: dbms_sql.bind_variable(p_update_cursor, ':global_attribute27',
617: p_trx_rec.global_attribute27);

Line 616: dbms_sql.bind_variable(p_update_cursor, ':global_attribute27',

612:
613: dbms_sql.bind_variable(p_update_cursor, ':global_attribute26',
614: p_trx_rec.global_attribute26);
615:
616: dbms_sql.bind_variable(p_update_cursor, ':global_attribute27',
617: p_trx_rec.global_attribute27);
618:
619: dbms_sql.bind_variable(p_update_cursor, ':global_attribute28',
620: p_trx_rec.global_attribute28);

Line 619: dbms_sql.bind_variable(p_update_cursor, ':global_attribute28',

615:
616: dbms_sql.bind_variable(p_update_cursor, ':global_attribute27',
617: p_trx_rec.global_attribute27);
618:
619: dbms_sql.bind_variable(p_update_cursor, ':global_attribute28',
620: p_trx_rec.global_attribute28);
621:
622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute29',
623: p_trx_rec.global_attribute29);

Line 622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute29',

618:
619: dbms_sql.bind_variable(p_update_cursor, ':global_attribute28',
620: p_trx_rec.global_attribute28);
621:
622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute29',
623: p_trx_rec.global_attribute29);
624:
625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute30',
626: p_trx_rec.global_attribute30);

Line 625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute30',

621:
622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute29',
623: p_trx_rec.global_attribute29);
624:
625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute30',
626: p_trx_rec.global_attribute30);
627:
628: /*End of Bug2427456*/
629: arp_util.debug('arp_ct_pkg.bind_trx_variables()-');

Line 1444: | dbms_sql.open_cursor |

1440: | SCOPE - PRIVATE |
1441: | |
1442: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1443: | arp_util.debug |
1444: | dbms_sql.open_cursor |
1445: | dbms_sql.parse |
1446: | dbms_sql.execute |
1447: | dbms_sql.close_cursor |
1448: | |

Line 1445: | dbms_sql.parse |

1441: | |
1442: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1443: | arp_util.debug |
1444: | dbms_sql.open_cursor |
1445: | dbms_sql.parse |
1446: | dbms_sql.execute |
1447: | dbms_sql.close_cursor |
1448: | |
1449: | ARGUMENTS : IN: |

Line 1446: | dbms_sql.execute |

1442: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1443: | arp_util.debug |
1444: | dbms_sql.open_cursor |
1445: | dbms_sql.parse |
1446: | dbms_sql.execute |
1447: | dbms_sql.close_cursor |
1448: | |
1449: | ARGUMENTS : IN: |
1450: | p_update_cursor - identifies the cursor to use |

Line 1447: | dbms_sql.close_cursor |

1443: | arp_util.debug |
1444: | dbms_sql.open_cursor |
1445: | dbms_sql.parse |
1446: | dbms_sql.execute |
1447: | dbms_sql.close_cursor |
1448: | |
1449: | ARGUMENTS : IN: |
1450: | p_update_cursor - identifies the cursor to use |
1451: | p_where_clause - identifies which rows to update |

Line 1477: ctrx_array dbms_sql.number_table;

1473: l_count number;
1474: l_update_statement_1 varchar2(30000);
1475: l_update_statement_2 varchar2(30000);
1476: l_update_statement long;
1477: ctrx_array dbms_sql.number_table;
1478:
1479: BEGIN
1480: arp_util.debug('arp_ct_pkg.generic_update()+');
1481:

Line 1492: p_update_cursor := dbms_sql.open_cursor;

1488:
1489: IF (p_update_cursor is null)
1490: THEN
1491:
1492: p_update_cursor := dbms_sql.open_cursor;
1493:
1494: /*---------------------------------+
1495: | Construct the update statement |
1496: +---------------------------------*/

Line 1516: dbms_sql.parse(p_update_cursor,

1512: /*-----------------------------------------------+
1513: | Parse, bind, execute and close the statement |
1514: +-----------------------------------------------*/
1515:
1516: dbms_sql.parse(p_update_cursor,
1517: l_update_statement,
1518: dbms_sql.v7);
1519:
1520: END IF;

Line 1518: dbms_sql.v7);

1514: +-----------------------------------------------*/
1515:
1516: dbms_sql.parse(p_update_cursor,
1517: l_update_statement,
1518: dbms_sql.v7);
1519:
1520: END IF;
1521:
1522: arp_ct_pkg.bind_trx_variables(p_update_cursor, p_trx_rec);

Line 1528: dbms_sql.bind_array(p_update_cursor, ':ctrx_key_value',

1524: /*----------------------------+
1525: | Bind output variable |
1526: +----------------------------*/
1527:
1528: dbms_sql.bind_array(p_update_cursor, ':ctrx_key_value',
1529: ctrx_array);
1530:
1531: /*-----------------------------------------+
1532: | Bind the variables in the where clause |

Line 1535: dbms_sql.bind_variable(p_update_cursor, ':where_1',

1531: /*-----------------------------------------+
1532: | Bind the variables in the where clause |
1533: +-----------------------------------------*/
1534:
1535: dbms_sql.bind_variable(p_update_cursor, ':where_1',
1536: p_where1);
1537:
1538: l_count := dbms_sql.execute(p_update_cursor);
1539:

Line 1538: l_count := dbms_sql.execute(p_update_cursor);

1534:
1535: dbms_sql.bind_variable(p_update_cursor, ':where_1',
1536: p_where1);
1537:
1538: l_count := dbms_sql.execute(p_update_cursor);
1539:
1540: arp_util.debug( to_char(l_count) || ' rows updated');
1541:
1542: /*------------------------------------------+

Line 1546: dbms_sql.variable_value( p_update_cursor, ':ctrx_key_value', ctrx_array);

1542: /*------------------------------------------+
1543: | get RETURNING COLUMN into OUT NOCOPY bind array |
1544: +------------------------------------------*/
1545:
1546: dbms_sql.variable_value( p_update_cursor, ':ctrx_key_value', ctrx_array);
1547:
1548:
1549: /*------------------------------------------------------------+
1550: | Raise the NO_DATA_FOUND exception if no rows were updated |

Line 1578: to_char(dbms_sql.last_error_position));

1574: WHEN OTHERS THEN
1575: arp_util.debug('EXCEPTION: arp_ct_pkg.generic_update()');
1576: arp_util.debug(l_update_statement);
1577: arp_util.debug('Error at character: ' ||
1578: to_char(dbms_sql.last_error_position));
1579: RAISE;
1580: END;
1581:
1582: /*===========================================================================+

Line 3734: -- Bug 1185665 : change dbms_sql to use native dynamic sql

3730: ELSE
3731: l_org_str := NULL;
3732: END IF;
3733:
3734: -- Bug 1185665 : change dbms_sql to use native dynamic sql
3735:
3736: /* Bug 1738914 : Selecting copy_doc_number_flag. Chargebacks are always
3737: numbered automatically , so this piece of code gets executed all the time */
3738:

Line 3752: l_trx_num_cursor := dbms_sql.open_cursor;

3748: EXECUTE IMMEDIATE l_trx_str
3749: INTO l_trx_number,l_copy_doc_number_flag;
3750:
3751: /*
3752: l_trx_num_cursor := dbms_sql.open_cursor;
3753:
3754: dbms_sql.parse(l_trx_num_cursor,
3755: 'select ra_trx_number_' ||
3756: REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||

Line 3754: dbms_sql.parse(l_trx_num_cursor,

3750:
3751: /*
3752: l_trx_num_cursor := dbms_sql.open_cursor;
3753:
3754: dbms_sql.parse(l_trx_num_cursor,
3755: 'select ra_trx_number_' ||
3756: REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||
3757: l_org_str||
3758: '_s.nextval trx_number ' ||

Line 3763: dbms_sql.v7);

3759: 'from ra_batch_sources ' ||
3760: 'where batch_source_id = ' ||
3761: p_trx_rec.batch_source_id ||
3762: ' and auto_trx_numbering_flag = ''Y''',
3763: dbms_sql.v7);
3764:
3765: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
3766:
3767: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);

Line 3765: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);

3761: p_trx_rec.batch_source_id ||
3762: ' and auto_trx_numbering_flag = ''Y''',
3763: dbms_sql.v7);
3764:
3765: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
3766:
3767: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
3768:
3769: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);

Line 3767: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);

3763: dbms_sql.v7);
3764:
3765: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
3766:
3767: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
3768:
3769: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
3770:
3771: dbms_sql.close_cursor(l_trx_num_cursor);

Line 3769: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);

3765: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
3766:
3767: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
3768:
3769: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
3770:
3771: dbms_sql.close_cursor(l_trx_num_cursor);
3772: */
3773: ELSE

Line 3771: dbms_sql.close_cursor(l_trx_num_cursor);

3767: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
3768:
3769: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
3770:
3771: dbms_sql.close_cursor(l_trx_num_cursor);
3772: */
3773: ELSE
3774: l_trx_number := p_trx_rec.trx_number;
3775: END IF;