[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: --
5043: -- error will be raised and processing is terminated.
5044: --
5045: -- Developer/Implementation Notes:
5046: -- Duplicate validation exists on form, so any changes made here
5047: -- or on form must be dual-maintained.
5048: --
5049: -- Access Status:
5050: -- Internal Row Table Handler Use Only.
5051: --
5066: --
5067: BEGIN
5068: SELECT 'Y'
5069: INTO l_exists
5070: FROM sys.dual
5071: WHERE EXISTS
5072: (SELECT null
5073: FROM PER_BUSINESS_GROUPS
5074: WHERE business_group_id = p_bgr_id);
5220: -- error will be raised and processing is terminated.
5221: --
5222: -- Developer/Implementation Notes:
5223: -- Duplicate validation exists on form, so any changes made here
5224: -- or on form must be dual-maintained.
5225: --
5226: -- Access Status:
5227: -- Internal Row Table Handler Use Only.
5228: --
5243: --
5244: BEGIN
5245: SELECT 'Y'
5246: INTO l_exists
5247: FROM sys.dual
5248: WHERE EXISTS
5249: (SELECT null
5250: FROM hr_all_organization_units
5251: WHERE organization_id = p_organization_id);