APPS.PA_TASK_PUB1 dependencies on PA_CONTROL_ITEMS

Line 17155: FROM pa_control_items pci, pa_ci_actions pcia

17151:
17152: CURSOR C3(p_project_id NUMBER, p_task_id NUMBER) IS
17153: SELECT pci.ci_id,
17154: pcia.ci_action_id action_id
17155: FROM pa_control_items pci, pa_ci_actions pcia
17156: WHERE pci.project_id = p_project_id
17157: AND pcia.ci_id = pci.ci_id
17158: AND pcia.ci_action_number = pci.open_action_num
17159: AND EXISTS (SELECT 1 FROM pa_budget_versions pbv, pa_resource_assignments pra

Line 17252: /*PA_CONTROL_ITEMS_WORKFLOW.START_NOTIFICATION_WF

17248: ,l_msg_data2
17249: ,l_return_status2);
17250:
17251: IF x_return_status = 'S' THEN
17252: /*PA_CONTROL_ITEMS_WORKFLOW.START_NOTIFICATION_WF
17253: ( p_item_type => 'PAWFCISC'
17254: ,p_process_name => 'PA_CI_PROCESS_APPROVAL'
17255: ,p_ci_id => ci_info.ci_id
17256: ,p_action_id => ci_info.action_id

Line 17261: PA_CONTROL_ITEMS_WORKFLOW.start_workflow

17257: ,x_item_key => l_item_key
17258: ,x_return_status => l_return_status2
17259: ,x_msg_count => l_msg_count2
17260: ,x_msg_data => l_msg_data2 );*/
17261: PA_CONTROL_ITEMS_WORKFLOW.start_workflow
17262: (
17263: p_item_type => 'PAWFCISC'
17264: , p_process_name => 'PA_CI_PROCESS_APPROVAL'
17265: , p_ci_id => ci_info.ci_id