APPS.PA_WORKPLAN_ATTR_PVT dependencies on PA_PROJ_WORKPLAN_ATTR

Line 96: FROM PA_PROJ_WORKPLAN_ATTR

92: l_use_task_schedule_flag VARCHAR2(1);
93:
94: CURSOR c2(p_project_id IN NUMBER) IS
95: SELECT use_task_schedule_flag
96: FROM PA_PROJ_WORKPLAN_ATTR
97: WHERE PROJECT_ID IN
98: (SELECT created_from_project_id
99: FROM pa_projects_all
100: WHERE project_id = p_project_id);

Line 181: INSERT INTO PA_PROJ_WORKPLAN_ATTR (

177: END IF;
178: --end bug 3325803
179:
180: if p_validate_only <> FND_API.G_TRUE then
181: INSERT INTO PA_PROJ_WORKPLAN_ATTR (
182: project_id
183: ,proj_element_id
184: ,wp_approval_reqd_flag
185: ,wp_auto_publish_flag

Line 429: FROM pa_proj_workplan_attr

425: auto_rollup_subproj_flag, third_party_schedule_code
426: INTO l_lifecycle_version_id, l_current_phase_version_id,
427: l_schedule_third_party_flag, l_allow_lowest_tsk_dep_flag,
428: l_auto_rollup_subproj_flag, l_third_party_schedule_code
429: FROM pa_proj_workplan_attr
430: WHERE proj_element_id = p_proj_element_id
431: AND record_version_number = p_record_version_number;
432:
433:

Line 473: FROM pa_proj_workplan_attr

469: if p_validate_only <> FND_API.G_TRUE then
470: BEGIN
471: SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
472: INTO l_lifecycle_version_id, l_current_phase_version_id
473: FROM pa_proj_workplan_attr
474: WHERE proj_element_id = p_proj_element_id
475: AND record_version_number = p_record_version_number
476: FOR UPDATE OF record_version_number NOWAIT;
477: EXCEPTION

Line 505: FROM pa_proj_workplan_attr

501: else
502: BEGIN
503: SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
504: INTO l_lifecycle_version_id, l_current_phase_version_id
505: FROM pa_proj_workplan_attr
506: WHERE proj_element_id = p_proj_element_id
507: AND record_version_number = p_record_version_number;
508: EXCEPTION
509: when NO_DATA_FOUND then

Line 750: UPDATE PA_PROJ_WORKPLAN_ATTR

746: wp_approval_reqd_flag,wp_auto_publish_flag,wp_default_display_lvl,wp_enable_version_flag,auto_pub_upon_creation_flag,
747: auto_sync_txn_date_flag.
748: */
749: --bug 3905167: added nvl for p_default_display_lvl.
750: UPDATE PA_PROJ_WORKPLAN_ATTR
751: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
752: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
753: wp_approver_source_id = l_approver_source_id,
754: wp_approver_source_type = l_approver_source_type,

Line 1062: FROM pa_proj_workplan_attr

1058:
1059: if p_validate_only <> FND_API.G_TRUE then
1060: BEGIN
1061: SELECT 'x' INTO l_dummy
1062: FROM pa_proj_workplan_attr
1063: WHERE proj_element_id = p_proj_element_id
1064: AND record_version_number = p_record_version_number
1065: FOR UPDATE OF record_version_number NOWAIT;
1066: EXCEPTION

Line 1093: FROM pa_proj_workplan_attr

1089: END;
1090: else
1091: BEGIN
1092: SELECT 'x' INTO l_dummy
1093: FROM pa_proj_workplan_attr
1094: WHERE proj_element_id = p_proj_element_id
1095: AND record_version_number = p_record_version_number;
1096: EXCEPTION
1097: when NO_DATA_FOUND then

Line 1123: DELETE FROM PA_PROJ_WORKPLAN_ATTR

1119: end if;
1120:
1121: if p_validate_only <> FND_API.G_TRUE then
1122:
1123: DELETE FROM PA_PROJ_WORKPLAN_ATTR
1124: WHERE proj_element_id = p_proj_element_id;
1125:
1126: end if;
1127: