DBA Data[Home] [Help]

APPS.APRX_WT dependencies on DBMS_SQL

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

403: fa_rx_util_pkg.debug('aprx_wt.awt_bind()+');
404:
405: IF parm.p_date_from is not null then
406: fa_rx_util_pkg.debug('Binding b_date_from');
407: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);
408: END IF;
409:
410: IF parm.p_date_to is not null then
411: fa_rx_util_pkg.debug('Binding b_date_to');

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

408: END IF;
409:
410: IF parm.p_date_to is not null then
411: fa_rx_util_pkg.debug('Binding b_date_to');
412: dbms_sql.bind_variable(c, 'b_date_to', parm.p_date_to);
413: END IF;
414:
415: IF parm.p_supplier_from is not null then
416: fa_rx_util_pkg.debug('Binding b_supplier_from');

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

413: END IF;
414:
415: IF parm.p_supplier_from is not null then
416: fa_rx_util_pkg.debug('Binding b_supplier_from');
417: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);
418: END IF;
419:
420: IF parm.p_supplier_to is not null then
421: fa_rx_util_pkg.debug('Binding b_supplier_to');

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

418: END IF;
419:
420: IF parm.p_supplier_to is not null then
421: fa_rx_util_pkg.debug('Binding b_supplier_to');
422: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);
423: END IF;
424:
425: IF parm.p_supplier_type is not null then
426: fa_rx_util_pkg.debug('Binding b_supplier_type_from');

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

423: END IF;
424:
425: IF parm.p_supplier_type is not null then
426: fa_rx_util_pkg.debug('Binding b_supplier_type_from');
427: dbms_sql.bind_variable(c, 'b_supplier_type', parm.p_supplier_type);
428: END IF;
429:
430: IF parm.p_system_acct_method is not null then
431: fa_rx_util_pkg.debug('Binding b_system_acct_method');

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

428: END IF;
429:
430: IF parm.p_system_acct_method is not null then
431: fa_rx_util_pkg.debug('Binding b_system_acct_method');
432: dbms_sql.bind_variable(c, 'b_system_acct_method', parm.p_system_acct_method);
433: END IF;
434:
435: fa_rx_util_pkg.debug('aprx_wt.awt_bind()-');
436: