APPS.PA_PROJECT_CORE1 dependencies on PA_LOCATIONS

Line 304: l_location_id PA_LOCATIONS.LOCATION_ID%TYPE;

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

Line 1011: pa_locations_pkg.INSERT_ROW

1007: END;
1008:
1009: if l_location_id is null then
1010:
1011: pa_locations_pkg.INSERT_ROW
1012: ( p_CITY => x_city,
1013: p_REGION => x_region,
1014: p_COUNTRY_CODE => x_country_code,
1015: p_CREATION_DATE => sysdate,

Line 1107: pa_locations_pkg.INSERT_ROW(

1103: If l_location_id is null then
1104: /* Commented the below line for bug 2688170 */
1105: /* If l_city is not null and l_region is not null and */
1106: If l_country_code is not null then
1107: pa_locations_pkg.INSERT_ROW(
1108: p_CITY => l_city,
1109: p_REGION => l_region,
1110: p_COUNTRY_CODE => l_country_code,
1111: p_CREATION_DATE => sysdate,