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.AP_CUSTOM_INT_INV_PKG dependencies on DBMS_SQL

Line 185: c := dbms_sql.open_cursor; --bug8652516: Added X_Org_id

181: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
182: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
183: END IF;
184:
185: c := dbms_sql.open_cursor; --bug8652516: Added X_Org_id
186: statement := 'BEGIN
187: JL_BR_INTEREST_HANDLING.JL_BR_INTEREST(' ||
188: 'X_Interest_Type=>:interest_type, ' ||
189: 'X_Interest_Rate_Amount=>:interest_rate_amount, ' ||

Line 206: dbms_sql.parse(c, statement, dbms_sql.native);

202: 'X_Days_Late=>:days_late, ' ||
203: 'X_Exit_Code=>:exit_code, ' ||
204: 'X_Org_id=>:org_id ); END; ';
205:
206: dbms_sql.parse(c, statement, dbms_sql.native);
207:
208: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
209: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
210: );

Line 208: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );

204: 'X_Org_id=>:org_id ); END; ';
205:
206: dbms_sql.parse(c, statement, dbms_sql.native);
207:
208: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
209: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
210: );
211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );

Line 209: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount

205:
206: dbms_sql.parse(c, statement, dbms_sql.native);
207:
208: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
209: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
210: );
211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );

Line 211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );

207:
208: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
209: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
210: );
211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );

Line 212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );

208: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
209: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
210: );
211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );

Line 213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );

209: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
210: );
211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );

Line 214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );

210: );
211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );

Line 215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );

211: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );

Line 216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );

212: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );

Line 217: dbms_sql.bind_variable( c, 'check_date', p_check_date );

213: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );

Line 218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );

214: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);

Line 219: dbms_sql.bind_variable( c, 'calendar', l_calendar );

215: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);

Line 220: dbms_sql.bind_variable( c, 'city', l_city );

216: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);

Line 221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );

217: dbms_sql.bind_variable( c, 'check_date', p_check_date );
218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
225: dbms_sql.bind_variable( c, 'org_id', l_org_id );

Line 222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);

218: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
225: dbms_sql.bind_variable( c, 'org_id', l_org_id );
226:

Line 223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);

219: dbms_sql.bind_variable( c, 'calendar', l_calendar );
220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
225: dbms_sql.bind_variable( c, 'org_id', l_org_id );
226:
227: rows := dbms_sql.execute(c);

Line 224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);

220: dbms_sql.bind_variable( c, 'city', l_city );
221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
225: dbms_sql.bind_variable( c, 'org_id', l_org_id );
226:
227: rows := dbms_sql.execute(c);
228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );

Line 225: dbms_sql.bind_variable( c, 'org_id', l_org_id );

221: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
222: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
225: dbms_sql.bind_variable( c, 'org_id', l_org_id );
226:
227: rows := dbms_sql.execute(c);
228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
229: dbms_sql.variable_value ( c, 'days_late', l_days_late );

Line 227: rows := dbms_sql.execute(c);

223: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
225: dbms_sql.bind_variable( c, 'org_id', l_org_id );
226:
227: rows := dbms_sql.execute(c);
228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
229: dbms_sql.variable_value ( c, 'days_late', l_days_late );
230: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
231:

Line 228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );

224: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
225: dbms_sql.bind_variable( c, 'org_id', l_org_id );
226:
227: rows := dbms_sql.execute(c);
228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
229: dbms_sql.variable_value ( c, 'days_late', l_days_late );
230: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
231:
232: dbms_sql.close_cursor(c);

Line 229: dbms_sql.variable_value ( c, 'days_late', l_days_late );

225: dbms_sql.bind_variable( c, 'org_id', l_org_id );
226:
227: rows := dbms_sql.execute(c);
228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
229: dbms_sql.variable_value ( c, 'days_late', l_days_late );
230: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
231:
232: dbms_sql.close_cursor(c);
233:

Line 230: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );

226:
227: rows := dbms_sql.execute(c);
228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
229: dbms_sql.variable_value ( c, 'days_late', l_days_late );
230: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
231:
232: dbms_sql.close_cursor(c);
233:
234: EXCEPTION

Line 232: dbms_sql.close_cursor(c);

228: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
229: dbms_sql.variable_value ( c, 'days_late', l_days_late );
230: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
231:
232: dbms_sql.close_cursor(c);
233:
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN P_INTEREST_AMOUNT := NULL;
236: debug_info := 'sqlcode: '|| sqlcode||' sqlerrm: '||sqlerrm;