APPS.PSP_GENERAL dependencies on PSP_ADJUSTMENT_LINES_HISTORY

Line 3719: CURSOR c_psp_adjustment_lines_history IS

3715: AND task_id = nvl (p_task_id, task_id)
3716: AND project_id is NOT NULL
3717: AND ROWNUM = 1;
3718:
3719: CURSOR c_psp_adjustment_lines_history IS
3720: SELECT 1
3721: FROM psp_adjustment_lines_history
3722: WHERE project_id = nvl (p_project_id, project_id)
3723: AND task_id = nvl (p_task_id, task_id)

Line 3721: FROM psp_adjustment_lines_history

3717: AND ROWNUM = 1;
3718:
3719: CURSOR c_psp_adjustment_lines_history IS
3720: SELECT 1
3721: FROM psp_adjustment_lines_history
3722: WHERE project_id = nvl (p_project_id, project_id)
3723: AND task_id = nvl (p_task_id, task_id)
3724: AND project_id is NOT NULL
3725: AND ROWNUM = 1;

Line 3749: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';

3745: hr_utility.trace('Leaving:'|| l_proc);
3746: END IF;
3747:
3748: IF l_debug_enabled THEN
3749: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';
3750: hr_utility.trace('Entering:'|| l_proc);
3751: END IF;
3752:
3753: OPEN c_psp_adjustment_lines_history;

Line 3753: OPEN c_psp_adjustment_lines_history;

3749: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';
3750: hr_utility.trace('Entering:'|| l_proc);
3751: END IF;
3752:
3753: OPEN c_psp_adjustment_lines_history;
3754: FETCH c_psp_adjustment_lines_history INTO l_record_count;
3755: CLOSE c_psp_adjustment_lines_history;
3756:
3757: IF l_record_count IS NOT NULL

Line 3754: FETCH c_psp_adjustment_lines_history INTO l_record_count;

3750: hr_utility.trace('Entering:'|| l_proc);
3751: END IF;
3752:
3753: OPEN c_psp_adjustment_lines_history;
3754: FETCH c_psp_adjustment_lines_history INTO l_record_count;
3755: CLOSE c_psp_adjustment_lines_history;
3756:
3757: IF l_record_count IS NOT NULL
3758: THEN

Line 3755: CLOSE c_psp_adjustment_lines_history;

3751: END IF;
3752:
3753: OPEN c_psp_adjustment_lines_history;
3754: FETCH c_psp_adjustment_lines_history INTO l_record_count;
3755: CLOSE c_psp_adjustment_lines_history;
3756:
3757: IF l_record_count IS NOT NULL
3758: THEN
3759: l_return_code := 20;

Line 3764: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';

3760: RETURN l_return_code;
3761: END IF;
3762:
3763: IF l_debug_enabled THEN
3764: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';
3765: hr_utility.trace('Leaving:'|| l_proc);
3766: END IF;
3767: RETURN l_return_code;
3768: EXCEPTION