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.AHL_VWP_PROJ_PROD_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 2931: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

2927: OPEN get_task_id_parent_ref_csr(c_project_id => c_visit_rec.PROJECT_ID, c_task_number => l_task_in(i).PA_TASK_NUMBER);
2928: FETCH get_task_id_parent_ref_csr INTO l_task_in(i).PA_TASK_ID, l_task_in(i).PM_PARENT_TASK_REFERENCE;
2929: CLOSE get_task_id_parent_ref_csr;
2930:
2931: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
2932: OPEN get_task_disp_seq_csr(c_project_task_id => l_task_in(i).PA_TASK_ID);
2933: FETCH get_task_disp_seq_csr INTO l_task_in(i).DISPLAY_SEQUENCE;
2934: CLOSE get_task_disp_seq_csr;
2935: END IF;

Line 3078: IF l_task_in(i).PA_TASK_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --i.e. above cursor did not fetch anything

3074: END IF;
3075:
3076: -- Store the value of the cost parent id temporarily
3077: -- which will be reset or overwritten later with the task number corresponding to this cost parent
3078: IF l_task_in(i).PA_TASK_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --i.e. above cursor did not fetch anything
3079: IF (get_prj_route_dtls_rec.cost_parent_id IS NOT NULL) THEN
3080: l_task_in(i).PM_PARENT_TASK_REFERENCE := '-' || get_prj_route_dtls_rec.cost_parent_id;
3081: ELSE
3082: -- Add this under the top task

Line 3155: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

3151: OPEN get_task_id_parent_ref_csr(c_project_id => c_visit_rec.PROJECT_ID, c_task_number => l_task_in(i).PA_TASK_NUMBER);
3152: FETCH get_task_id_parent_ref_csr INTO l_task_in(i).PA_TASK_ID, l_task_in(i).PM_PARENT_TASK_REFERENCE;
3153: CLOSE get_task_id_parent_ref_csr;
3154:
3155: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3156: OPEN get_task_disp_seq_csr(c_project_task_id => l_task_in(i).PA_TASK_ID);
3157: FETCH get_task_disp_seq_csr INTO l_task_in(i).DISPLAY_SEQUENCE;
3158: CLOSE get_task_disp_seq_csr;
3159: END IF;

Line 3320: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

3316: OPEN get_task_id_parent_ref_csr(c_project_id => c_visit_rec.PROJECT_ID, c_task_number => l_task_in(i).PA_TASK_NUMBER);
3317: FETCH get_task_id_parent_ref_csr INTO l_task_in(i).PA_TASK_ID, l_task_in(i).PM_PARENT_TASK_REFERENCE;
3318: CLOSE get_task_id_parent_ref_csr;
3319:
3320: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3321: OPEN get_task_disp_seq_csr(c_project_task_id => l_task_in(i).PA_TASK_ID);
3322: FETCH get_task_disp_seq_csr INTO l_task_in(i).DISPLAY_SEQUENCE;
3323: CLOSE get_task_disp_seq_csr;
3324: END IF;

Line 3328: IF l_task_in(i).PA_TASK_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --i.e. above cursor did not fetch anything

3324: END IF;
3325:
3326: -- Store the value of the cost parent id temporarily
3327: -- which will be reset or overwritten later with the task number corresponding to this cost parent
3328: IF l_task_in(i).PA_TASK_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --i.e. above cursor did not fetch anything
3329: IF (get_prj_route_dtls_rec.cost_parent_id IS NOT NULL) THEN
3330: l_task_in(i).PM_PARENT_TASK_REFERENCE := '-' || get_prj_route_dtls_rec.cost_parent_id;
3331: ELSE
3332: l_task_in(i).PM_PARENT_TASK_REFERENCE := null;

Line 3400: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

3396: OPEN get_task_id_parent_ref_csr(c_project_id => c_visit_rec.PROJECT_ID, c_task_number => l_task_in(i).PA_TASK_NUMBER);
3397: FETCH get_task_id_parent_ref_csr INTO l_task_in(i).PA_TASK_ID, l_task_in(i).PM_PARENT_TASK_REFERENCE;
3398: CLOSE get_task_id_parent_ref_csr;
3399:
3400: IF (l_task_in(i).PA_TASK_ID IS NOT NULL AND l_task_in(i).PA_TASK_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3401: OPEN get_task_disp_seq_csr(c_project_task_id => l_task_in(i).PA_TASK_ID);
3402: FETCH get_task_disp_seq_csr INTO l_task_in(i).DISPLAY_SEQUENCE;
3403: CLOSE get_task_disp_seq_csr;
3404: END IF;

Line 11927: -- the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info may be removed.

11923: -- To check Project responsibilites
11924:
11925: -- Begin changes by jaramana on Mar 4, 2008 for bug 6788115 (FP of 6759574)
11926: -- As per update from ravichandran.velusamy in Projects team in the bug 6759574,
11927: -- the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info may be removed.
11928: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info
11929: /***
11930: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
11931: (x_check_project => l_chk_project,

Line 11928: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info

11924:
11925: -- Begin changes by jaramana on Mar 4, 2008 for bug 6788115 (FP of 6759574)
11926: -- As per update from ravichandran.velusamy in Projects team in the bug 6759574,
11927: -- the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info may be removed.
11928: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info
11929: /***
11930: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
11931: (x_check_project => l_chk_project,
11932: x_return_status => l_return_status);