APPS.APRX_WT dependencies on DBMS_SQL

Line 504: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);

500: fa_rx_util_pkg.debug('aprx_wt.awt_bind()+');
501:
502: IF parm.p_date_from is not null then
503: fa_rx_util_pkg.debug('Binding b_date_from');
504: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);
505: END IF;
506:
507: IF parm.p_date_to is not null then
508: fa_rx_util_pkg.debug('Binding b_date_to');

Line 509: dbms_sql.bind_variable(c, 'b_date_to', parm.p_date_to);

505: END IF;
506:
507: IF parm.p_date_to is not null then
508: fa_rx_util_pkg.debug('Binding b_date_to');
509: dbms_sql.bind_variable(c, 'b_date_to', parm.p_date_to);
510: END IF;
511:
512: IF parm.p_supplier_from is not null then
513: fa_rx_util_pkg.debug('Binding b_supplier_from');

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

510: END IF;
511:
512: IF parm.p_supplier_from is not null then
513: fa_rx_util_pkg.debug('Binding b_supplier_from');
514: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);
515: END IF;
516:
517: IF parm.p_supplier_to is not null then
518: fa_rx_util_pkg.debug('Binding b_supplier_to');

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

515: END IF;
516:
517: IF parm.p_supplier_to is not null then
518: fa_rx_util_pkg.debug('Binding b_supplier_to');
519: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);
520: END IF;
521:
522: IF parm.p_supplier_type is not null then
523: fa_rx_util_pkg.debug('Binding b_supplier_type_from');

Line 524: dbms_sql.bind_variable(c, 'b_supplier_type', parm.p_supplier_type);

520: END IF;
521:
522: IF parm.p_supplier_type is not null then
523: fa_rx_util_pkg.debug('Binding b_supplier_type_from');
524: dbms_sql.bind_variable(c, 'b_supplier_type', parm.p_supplier_type);
525: END IF;
526:
527: IF parm.p_system_acct_method is not null then
528: fa_rx_util_pkg.debug('Binding b_system_acct_method');

Line 529: dbms_sql.bind_variable(c, 'b_system_acct_method', parm.p_system_acct_method);

525: END IF;
526:
527: IF parm.p_system_acct_method is not null then
528: fa_rx_util_pkg.debug('Binding b_system_acct_method');
529: dbms_sql.bind_variable(c, 'b_system_acct_method', parm.p_system_acct_method);
530: END IF;
531:
532: fa_rx_util_pkg.debug('aprx_wt.awt_bind()-');
533: