APPS.PA_CAPITAL_EVENTS_PVT dependencies on PA_PROJECTS_ALL

Line 42: v_project_number pa_projects_all.segment1%TYPE;

38: v_null_rowid ROWID := NULL;
39: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
40: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
41:
42: v_project_number pa_projects_all.segment1%TYPE;
43: v_ret_assets_count NUMBER := 0;
44: v_ret_tasks_count NUMBER := 0;
45: v_return_status VARCHAR2(1);
46: v_msg_data VARCHAR2(2000);

Line 370: FROM pa_projects_all

366: IF p_project_id IS NOT NULL THEN
367:
368: SELECT segment1
369: INTO v_project_number
370: FROM pa_projects_all
371: WHERE project_id = p_project_id;
372:
373:
374: INSERT INTO pa_cap_event_creation_v

Line 842: v_project_number pa_projects_all.segment1%TYPE;

838: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
839: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
840:
841: v_common_project VARCHAR2(1);
842: v_project_number pa_projects_all.segment1%TYPE;
843: v_print_project_number pa_projects_all.segment1%TYPE;
844: v_addtl_costs_or_assets VARCHAR2(1);
845: v_first_addtl VARCHAR2(1);
846: v_event_number pa_capital_events.capital_event_number%TYPE;

Line 843: v_print_project_number pa_projects_all.segment1%TYPE;

839: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
840:
841: v_common_project VARCHAR2(1);
842: v_project_number pa_projects_all.segment1%TYPE;
843: v_print_project_number pa_projects_all.segment1%TYPE;
844: v_addtl_costs_or_assets VARCHAR2(1);
845: v_first_addtl VARCHAR2(1);
846: v_event_number pa_capital_events.capital_event_number%TYPE;
847: v_new_event_id pa_capital_events.capital_event_id%TYPE := NULL;