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_ASG_GEO_PKG dependencies on PAY_ASG_GEO_PKG

Line 1: PACKAGE BODY PAY_ASG_GEO_PKG AS

1: PACKAGE BODY PAY_ASG_GEO_PKG AS
2: -- $Header: pyasgrpt.pkb 120.1 2005/12/07 04:11:19 sackumar noship $
3: -- This packages maintains the table: pay_us_asg_reporting.
4: -- It is called from pyustaxr.pkb, peasgo1t.pkb.
5: --

Line 33: hr_utility.set_location('PAY_ASG_GEO_PKG for: '||p_jurisdiction,10);

29: v_level varchar2(10);
30:
31: BEGIN
32: --
33: hr_utility.set_location('PAY_ASG_GEO_PKG for: '||p_jurisdiction,10);
34: /* First get effective dates and tax_unit_id if it is not passed */
35: --
36: hr_utility.set_location('PAY_ASG_GEO_PKG', 20);
37: FOR cur_rec IN csr_date_and_gre LOOP

Line 36: hr_utility.set_location('PAY_ASG_GEO_PKG', 20);

32: --
33: hr_utility.set_location('PAY_ASG_GEO_PKG for: '||p_jurisdiction,10);
34: /* First get effective dates and tax_unit_id if it is not passed */
35: --
36: hr_utility.set_location('PAY_ASG_GEO_PKG', 20);
37: FOR cur_rec IN csr_date_and_gre LOOP
38:
39: v_tax_unit_id := cur_rec.tax_unit_id;
40: BEGIN/* inner unit */

Line 44: hr_utility.set_location('PAY_ASG_GEO_PKG', 0);

40: BEGIN/* inner unit */
41:
42: --
43: --
44: hr_utility.set_location('PAY_ASG_GEO_PKG', 0);
45: /* Check if an appropriate record already exists */
46: /* If like state see if any record exists in that state*/
47: --
48: IF P_jurisdiction like '%000-0000' THEN

Line 60: hr_utility.set_location('PAY_ASG_GEO_PKG', '1');

56: WHERE assignment_id = P_assignment_id
57: AND P_jurisdiction = substr(jurisdiction_code,1,2)||'-000-0000'
58: AND v_tax_unit_id = tax_unit_id);
59: --
60: hr_utility.set_location('PAY_ASG_GEO_PKG', '1');
61:
62: --
63: /* If like county see if any record for that county already exists*/
64: --

Line 78: hr_utility.set_location('PAY_ASG_GEO_PKG', 2);

74: AND P_jurisdiction = substr(jurisdiction_code,1,6)||'-0000'
75: AND v_tax_unit_id = tax_unit_id);
76: --
77: --
78: hr_utility.set_location('PAY_ASG_GEO_PKG', 2);
79: /* If city make certain it is not already present */
80: --
81: ELSIF length(P_jurisdiction) = 8 THEN
82: v_level := 'School';

Line 104: hr_utility.set_location('PAY_ASG_GEO_PKG', 3);

100: WHERE assignment_id = P_assignment_id
101: AND P_jurisdiction = jurisdiction_code
102: AND v_tax_unit_id = tax_unit_id);
103: --
104: hr_utility.set_location('PAY_ASG_GEO_PKG', 3);
105: --
106: END IF;
107: v_level := 'Federal';
108: --

Line 110: hr_utility.set_location('PAY_ASG_GEO_PKG', 4);

106: END IF;
107: v_level := 'Federal';
108: --
109: /* Update the table if nessesary*/
110: hr_utility.set_location('PAY_ASG_GEO_PKG', 4);
111:
112:
113: EXCEPTION
114: when NO_DATA_FOUND then

Line 116: hr_utility.set_location('PAY_ASG_GEO_PKG', 4);

112:
113: EXCEPTION
114: when NO_DATA_FOUND then
115: /* Update the table if nessesary*/
116: hr_utility.set_location('PAY_ASG_GEO_PKG', 4);
117:
118: IF v_level = 'County' THEN /* look for state to update */
119: UPDATE pay_us_asg_reporting
120: SET jurisdiction_code = P_jurisdiction

Line 124: hr_utility.set_location('PAY_ASG_GEO_PKG', 5);

120: SET jurisdiction_code = P_jurisdiction
121: WHERE assignment_id = P_assignment_id
122: AND v_tax_unit_id = tax_unit_id
123: AND jurisdiction_code = substr(P_jurisdiction,1,2)||'-000-0000';
124: hr_utility.set_location('PAY_ASG_GEO_PKG', 5);
125: ELSIF v_level = 'City' THEN /* look for state or county to update */
126: UPDATE pay_us_asg_reporting
127: SET jurisdiction_code = P_jurisdiction
128: WHERE assignment_id = P_assignment_id

Line 133: hr_utility.set_location('PAY_ASG_GEO_PKG', 6);

129: AND v_tax_unit_id = tax_unit_id
130: AND (jurisdiction_code = substr(P_jurisdiction,1,2)||'-000-0000'
131: OR
132: jurisdiction_code = substr(P_jurisdiction,1,6)||'-0000');
133: hr_utility.set_location('PAY_ASG_GEO_PKG', 6);
134: END IF;
135: IF (SQL%ROWCOUNT = 0 OR v_level = 'State' OR v_level = 'School')
136: AND (P_jurisdiction IS NOT NULL) AND (length(P_jurisdiction) <> 3) THEN
137: INSERT INTO pay_us_asg_reporting

Line 151: hr_utility.set_location('PAY_ASG_GEO_PKG', 7);

147: --
148: END LOOP;
149: --
150: --
151: hr_utility.set_location('PAY_ASG_GEO_PKG', 7);
152: --
153: END;
154: --
155: --

Line 225: PAY_ASG_GEO_PKG.create_asg_geo_row(cur_rec.assignment_id,

221: /* Call create_asg_geo_row for each jurisdiction and taxunit */
222: FOR cur_rec IN csr_city_asg_info LOOP
223: hr_utility.set_location('PAY_US_ASG_RPT', 2);
224: --
225: PAY_ASG_GEO_PKG.create_asg_geo_row(cur_rec.assignment_id,
226: cur_rec.jurisdiction_code,
227: cur_rec.tax_unit_id);
228: --
229: END LOOP;

Line 234: PAY_ASG_GEO_PKG.create_asg_geo_row(cur_rec.assignment_id,

230:
231: FOR cur_rec IN csr_county_asg_info LOOP
232: hr_utility.set_location('PAY_US_ASG_RPT', 2);
233: --
234: PAY_ASG_GEO_PKG.create_asg_geo_row(cur_rec.assignment_id,
235: cur_rec.jurisdiction_code,
236: cur_rec.tax_unit_id);
237: --
238: END LOOP;

Line 243: PAY_ASG_GEO_PKG.create_asg_geo_row(cur_rec.assignment_id,

239:
240: FOR cur_rec IN csr_state_asg_info LOOP
241: hr_utility.set_location('PAY_US_ASG_RPT', 2);
242: --
243: PAY_ASG_GEO_PKG.create_asg_geo_row(cur_rec.assignment_id,
244: cur_rec.jurisdiction_code,
245: cur_rec.tax_unit_id);
246: --
247: END LOOP;

Line 253: END PAY_ASG_GEO_PKG;

249: hr_utility.set_location('PAY_US_ASG_RPT', 3);
250: --
251: END; /* END pay_us_rpt */
252: --
253: END PAY_ASG_GEO_PKG;
254:
255: