APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_LOCATIONS

Line 119: l_country_code PA_LOCATIONS.COUNTRY_CODE%TYPE;

115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
118: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
119: l_country_code PA_LOCATIONS.COUNTRY_CODE%TYPE;
120: l_region PA_LOCATIONS.REGION%TYPE;
121: l_city PA_LOCATIONS.CITY%TYPE;
122: l_return_status VARCHAR2(1);
123: l_error_msg_code VARCHAR2(250);

Line 120: l_region PA_LOCATIONS.REGION%TYPE;

116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
118: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
119: l_country_code PA_LOCATIONS.COUNTRY_CODE%TYPE;
120: l_region PA_LOCATIONS.REGION%TYPE;
121: l_city PA_LOCATIONS.CITY%TYPE;
122: l_return_status VARCHAR2(1);
123: l_error_msg_code VARCHAR2(250);
124: l_msg_count NUMBER;

Line 121: l_city PA_LOCATIONS.CITY%TYPE;

117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
118: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
119: l_country_code PA_LOCATIONS.COUNTRY_CODE%TYPE;
120: l_region PA_LOCATIONS.REGION%TYPE;
121: l_city PA_LOCATIONS.CITY%TYPE;
122: l_return_status VARCHAR2(1);
123: l_error_msg_code VARCHAR2(250);
124: l_msg_count NUMBER;
125: l_msg_data VARCHAR2(250);

Line 4156: from pa_locations

4152: x_state_region varchar2,
4153: x_city varchar2)
4154: IS
4155: Select location_id
4156: from pa_locations
4157: where country_code = x_country_code
4158: and region = x_state_region
4159: and city = x_city;
4160:

Line 5032: pa_locations_pkg.INSERT_ROW(

5028: x_location_id => x_location_id);
5029:
5030: If x_location_id is null then
5031:
5032: pa_locations_pkg.INSERT_ROW(
5033: p_CITY => x_city_name,
5034: p_REGION => x_region_name,
5035: p_COUNTRY_CODE => x_country_code,
5036: p_CREATION_DATE => sysdate,

Line 5393: pa_locations_pkg.INSERT_ROW(

5389: THEN
5390: pa_debug.debug('Validate_project_info PVT: location
5391: table handler to insert new record');
5392: End if;
5393: pa_locations_pkg.INSERT_ROW(
5394: p_CITY => p_city,
5395: p_REGION => p_state_region,
5396: p_COUNTRY_CODE => x_country_code,
5397: p_CREATION_DATE => sysdate,