eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_CITY_PKG dependencies on PAY_US_ZIP_CODES

Line 119: l_zip_start pay_us_zip_codes.zip_start%TYPE;

115: ) is
116:
117: -- Define Local Variables to hold local information
118:
119: l_zip_start pay_us_zip_codes.zip_start%TYPE;
120: l_zip_end pay_us_zip_codes.zip_end%TYPE;
121: l_st_code pay_us_states.state_code%TYPE;
122: l_st_abbrev pay_us_states.state_abbrev%TYPE;
123: l_state_Name pay_us_states.state_name%TYPE;

Line 120: l_zip_end pay_us_zip_codes.zip_end%TYPE;

116:
117: -- Define Local Variables to hold local information
118:
119: l_zip_start pay_us_zip_codes.zip_start%TYPE;
120: l_zip_end pay_us_zip_codes.zip_end%TYPE;
121: l_st_code pay_us_states.state_code%TYPE;
122: l_st_abbrev pay_us_states.state_abbrev%TYPE;
123: l_state_Name pay_us_states.state_name%TYPE;
124: l_county_code pay_us_counties.county_code%TYPE;

Line 236: insert into pay_us_zip_codes

232: 'Y',
233: p_disable);
234:
235:
236: insert into pay_us_zip_codes
237: (zip_start,
238: zip_end,
239: state_code,
240: county_code,

Line 313: l_zip_start pay_us_zip_codes.zip_start%TYPE;

309: l_n_ci_code number := 0;
310: l_max_ci_code number := 0;
311: l_n_ci_name number := 0;
312:
313: l_zip_start pay_us_zip_codes.zip_start%TYPE;
314: l_zip_end pay_us_zip_codes.zip_end%TYPE;
315: l_st_code pay_us_states.state_code%TYPE;
316: l_st_abbrev pay_us_states.state_abbrev%TYPE;
317: l_stateName pay_us_states.state_name%TYPE;

Line 314: l_zip_end pay_us_zip_codes.zip_end%TYPE;

310: l_max_ci_code number := 0;
311: l_n_ci_name number := 0;
312:
313: l_zip_start pay_us_zip_codes.zip_start%TYPE;
314: l_zip_end pay_us_zip_codes.zip_end%TYPE;
315: l_st_code pay_us_states.state_code%TYPE;
316: l_st_abbrev pay_us_states.state_abbrev%TYPE;
317: l_stateName pay_us_states.state_name%TYPE;
318: l_co_code pay_us_counties.county_code%TYPE;

Line 335: FROM pay_us_zip_codes zc

331: zc.county_code,
332: zc.city_code,
333: zc.zip_start,
334: zc.zip_end
335: FROM pay_us_zip_codes zc
336: WHERE zc.state_code = l_st_code
337: AND zc.county_code = l_co_code
338: AND zc.city_code = l_ci_code
339: AND (l_zip_start BETWEEN zc.zip_start AND zc.zip_end

Line 459: insert into pay_us_zip_codes

455: values
456: (l_st_code, l_co_code, l_ci_code);
457: hr_utility.trace ('Inserted a geocode.');
458:
459: insert into pay_us_zip_codes
460: (zip_start, zip_end, state_code, county_code, city_code)
461: values
462: (p_zi_start, p_zi_end, l_st_code, l_co_code, l_ci_code);
463: hr_utility.trace ('Inserted a zip code.');

Line 491: DELETE FROM pay_us_zip_codes

487: IF zip_exist_rec.zip_end > l_zip_end THEN
488: l_zip_end := zip_exist_rec.zip_end;
489: END IF;
490:
491: DELETE FROM pay_us_zip_codes
492: WHERE zip_start = zip_exist_rec.zip_start
493: AND zip_end = zip_exist_rec.zip_end
494: AND state_code = zip_exist_rec.state_code
495: AND county_code = zip_exist_rec.county_code

Line 501: INSERT INTO pay_us_zip_codes

497:
498: END LOOP;
499: CLOSE zip_exist_c;
500:
501: INSERT INTO pay_us_zip_codes
502: (ZIP_START, ZIP_END, STATE_CODE, COUNTY_CODE, CITY_CODE)
503: VALUES
504: (l_zip_start,l_zip_end,l_st_code,l_co_code,l_ci_code);
505: hr_utility.trace ('Inserted a new zip code for an existing city.');

Line 555: l_zip_start pay_us_zip_codes.zip_start%TYPE;

551:
552: --
553: --
554: --
555: l_zip_start pay_us_zip_codes.zip_start%TYPE;
556: l_zip_end pay_us_zip_codes.zip_end%TYPE;
557:
558: CURSOR C IS SELECT rowid FROM pay_us_zip_codes
559: WHERE state_code = p_state_code

Line 556: l_zip_end pay_us_zip_codes.zip_end%TYPE;

552: --
553: --
554: --
555: l_zip_start pay_us_zip_codes.zip_start%TYPE;
556: l_zip_end pay_us_zip_codes.zip_end%TYPE;
557:
558: CURSOR C IS SELECT rowid FROM pay_us_zip_codes
559: WHERE state_code = p_state_code
560: AND county_code= p_county_code

Line 558: CURSOR C IS SELECT rowid FROM pay_us_zip_codes

554: --
555: l_zip_start pay_us_zip_codes.zip_start%TYPE;
556: l_zip_end pay_us_zip_codes.zip_end%TYPE;
557:
558: CURSOR C IS SELECT rowid FROM pay_us_zip_codes
559: WHERE state_code = p_state_code
560: AND county_code= p_county_code
561: AND city_code = p_city_code
562: AND zip_start = l_zip_start

Line 653: CURSOR C IS SELECT * FROM pay_us_zip_codes

649: p_city_name VARCHAR2,
650: p_zip_start VARCHAR2,
651: p_zip_end VARCHAR2) IS
652: --
653: CURSOR C IS SELECT * FROM pay_us_zip_codes
654: WHERE rowid = p_zprowid FOR UPDATE of zip_start NOWAIT ;
655: --
656: CURSOR C2 IS SELECT * FROM pay_us_city_names
657: WHERE rowid = p_cirowid FOR UPDATE OF city_name NOWAIT;

Line 757: UPDATE pay_us_zip_codes

753: --
754: -- The appropriate tables need to be locked during the updating process.
755: --
756: --
757: UPDATE pay_us_zip_codes
758: SET zip_start = p_zip_start,
759: zip_end = p_zip_end
760: WHERE rowid = p_zprowid;
761: --

Line 810: -- Deleting from the pay_us_zip_codes table.

806: BEGIN
807: --
808: --
809: --
810: -- Deleting from the pay_us_zip_codes table.
811: --
812: DELETE FROM pay_us_zip_codes
813: WHERE rowid = p_zprowid;
814:

Line 812: DELETE FROM pay_us_zip_codes

808: --
809: --
810: -- Deleting from the pay_us_zip_codes table.
811: --
812: DELETE FROM pay_us_zip_codes
813: WHERE rowid = p_zprowid;
814:
815: SELECT count(a.zip_start)
816: INTO zip_counter

Line 817: FROM pay_us_zip_codes a,

813: WHERE rowid = p_zprowid;
814:
815: SELECT count(a.zip_start)
816: INTO zip_counter
817: FROM pay_us_zip_codes a,
818: pay_us_city_names b
819: WHERE b.rowid = p_cirowid
820: AND a.city_code = b.city_code
821: AND a.county_code = b.county_code