APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_CONTROL_ITEMS

Line 61: FROM PA_CONTROL_ITEMS pci,

57: pctb.short_name||' ('||pci.ci_number||')' ci_number,
58: ci_type_class_code,
59: pci.created_by created_by,
60: pci.creation_date creation_date
61: FROM PA_CONTROL_ITEMS pci,
62: PA_CI_TYPES_vl pctb
63: WHERE ci_id = p_ci_id
64: AND pctb.ci_type_id = pci.ci_type_id;
65:

Line 473: FROM PA_CONTROL_ITEMS pci,

469: pctb.short_name||' ('||pci.ci_number||')' ci_number,
470: ci_type_class_code,
471: pci.created_by created_by,
472: pci.creation_date creation_date
473: FROM PA_CONTROL_ITEMS pci,
474: PA_CI_TYPES_vl pctb
475: WHERE ci_id = p_ci_id
476: AND pctb.ci_type_id = pci.ci_type_id;
477:

Line 495: l_ci_description PA_CONTROL_ITEMS.description%TYPE;

491:
492: l_page_content_id NUMBER :=0;
493:
494: l_ci_type_class_code VARCHAR2(15);
495: l_ci_description PA_CONTROL_ITEMS.description%TYPE;
496: l_ci_created_by VARCHAR2(300);
497: l_ci_creation_date DATE;
498: l_ci_number pa_control_items.ci_number%TYPE;
499:

Line 498: l_ci_number pa_control_items.ci_number%TYPE;

494: l_ci_type_class_code VARCHAR2(15);
495: l_ci_description PA_CONTROL_ITEMS.description%TYPE;
496: l_ci_created_by VARCHAR2(300);
497: l_ci_creation_date DATE;
498: l_ci_number pa_control_items.ci_number%TYPE;
499:
500: l_mgr_name VARCHAR2(1000);
501:
502: c_task_info_rec c_task_info%ROWTYPE;

Line 1163: FROM pa_control_items pci, pa_ci_actions pcia

1159: -- and are in SUBMITTED status.
1160: CURSOR C3(p_project_id NUMBER, p_task_id NUMBER) IS
1161: SELECT pci.ci_id,
1162: pcia.ci_action_id action_id
1163: FROM pa_control_items pci, pa_ci_actions pcia
1164: WHERE pci.project_id = p_project_id
1165: AND pcia.ci_id(+) = pci.ci_id
1166: AND pcia.ci_action_number(+) = pci.open_action_num
1167: AND EXISTS (SELECT 1 FROM pa_budget_versions pbv, pa_resource_assignments pra

Line 1297: /*PA_CONTROL_ITEMS_WORKFLOW.START_NOTIFICATION_WF

1293: ,x_msg_data
1294: ,x_return_status);
1295:
1296: IF x_return_status = 'S' THEN
1297: /*PA_CONTROL_ITEMS_WORKFLOW.START_NOTIFICATION_WF
1298: ( p_item_type => 'PAWFCISC'
1299: ,p_process_name => 'PA_CI_PROCESS_APPROVAL'
1300: ,p_ci_id => ci_info.ci_id
1301: ,p_action_id => ci_info.action_id

Line 1306: PA_CONTROL_ITEMS_WORKFLOW.start_workflow

1302: ,x_item_key => l_item_key
1303: ,x_return_status => x_return_status
1304: ,x_msg_count => x_msg_count
1305: ,x_msg_data => x_msg_data );*/
1306: PA_CONTROL_ITEMS_WORKFLOW.start_workflow
1307: (p_item_type => 'PAWFCISC'
1308: ,p_process_name => 'PA_CI_PROCESS_APPROVAL'
1309: ,p_ci_id => ci_info.ci_id
1310: ,x_item_key => l_item_key