[Home] [Help]
2237: WHERE budget_group_id = l_budget_group_id
2238: );
2239: l_p5_exists VARCHAR2(1) := FND_API.G_FALSE;
2240: CURSOR c_p6 IS
2241: SELECT 'PSB_BUDGET_WORKFLOW_RULES'
2242: FROM dual
2243: WHERE exists
2244: (SELECT 1
2245: FROM PSB_BUDGET_WORKFLOW_RULES
2241: SELECT 'PSB_BUDGET_WORKFLOW_RULES'
2242: FROM dual
2243: WHERE exists
2244: (SELECT 1
2245: FROM PSB_BUDGET_WORKFLOW_RULES
2246: WHERE budget_group_id = l_budget_group_id
2247: );
2248: l_p6_exists VARCHAR2(1) := FND_API.G_FALSE;
2249: CURSOR c_p7 IS
2451: end loop;
2452:
2453: IF FND_API.to_Boolean(l_p6_exists) THEN
2454: rollback to Delete_Row;
2455: message_token('TABLE','PSB_BUDGET_WORKFLOW_RULES' );
2456: message_token('BUDGET_GROUP', c1rec.short_name);
2457: add_message('PSB', 'PSB_BG_CANNOT_BE_DELETED');
2458: p_delete := 'NO_DELETE';
2459: raise FND_API.G_EXC_ERROR;