eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_GENERAL dependencies on PSP_ADJUSTMENT_LINES

Line 3709: FUNCTION chk_in_psp_adjustment_lines

3705: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlcode is ' || SQLCODE);
3706: RAISE;
3707: END chk_in_psp_pre_gen_dist_lines;
3708:
3709: FUNCTION chk_in_psp_adjustment_lines
3710: RETURN NUMBER IS
3711: CURSOR c_psp_adjustment_lines IS
3712: SELECT 1
3713: FROM psp_adjustment_lines

Line 3711: CURSOR c_psp_adjustment_lines IS

3707: END chk_in_psp_pre_gen_dist_lines;
3708:
3709: FUNCTION chk_in_psp_adjustment_lines
3710: RETURN NUMBER IS
3711: CURSOR c_psp_adjustment_lines IS
3712: SELECT 1
3713: FROM psp_adjustment_lines
3714: WHERE project_id = nvl (p_project_id, project_id)
3715: AND task_id = nvl (p_task_id, task_id)

Line 3713: FROM psp_adjustment_lines

3709: FUNCTION chk_in_psp_adjustment_lines
3710: RETURN NUMBER IS
3711: CURSOR c_psp_adjustment_lines IS
3712: SELECT 1
3713: FROM psp_adjustment_lines
3714: WHERE project_id = nvl (p_project_id, project_id)
3715: AND task_id = nvl (p_task_id, task_id)
3716: AND project_id is NOT NULL
3717: AND ROWNUM = 1;

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 3729: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines';

3725: AND ROWNUM = 1;
3726: BEGIN
3727:
3728: IF l_debug_enabled THEN
3729: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines';
3730: hr_utility.trace('Entering:'|| l_proc);
3731: END IF;
3732:
3733: OPEN c_psp_adjustment_lines;

Line 3733: OPEN c_psp_adjustment_lines;

3729: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines';
3730: hr_utility.trace('Entering:'|| l_proc);
3731: END IF;
3732:
3733: OPEN c_psp_adjustment_lines;
3734: FETCH c_psp_adjustment_lines INTO l_record_count;
3735: CLOSE c_psp_adjustment_lines;
3736:
3737: IF l_record_count IS NOT NULL

Line 3734: FETCH c_psp_adjustment_lines INTO l_record_count;

3730: hr_utility.trace('Entering:'|| l_proc);
3731: END IF;
3732:
3733: OPEN c_psp_adjustment_lines;
3734: FETCH c_psp_adjustment_lines INTO l_record_count;
3735: CLOSE c_psp_adjustment_lines;
3736:
3737: IF l_record_count IS NOT NULL
3738: THEN

Line 3735: CLOSE c_psp_adjustment_lines;

3731: END IF;
3732:
3733: OPEN c_psp_adjustment_lines;
3734: FETCH c_psp_adjustment_lines INTO l_record_count;
3735: CLOSE c_psp_adjustment_lines;
3736:
3737: IF l_record_count IS NOT NULL
3738: THEN
3739: l_return_code := 19;

Line 3744: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines';

3740: RETURN l_return_code;
3741: END IF;
3742:
3743: IF l_debug_enabled THEN
3744: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines';
3745: hr_utility.trace('Leaving:'|| l_proc);
3746: END IF;
3747:
3748: IF l_debug_enabled THEN

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

Line 3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);

3767: RETURN l_return_code;
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);
3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);
3773: RAISE;
3774: END chk_in_psp_adjustment_lines;
3775:

Line 3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);

3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);
3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);
3773: RAISE;
3774: END chk_in_psp_adjustment_lines;
3775:
3776: FUNCTION chk_poeta_in_element_entries

Line 3774: END chk_in_psp_adjustment_lines;

3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);
3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);
3773: RAISE;
3774: END chk_in_psp_adjustment_lines;
3775:
3776: FUNCTION chk_poeta_in_element_entries
3777: RETURN NUMBER IS
3778: CURSOR c_poeta_setup_element_entries IS

Line 3936: l_return_flag := chk_in_psp_adjustment_lines;

3932: END IF;
3933:
3934: -- Validation of project_id and task_id in Adjustments
3935:
3936: l_return_flag := chk_in_psp_adjustment_lines;
3937: IF l_return_flag <> 0 THEN
3938: RETURN l_return_flag;
3939: END IF;
3940: