APPS.PA_WORKPLAN_ATTR_PVT dependencies on PA_PROJ_WORKPLAN_ATTR

Line 153: INSERT INTO PA_PROJ_WORKPLAN_ATTR (

149: END IF;
150: --end bug 3325803
151:
152: if p_validate_only <> FND_API.G_TRUE then
153: INSERT INTO PA_PROJ_WORKPLAN_ATTR (
154: project_id
155: ,proj_element_id
156: ,wp_approval_reqd_flag
157: ,wp_auto_publish_flag

Line 391: FROM pa_proj_workplan_attr

387: auto_rollup_subproj_flag, third_party_schedule_code
388: INTO l_lifecycle_version_id, l_current_phase_version_id,
389: l_schedule_third_party_flag, l_allow_lowest_tsk_dep_flag,
390: l_auto_rollup_subproj_flag, l_third_party_schedule_code
391: FROM pa_proj_workplan_attr
392: WHERE proj_element_id = p_proj_element_id
393: AND record_version_number = p_record_version_number;
394:
395:

Line 435: FROM pa_proj_workplan_attr

431: if p_validate_only <> FND_API.G_TRUE then
432: BEGIN
433: SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
434: INTO l_lifecycle_version_id, l_current_phase_version_id
435: FROM pa_proj_workplan_attr
436: WHERE proj_element_id = p_proj_element_id
437: AND record_version_number = p_record_version_number
438: FOR UPDATE OF record_version_number NOWAIT;
439: EXCEPTION

Line 467: FROM pa_proj_workplan_attr

463: else
464: BEGIN
465: SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
466: INTO l_lifecycle_version_id, l_current_phase_version_id
467: FROM pa_proj_workplan_attr
468: WHERE proj_element_id = p_proj_element_id
469: AND record_version_number = p_record_version_number;
470: EXCEPTION
471: when NO_DATA_FOUND then

Line 706: UPDATE PA_PROJ_WORKPLAN_ATTR

702: wp_approval_reqd_flag,wp_auto_publish_flag,wp_default_display_lvl,wp_enable_version_flag,auto_pub_upon_creation_flag,
703: auto_sync_txn_date_flag.
704: */
705: --bug 3905167: added nvl for p_default_display_lvl.
706: UPDATE PA_PROJ_WORKPLAN_ATTR
707: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
708: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
709: wp_approver_source_id = l_approver_source_id,
710: wp_approver_source_type = l_approver_source_type,

Line 1015: FROM pa_proj_workplan_attr

1011:
1012: if p_validate_only <> FND_API.G_TRUE then
1013: BEGIN
1014: SELECT 'x' INTO l_dummy
1015: FROM pa_proj_workplan_attr
1016: WHERE proj_element_id = p_proj_element_id
1017: AND record_version_number = p_record_version_number
1018: FOR UPDATE OF record_version_number NOWAIT;
1019: EXCEPTION

Line 1046: FROM pa_proj_workplan_attr

1042: END;
1043: else
1044: BEGIN
1045: SELECT 'x' INTO l_dummy
1046: FROM pa_proj_workplan_attr
1047: WHERE proj_element_id = p_proj_element_id
1048: AND record_version_number = p_record_version_number;
1049: EXCEPTION
1050: when NO_DATA_FOUND then

Line 1076: DELETE FROM PA_PROJ_WORKPLAN_ATTR

1072: end if;
1073:
1074: if p_validate_only <> FND_API.G_TRUE then
1075:
1076: DELETE FROM PA_PROJ_WORKPLAN_ATTR
1077: WHERE proj_element_id = p_proj_element_id;
1078:
1079: end if;
1080: