[Home] [Help]
285: p_pay_basis_id number,
286: p_costable_type varchar2,
287: p_link_to_all_payrolls_flag varchar2,
288: p_multiply_value_flag varchar2,
289: p_standard_link_flag varchar2,
290: p_transfer_to_gl_flag varchar2,
291: p_comment_id number,
292: p_employment_category varchar2,
293: p_qualifying_age number,
347: --
348:
349: /* commented the below block for bug no : 6764215
350:
351: if p_standard_link_flag = 'Y' and
352: pay_basis_exists(p_element_type_id, p_business_group_id) then
353:
354: hr_utility.set_message(801,'PAY_33093_LINK_NO_PAY_BASIS');
355: hr_utility.raise_error;
377: pay_basis_id,
378: costable_type,
379: link_to_all_payrolls_flag,
380: multiply_value_flag,
381: standard_link_flag,
382: transfer_to_gl_flag,
383: comment_id,
384: employment_category,
385: qualifying_age,
425: p_pay_basis_id,
426: p_costable_type,
427: p_link_to_all_payrolls_flag,
428: p_multiply_value_flag,
429: p_standard_link_flag,
430: p_transfer_to_gl_flag,
431: p_comment_id,
432: p_employment_category,
433: p_qualifying_age,
493: p_pay_basis_id number,
494: p_costable_type varchar2,
495: p_link_to_all_payrolls_flag varchar2,
496: p_multiply_value_flag varchar2,
497: p_standard_link_flag varchar2,
498: p_transfer_to_gl_flag varchar2,
499: p_comment_id number,
500: p_employment_category varchar2,
501: p_qualifying_age number,
599: and (p_link_to_all_payrolls_flag is null)))
600: and ( (locked_row.multiply_value_flag = p_multiply_value_flag)
601: or ( (locked_row.multiply_value_flag is null)
602: and (p_multiply_value_flag is null)))
603: and ( (locked_row.standard_link_flag = p_standard_link_flag)
604: or ( (locked_row.standard_link_flag is null)
605: and (p_standard_link_flag is null)))
606: and ( (locked_row.transfer_to_gl_flag = p_transfer_to_gl_flag)
607: or ( (locked_row.transfer_to_gl_flag is null)
600: and ( (locked_row.multiply_value_flag = p_multiply_value_flag)
601: or ( (locked_row.multiply_value_flag is null)
602: and (p_multiply_value_flag is null)))
603: and ( (locked_row.standard_link_flag = p_standard_link_flag)
604: or ( (locked_row.standard_link_flag is null)
605: and (p_standard_link_flag is null)))
606: and ( (locked_row.transfer_to_gl_flag = p_transfer_to_gl_flag)
607: or ( (locked_row.transfer_to_gl_flag is null)
608: and (p_transfer_to_gl_flag is null)))
601: or ( (locked_row.multiply_value_flag is null)
602: and (p_multiply_value_flag is null)))
603: and ( (locked_row.standard_link_flag = p_standard_link_flag)
604: or ( (locked_row.standard_link_flag is null)
605: and (p_standard_link_flag is null)))
606: and ( (locked_row.transfer_to_gl_flag = p_transfer_to_gl_flag)
607: or ( (locked_row.transfer_to_gl_flag is null)
608: and (p_transfer_to_gl_flag is null)))
609: and ( (locked_row.comment_id = p_comment_id)
712: p_pay_basis_id number,
713: p_costable_type varchar2,
714: p_link_to_all_payrolls_flag varchar2,
715: p_multiply_value_flag varchar2,
716: p_standard_link_flag varchar2,
717: p_transfer_to_gl_flag varchar2,
718: p_comment_id number,
719: p_employment_category varchar2,
720: p_qualifying_age number,
836: pay_basis_id = p_pay_basis_id,
837: costable_type = p_costable_type,
838: link_to_all_payrolls_flag = p_link_to_all_payrolls_flag,
839: multiply_value_flag = p_multiply_value_flag,
840: standard_link_flag = p_standard_link_flag,
841: transfer_to_gl_flag = p_transfer_to_gl_flag,
842: comment_id = p_comment_id,
843: employment_category = p_employment_category,
844: qualifying_age = p_qualifying_age,