APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_TASKS

Line 1098: -- This procedure calls PA_TASKS_MAINT_PUB.CREATE_TASK API that populates pa_tasks.

1094: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);
1095: RAISE;
1096: END Is_Parent_Task_Approved;
1097:
1098: -- This procedure calls PA_TASKS_MAINT_PUB.CREATE_TASK API that populates pa_tasks.
1099: -- This is being called from Task approval workflow on approving the task from Approval Notification.
1100: PROCEDURE Post_Task (itemtype IN VARCHAR2
1101: ,itemkey IN VARCHAR2
1102: ,actid IN NUMBER

Line 1233: log_message('Before calling PA_TASKS_MAINT_PUB.CREATE_TASK',3);

1229: l_billable_flag := 'Y';
1230: l_chargeable_flag := 'N';
1231: END IF;
1232:
1233: log_message('Before calling PA_TASKS_MAINT_PUB.CREATE_TASK',3);
1234: PA_TASKS_MAINT_PUB.CREATE_TASK
1235: (
1236: p_calling_module => 'SELF_SERVICE'
1237: ,p_init_msg_list => FND_API.G_FALSE

Line 1234: PA_TASKS_MAINT_PUB.CREATE_TASK

1230: l_chargeable_flag := 'N';
1231: END IF;
1232:
1233: log_message('Before calling PA_TASKS_MAINT_PUB.CREATE_TASK',3);
1234: PA_TASKS_MAINT_PUB.CREATE_TASK
1235: (
1236: p_calling_module => 'SELF_SERVICE'
1237: ,p_init_msg_list => FND_API.G_FALSE
1238: ,p_debug_mode => 'Y'

Line 1259: log_message('Call to PA_TASKS_MAINT_PUB.CREATE_TASK is errored out',3);

1255: --b6694902_debug.debug('Inside POST_TASK for task '||l_task_id||' Status:'||x_return_status);
1256: --b6694902_debug.debug('Inside POST_TASK for task '||l_task_id||' x_msg_data:'||x_msg_data);
1257:
1258: IF x_return_status <> 'S' THEN
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 = ''

Line 1574: and por.object_type_to = 'PA_TASKS'

1570: and ppe.link_task_flag = 'Y'
1571: and ppe.type_id = 1
1572: and ppev.proj_element_id = ppe.proj_element_id
1573: and por.object_id_to1 = ppev.element_version_id
1574: and por.object_type_to = 'PA_TASKS'
1575: and por.relationship_type = 'S'
1576: and ppev.financial_task_flag = 'Y')
1577: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);
1578:

Line 1577: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);

1573: and por.object_id_to1 = ppev.element_version_id
1574: and por.object_type_to = 'PA_TASKS'
1575: and por.relationship_type = 'S'
1576: and ppev.financial_task_flag = 'Y')
1577: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);
1578:
1579: l_unapproved_task_cnt NUMBER :=0;
1580: c_task_rec c_task_info%ROWTYPE;
1581: l_max_notification_id WF_NOTIFICATIONS.notification_id%TYPE;