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_EMP_TAX_RULES_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 25: of US employee tax rule using PER_ASSIGNMENT_EXTRA_INFO

21:
22: Name : pay_us_emp_tax_rules_pkg
23:
24: Description : This package holds building blocks used in maintenace
25: of US employee tax rule using PER_ASSIGNMENT_EXTRA_INFO
26: table.
27:
28: Uses : hr_utility
29:

Line 176: per_assignment_extra_information records

172: it checks that a vertex element entry
173: of the same jurisdiction does not exist
174: prior to inserting. Previously this
175: validation was done on the
176: per_assignment_extra_information records
177: only.
178: 07-NOV-97 lwthomps 40.36 Added additional erroring for
179: invalid resident address and
180: existence of tax records. If

Line 235: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENT_EXTRA_INFO

231: X_time varchar2(20);
232: x_other_sd VARCHAR2(20);
233: X_sd_rowid VARCHAR2(30);
234: --
235: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENT_EXTRA_INFO
236: WHERE assignment_extra_info_id = X_Assignment_Extra_Info_Id;
237: --
238: CURSOR C2 IS SELECT per_assignment_extra_info_s.nextval FROM sys.dual;
239: --

Line 238: CURSOR C2 IS SELECT per_assignment_extra_info_s.nextval FROM sys.dual;

234: --
235: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENT_EXTRA_INFO
236: WHERE assignment_extra_info_id = X_Assignment_Extra_Info_Id;
237: --
238: CURSOR C2 IS SELECT per_assignment_extra_info_s.nextval FROM sys.dual;
239: --
240: -- Because of how we report school tax balances we need to check
241: -- that each local record within a state has a unique SD code
242: --

Line 245: FROM per_assignment_extra_info

241: -- that each local record within a state has a unique SD code
242: --
243: CURSOR check_sd IS
244: SELECT rowid
245: FROM per_assignment_extra_info
246: WHERE assignment_id = X_Assignment_Id
247: AND aei_information9 IS NOT NULL
248: AND Information_type = 'LOCALITY'
249: AND aei_information9 = X_Aei_Information9

