APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_PROJECTS_ALL

Line 1137: l_project_id pa_projects_all.project_id%TYPE;

1133: AS
1134:
1135: l_item_key NUMBER;
1136: l_last_item_key VARCHAR2(200);
1137: l_project_id pa_projects_all.project_id%TYPE;
1138: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;
1139: l_entity_key1 pa_wf_processes.entity_key1%TYPE;
1140: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
1141:

Line 1387: l_project_id pa_projects_all.project_id%TYPE;

1383:
1384: l_module_name VARCHAR2(100) := 'pa.plsql.set_workflow_attributes';
1385: Invalid_Arg_Exc_CI Exception;
1386:
1387: l_project_id pa_projects_all.project_id%TYPE;
1388: l_url VARCHAR2(2000);
1389: l_act_url VARCHAR2(2000);
1390: l_project_name pa_projects_all.name%TYPE;
1391: l_project_number pa_projects_all.segment1%TYPE;

Line 1390: l_project_name pa_projects_all.name%TYPE;

1386:
1387: l_project_id pa_projects_all.project_id%TYPE;
1388: l_url VARCHAR2(2000);
1389: l_act_url VARCHAR2(2000);
1390: l_project_name pa_projects_all.name%TYPE;
1391: l_project_number pa_projects_all.segment1%TYPE;
1392: l_customer pa_project_lists_v.customer_name%TYPE;
1393: l_project_manager pa_project_lists_v.person_name%TYPE;
1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;

Line 1391: l_project_number pa_projects_all.segment1%TYPE;

1387: l_project_id pa_projects_all.project_id%TYPE;
1388: l_url VARCHAR2(2000);
1389: l_act_url VARCHAR2(2000);
1390: l_project_name pa_projects_all.name%TYPE;
1391: l_project_number pa_projects_all.segment1%TYPE;
1392: l_customer pa_project_lists_v.customer_name%TYPE;
1393: l_project_manager pa_project_lists_v.person_name%TYPE;
1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1395: l_owner_id pa_control_items.owner_id%TYPE;