APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECTS

Line 1011: FROM pa_projects_all ppa, pa_project_statuses pps

1007: -- For retrieving project_status_name
1008: -- 3054787: Select from tables directly to improve performance.
1009: CURSOR get_project_status_name IS
1010: SELECT pps.project_status_name
1011: FROM pa_projects_all ppa, pa_project_statuses pps
1012: WHERE ppa.project_id = p_project_id
1013: AND ppa.project_status_code = pps.project_status_code;
1014:
1015: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 1961: FROM pa_projects_all ppa, pa_project_statuses pps

1957: -- For retrieving project_status_name
1958: -- 3054787: Select from tables directly to improve performance.
1959: CURSOR get_project_status_name IS
1960: SELECT pps.project_status_name
1961: FROM pa_projects_all ppa, pa_project_statuses pps
1962: WHERE ppa.project_id = p_project_id
1963: AND ppa.project_status_code = pps.project_status_code;
1964:
1965: l_project_status_name pa_project_statuses.project_status_name%TYPE;

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

3048: l_no_calendar_at_org BOOLEAN;
3049: l_temp_calendar_id VARCHAR2(80);
3050: l_null_default_calendar EXCEPTION;
3051: l_invalid_default_calendar EXCEPTION;
3052: l_t_carrying_out_org_id PA_PROJECTS.carrying_out_organization_id%TYPE; -- To store the orgnaization id
3053: L_MSG_INDEX_OUT NUMBER;
3054:
3055: l_data varchar2(2000); -- 4537865
3056: BEGIN

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

3072:
3073: -- Taking out the orgnization id for passing to the get_proj_calendar_default */
3074: IF (p_project_id IS NOT NULL ) THEN
3075: BEGIN
3076: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3077: SELECT carrying_out_organization_id
3078: INTO l_t_carrying_out_org_id
3079: FROM PA_PROJECTS_ALL
3080: WHERE project_id = p_project_id;

Line 3079: FROM PA_PROJECTS_ALL

3075: BEGIN
3076: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3077: SELECT carrying_out_organization_id
3078: INTO l_t_carrying_out_org_id
3079: FROM PA_PROJECTS_ALL
3080: WHERE project_id = p_project_id;
3081:
3082: EXCEPTION
3083: WHEN NO_DATA_FOUND THEN

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

4655: assignment_effort,
4656: assignment_duration,
4657: project_system_status_code,
4658: --decode(decode(assignment_type, 'STAFFED_ASSIGNMENT', pa_security_pvt.check_user_privilege
4659: --('PA_ASN_SCHEDULE_ED', 'PA_PROJECTS', project_id), 'STAFFED_ADMIN_ASSIGNMENT',
4660: -- pa_security_pvt.check_user_privilege('PA_ADM_ASN_SCHEDULE_ED', 'PA_PROJECTS',project_id)),'Y',1,0) read_only_flag
4661: -- 1 read_only_flag -- Here we are selecting read_only_flag as 0, actual value will be poulated Java side bcoz it does caching
4662: DECODE(mass_wf_in_progress_flag, 'Y', 1,
4663: DECODE(pending_approval_flag, 'Y', 1,

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

4656: assignment_duration,
4657: project_system_status_code,
4658: --decode(decode(assignment_type, 'STAFFED_ASSIGNMENT', pa_security_pvt.check_user_privilege
4659: --('PA_ASN_SCHEDULE_ED', 'PA_PROJECTS', project_id), 'STAFFED_ADMIN_ASSIGNMENT',
4660: -- pa_security_pvt.check_user_privilege('PA_ADM_ASN_SCHEDULE_ED', 'PA_PROJECTS',project_id)),'Y',1,0) read_only_flag
4661: -- 1 read_only_flag -- Here we are selecting read_only_flag as 0, actual value will be poulated Java side bcoz it does caching
4662: DECODE(mass_wf_in_progress_flag, 'Y', 1,
4663: DECODE(pending_approval_flag, 'Y', 1,
4664: DECODE(apprvl_status_code, 'ASGMT_APPRVL_CANCELED', 1, -- Bug 3235731