2356: DESCRIPTION
2357: Creates a new customize restriction type.
2358: NOTES
2359: This function returns the customized_restriction_id of the row it has
2360: created and inserted into pay_customized_restrictions.
2361: */
2362: --
2363: FUNCTION insert_customize_restriction
2364: ( p_business_group_id number default NULL,
2393: --
2394: begin
2395: select 'Y'
2396: into v_name_already_exists
2397: from pay_customized_restrictions pcr
2398: where pcr.form_name = p_form_name;
2399: exception
2400: when NO_DATA_FOUND then NULL;
2401: end;
2430: if g_debug then
2431: hr_utility.set_location('insert_customize_restriction',5);
2432: end if;
2433: --
2434: -- Create a row in pay_customized_restrictions and pay_custom_restrictions_tl
2435: --
2436:
2437: PER_CUSTOMIZED_RESTR_PKG.INSERT_ROW (
2438: X_ROWID => v_rowid,