APPS.APRX_PY dependencies on DBMS_SQL

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

297: -- These bind variables were included in the WHERE clause.
298: --
299: if param.payment_date_start is not null then
300: fa_rx_util_pkg.debug('Binding b_payment_date_start.');
301: dbms_sql.bind_variable(c, 'b_payment_date_start', param.payment_date_start);
302: end if;
303: if param.payment_date_end is not null and param.payment_date_end <> param.payment_date_start then
304: fa_rx_util_pkg.debug('Binding b_payment_date_end.');
305: dbms_sql.bind_variable(c, 'b_payment_date_end', param.payment_date_end);

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

301: dbms_sql.bind_variable(c, 'b_payment_date_start', param.payment_date_start);
302: end if;
303: if param.payment_date_end is not null and param.payment_date_end <> param.payment_date_start then
304: fa_rx_util_pkg.debug('Binding b_payment_date_end.');
305: dbms_sql.bind_variable(c, 'b_payment_date_end', param.payment_date_end);
306: end if;
307:
308: if param.payment_currency_code is not null then
309: fa_rx_util_pkg.debug('Binding b_payment_currency_code.');

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

306: end if;
307:
308: if param.payment_currency_code is not null then
309: fa_rx_util_pkg.debug('Binding b_payment_currency_code.');
310: dbms_sql.bind_variable(c, 'b_payment_currency_code', param.payment_currency_code);
311: end if;
312:
313: if param.payment_bank_account_name is not null then
314: fa_rx_util_pkg.debug('Binding b_payment_bank_account_name.');

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

311: end if;
312:
313: if param.payment_bank_account_name is not null then
314: fa_rx_util_pkg.debug('Binding b_payment_bank_account_name.');
315: dbms_sql.bind_variable(c, 'b_payment_bank_account_name', param.payment_bank_account_name);
316: end if;
317:
318: if param.payment_method is not null then
319: fa_rx_util_pkg.debug('Binding b_payment_method');

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

316: end if;
317:
318: if param.payment_method is not null then
319: fa_rx_util_pkg.debug('Binding b_payment_method');
320: dbms_sql.bind_variable(c, 'b_payment_method', param.payment_method);
321: end if;
322:
323: if param.payment_type_flag is not null then
324: fa_rx_util_pkg.debug('Binding b_payment_type_flag.');

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

321: end if;
322:
323: if param.payment_type_flag is not null then
324: fa_rx_util_pkg.debug('Binding b_payment_type_flag.');
325: dbms_sql.bind_variable(c, 'b_payment_type_flag', param.payment_type_flag);
326: end if;
327:
328:
329: --

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

333: where lookup_type='YES_NO' and lookup_code='Y';
334: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
335: where lookup_type='YES_NO' and lookup_code='N';
336: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');
337: dbms_sql.bind_variable(c, 'b_nls_yes', l_nls_yes);
338: dbms_sql.bind_variable(c, 'b_nls_no', l_nls_no);
339:
340: fa_rx_util_pkg.debug('aprx_py.register_bind()-');
341: end register_bind;

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

334: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
335: where lookup_type='YES_NO' and lookup_code='N';
336: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');
337: dbms_sql.bind_variable(c, 'b_nls_yes', l_nls_yes);
338: dbms_sql.bind_variable(c, 'b_nls_no', l_nls_no);
339:
340: fa_rx_util_pkg.debug('aprx_py.register_bind()-');
341: end register_bind;
342: