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

Line 367: dbms_sql.bind_variable(c, 'b_payment_date_start', param.payment_date_start);

363: -- These bind variables were included in the WHERE clause.
364: --
365: if param.payment_date_start is not null then
366: fa_rx_util_pkg.debug('Binding b_payment_date_start.');
367: dbms_sql.bind_variable(c, 'b_payment_date_start', param.payment_date_start);
368: end if;
369: if param.payment_date_end is not null and param.payment_date_end <> param.payment_date_start then
370: fa_rx_util_pkg.debug('Binding b_payment_date_end.');
371: dbms_sql.bind_variable(c, 'b_payment_date_end', param.payment_date_end);

Line 371: dbms_sql.bind_variable(c, 'b_payment_date_end', param.payment_date_end);

367: dbms_sql.bind_variable(c, 'b_payment_date_start', param.payment_date_start);
368: end if;
369: if param.payment_date_end is not null and param.payment_date_end <> param.payment_date_start then
370: fa_rx_util_pkg.debug('Binding b_payment_date_end.');
371: dbms_sql.bind_variable(c, 'b_payment_date_end', param.payment_date_end);
372: end if;
373:
374: if param.payment_currency_code is not null then
375: fa_rx_util_pkg.debug('Binding b_payment_currency_code.');

Line 376: dbms_sql.bind_variable(c, 'b_payment_currency_code', param.payment_currency_code);

372: end if;
373:
374: if param.payment_currency_code is not null then
375: fa_rx_util_pkg.debug('Binding b_payment_currency_code.');
376: dbms_sql.bind_variable(c, 'b_payment_currency_code', param.payment_currency_code);
377: end if;
378:
379: if param.payment_bank_account_name is not null then
380: fa_rx_util_pkg.debug('Binding b_payment_bank_account_name.');

Line 381: dbms_sql.bind_variable(c, 'b_payment_bank_account_name', param.payment_bank_account_name);

377: end if;
378:
379: if param.payment_bank_account_name is not null then
380: fa_rx_util_pkg.debug('Binding b_payment_bank_account_name.');
381: dbms_sql.bind_variable(c, 'b_payment_bank_account_name', param.payment_bank_account_name);
382: end if;
383:
384: if param.payment_method is not null then
385: fa_rx_util_pkg.debug('Binding b_payment_method');

Line 386: dbms_sql.bind_variable(c, 'b_payment_method', param.payment_method);

382: end if;
383:
384: if param.payment_method is not null then
385: fa_rx_util_pkg.debug('Binding b_payment_method');
386: dbms_sql.bind_variable(c, 'b_payment_method', param.payment_method);
387: end if;
388:
389: if param.payment_type_flag is not null then
390: fa_rx_util_pkg.debug('Binding b_payment_type_flag.');

Line 391: dbms_sql.bind_variable(c, 'b_payment_type_flag', param.payment_type_flag);

387: end if;
388:
389: if param.payment_type_flag is not null then
390: fa_rx_util_pkg.debug('Binding b_payment_type_flag.');
391: dbms_sql.bind_variable(c, 'b_payment_type_flag', param.payment_type_flag);
392: end if;
393:
394: /* Start of bug8760710 */
395: /* bug13941628 Also ensure ledger_id is not -9999*/

Line 398: dbms_sql.bind_variable(c, 'b_ledger_id', param.ledger_id);

394: /* Start of bug8760710 */
395: /* bug13941628 Also ensure ledger_id is not -9999*/
396: if (nvl(param.ledger_id,-9999) <> -9999) then
397: fa_rx_util_pkg.debug('Binding b_ledger_id');
398: dbms_sql.bind_variable(c, 'b_ledger_id', param.ledger_id);
399: end if;
400: /* bug13941628 */
401: /* End of bug8760710 */
402:

Line 406: dbms_sql.bind_variable(c, 'b_org_id', param.org_id);

402:
403: /* bug13941628 If report is run by OU context*/
404: if (nvl(param.org_id,-9999) <> -9999) then
405: fa_rx_util_pkg.debug('Binding b_org_id');
406: dbms_sql.bind_variable(c, 'b_org_id', param.org_id);
407: end if;
408: /* bug13941628 */
409:
410: --

Line 418: dbms_sql.bind_variable(c, 'b_nls_yes', l_nls_yes);

414: where lookup_type='YES_NO' and lookup_code='Y';
415: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
416: where lookup_type='YES_NO' and lookup_code='N';
417: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');
418: dbms_sql.bind_variable(c, 'b_nls_yes', l_nls_yes);
419: dbms_sql.bind_variable(c, 'b_nls_no', l_nls_no);
420:
421: fa_rx_util_pkg.debug('aprx_py.register_bind()-');
422: end register_bind;

Line 419: dbms_sql.bind_variable(c, 'b_nls_no', l_nls_no);

415: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
416: where lookup_type='YES_NO' and lookup_code='N';
417: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');
418: dbms_sql.bind_variable(c, 'b_nls_yes', l_nls_yes);
419: dbms_sql.bind_variable(c, 'b_nls_no', l_nls_no);
420:
421: fa_rx_util_pkg.debug('aprx_py.register_bind()-');
422: end register_bind;
423: