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.HR_US_FF_UDF1 dependencies on PAY_BALANCE_PKG

Line 385: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;

381: per_adr_geocode varchar2 -- Parameter /*7238809*/
382: )
383: RETURN NUMBER IS
384:
385: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;
386: l_context_tab pay_balance_pkg.t_context_tab;
387: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
388: l_assignment_id number;
389: l_bal_assact number;

Line 386: l_context_tab pay_balance_pkg.t_context_tab;

382: )
383: RETURN NUMBER IS
384:
385: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;
386: l_context_tab pay_balance_pkg.t_context_tab;
387: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
388: l_assignment_id number;
389: l_bal_assact number;
390: l_payroll_id number;

Line 387: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

383: RETURN NUMBER IS
384:
385: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;
386: l_context_tab pay_balance_pkg.t_context_tab;
387: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
388: l_assignment_id number;
389: l_bal_assact number;
390: l_payroll_id number;
391: l_asg_type varchar2(11) := null;

Line 476: pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);

472: l_asg_type := 'PER_PAYROLL';
473:
474: hr_utility.trace('p_regular_aggregate not = 0 asg_type = PER_PAYROLL' );
475:
476: pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);
477:
478: END IF;
479:
480: IF p_fed_or_state = 'FED' THEN

Line 485: --pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);

481:
482: hr_utility.trace('p_fed_or_state = FED' );
483:
484: -- MAY NEED FOR AGGREGATION.
485: --pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);
486:
487: SELECT creator_id
488: INTO l_defined_balance_tab(1).defined_balance_id
489: FROM ff_user_entities

Line 903: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,

899: l_context_tab(23).source_text := null;
900: l_context_tab(23).source_number := null;
901: l_context_tab(23).source_text2 := null;
902:
903: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
904: p_defined_balance_lst => l_defined_balance_tab,
905: p_context_lst => l_context_tab,
906: p_get_rr_route => FALSE,
907: p_get_rb_route => FALSE,

Line 1085: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,

1081: l_context_tab(5).source_text := null;
1082: l_context_tab(5).source_number := null;
1083: l_context_tab(5).source_text2 := null;
1084:
1085: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1086: p_defined_balance_lst => l_defined_balance_tab,
1087: p_context_lst => l_context_tab,
1088: p_get_rr_route => FALSE,
1089: p_get_rb_route => FALSE,

Line 1144: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,

1140: l_context_tab(1).source_text := null;
1141: l_context_tab(1).source_number := null;
1142: l_context_tab(1).source_text2 := null;
1143:
1144: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1145: p_defined_balance_lst => l_defined_balance_tab,
1146: p_context_lst => l_context_tab,
1147: p_get_rr_route => FALSE,
1148: p_get_rb_route => FALSE,

Line 1181: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,

1177: l_context_tab(1).source_text := null;
1178: l_context_tab(1).source_number := null;
1179: l_context_tab(1).source_text2 := null;
1180:
1181: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1182: p_defined_balance_lst => l_defined_balance_tab,
1183: p_context_lst => l_context_tab,
1184: p_get_rr_route => FALSE,
1185: p_get_rb_route => FALSE,

Line 1218: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,

1214: l_context_tab(1).source_text := null;
1215: l_context_tab(1).source_number := null;
1216: l_context_tab(1).source_text2 := null;
1217:
1218: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1219: p_defined_balance_lst => l_defined_balance_tab,
1220: p_context_lst => l_context_tab,
1221: p_get_rr_route => FALSE,
1222: p_get_rb_route => FALSE,

Line 4905: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

4901:
4902: hr_utility.trace('EMJT: STATE l_defined_balance_id -> '|| l_defined_balance_id);
4903: hr_utility.trace('EMJT: STATE l_balance_type_id -> '|| l_balance_type_id);
4904:
4905: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4906: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4907: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4908:
4909: l_value := NVL(pay_balance_pkg.get_value

Line 4906: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

4902: hr_utility.trace('EMJT: STATE l_defined_balance_id -> '|| l_defined_balance_id);
4903: hr_utility.trace('EMJT: STATE l_balance_type_id -> '|| l_balance_type_id);
4904:
4905: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4906: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4907: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4908:
4909: l_value := NVL(pay_balance_pkg.get_value
4910: (p_defined_balance_id => l_defined_balance_id

Line 4907: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);

4903: hr_utility.trace('EMJT: STATE l_balance_type_id -> '|| l_balance_type_id);
4904:
4905: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4906: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4907: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4908:
4909: l_value := NVL(pay_balance_pkg.get_value
4910: (p_defined_balance_id => l_defined_balance_id
4911: ,p_assignment_action_id => p_assignment_action_id)

Line 4909: l_value := NVL(pay_balance_pkg.get_value

4905: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4906: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4907: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4908:
4909: l_value := NVL(pay_balance_pkg.get_value
4910: (p_defined_balance_id => l_defined_balance_id
4911: ,p_assignment_action_id => p_assignment_action_id)
4912: ,0);
4913:

Line 4920: l_value := NVL(pay_balance_pkg.get_value

4916: OPEN csr_defined_balance_id('SIT Supp Withheld','_PER_JD_GRE_YTD');
4917: hr_utility.trace('EMJT: Fetching SIT Supp Withheld_PER_JD_GRE_YTD for YTD ');
4918: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
4919: CLOSE csr_defined_balance_id;
4920: l_value := NVL(pay_balance_pkg.get_value
4921: (p_defined_balance_id => l_defined_balance_id
4922: ,p_assignment_action_id => p_assignment_action_id)
4923: ,0);
4924: --}

Line 4935: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

4931: hr_utility.trace('EMJT: Fetching SIT Withheld _PER_JD_GRE_RTD ');
4932: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
4933: CLOSE csr_defined_balance_id;
4934:
4935: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4936: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4937: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4938: l_value := NVL(pay_balance_pkg.get_value
4939: (p_defined_balance_id => l_defined_balance_id

Line 4936: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

4932: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
4933: CLOSE csr_defined_balance_id;
4934:
4935: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4936: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4937: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4938: l_value := NVL(pay_balance_pkg.get_value
4939: (p_defined_balance_id => l_defined_balance_id
4940: ,p_assignment_action_id => p_assignment_action_id)

Line 4937: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);

4933: CLOSE csr_defined_balance_id;
4934:
4935: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4936: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4937: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4938: l_value := NVL(pay_balance_pkg.get_value
4939: (p_defined_balance_id => l_defined_balance_id
4940: ,p_assignment_action_id => p_assignment_action_id)
4941: ,0);

Line 4938: l_value := NVL(pay_balance_pkg.get_value

4934:
4935: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4936: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4937: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4938: l_value := NVL(pay_balance_pkg.get_value
4939: (p_defined_balance_id => l_defined_balance_id
4940: ,p_assignment_action_id => p_assignment_action_id)
4941: ,0);
4942:

Line 4950: l_value := NVL(pay_balance_pkg.get_value

4946: hr_utility.trace('EMJT: Fetching SIT Supp Withheld_PER_JD_GRE_RTD for RTD');
4947: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
4948: CLOSE csr_defined_balance_id;
4949:
4950: l_value := NVL(pay_balance_pkg.get_value
4951: (p_defined_balance_id => l_defined_balance_id
4952: ,p_assignment_action_id => p_assignment_action_id)
4953: ,0);
4954: --}

Line 4975: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

4971:
4972: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
4973: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
4974:
4975: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4976: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4977: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4978: hr_utility.trace('EMJT: p_threshold_basis = YTD');
4979: l_value := NVL(pay_balance_pkg.get_value

Line 4976: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

4972: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
4973: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
4974:
4975: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4976: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4977: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4978: hr_utility.trace('EMJT: p_threshold_basis = YTD');
4979: l_value := NVL(pay_balance_pkg.get_value
4980: (p_defined_balance_id => l_defined_balance_id

Line 4977: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);

4973: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
4974:
4975: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4976: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4977: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4978: hr_utility.trace('EMJT: p_threshold_basis = YTD');
4979: l_value := NVL(pay_balance_pkg.get_value
4980: (p_defined_balance_id => l_defined_balance_id
4981: ,p_assignment_action_id => p_assignment_action_id)

Line 4979: l_value := NVL(pay_balance_pkg.get_value

4975: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4976: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4977: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4978: hr_utility.trace('EMJT: p_threshold_basis = YTD');
4979: l_value := NVL(pay_balance_pkg.get_value
4980: (p_defined_balance_id => l_defined_balance_id
4981: ,p_assignment_action_id => p_assignment_action_id)
4982: ,0);
4983:

Line 4996: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

4992:
4993: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
4994: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
4995:
4996: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4997: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4998: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4999: l_value := NVL(pay_balance_pkg.get_value
5000: (p_defined_balance_id => l_defined_balance_id

Line 4997: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

4993: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
4994: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
4995:
4996: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4997: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4998: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4999: l_value := NVL(pay_balance_pkg.get_value
5000: (p_defined_balance_id => l_defined_balance_id
5001: ,p_assignment_action_id => p_assignment_action_id)

Line 4998: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);

4994: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
4995:
4996: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4997: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4998: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4999: l_value := NVL(pay_balance_pkg.get_value
5000: (p_defined_balance_id => l_defined_balance_id
5001: ,p_assignment_action_id => p_assignment_action_id)
5002: ,0);

Line 4999: l_value := NVL(pay_balance_pkg.get_value

4995:
4996: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4997: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
4998: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
4999: l_value := NVL(pay_balance_pkg.get_value
5000: (p_defined_balance_id => l_defined_balance_id
5001: ,p_assignment_action_id => p_assignment_action_id)
5002: ,0);
5003: --}

Line 5023: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

5019:
5020: hr_utility.trace('EMJT: CITY l_defined_balance_id -> '|| l_defined_balance_id);
5021: hr_utility.trace('EMJT: CITY l_balance_type_id -> '|| l_balance_type_id);
5022:
5023: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5024: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5025: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5026:
5027: l_value := NVL(pay_balance_pkg.get_value

Line 5024: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

5020: hr_utility.trace('EMJT: CITY l_defined_balance_id -> '|| l_defined_balance_id);
5021: hr_utility.trace('EMJT: CITY l_balance_type_id -> '|| l_balance_type_id);
5022:
5023: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5024: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5025: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5026:
5027: l_value := NVL(pay_balance_pkg.get_value
5028: (p_defined_balance_id => l_defined_balance_id

Line 5025: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);

5021: hr_utility.trace('EMJT: CITY l_balance_type_id -> '|| l_balance_type_id);
5022:
5023: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5024: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5025: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5026:
5027: l_value := NVL(pay_balance_pkg.get_value
5028: (p_defined_balance_id => l_defined_balance_id
5029: ,p_assignment_action_id => p_assignment_action_id)

Line 5027: l_value := NVL(pay_balance_pkg.get_value

5023: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5024: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5025: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5026:
5027: l_value := NVL(pay_balance_pkg.get_value
5028: (p_defined_balance_id => l_defined_balance_id
5029: ,p_assignment_action_id => p_assignment_action_id)
5030: ,0);
5031:

Line 5045: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

5041:
5042: hr_utility.trace('EMJT: CITY RTD l_defined_balance_id -> '|| l_defined_balance_id);
5043: hr_utility.trace('EMJT: CITY RTD l_balance_type_id -> '|| l_balance_type_id);
5044:
5045: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5046: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5047: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5048:
5049: l_value := NVL(pay_balance_pkg.get_value

Line 5046: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

5042: hr_utility.trace('EMJT: CITY RTD l_defined_balance_id -> '|| l_defined_balance_id);
5043: hr_utility.trace('EMJT: CITY RTD l_balance_type_id -> '|| l_balance_type_id);
5044:
5045: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5046: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5047: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5048:
5049: l_value := NVL(pay_balance_pkg.get_value
5050: (p_defined_balance_id => l_defined_balance_id

Line 5047: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);

5043: hr_utility.trace('EMJT: CITY RTD l_balance_type_id -> '|| l_balance_type_id);
5044:
5045: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5046: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5047: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5048:
5049: l_value := NVL(pay_balance_pkg.get_value
5050: (p_defined_balance_id => l_defined_balance_id
5051: ,p_assignment_action_id => p_assignment_action_id)

Line 5049: l_value := NVL(pay_balance_pkg.get_value

5045: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5046: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5047: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5048:
5049: l_value := NVL(pay_balance_pkg.get_value
5050: (p_defined_balance_id => l_defined_balance_id
5051: ,p_assignment_action_id => p_assignment_action_id)
5052: ,0);
5053: