APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_PROJ_ELEMENTS

Line 981: UPDATE PA_PROJ_ELEMENTS

977: ,avalue => l_content_id
978: );
979: END IF;
980:
981: UPDATE PA_PROJ_ELEMENTS
982: SET task_status = 'SUBMITTED'
983: WHERE proj_element_id = l_proj_element;
984:
985: resultout := wf_engine.eng_completed||':'||'F';

Line 1075: UPDATE PA_PROJ_ELEMENTS

1071:
1072: log_message('Parent Task '||l_parent_task_id||' of task '||l_proj_element||' is approved',3);
1073: log_message('Updating the task status to Submitted',3);
1074:
1075: UPDATE PA_PROJ_ELEMENTS
1076: SET task_status = 'SUBMITTED'
1077: WHERE proj_element_id = l_proj_element;
1078:
1079: resultout := wf_engine.eng_completed||':'||'T';

Line 1135: FROM PA_PROJ_ELEMENTS ppe,

1131: CURSOR C1(p_proj_elemt_id NUMBER) IS
1132: SELECT ppe.proj_element_id,
1133: ppev.element_version_id,
1134: ppev.parent_structure_version_id
1135: FROM PA_PROJ_ELEMENTS ppe,
1136: PA_PROJ_ELEMENT_VERSIONS ppev
1137: WHERE ppev.proj_element_id = ppe.proj_element_id
1138: AND ppe.proj_element_id = p_proj_elemt_id;
1139:

Line 1147: FROM PA_PROJ_ELEMENTS PPE, PA_OBJECT_RELATIONSHIPS POR, PA_PROJ_ELEMENT_VERSIONS PPEV

1143: SELECT ppe.proj_element_Id task_id,
1144: ppe.record_version_number,
1145: ppev.parent_structure_version_id,
1146: ppe.task_approver_id task_app_chg_id
1147: FROM PA_PROJ_ELEMENTS PPE, PA_OBJECT_RELATIONSHIPS POR, PA_PROJ_ELEMENT_VERSIONS PPEV
1148: WHERE ppe.project_id = p_project_id
1149: AND ppev.proj_element_id = ppe.proj_element_id
1150: AND ppev.financial_task_flag = 'Y'
1151: AND por.object_id_to1 = ppev.element_version_id

Line 1263: UPDATE PA_PROJ_ELEMENTS SET link_task_flag = 'N', task_status = ''

1259: log_message('Call to PA_TASKS_MAINT_PUB.CREATE_TASK is errored out',3);
1260: resultout := wf_engine.eng_completed||':'||'F';
1261: ELSE
1262: log_message('Create Task is successful',3);
1263: UPDATE PA_PROJ_ELEMENTS SET link_task_flag = 'N', task_status = ''
1264: WHERE proj_element_id = l_task_id;
1265:
1266: log_message('Raising notification for all child tasks in pending status',3);
1267: -- This is to raise notification for all child tasks which are in submitted status when the parent task is approved.

Line 1388: UPDATE PA_PROJ_ELEMENTS SET task_status = 'PENDING',

1384: ,itemkey => itemkey
1385: ,aname => 'CI_ID');
1386:
1387: log_message('Marking task status to pending for its parent tasks approval',3);
1388: UPDATE PA_PROJ_ELEMENTS SET task_status = 'PENDING',
1389: task_approver_id = l_aprv_user_id
1390: WHERE proj_element_id = l_proj_element_id;
1391:
1392: log_message('Calling generate_task_aprv_notify to generate the notification',3);

Line 1439: FROM PA_PROJ_ELEMENTS ppe,

1435: CURSOR C1(p_proj_elemt_id NUMBER) IS
1436: SELECT ppe.proj_element_id,
1437: ppev.element_version_id,
1438: ppev.parent_structure_version_id
1439: FROM PA_PROJ_ELEMENTS ppe,
1440: PA_PROJ_ELEMENT_VERSIONS ppev
1441: WHERE ppev.proj_element_id = ppe.proj_element_id
1442: AND ppe.proj_element_id = p_proj_elemt_id;
1443:

Line 1451: FROM PA_PROJ_ELEMENTS PPE,

1447: SELECT ppe.proj_element_Id task_id,
1448: ppe.record_version_number,
1449: ppev.parent_structure_version_id,
1450: ppev.element_version_id
1451: FROM PA_PROJ_ELEMENTS PPE,
1452: PA_PROJ_ELEMENT_VERSIONS PPEV
1453: WHERE ppe.project_id = p_project_id
1454: AND ppev.proj_element_id = ppe.proj_element_id
1455: AND ppev.financial_task_flag = 'Y'

Line 1471: FROM PA_PROJ_ELEMENTS PPE,

1467: SELECT ppe.proj_element_Id task_id,
1468: ppe.record_version_number,
1469: ppev.parent_structure_version_id,
1470: ppev.element_version_id
1471: FROM PA_PROJ_ELEMENTS PPE,
1472: PA_PROJ_ELEMENT_VERSIONS PPEV
1473: WHERE ppe.project_id = p_project_id
1474: AND ppe.proj_element_id = ppev.proj_element_id
1475: AND ppe.proj_element_id =p_task_id;

Line 1565: from pa_proj_elements ppe,

1561: pa_resource_assignments pra where
1562: budget_version_id in (
1563: select budget_version_id from pa_budget_versions where ci_id = l_ci_id )
1564: and exists (select 1
1565: from pa_proj_elements ppe,
1566: pa_proj_element_versions ppev,
1567: pa_object_relationships por
1568: where ppe.proj_element_id = pra.task_id
1569: and ppe.project_id = pra.project_id