[Home] [Help]
233: -- Only need to open the cursor if category_name is not null
234: --
235: if p_category_name is not null then
236: --
237: l_mode := hr_startup_data_api_support.return_startup_mode;
238: --
239: OPEN csr_category_name;
240: FETCH csr_category_name INTO l_category_name
241: ,l_leg_code
366: -- Only need to open the cursor if user_category_name is not null
367: --
368: if p_user_category_name is not null then
369: --
370: l_mode := hr_startup_data_api_support.return_startup_mode;
371: --
372: OPEN csr_user_category_name;
373: FETCH csr_user_category_name INTO l_user_category_name
374: ,l_leg_code
1071: -- Call the supporting procedure to check startup mode
1072: -- NOTE: USER rows are not permitted in PAY_BALANCE_CATEGORIES_F
1073: --
1074: IF (p_insert) THEN
1075: hr_startup_data_api_support.chk_startup_action
1076: (p_generic_allowed => TRUE
1077: ,p_startup_allowed => TRUE
1078: ,p_user_allowed => FALSE
1079: ,p_business_group_id => p_business_group_id
1080: ,p_legislation_code => p_legislation_code
1081: ,p_legislation_subgroup => p_legislation_subgroup
1082: );
1083: ELSE
1084: hr_startup_data_api_support.chk_upd_del_startup_action
1085: (p_generic_allowed => TRUE
1086: ,p_startup_allowed => TRUE
1087: ,p_user_allowed => FALSE
1088: ,p_business_group_id => p_business_group_id
1115: chk_startup_action(true
1116: ,p_rec.business_group_id
1117: ,p_rec.legislation_code
1118: );
1119: IF hr_startup_data_api_support.g_startup_mode
1120: NOT IN ('GENERIC','STARTUP') THEN
1121: --
1122: -- Validate Important Attributes
1123: --
1184: chk_startup_action(false
1185: ,p_rec.business_group_id
1186: ,p_rec.legislation_code
1187: );
1188: IF hr_startup_data_api_support.g_startup_mode
1189: NOT IN ('GENERIC','STARTUP') THEN
1190: --
1191: --
1192: -- Validate Important Attributes