DBA Data[Home] [Help]

APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_BUDGET_REVISION_POSITIONS

Line 2223: SELECT 'PSB_BUDGET_REVISION_POSITIONS'

2219: WHERE budget_group_id = l_budget_group_id
2220: );
2221: l_p3_exists VARCHAR2(1) := FND_API.G_FALSE;
2222: CURSOR c_p4 IS
2223: SELECT 'PSB_BUDGET_REVISION_POSITIONS'
2224: FROM dual
2225: WHERE exists
2226: (SELECT 1
2227: FROM PSB_BUDGET_REVISION_POSITIONS

Line 2227: FROM PSB_BUDGET_REVISION_POSITIONS

2223: SELECT 'PSB_BUDGET_REVISION_POSITIONS'
2224: FROM dual
2225: WHERE exists
2226: (SELECT 1
2227: FROM PSB_BUDGET_REVISION_POSITIONS
2228: WHERE budget_group_id = l_budget_group_id
2229: );
2230: l_p4_exists VARCHAR2(1) := FND_API.G_FALSE;
2231: CURSOR c_p5 IS

Line 2429: message_token('TABLE','PSB_BUDGET_REVISION_POSITIONS' );

2425: end loop;
2426:
2427: IF FND_API.to_Boolean(l_p4_exists) THEN
2428: rollback to Delete_Row;
2429: message_token('TABLE','PSB_BUDGET_REVISION_POSITIONS' );
2430: message_token('BUDGET_GROUP', c1rec.short_name);
2431: add_message('PSB', 'PSB_BG_CANNOT_BE_DELETED');
2432: p_delete := 'NO_DELETE';
2433: raise FND_API.G_EXC_ERROR;