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_STAGED_DUNNING dependencies on FND_DATE

Line 101: ',fnd_date.canonical_to_date(:b_dun_date) - ps.due_date ' ||

97: sql_statement :=
98: 'SELECT ps.payment_schedule_id' ||
99: ',ps.invoice_currency_code' ||
100: ',ps.amount_due_remaining' ||
101: ',fnd_date.canonical_to_date(:b_dun_date) - ps.due_date ' ||
102: ',ps.staged_dunning_level' ||
103: ',ps.dunning_level_override_date' ||
104: ' FROM ar_payment_schedules ps';
105:

Line 161: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||

157: END IF;
158: /* End of bug fix for 2107939.*/
159: if site.grace_days = 'Y' then
160: sql_statement := sql_statement ||
161: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||
162: ' to_number(:b_payment_grace_days) ' ||
163: ' <= fnd_date.canonical_to_date(:b_dun_date)';
164: sql_statement_s := sql_statement_s ||
165: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||

Line 163: ' <= fnd_date.canonical_to_date(:b_dun_date)';

159: if site.grace_days = 'Y' then
160: sql_statement := sql_statement ||
161: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||
162: ' to_number(:b_payment_grace_days) ' ||
163: ' <= fnd_date.canonical_to_date(:b_dun_date)';
164: sql_statement_s := sql_statement_s ||
165: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||
166: ' to_number(:b_payment_grace_days) ' ||
167: ' <= fnd_date.canonical_to_date(:b_dun_date)';

Line 165: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||

161: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||
162: ' to_number(:b_payment_grace_days) ' ||
163: ' <= fnd_date.canonical_to_date(:b_dun_date)';
164: sql_statement_s := sql_statement_s ||
165: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||
166: ' to_number(:b_payment_grace_days) ' ||
167: ' <= fnd_date.canonical_to_date(:b_dun_date)';
168:
169: else

Line 167: ' <= fnd_date.canonical_to_date(:b_dun_date)';

163: ' <= fnd_date.canonical_to_date(:b_dun_date)';
164: sql_statement_s := sql_statement_s ||
165: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))+'||
166: ' to_number(:b_payment_grace_days) ' ||
167: ' <= fnd_date.canonical_to_date(:b_dun_date)';
168:
169: else
170: sql_statement := sql_statement ||
171: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||

Line 171: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||

167: ' <= fnd_date.canonical_to_date(:b_dun_date)';
168:
169: else
170: sql_statement := sql_statement ||
171: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
172: ' <= fnd_date.canonical_to_date(:b_dun_date)';
173: sql_statement_s := sql_statement_s ||
174: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
175: ' <= fnd_date.canonical_to_date(:b_dun_date)';

Line 172: ' <= fnd_date.canonical_to_date(:b_dun_date)';

168:
169: else
170: sql_statement := sql_statement ||
171: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
172: ' <= fnd_date.canonical_to_date(:b_dun_date)';
173: sql_statement_s := sql_statement_s ||
174: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
175: ' <= fnd_date.canonical_to_date(:b_dun_date)';
176:

Line 174: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||

170: sql_statement := sql_statement ||
171: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
172: ' <= fnd_date.canonical_to_date(:b_dun_date)';
173: sql_statement_s := sql_statement_s ||
174: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
175: ' <= fnd_date.canonical_to_date(:b_dun_date)';
176:
177: end if;
178:

Line 175: ' <= fnd_date.canonical_to_date(:b_dun_date)';

171: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
172: ' <= fnd_date.canonical_to_date(:b_dun_date)';
173: sql_statement_s := sql_statement_s ||
174: ' AND nvl(ps.trx_date,fnd_date.canonical_to_date(:b_dun_date))'||
175: ' <= fnd_date.canonical_to_date(:b_dun_date)';
176:
177: end if;
178:
179: if parameter.transaction_type_from is not null

Line 300: current_dun_date := fnd_date.canonical_to_date(parameter.dun_date);

296: sum_adr := 0;
297: dun_ok := FALSE;
298: ignore := dbms_sql.execute(ps_cursor);
299: prev_currency := '0';
300: current_dun_date := fnd_date.canonical_to_date(parameter.dun_date);
301:
302: <>
303: LOOP
304: if dbms_sql.fetch_rows(ps_cursor) <= 0 then