Line 277: INSERT INTO PER_ASSIGNMENT_EXTRA_INFO(

273:
274: OPEN check_sd;
275:
276: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',4);
277: INSERT INTO PER_ASSIGNMENT_EXTRA_INFO(
278: creation_date,
279: created_by,
280: last_update_date,
281: last_updated_by,

Line 430: FROM PER_ASSIGNMENT_EXTRA_INFO

426: ) IS
427: --
428: CURSOR C IS
429: SELECT *
430: FROM PER_ASSIGNMENT_EXTRA_INFO
431: WHERE rowid = X_Rowid
432: FOR UPDATE of Assignment_Extra_Info_Id NOWAIT;
433: --
434: Recinfo C%ROWTYPE;

Line 583: FROM per_assignment_extra_info

579: X_sd_rowid VARCHAR2(30);
580: --
581: CURSOR check_sd IS
582: SELECT rowid
583: FROM per_assignment_extra_info
584: WHERE assignment_id = X_Assignment_Id
585: AND X_Aei_Information9 IS NOT NULL
586: AND Information_type = 'LOCALITY'
587: AND aei_information9 = X_Aei_Information9

Line 596: UPDATE PER_ASSIGNMENT_EXTRA_INFO

592: --
593: X_User_Id := FND_PROFILE.Value('USER_ID');
594: X_Login_Id := FND_PROFILE.Value('LOGIN_ID');
595: --
596: UPDATE PER_ASSIGNMENT_EXTRA_INFO
597: SET
598: last_updated_by = X_User_Id,
599: last_update_login = X_Login_Id,
600: aei_information1 = X_Aei_Information1,

Line 683: DELETE FROM PER_ASSIGNMENT_EXTRA_INFO

679: ---------------------- Delete_Row --------------------------------------
680: --
681: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
682: BEGIN
683: DELETE FROM PER_ASSIGNMENT_EXTRA_INFO
684: WHERE rowid = X_Rowid;
685: --
686: if (SQL%NOTFOUND) then
687: RAISE NO_DATA_FOUND;

Line 701: select 1 from PER_ASSIGNMENT_EXTRA_INFO

697: RETURN NUMBER is
698: ret number :=0;
699: --
700: cursor csr_federal is
701: select 1 from PER_ASSIGNMENT_EXTRA_INFO
702: where assignment_id = X_assignment_id
703: and information_type = X_information_type;
704: --
705: cursor csr_state is

Line 706: select 1 from PER_ASSIGNMENT_EXTRA_INFO

702: where assignment_id = X_assignment_id
703: and information_type = X_information_type;
704: --
705: cursor csr_state is
706: select 1 from PER_ASSIGNMENT_EXTRA_INFO
707: where assignment_id = X_assignment_id
708: and information_type = X_information_type
709: and Aei_Information1 = X_state_code;
710: --

Line 712: select 1 from PER_ASSIGNMENT_EXTRA_INFO

708: and information_type = X_information_type
709: and Aei_Information1 = X_state_code;
710: --
711: cursor csr_local is
712: select 1 from PER_ASSIGNMENT_EXTRA_INFO
713: where assignment_id = X_assignment_id
714: and information_type = X_information_type
715: and Aei_Information1 = X_state_code
716: and Aei_Information2 = X_locality_code;

Line 837: from PER_ASSIGNMENT_EXTRA_INFO

833: -- Cursor to check whether tax rules exist
834: --
835: CURSOR csr_check_federal is
836: select 1
837: from PER_ASSIGNMENT_EXTRA_INFO
838: where assignment_id = X_assignment_id
839: and INFORMATION_TYPE = 'FEDERAL';
840: --
841: -- Cursor to check state tax rules exists

Line 845: from PER_ASSIGNMENT_EXTRA_INFO

841: -- Cursor to check state tax rules exists
842: --
843: CURSOR csr_check_state ( P_state varchar2 ) is
844: select 1
845: from PER_ASSIGNMENT_EXTRA_INFO
846: where assignment_id = X_assignment_id
847: and INFORMATION_TYPE = 'STATE'
848: and AEI_INFORMATION1 = P_state;
849: --

Line 854: from PER_ASSIGNMENT_EXTRA_INFO

850: -- Cursor to check state tax rules exists with time in state=100
851: --
852: CURSOR csr_check_state_100 is
853: select ROWID, AEI_INFORMATION1
854: from PER_ASSIGNMENT_EXTRA_INFO
855: where assignment_id = X_assignment_id
856: and INFORMATION_TYPE = 'STATE'
857: and fnd_number.canonical_to_number(AEI_INFORMATION13) = 100;
858: --

Line 864: from PER_ASSIGNMENT_EXTRA_INFO

860: --
861: CURSOR csr_check_local( P_state varchar2,
862: P_local varchar2) is
863: select 1
864: from PER_ASSIGNMENT_EXTRA_INFO
865: where assignment_id = X_assignment_id
866: and INFORMATION_TYPE = 'LOCALITY'
867: and AEI_INFORMATION1 = P_state
868: and AEI_INFORMATION2 = P_local;

Line 1244: from per_assignment_extra_info

1240: l_county_locality_code VARCHAR2(11);
1241: --
1242: CURSOR csr_county_exists (Jurisdiction varchar2) is /* 390941 */
1243: select 1
1244: from per_assignment_extra_info
1245: where assignment_id = P_assignment_id
1246: and aei_information2 = Jurisdiction;
1247:
1248:

Line 2143: from per_assignment_extra_info

2139:
2140: /* Check if county record already exists */
2141: CURSOR csr_county_for_city is
2142: select 1
2143: from per_assignment_extra_info
2144: where assignment_id = P_assignment_id
2145: and aei_information2 = substr(P_jurisdiction,1,6)||'-0000';
2146:
2147: /* Get state abbreviation */

Line 2252: UPDATE per_assignment_extra_info

2248: BEGIN
2249: --
2250: hr_utility.set_location('pay_us_emp_tax_rules_pkg.update_attribute '||p_assignment_id||' '||p_jurisdiction,0);
2251: IF p_attribute_type = 'SCHOOL' THEN
2252: UPDATE per_assignment_extra_info
2253: SET aei_information9 = p_new_value
2254: where rowid = p_rowid;
2255: hr_utility.set_location('pay_us_emp_tax_rules_pkg.update_attribute',1);
2256: --

Line 2259: UPDATE per_assignment_extra_info

2255: hr_utility.set_location('pay_us_emp_tax_rules_pkg.update_attribute',1);
2256: --
2257: ELSIF p_attribute_type = 'PERCENT TIME' THEN
2258: /* for Locality */
2259: UPDATE per_assignment_extra_info
2260: SET aei_information10 = p_new_value
2261: WHERE information_type = 'LOCALITY'
2262: AND aei_information2 = p_jurisdiction
2263: AND assignment_id = p_assignment_id;

Line 2266: UPDATE per_assignment_extra_info

2262: AND aei_information2 = p_jurisdiction
2263: AND assignment_id = p_assignment_id;
2264: --
2265: /* for State */
2266: UPDATE per_assignment_extra_info
2267: SET aei_information13 = p_new_value
2268: WHERE information_type = 'STATE'
2269: AND aei_information1 = p_state_abbrev
2270: AND assignment_id = p_assignment_id;

Line 2274: UPDATE per_assignment_extra_info

2270: AND assignment_id = p_assignment_id;
2271: hr_utility.set_location('pay_us_emp_tax_rules_pkg.update_attribute',2);
2272: --
2273: /* for Federal update the SUI state */
2274: UPDATE per_assignment_extra_info
2275: SET aei_information18 = substr(p_jurisdiction,1,2)||'-000-0000'
2276: WHERE information_type = 'FEDERAL'
2277: AND assignment_id = p_assignment_id;
2278: --

Line 2564: UPDATE per_assignment_extra_info

2560: /* Set all tax records to zero percent time in state */
2561: --
2562: -- Localities
2563: --
2564: UPDATE per_assignment_extra_info
2565: SET aei_information10 = 0
2566: WHERE assignment_id = p_assignment_id
2567: AND INFORMATION_TYPE = 'LOCALITY';
2568: hr_utility.set_location('pay_us_emp_tax_rules_pkg.zero_out',5);

Line 2572: UPDATE per_assignment_extra_info

2568: hr_utility.set_location('pay_us_emp_tax_rules_pkg.zero_out',5);
2569: --
2570: -- States
2571: --
2572: UPDATE per_assignment_extra_info
2573: SET aei_information13 = 0,
2574: aei_information16 = 0 /* Remainder percent */
2575: WHERE assignment_id = p_assignment_id
2576: AND INFORMATION_TYPE = 'STATE';