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 426: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;

422: per_adr_geocode varchar2 -- Parameter /*7238809*/
423: )
424: RETURN NUMBER IS
425:
426: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;
427: l_context_tab pay_balance_pkg.t_context_tab;
428: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
429: l_assignment_id number;
430: l_bal_assact number;

Line 427: l_context_tab pay_balance_pkg.t_context_tab;

423: )
424: RETURN NUMBER IS
425:
426: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;
427: l_context_tab pay_balance_pkg.t_context_tab;
428: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
429: l_assignment_id number;
430: l_bal_assact number;
431: l_payroll_id number;

Line 428: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

424: RETURN NUMBER IS
425:
426: l_defined_balance_tab pay_balance_pkg.t_balance_value_tab;
427: l_context_tab pay_balance_pkg.t_context_tab;
428: l_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
429: l_assignment_id number;
430: l_bal_assact number;
431: l_payroll_id number;
432: l_asg_type varchar2(11) := null;

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

513: l_asg_type := 'PER_PAYROLL';
514:
515: hr_utility.trace('p_regular_aggregate not = 0 asg_type = PER_PAYROLL' );
516:
517: pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);
518:
519: END IF;
520:
521: IF p_fed_or_state = 'FED' THEN

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

522:
523: hr_utility.trace('p_fed_or_state = FED' );
524:
525: -- MAY NEED FOR AGGREGATION.
526: --pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);
527:
528: SELECT creator_id
529: INTO l_defined_balance_tab(1).defined_balance_id
530: FROM ff_user_entities

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

940: l_context_tab(23).source_text := null;
941: l_context_tab(23).source_number := null;
942: l_context_tab(23).source_text2 := null;
943:
944: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
945: p_defined_balance_lst => l_defined_balance_tab,
946: p_context_lst => l_context_tab,
947: p_get_rr_route => FALSE,
948: p_get_rb_route => FALSE,

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

1122: l_context_tab(5).source_text := null;
1123: l_context_tab(5).source_number := null;
1124: l_context_tab(5).source_text2 := null;
1125:
1126: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1127: p_defined_balance_lst => l_defined_balance_tab,
1128: p_context_lst => l_context_tab,
1129: p_get_rr_route => FALSE,
1130: p_get_rb_route => FALSE,

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

1181: l_context_tab(1).source_text := null;
1182: l_context_tab(1).source_number := null;
1183: l_context_tab(1).source_text2 := null;
1184:
1185: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1186: p_defined_balance_lst => l_defined_balance_tab,
1187: p_context_lst => l_context_tab,
1188: p_get_rr_route => FALSE,
1189: p_get_rb_route => FALSE,

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

1218: l_context_tab(1).source_text := null;
1219: l_context_tab(1).source_number := null;
1220: l_context_tab(1).source_text2 := null;
1221:
1222: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1223: p_defined_balance_lst => l_defined_balance_tab,
1224: p_context_lst => l_context_tab,
1225: p_get_rr_route => FALSE,
1226: p_get_rb_route => FALSE,

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

1255: l_context_tab(1).source_text := null;
1256: l_context_tab(1).source_number := null;
1257: l_context_tab(1).source_text2 := null;
1258:
1259: pay_balance_pkg.get_value (p_assignment_action_id => l_bal_assact,
1260: p_defined_balance_lst => l_defined_balance_tab,
1261: p_context_lst => l_context_tab,
1262: p_get_rr_route => FALSE,
1263: p_get_rb_route => FALSE,

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

5088:
5089: hr_utility.trace('EMJT: STATE l_defined_balance_id -> '|| l_defined_balance_id);
5090: hr_utility.trace('EMJT: STATE l_balance_type_id -> '|| l_balance_type_id);
5091:
5092: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5093: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5094: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5095:
5096: l_value := NVL(pay_balance_pkg.get_value

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

5089: hr_utility.trace('EMJT: STATE l_defined_balance_id -> '|| l_defined_balance_id);
5090: hr_utility.trace('EMJT: STATE l_balance_type_id -> '|| l_balance_type_id);
5091:
5092: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5093: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5094: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5095:
5096: l_value := NVL(pay_balance_pkg.get_value
5097: (p_defined_balance_id => l_defined_balance_id

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

5090: hr_utility.trace('EMJT: STATE l_balance_type_id -> '|| l_balance_type_id);
5091:
5092: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5093: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5094: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5095:
5096: l_value := NVL(pay_balance_pkg.get_value
5097: (p_defined_balance_id => l_defined_balance_id
5098: ,p_assignment_action_id => p_assignment_action_id)

Line 5096: l_value := NVL(pay_balance_pkg.get_value

5092: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5093: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5094: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5095:
5096: l_value := NVL(pay_balance_pkg.get_value
5097: (p_defined_balance_id => l_defined_balance_id
5098: ,p_assignment_action_id => p_assignment_action_id)
5099: ,0);
5100:

Line 5107: l_value := NVL(pay_balance_pkg.get_value

5103: OPEN csr_defined_balance_id('SIT Supp Withheld','_PER_JD_GRE_YTD');
5104: hr_utility.trace('EMJT: Fetching SIT Supp Withheld_PER_JD_GRE_YTD for YTD ');
5105: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
5106: CLOSE csr_defined_balance_id;
5107: l_value := NVL(pay_balance_pkg.get_value
5108: (p_defined_balance_id => l_defined_balance_id
5109: ,p_assignment_action_id => p_assignment_action_id)
5110: ,0);
5111: --}

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

5118: hr_utility.trace('EMJT: Fetching SIT Withheld _PER_JD_GRE_RTD ');
5119: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
5120: CLOSE csr_defined_balance_id;
5121:
5122: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5123: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5124: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5125: l_value := NVL(pay_balance_pkg.get_value
5126: (p_defined_balance_id => l_defined_balance_id

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

5119: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
5120: CLOSE csr_defined_balance_id;
5121:
5122: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5123: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5124: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5125: l_value := NVL(pay_balance_pkg.get_value
5126: (p_defined_balance_id => l_defined_balance_id
5127: ,p_assignment_action_id => p_assignment_action_id)

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

5120: CLOSE csr_defined_balance_id;
5121:
5122: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5123: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5124: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5125: l_value := NVL(pay_balance_pkg.get_value
5126: (p_defined_balance_id => l_defined_balance_id
5127: ,p_assignment_action_id => p_assignment_action_id)
5128: ,0);

Line 5125: l_value := NVL(pay_balance_pkg.get_value

5121:
5122: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5123: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5124: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5125: l_value := NVL(pay_balance_pkg.get_value
5126: (p_defined_balance_id => l_defined_balance_id
5127: ,p_assignment_action_id => p_assignment_action_id)
5128: ,0);
5129:

Line 5137: l_value := NVL(pay_balance_pkg.get_value

5133: hr_utility.trace('EMJT: Fetching SIT Supp Withheld_PER_JD_GRE_RTD for RTD');
5134: FETCH csr_defined_balance_id INTO l_defined_balance_id,l_balance_type_id;
5135: CLOSE csr_defined_balance_id;
5136:
5137: l_value := NVL(pay_balance_pkg.get_value
5138: (p_defined_balance_id => l_defined_balance_id
5139: ,p_assignment_action_id => p_assignment_action_id)
5140: ,0);
5141: --}

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

5158:
5159: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
5160: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
5161:
5162: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5163: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5164: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5165: hr_utility.trace('EMJT: p_threshold_basis = YTD');
5166: l_value := NVL(pay_balance_pkg.get_value

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

5159: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
5160: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
5161:
5162: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5163: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5164: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5165: hr_utility.trace('EMJT: p_threshold_basis = YTD');
5166: l_value := NVL(pay_balance_pkg.get_value
5167: (p_defined_balance_id => l_defined_balance_id

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

5160: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
5161:
5162: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5163: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5164: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5165: hr_utility.trace('EMJT: p_threshold_basis = YTD');
5166: l_value := NVL(pay_balance_pkg.get_value
5167: (p_defined_balance_id => l_defined_balance_id
5168: ,p_assignment_action_id => p_assignment_action_id)

Line 5166: l_value := NVL(pay_balance_pkg.get_value

5162: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5163: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5164: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5165: hr_utility.trace('EMJT: p_threshold_basis = YTD');
5166: l_value := NVL(pay_balance_pkg.get_value
5167: (p_defined_balance_id => l_defined_balance_id
5168: ,p_assignment_action_id => p_assignment_action_id)
5169: ,0);
5170:

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

5179:
5180: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
5181: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
5182:
5183: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5184: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5185: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5186: l_value := NVL(pay_balance_pkg.get_value
5187: (p_defined_balance_id => l_defined_balance_id

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

5180: hr_utility.trace('EMJT: COUNTY l_defined_balance_id -> '|| l_defined_balance_id);
5181: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
5182:
5183: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5184: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5185: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5186: l_value := NVL(pay_balance_pkg.get_value
5187: (p_defined_balance_id => l_defined_balance_id
5188: ,p_assignment_action_id => p_assignment_action_id)

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

5181: hr_utility.trace('EMJT: COUNTY l_balance_type_id -> '|| l_balance_type_id);
5182:
5183: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5184: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5185: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5186: l_value := NVL(pay_balance_pkg.get_value
5187: (p_defined_balance_id => l_defined_balance_id
5188: ,p_assignment_action_id => p_assignment_action_id)
5189: ,0);

Line 5186: l_value := NVL(pay_balance_pkg.get_value

5182:
5183: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5184: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5185: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5186: l_value := NVL(pay_balance_pkg.get_value
5187: (p_defined_balance_id => l_defined_balance_id
5188: ,p_assignment_action_id => p_assignment_action_id)
5189: ,0);
5190: --}

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

5206:
5207: hr_utility.trace('EMJT: CITY l_defined_balance_id -> '|| l_defined_balance_id);
5208: hr_utility.trace('EMJT: CITY l_balance_type_id -> '|| l_balance_type_id);
5209:
5210: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5211: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5212: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5213:
5214: l_value := NVL(pay_balance_pkg.get_value

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

5207: hr_utility.trace('EMJT: CITY l_defined_balance_id -> '|| l_defined_balance_id);
5208: hr_utility.trace('EMJT: CITY l_balance_type_id -> '|| l_balance_type_id);
5209:
5210: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5211: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5212: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5213:
5214: l_value := NVL(pay_balance_pkg.get_value
5215: (p_defined_balance_id => l_defined_balance_id

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

5208: hr_utility.trace('EMJT: CITY l_balance_type_id -> '|| l_balance_type_id);
5209:
5210: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5211: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5212: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5213:
5214: l_value := NVL(pay_balance_pkg.get_value
5215: (p_defined_balance_id => l_defined_balance_id
5216: ,p_assignment_action_id => p_assignment_action_id)

Line 5214: l_value := NVL(pay_balance_pkg.get_value

5210: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5211: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5212: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5213:
5214: l_value := NVL(pay_balance_pkg.get_value
5215: (p_defined_balance_id => l_defined_balance_id
5216: ,p_assignment_action_id => p_assignment_action_id)
5217: ,0);
5218:

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

5228:
5229: hr_utility.trace('EMJT: CITY RTD l_defined_balance_id -> '|| l_defined_balance_id);
5230: hr_utility.trace('EMJT: CITY RTD l_balance_type_id -> '|| l_balance_type_id);
5231:
5232: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5233: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5234: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5235:
5236: l_value := NVL(pay_balance_pkg.get_value

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

5229: hr_utility.trace('EMJT: CITY RTD l_defined_balance_id -> '|| l_defined_balance_id);
5230: hr_utility.trace('EMJT: CITY RTD l_balance_type_id -> '|| l_balance_type_id);
5231:
5232: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5233: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5234: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5235:
5236: l_value := NVL(pay_balance_pkg.get_value
5237: (p_defined_balance_id => l_defined_balance_id

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

5230: hr_utility.trace('EMJT: CITY RTD l_balance_type_id -> '|| l_balance_type_id);
5231:
5232: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5233: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5234: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5235:
5236: l_value := NVL(pay_balance_pkg.get_value
5237: (p_defined_balance_id => l_defined_balance_id
5238: ,p_assignment_action_id => p_assignment_action_id)

Line 5236: l_value := NVL(pay_balance_pkg.get_value

5232: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
5233: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
5234: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jurisdiction_code);
5235:
5236: l_value := NVL(pay_balance_pkg.get_value
5237: (p_defined_balance_id => l_defined_balance_id
5238: ,p_assignment_action_id => p_assignment_action_id)
5239: ,0);
5240: