APPS.PA_PROJECT_CORE1 dependencies on PA_LOCATIONS

Line 300: l_location_id PA_LOCATIONS.LOCATION_ID%TYPE;

296: l_wf_enabled_flag VARCHAR2(1);
297: l_assignment_id NUMBER;
298: l_err_code NUMBER := 0;
299: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
300: l_location_id PA_LOCATIONS.LOCATION_ID%TYPE;
301: l_start_date DATE;
302: l_return_status VARCHAR2(1);
303: l_msg_data VARCHAR2(2000);
304: l_msg_count NUMBER;

Line 999: pa_locations_pkg.INSERT_ROW

995: END;
996:
997: if l_location_id is null then
998:
999: pa_locations_pkg.INSERT_ROW
1000: ( p_CITY => x_city,
1001: p_REGION => x_region,
1002: p_COUNTRY_CODE => x_country_code,
1003: p_CREATION_DATE => sysdate,

Line 1095: pa_locations_pkg.INSERT_ROW(

1091: If l_location_id is null then
1092: /* Commented the below line for bug 2688170 */
1093: /* If l_city is not null and l_region is not null and */
1094: If l_country_code is not null then
1095: pa_locations_pkg.INSERT_ROW(
1096: p_CITY => l_city,
1097: p_REGION => l_region,
1098: p_COUNTRY_CODE => l_country_code,
1099: p_CREATION_DATE => sysdate,