[Home] [Help]
2241: -- depending on p_parent_call value.
2242: --
2243: -- Developer/Implementation Notes:
2244: -- Duplicate validation exists on form, so any changes made here
2245: -- or on form must be dual-maintained.
2246: --
2247: -- Access Status:
2248: -- From Business Processes
2249: --
2278: --
2279: BEGIN
2280: SELECT 'Y'
2281: INTO l_exists
2282: FROM sys.dual
2283: WHERE EXISTS
2284: (SELECT null
2285: FROM hr_org_info_types_by_class class,
2286: hr_org_information_types type
2474: -- then an application error will be raised and processing is terminated.
2475: --
2476: -- Developer/Implementation Notes:
2477: -- Duplicate validation exists on form, so any changes made here
2478: -- or on form must be dual-maintained.
2479: --
2480: -- Access Status:
2481: -- From Business Processes
2482: --
5097: -- error will be raised and processing is terminated.
5098: --
5099: -- Developer/Implementation Notes:
5100: -- Duplicate validation exists on form, so any changes made here
5101: -- or on form must be dual-maintained.
5102: --
5103: -- Access Status:
5104: -- Internal Row Table Handler Use Only.
5105: --
5120: --
5121: BEGIN
5122: SELECT 'Y'
5123: INTO l_exists
5124: FROM sys.dual
5125: WHERE EXISTS
5126: (SELECT null
5127: FROM PER_BUSINESS_GROUPS
5128: WHERE business_group_id = p_bgr_id);
5274: -- error will be raised and processing is terminated.
5275: --
5276: -- Developer/Implementation Notes:
5277: -- Duplicate validation exists on form, so any changes made here
5278: -- or on form must be dual-maintained.
5279: --
5280: -- Access Status:
5281: -- Internal Row Table Handler Use Only.
5282: --
5297: --
5298: BEGIN
5299: SELECT 'Y'
5300: INTO l_exists
5301: FROM sys.dual
5302: WHERE EXISTS
5303: (SELECT null
5304: FROM hr_all_organization_units
5305: WHERE organization_id = p_organization_id);