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

Line 351: dbms_sql.bind_variable(c, 'b_gldate_from', parm.p_gldate_from);

347: fa_rx_util_pkg.debug('jgrx_wt.wht_bind()+');
348:
349: If parm.p_gldate_from IS NOT NULL then
350: fa_rx_util_pkg.debug('Binding b_gldate_from');
351: dbms_sql.bind_variable(c, 'b_gldate_from', parm.p_gldate_from);
352: End If;
353:
354: If parm.p_gldate_to IS NOT NULL then
355: fa_rx_util_pkg.debug('Binding b_gldate_to');

Line 356: dbms_sql.bind_variable(c, 'b_gldate_to', parm.p_gldate_to);

352: End If;
353:
354: If parm.p_gldate_to IS NOT NULL then
355: fa_rx_util_pkg.debug('Binding b_gldate_to');
356: dbms_sql.bind_variable(c, 'b_gldate_to', parm.p_gldate_to);
357: End If;
358:
359: If parm.p_supplier_from IS NOT NULL then
360: fa_rx_util_pkg.debug('Binding b_supplier_from');

Line 361: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);

357: End If;
358:
359: If parm.p_supplier_from IS NOT NULL then
360: fa_rx_util_pkg.debug('Binding b_supplier_from');
361: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);
362: End If;
363:
364: If parm.p_supplier_to IS NOT NULL then
365: fa_rx_util_pkg.debug('Binding b_supplier_to');

Line 366: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);

362: End If;
363:
364: If parm.p_supplier_to IS NOT NULL then
365: fa_rx_util_pkg.debug('Binding b_supplier_to');
366: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);
367: End If;
368:
369: If parm.p_supp_tax_reg_num IS NOT NULL then
370: fa_rx_util_pkg.debug('Binding b_supp_tax_reg_num');

Line 371: dbms_sql.bind_variable(c, 'b_supp_tax_reg_num', parm.p_supp_tax_reg_num);

367: End If;
368:
369: If parm.p_supp_tax_reg_num IS NOT NULL then
370: fa_rx_util_pkg.debug('Binding b_supp_tax_reg_num');
371: dbms_sql.bind_variable(c, 'b_supp_tax_reg_num', parm.p_supp_tax_reg_num);
372: End If;
373:
374: If parm.p_invoice_number IS NOT NULL then
375: fa_rx_util_pkg.debug('Binding b_invoice_number');

Line 376: dbms_sql.bind_variable(c, 'b_invoice_number', parm.p_invoice_number);

372: End If;
373:
374: If parm.p_invoice_number IS NOT NULL then
375: fa_rx_util_pkg.debug('Binding b_invoice_number');
376: dbms_sql.bind_variable(c, 'b_invoice_number', parm.p_invoice_number);
377: End If;
378:
379: /* Commented out NOCOPY for Bug 1339331
380:

Line 383: dbms_sql.bind_variable(c, 'b_acct_flexfield_from',parm.p_acct_flexfield_from);

379: /* Commented out NOCOPY for Bug 1339331
380:
381: If parm.p_acct_flexfield_from IS NOT NULL then
382: fa_rx_util_pkg.debug('Binding b_acct_flexfield_from');
383: dbms_sql.bind_variable(c, 'b_acct_flexfield_from',parm.p_acct_flexfield_from);
384: End If;
385:
386: If parm.p_acct_flexfield_to IS NOT NULL then
387: fa_rx_util_pkg.debug('Binding b_acct_flexfield_to');

Line 388: dbms_sql.bind_variable(c, 'b_acct_flexfield_to', parm.p_acct_flexfield_to);

384: End If;
385:
386: If parm.p_acct_flexfield_to IS NOT NULL then
387: fa_rx_util_pkg.debug('Binding b_acct_flexfield_to');
388: dbms_sql.bind_variable(c, 'b_acct_flexfield_to', parm.p_acct_flexfield_to);
389: End If;
390: End Comment for Bug 1339331 */
391:
392: If parm.p_org_type IS NOT NULL then

Line 394: dbms_sql.bind_variable(c, 'b_org_type', parm.p_org_type);

390: End Comment for Bug 1339331 */
391:
392: If parm.p_org_type IS NOT NULL then
393: fa_rx_util_pkg.debug('Binding b_org_type');
394: dbms_sql.bind_variable(c, 'b_org_type', parm.p_org_type);
395: End If;
396:
397: If parm.p_location IS NOT NULL then
398: fa_rx_util_pkg.debug('Binding b_location');

Line 399: dbms_sql.bind_variable(c, 'b_location', parm.p_location);

395: End If;
396:
397: If parm.p_location IS NOT NULL then
398: fa_rx_util_pkg.debug('Binding b_location');
399: dbms_sql.bind_variable(c, 'b_location', parm.p_location);
400: End If;
401:
402: If parm.p_res_inc_categ IS NOT NULL then
403: fa_rx_util_pkg.debug('Binding b_res_inc_categ');

Line 404: dbms_sql.bind_variable(c, 'b_res_inc_categ', parm.p_res_inc_categ);

400: End If;
401:
402: If parm.p_res_inc_categ IS NOT NULL then
403: fa_rx_util_pkg.debug('Binding b_res_inc_categ');
404: dbms_sql.bind_variable(c, 'b_res_inc_categ', parm.p_res_inc_categ);
405: End If;
406:
407: If parm.p_for_inc_categ IS NOT NULL then
408: fa_rx_util_pkg.debug('Binding b_for_inc_categ');

Line 409: dbms_sql.bind_variable(c, 'b_for_inc_categ', parm.p_for_inc_categ);

405: End If;
406:
407: If parm.p_for_inc_categ IS NOT NULL then
408: fa_rx_util_pkg.debug('Binding b_for_inc_categ');
409: dbms_sql.bind_variable(c, 'b_for_inc_categ', parm.p_for_inc_categ);
410: End If;
411:
412: If parm.p_legal_entity_id IS NOT NULL then
413: fa_rx_util_pkg.debug('Binding b_legal_entity_id');

Line 414: dbms_sql.bind_variable(c, 'b_legal_entity_id', parm.p_legal_entity_id);

410: End If;
411:
412: If parm.p_legal_entity_id IS NOT NULL then
413: fa_rx_util_pkg.debug('Binding b_legal_entity_id');
414: dbms_sql.bind_variable(c, 'b_legal_entity_id', parm.p_legal_entity_id);
415: End If;
416:
417:
418: fa_rx_util_pkg.debug('jgrx_wt.wht_bind()-');