APPS.PAY_CALENDARS_PKG dependencies on PQH_BUDGETS

Line 47: CURSOR c_pqh_budgets IS

43: FROM per_budgets pb
44: WHERE pb.period_set_name = X_Period_Set_Name
45: AND pb.budget_type_code = 'OTA_BUDGET';
46: --
47: CURSOR c_pqh_budgets IS
48: SELECT NULL
49: FROM pqh_budgets pb
50: WHERE pb.period_set_name = X_Period_Set_Name;
51: --

Line 49: FROM pqh_budgets pb

45: AND pb.budget_type_code = 'OTA_BUDGET';
46: --
47: CURSOR c_pqh_budgets IS
48: SELECT NULL
49: FROM pqh_budgets pb
50: WHERE pb.period_set_name = X_Period_Set_Name;
51: --
52: l_result VARCHAR2(255);
53: l_proc VARCHAR2(72) := g_package||'chk_budget_exists';

Line 69: OPEN c_pqh_budgets;

65: hr_utility.raise_error;
66: END IF;
67: CLOSE c_budgets;
68: --
69: OPEN c_pqh_budgets;
70: FETCH c_pqh_budgets INTO l_result;
71: IF c_pqh_budgets%FOUND THEN
72: CLOSE c_pqh_budgets;
73: hr_utility.set_location(' pqh budget exists'||l_proc, 20);

Line 70: FETCH c_pqh_budgets INTO l_result;

66: END IF;
67: CLOSE c_budgets;
68: --
69: OPEN c_pqh_budgets;
70: FETCH c_pqh_budgets INTO l_result;
71: IF c_pqh_budgets%FOUND THEN
72: CLOSE c_pqh_budgets;
73: hr_utility.set_location(' pqh budget exists'||l_proc, 20);
74: hr_utility.set_message(800,'PQH_52887_BUD_CAL_DELETE_FAIL');

Line 71: IF c_pqh_budgets%FOUND THEN

67: CLOSE c_budgets;
68: --
69: OPEN c_pqh_budgets;
70: FETCH c_pqh_budgets INTO l_result;
71: IF c_pqh_budgets%FOUND THEN
72: CLOSE c_pqh_budgets;
73: hr_utility.set_location(' pqh budget exists'||l_proc, 20);
74: hr_utility.set_message(800,'PQH_52887_BUD_CAL_DELETE_FAIL');
75: hr_utility.raise_error;

Line 72: CLOSE c_pqh_budgets;

68: --
69: OPEN c_pqh_budgets;
70: FETCH c_pqh_budgets INTO l_result;
71: IF c_pqh_budgets%FOUND THEN
72: CLOSE c_pqh_budgets;
73: hr_utility.set_location(' pqh budget exists'||l_proc, 20);
74: hr_utility.set_message(800,'PQH_52887_BUD_CAL_DELETE_FAIL');
75: hr_utility.raise_error;
76: END IF;

Line 77: CLOSE c_pqh_budgets;

73: hr_utility.set_location(' pqh budget exists'||l_proc, 20);
74: hr_utility.set_message(800,'PQH_52887_BUD_CAL_DELETE_FAIL');
75: hr_utility.raise_error;
76: END IF;
77: CLOSE c_pqh_budgets;
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 50);
80: --
81: END chk_budget_exists;