DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PAY_CORE_UTILS

Line 219: pay_core_utils.get_upgrade_status(p_business_group_id,p_short_name,l_status);

215: l_status pay_upgrade_status.status%type;
216: --
217: begin
218: --
219: pay_core_utils.get_upgrade_status(p_business_group_id,p_short_name,l_status);
220: --
221: return l_status;
222: --
223: exception

Line 3139: if pay_core_utils.get_sql_cursor(statem,sql_curs) then

3135: begin
3136: statem := 'BEGIN
3137: :line_check := pay_'||lower(l_legislation_code)||'_bee.line_check_supported; END;';
3138: --
3139: if pay_core_utils.get_sql_cursor(statem,sql_curs) then
3140: --
3141: dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
3142: --
3143: rows_processed := dbms_sql.execute(sql_curs);

Line 3916: if pay_core_utils.get_sql_cursor(statem,sql_curs) then

3912: hr_utility.set_location('payplnk.validate_lines',67);
3913: statem := 'BEGIN
3914: pay_'||lower(l_legislation_code)||'_bee.validate_line(:batch_line_id, :valid, :leg_message, :line_changed); END;';
3915: --
3916: if pay_core_utils.get_sql_cursor(statem,sql_curs) then
3917: --
3918: dbms_sql.bind_variable(sql_curs, 'batch_line_id', g_line_record.batch_line_id);
3919: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
3920: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);