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_CA_CITY_PKG dependencies on PAY_US_ZIP_CODES

Line 69: l_zip_start pay_us_zip_codes.zip_start%TYPE;

65: ) is
66:
67: -- Define Local Variables to hold local information
68:
69: l_zip_start pay_us_zip_codes.zip_start%TYPE;
70: l_zip_end pay_us_zip_codes.zip_end%TYPE;
71: l_st_code pay_us_states.state_code%TYPE;
72: l_st_abbrev pay_us_states.state_abbrev%TYPE;
73: l_state_Name pay_us_states.state_name%TYPE;

Line 70: l_zip_end pay_us_zip_codes.zip_end%TYPE;

66:
67: -- Define Local Variables to hold local information
68:
69: l_zip_start pay_us_zip_codes.zip_start%TYPE;
70: l_zip_end pay_us_zip_codes.zip_end%TYPE;
71: l_st_code pay_us_states.state_code%TYPE;
72: l_st_abbrev pay_us_states.state_abbrev%TYPE;
73: l_state_Name pay_us_states.state_name%TYPE;
74: l_county_code pay_us_counties.county_code%TYPE;

Line 186: insert into pay_us_zip_codes

182: 'Y',
183: p_disable);
184:
185:
186: insert into pay_us_zip_codes
187: (zip_start,
188: zip_end,
189: state_code,
190: county_code,

Line 263: l_zip_start pay_us_zip_codes.zip_start%TYPE;

259: l_n_ci_code number := 0;
260: l_max_ci_code number := 0;
261: l_n_ci_name number := 0;
262:
263: l_zip_start pay_us_zip_codes.zip_start%TYPE;
264: l_zip_end pay_us_zip_codes.zip_end%TYPE;
265: l_st_code pay_us_states.state_code%TYPE;
266: l_st_abbrev pay_us_states.state_abbrev%TYPE;
267: l_stateName pay_us_states.state_name%TYPE;

Line 264: l_zip_end pay_us_zip_codes.zip_end%TYPE;

260: l_max_ci_code number := 0;
261: l_n_ci_name number := 0;
262:
263: l_zip_start pay_us_zip_codes.zip_start%TYPE;
264: l_zip_end pay_us_zip_codes.zip_end%TYPE;
265: l_st_code pay_us_states.state_code%TYPE;
266: l_st_abbrev pay_us_states.state_abbrev%TYPE;
267: l_stateName pay_us_states.state_name%TYPE;
268: l_co_code pay_us_counties.county_code%TYPE;

Line 285: FROM pay_us_zip_codes zc

281: zc.county_code,
282: zc.city_code,
283: zc.zip_start,
284: zc.zip_end
285: FROM pay_us_zip_codes zc
286: WHERE zc.state_code = l_st_code
287: AND zc.county_code = l_co_code
288: AND zc.city_code = l_ci_code
289: AND (l_zip_start BETWEEN zc.zip_start AND zc.zip_end

Line 409: insert into pay_us_zip_codes

405: values
406: (l_st_code, l_co_code, l_ci_code);
407: hr_utility.trace ('Inserted a geocode.');
408:
409: insert into pay_us_zip_codes
410: (zip_start, zip_end, state_code, county_code, city_code)
411: values
412: (p_zi_start, p_zi_end, l_st_code, l_co_code, l_ci_code);
413: hr_utility.trace ('Inserted a zip code.');

Line 441: DELETE FROM pay_us_zip_codes

437: IF zip_exist_rec.zip_end > l_zip_end THEN
438: l_zip_end := zip_exist_rec.zip_end;
439: END IF;
440:
441: DELETE FROM pay_us_zip_codes
442: WHERE zip_start = zip_exist_rec.zip_start
443: AND zip_end = zip_exist_rec.zip_end
444: AND state_code = zip_exist_rec.state_code
445: AND county_code = zip_exist_rec.county_code

Line 451: INSERT INTO pay_us_zip_codes

447:
448: END LOOP;
449: CLOSE zip_exist_c;
450:
451: INSERT INTO pay_us_zip_codes
452: (ZIP_START, ZIP_END, STATE_CODE, COUNTY_CODE, CITY_CODE)
453: VALUES
454: (l_zip_start,l_zip_end,l_st_code,l_co_code,l_ci_code);
455: hr_utility.trace ('Inserted a new zip code for an existing city.');

Line 505: l_zip_start pay_us_zip_codes.zip_start%TYPE;

501:
502: --
503: --
504: --
505: l_zip_start pay_us_zip_codes.zip_start%TYPE;
506: l_zip_end pay_us_zip_codes.zip_end%TYPE;
507:
508: CURSOR C IS SELECT rowid FROM pay_us_zip_codes
509: WHERE state_code = p_state_code

Line 506: l_zip_end pay_us_zip_codes.zip_end%TYPE;

502: --
503: --
504: --
505: l_zip_start pay_us_zip_codes.zip_start%TYPE;
506: l_zip_end pay_us_zip_codes.zip_end%TYPE;
507:
508: CURSOR C IS SELECT rowid FROM pay_us_zip_codes
509: WHERE state_code = p_state_code
510: AND county_code= p_county_code

Line 508: CURSOR C IS SELECT rowid FROM pay_us_zip_codes

504: --
505: l_zip_start pay_us_zip_codes.zip_start%TYPE;
506: l_zip_end pay_us_zip_codes.zip_end%TYPE;
507:
508: CURSOR C IS SELECT rowid FROM pay_us_zip_codes
509: WHERE state_code = p_state_code
510: AND county_code= p_county_code
511: AND city_code = p_city_code
512: AND zip_start = l_zip_start

Line 603: CURSOR C IS SELECT * FROM pay_us_zip_codes

599: p_city_name VARCHAR2,
600: p_zip_start VARCHAR2,
601: p_zip_end VARCHAR2) IS
602: --
603: CURSOR C IS SELECT * FROM pay_us_zip_codes
604: WHERE rowid = p_zprowid FOR UPDATE of zip_start NOWAIT ;
605: --
606: CURSOR C2 IS SELECT * FROM pay_us_city_names
607: WHERE rowid = p_cirowid FOR UPDATE OF city_name NOWAIT;

Line 707: UPDATE pay_us_zip_codes

703: --
704: -- The appropriate tables need to be locked during the updating process.
705: --
706: --
707: UPDATE pay_us_zip_codes
708: SET zip_start = p_zip_start,
709: zip_end = p_zip_end
710: WHERE rowid = p_zprowid;
711: --

Line 760: -- Deleting from the pay_us_zip_codes table.

756: BEGIN
757: --
758: --
759: --
760: -- Deleting from the pay_us_zip_codes table.
761: --
762: DELETE FROM pay_us_zip_codes
763: WHERE rowid = p_zprowid;
764:

Line 762: DELETE FROM pay_us_zip_codes

758: --
759: --
760: -- Deleting from the pay_us_zip_codes table.
761: --
762: DELETE FROM pay_us_zip_codes
763: WHERE rowid = p_zprowid;
764:
765: SELECT count(a.zip_start)
766: INTO zip_counter

Line 767: FROM pay_us_zip_codes a,

763: WHERE rowid = p_zprowid;
764:
765: SELECT count(a.zip_start)
766: INTO zip_counter
767: FROM pay_us_zip_codes a,
768: pay_us_city_names b
769: WHERE b.rowid = p_cirowid
770: AND a.city_code = b.city_code
771: AND a.county_code = b.county_code