APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECTS

Line 1480: FROM pa_projects_all ppa, pa_project_statuses pps

1476: -- For retrieving project_status_name
1477: -- 3054787: Select from tables directly to improve performance.
1478: CURSOR get_project_status_name IS
1479: SELECT pps.project_status_name
1480: FROM pa_projects_all ppa, pa_project_statuses pps
1481: WHERE ppa.project_id = p_project_id
1482: AND ppa.project_status_code = pps.project_status_code;
1483:
1484: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 2433: FROM pa_projects_all ppa, pa_project_statuses pps

2429: -- For retrieving project_status_name
2430: -- 3054787: Select from tables directly to improve performance.
2431: CURSOR get_project_status_name IS
2432: SELECT pps.project_status_name
2433: FROM pa_projects_all ppa, pa_project_statuses pps
2434: WHERE ppa.project_id = p_project_id
2435: AND ppa.project_status_code = pps.project_status_code;
2436:
2437: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 3532: l_t_carrying_out_org_id PA_PROJECTS.carrying_out_organization_id%TYPE; -- To store the orgnaization id

3528: l_no_calendar_at_org BOOLEAN;
3529: l_temp_calendar_id VARCHAR2(80);
3530: l_null_default_calendar EXCEPTION;
3531: l_invalid_default_calendar EXCEPTION;
3532: l_t_carrying_out_org_id PA_PROJECTS.carrying_out_organization_id%TYPE; -- To store the orgnaization id
3533: L_MSG_INDEX_OUT NUMBER;
3534:
3535: l_data varchar2(2000); -- 4537865
3536: BEGIN

Line 3556: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.

3552:
3553: -- Taking out the orgnization id for passing to the get_proj_calendar_default */
3554: IF (p_project_id IS NOT NULL ) THEN
3555: BEGIN
3556: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3557: SELECT carrying_out_organization_id
3558: INTO l_t_carrying_out_org_id
3559: FROM PA_PROJECTS_ALL
3560: WHERE project_id = p_project_id;

Line 3559: FROM PA_PROJECTS_ALL

3555: BEGIN
3556: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3557: SELECT carrying_out_organization_id
3558: INTO l_t_carrying_out_org_id
3559: FROM PA_PROJECTS_ALL
3560: WHERE project_id = p_project_id;
3561:
3562: EXCEPTION
3563: WHEN NO_DATA_FOUND THEN

Line 5139: --('PA_ASN_SCHEDULE_ED', 'PA_PROJECTS', project_id), 'STAFFED_ADMIN_ASSIGNMENT',

5135: assignment_effort,
5136: assignment_duration,
5137: project_system_status_code,
5138: --decode(decode(assignment_type, 'STAFFED_ASSIGNMENT', pa_security_pvt.check_user_privilege
5139: --('PA_ASN_SCHEDULE_ED', 'PA_PROJECTS', project_id), 'STAFFED_ADMIN_ASSIGNMENT',
5140: -- pa_security_pvt.check_user_privilege('PA_ADM_ASN_SCHEDULE_ED', 'PA_PROJECTS',project_id)),'Y',1,0) read_only_flag
5141: -- 1 read_only_flag -- Here we are selecting read_only_flag as 0, actual value will be poulated Java side bcoz it does caching
5142: DECODE(mass_wf_in_progress_flag, 'Y', 1,
5143: DECODE(pending_approval_flag, 'Y', 1,

Line 5140: -- pa_security_pvt.check_user_privilege('PA_ADM_ASN_SCHEDULE_ED', 'PA_PROJECTS',project_id)),'Y',1,0) read_only_flag

5136: assignment_duration,
5137: project_system_status_code,
5138: --decode(decode(assignment_type, 'STAFFED_ASSIGNMENT', pa_security_pvt.check_user_privilege
5139: --('PA_ASN_SCHEDULE_ED', 'PA_PROJECTS', project_id), 'STAFFED_ADMIN_ASSIGNMENT',
5140: -- pa_security_pvt.check_user_privilege('PA_ADM_ASN_SCHEDULE_ED', 'PA_PROJECTS',project_id)),'Y',1,0) read_only_flag
5141: -- 1 read_only_flag -- Here we are selecting read_only_flag as 0, actual value will be poulated Java side bcoz it does caching
5142: DECODE(mass_wf_in_progress_flag, 'Y', 1,
5143: DECODE(pending_approval_flag, 'Y', 1,
5144: DECODE(apprvl_status_code, 'ASGMT_APPRVL_CANCELED', 1, -- Bug 3235731