APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_US_MODIFIED_GEOCODES

Line 1037: l_state_code hr_h2pi_us_modified_geocodes.state_code%TYPE;

1033:
1034: l_jurisdiction_code hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1036:
1037: l_state_code hr_h2pi_us_modified_geocodes.state_code%TYPE;
1038: l_county_code hr_h2pi_us_modified_geocodes.county_code%TYPE;
1039: l_city_code hr_h2pi_us_modified_geocodes.old_city_code%TYPE;
1040:
1041: --

Line 1038: l_county_code hr_h2pi_us_modified_geocodes.county_code%TYPE;

1034: l_jurisdiction_code hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1036:
1037: l_state_code hr_h2pi_us_modified_geocodes.state_code%TYPE;
1038: l_county_code hr_h2pi_us_modified_geocodes.county_code%TYPE;
1039: l_city_code hr_h2pi_us_modified_geocodes.old_city_code%TYPE;
1040:
1041: --
1042: l_input_value1 hr_h2pi_input_values.input_value_id%Type;

Line 1039: l_city_code hr_h2pi_us_modified_geocodes.old_city_code%TYPE;

1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1036:
1037: l_state_code hr_h2pi_us_modified_geocodes.state_code%TYPE;
1038: l_county_code hr_h2pi_us_modified_geocodes.county_code%TYPE;
1039: l_city_code hr_h2pi_us_modified_geocodes.old_city_code%TYPE;
1040:
1041: --
1042: l_input_value1 hr_h2pi_input_values.input_value_id%Type;
1043: l_input_value2 hr_h2pi_input_values.input_value_id%Type;

Line 1070: FROM hr_h2pi_us_modified_geocodes

1066: CURSOR csr_ud_city_tax_comp(p_state_code VARCHAR2,
1067: p_county_code VARCHAR2,
1068: p_city_code VARCHAR2) IS
1069: SELECT old_city_code
1070: FROM hr_h2pi_us_modified_geocodes
1071: WHERE state_code = p_state_code
1072: AND county_code = p_county_code
1073: AND new_city_code = p_city_code;
1074:

Line 1095: FROM hr_h2pi_us_modified_geocodes_v

1091: CURSOR csr_ed_city_tax_comp(p_state_code VARCHAR2,
1092: p_county_code VARCHAR2,
1093: p_city_code VARCHAR2) IS
1094: SELECT new_city_code
1095: FROM hr_h2pi_us_modified_geocodes_v
1096: WHERE state_code = p_state_code
1097: AND county_code = p_county_code
1098: AND new_city_code = p_city_code;
1099:

Line 1178: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',

1174: hr_utility.set_location(l_proc, 90);
1175: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1176: l_county_code ||
1177: REPLACE(l_city_code,'U',0),
1178: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1179: p_message_level => 'FATAL',
1180: p_message_name => 'HR_289269_USER_CITY_CODE');
1181: -- Message name to be changed.
1182: ELSIF csr_ud_city_tax_comp%FOUND THEN

Line 1187: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',

1183: hr_utility.set_location(l_proc, 100);
1184: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1185: l_county_code ||
1186: REPLACE(l_city_code,'U',0),
1187: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1188: p_message_level => 'FATAL',
1189: p_message_name => 'HR_289236_UD_DATA_REMOVED');
1190: EXIT;
1191: ELSE

Line 1212: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',

1208:
1209: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1210: l_county_code ||
1211: REPLACE(l_city_code,'U',0),
1212: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1213: p_message_level => 'FATAL',
1214: p_message_name => 'HR_289269_USER_CITY_CODE');
1215: ELSIF csr_ed_city_tax_comp%FOUND THEN
1216: hr_h2pi_error.data_error(p_from_id => l_state_code ||

Line 1219: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',

1215: ELSIF csr_ed_city_tax_comp%FOUND THEN
1216: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1217: l_county_code ||
1218: REPLACE(l_city_code,'U',0),
1219: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1220: p_message_level => 'FATAL',
1221: p_message_name => 'HR_289235_ED_DATA_REMOVED');
1222:
1223: EXIT;

Line 1237: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',

1233: EXCEPTION
1234: WHEN e_ed_more_then_two_ver_ahead THEN
1235: hr_utility.set_location(l_proc, 140);
1236: hr_h2pi_error.data_error(p_from_id => '99999',
1237: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1238: p_message_level => 'FATAL',
1239: p_message_name => 'HR_289235_ED_DATA_REMOVED');
1240: --RAISE;
1241: WHEN e_ud_more_then_two_ver_ahead THEN

Line 1244: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',

1240: --RAISE;
1241: WHEN e_ud_more_then_two_ver_ahead THEN
1242: hr_utility.set_location(l_proc, 150);
1243: hr_h2pi_error.data_error(p_from_id => '99999',
1244: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1245: p_message_level => 'FATAL',
1246: p_message_name => 'HR_289235_ED_DATA_REMOVED');
1247: --RAISE;
1248: WHEN MAPPING_ID_MISSING THEN