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_PRE_GEN_DIST_LINES

Line 3582: FUNCTION chk_in_psp_pre_gen_dist_lines

3578: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlcode is ' || SQLCODE);
3579: RAISE;
3580: END chk_dist_adj_pregen_summ_lines;
3581:
3582: FUNCTION chk_in_psp_pre_gen_dist_lines
3583: RETURN NUMBER
3584: IS
3585: CURSOR c_pre_gen_dist_lines IS
3586: SELECT 1

Line 3587: FROM psp_pre_gen_dist_lines

3583: RETURN NUMBER
3584: IS
3585: CURSOR c_pre_gen_dist_lines IS
3586: SELECT 1
3587: FROM psp_pre_gen_dist_lines
3588: WHERE project_id = nvl (p_project_id, project_id)
3589: AND task_id = nvl (p_task_id, task_id)
3590: AND project_id is NOT NULL
3591: AND ROWNUM = 1;

Line 3595: FROM psp_pre_gen_dist_lines_history

3591: AND ROWNUM = 1;
3592:
3593: CURSOR c_pre_gen_dist_lines_hist IS
3594: SELECT 1
3595: FROM psp_pre_gen_dist_lines_history
3596: WHERE project_id = nvl (p_project_id, project_id)
3597: AND task_id = nvl (p_task_id, task_id)
3598: AND project_id is NOT NULL
3599: AND ROWNUM = 1;

Line 3621: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines';

3617:
3618: BEGIN
3619:
3620: IF l_debug_enabled THEN
3621: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines';
3622: hr_utility.trace('Entering:'|| l_proc);
3623: END IF;
3624:
3625: OPEN c_pre_gen_dist_lines;

Line 3636: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines';

3632: RETURN l_return_code;
3633: END IF;
3634:
3635: IF l_debug_enabled THEN
3636: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines';
3637: hr_utility.trace('Leaving:'|| l_proc);
3638: END IF;
3639:
3640: IF l_debug_enabled THEN

Line 3641: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines_hist';

3637: hr_utility.trace('Leaving:'|| l_proc);
3638: END IF;
3639:
3640: IF l_debug_enabled THEN
3641: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines_hist';
3642: hr_utility.trace('Entering:'|| l_proc);
3643: END IF;
3644:
3645: OPEN c_pre_gen_dist_lines_hist;

Line 3656: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines_hist';

3652: RETURN l_return_code;
3653: END IF;
3654:
3655: IF l_debug_enabled THEN
3656: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines_hist';
3657: hr_utility.trace('Leaving:'|| l_proc);
3658: END IF;
3659:
3660: IF l_debug_enabled THEN

Line 3661: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_interface';

3657: hr_utility.trace('Leaving:'|| l_proc);
3658: END IF;
3659:
3660: IF l_debug_enabled THEN
3661: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_interface';
3662: hr_utility.trace('Entering:'|| l_proc);
3663: END IF;
3664:
3665: OPEN c_distribution_interface;

Line 3676: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_interface';

3672: RETURN l_return_code;
3673: END IF;
3674:
3675: IF l_debug_enabled THEN
3676: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_interface';
3677: hr_utility.trace('Leaving:'|| l_proc);
3678: END IF;
3679:
3680: IF l_debug_enabled THEN

Line 3681: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_int_arch';

3677: hr_utility.trace('Leaving:'|| l_proc);
3678: END IF;
3679:
3680: IF l_debug_enabled THEN
3681: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_int_arch';
3682: hr_utility.trace('Entering:'|| l_proc);
3683: END IF;
3684:
3685: OPEN c_distribution_int_arch;

Line 3696: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_int_arch';

3692: RETURN l_return_code;
3693: END IF;
3694:
3695: IF l_debug_enabled THEN
3696: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_int_arch';
3697: hr_utility.trace('Leaving:'|| l_proc);
3698: END IF;
3699: RETURN l_return_code;
3700:

Line 3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);

3700:
3701: EXCEPTION
3702: WHEN OTHERS THEN
3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);
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:

Line 3705: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlcode is ' || SQLCODE);

3701: EXCEPTION
3702: WHEN OTHERS THEN
3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);
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

Line 3707: END chk_in_psp_pre_gen_dist_lines;

3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);
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

Line 3929: l_return_flag := chk_in_psp_pre_gen_dist_lines;

3925: END IF;
3926:
3927: -- Validation of project_id and task_id in pre gen dist lines and psp_distribution_interface table
3928:
3929: l_return_flag := chk_in_psp_pre_gen_dist_lines;
3930: IF l_return_flag <> 0 THEN
3931: RETURN l_return_flag;
3932: END IF;
3933: