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 144: c := dbms_sql.open_cursor;

140: from user_objects
141: where object_name = 'JL_BR_INTEREST_HANDLING'
142: and object_type = 'PACKAGE BODY';
143:
144: c := dbms_sql.open_cursor;
145: statement := 'BEGIN
146: JL_BR_INTEREST_HANDLING.JL_BR_INTEREST(' ||
147: 'X_Interest_Type=>:interest_type, ' ||
148: 'X_Interest_Rate_Amount=>:interest_rate_amount, ' ||

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

160: 'X_Interest_Calculated=>:interest_amount, ' ||
161: 'X_Days_Late=>:days_late, ' ||
162: 'X_Exit_Code=>:exit_code ); END; ';
163:
164: dbms_sql.parse(c, statement, dbms_sql.native);
165:
166: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
167: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
168: );

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

162: 'X_Exit_Code=>:exit_code ); END; ';
163:
164: dbms_sql.parse(c, statement, dbms_sql.native);
165:
166: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
167: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
168: );
169: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );

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

163:
164: dbms_sql.parse(c, statement, dbms_sql.native);
165:
166: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
167: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
168: );
169: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );

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

165:
166: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
167: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
168: );
169: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );

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

166: dbms_sql.bind_variable( c, 'interest_type', l_interest_type );
167: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
168: );
169: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );

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

167: dbms_sql.bind_variable( c, 'interest_rate_amount', l_interest_rate_amount
168: );
169: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );

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

168: );
169: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );

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

169: dbms_sql.bind_variable( c, 'interest_period', l_interest_period );
170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );

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

170: dbms_sql.bind_variable( c, 'interest_formula', l_interest_formula );
171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );

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

171: dbms_sql.bind_variable( c, 'interest_grace_days', l_interest_grace_days );
172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );

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

172: dbms_sql.bind_variable( c, 'penalty_type', l_penalty_type );
173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);

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

173: dbms_sql.bind_variable( c, 'penalty_rate_amount', l_penalty_rate_amount );
174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);

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

174: dbms_sql.bind_variable( c, 'invoice_due_date', p_invoice_due_date );
175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);

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

175: dbms_sql.bind_variable( c, 'check_date', p_check_date );
176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
183:

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

176: dbms_sql.bind_variable( c, 'payment_amount', p_payment_amount );
177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
183:
184: rows := dbms_sql.execute(c);

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

177: dbms_sql.bind_variable( c, 'calendar', l_calendar );
178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
183:
184: rows := dbms_sql.execute(c);
185: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );

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

178: dbms_sql.bind_variable( c, 'city', l_city );
179: dbms_sql.bind_variable( c, 'payment_action', l_payment_action );
180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
183:
184: rows := dbms_sql.execute(c);
185: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
186: dbms_sql.variable_value ( c, 'days_late', l_days_late );

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

180: dbms_sql.bind_variable ( c, 'interest_amount', l_interest_amount);
181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
183:
184: rows := dbms_sql.execute(c);
185: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
186: dbms_sql.variable_value ( c, 'days_late', l_days_late );
187: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
188:

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

181: dbms_sql.bind_variable ( c, 'days_late', l_days_late);
182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
183:
184: rows := dbms_sql.execute(c);
185: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
186: dbms_sql.variable_value ( c, 'days_late', l_days_late );
187: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
188:
189: dbms_sql.close_cursor(c);

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

182: dbms_sql.bind_variable ( c, 'exit_code', l_exit_code);
183:
184: rows := dbms_sql.execute(c);
185: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
186: dbms_sql.variable_value ( c, 'days_late', l_days_late );
187: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
188:
189: dbms_sql.close_cursor(c);
190:

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

183:
184: rows := dbms_sql.execute(c);
185: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
186: dbms_sql.variable_value ( c, 'days_late', l_days_late );
187: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
188:
189: dbms_sql.close_cursor(c);
190:
191: EXCEPTION

Line 189: dbms_sql.close_cursor(c);

185: dbms_sql.variable_value ( c, 'interest_amount', p_interest_amount );
186: dbms_sql.variable_value ( c, 'days_late', l_days_late );
187: dbms_sql.variable_value ( c, 'exit_code', l_exit_code );
188:
189: dbms_sql.close_cursor(c);
190:
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN P_INTEREST_AMOUNT := NULL;
193: WHEN OTHERS THEN P_INTEREST_AMOUNT := NULL;