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_JP_IWHT_ARCH_PKG dependencies on PAY_JP_BALANCE_PKG

Line 410: ln_with_hold_agent := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_ITX_INFO'

406: lc_procedure := gc_package||'get_with_holding_id';
407: hr_utility.set_location('Entering '||lc_procedure,1);
408: END IF;
409: --
410: ln_with_hold_agent := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_ITX_INFO'
411: ,p_input_value_name => 'WITHHOLD_AGENT'
412: ,p_assignment_id => p_assignment_id
413: ,p_effective_date => p_effective_date -- Bug 9044516
414: );

Line 1266: ln_amt := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id,lr_get_assact_bal.assignment_action_id);

1262: FOR lr_get_assact_bal IN lcu_assact_details(lr_emp_rec.assignment_id
1263: ,gr_parameters.business_group_id
1264: )
1265: LOOP
1266: ln_amt := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id,lr_get_assact_bal.assignment_action_id);
1267: ln_term_ded_amt_spc := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id_spc,lr_get_assact_bal.assignment_action_id);
1268:
1269: l_value := 0;
1270:

Line 1267: ln_term_ded_amt_spc := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id_spc,lr_get_assact_bal.assignment_action_id);

1263: ,gr_parameters.business_group_id
1264: )
1265: LOOP
1266: ln_amt := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id,lr_get_assact_bal.assignment_action_id);
1267: ln_term_ded_amt_spc := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id_spc,lr_get_assact_bal.assignment_action_id);
1268:
1269: l_value := 0;
1270:
1271: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY',NULL,'JP')

Line 1271: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY',NULL,'JP')

1267: ln_term_ded_amt_spc := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id_spc,lr_get_assact_bal.assignment_action_id);
1268:
1269: l_value := 0;
1270:
1271: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY',NULL,'JP')
1272: ,lr_get_assact_bal.assignment_action_id),0)
1273: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND',NULL,'JP')
1274: ,lr_get_assact_bal.assignment_action_id),0);
1275:

Line 1273: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND',NULL,'JP')

1269: l_value := 0;
1270:
1271: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY',NULL,'JP')
1272: ,lr_get_assact_bal.assignment_action_id),0)
1273: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND',NULL,'JP')
1274: ,lr_get_assact_bal.assignment_action_id),0);
1275:
1276: IF ln_amt IS NOT NULL THEN
1277: IF l_value > 0 THEN

Line 1293: ln_service_years := pay_jp_balance_pkg.get_result_value_number('TRM_INCOME_DCT','SERVICE_YEARS',ln_term_ass_act_id);

1289: END LOOP;
1290: --
1291: -- Fetching service years
1292: --
1293: ln_service_years := pay_jp_balance_pkg.get_result_value_number('TRM_INCOME_DCT','SERVICE_YEARS',ln_term_ass_act_id);
1294: --
1295: -- Fetching Notification Flag
1296: --
1297: lc_note_submit_flag := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_INFO','SUBMIT_FLAG',lr_emp_rec.assignment_id,ld_date_earned);

Line 1297: lc_note_submit_flag := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_INFO','SUBMIT_FLAG',lr_emp_rec.assignment_id,ld_date_earned);

1293: ln_service_years := pay_jp_balance_pkg.get_result_value_number('TRM_INCOME_DCT','SERVICE_YEARS',ln_term_ass_act_id);
1294: --
1295: -- Fetching Notification Flag
1296: --
1297: lc_note_submit_flag := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_INFO','SUBMIT_FLAG',lr_emp_rec.assignment_id,ld_date_earned);
1298: --
1299: -- Fetching Term_ Withholding Tax Report Infromation
1300: --
1301: IF gb_debug THEN

Line 1307: lc_descfield := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191

1303: hr_utility.set_location('Date Earned = ' || ld_date_earned,10);
1304: --
1305: END IF;
1306: --
1307: lc_descfield := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1308: lc_descfield2 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD2',lr_emp_rec.assignment_id,ld_date_earned);
1309: lc_descfield3 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD3',lr_emp_rec.assignment_id,ld_date_earned);
1310: lc_descfield4 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD4',lr_emp_rec.assignment_id,ld_date_earned);
1311: lc_descfield5 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD5',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191

Line 1308: lc_descfield2 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD2',lr_emp_rec.assignment_id,ld_date_earned);

1304: --
1305: END IF;
1306: --
1307: lc_descfield := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1308: lc_descfield2 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD2',lr_emp_rec.assignment_id,ld_date_earned);
1309: lc_descfield3 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD3',lr_emp_rec.assignment_id,ld_date_earned);
1310: lc_descfield4 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD4',lr_emp_rec.assignment_id,ld_date_earned);
1311: lc_descfield5 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD5',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1312: --

Line 1309: lc_descfield3 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD3',lr_emp_rec.assignment_id,ld_date_earned);

1305: END IF;
1306: --
1307: lc_descfield := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1308: lc_descfield2 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD2',lr_emp_rec.assignment_id,ld_date_earned);
1309: lc_descfield3 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD3',lr_emp_rec.assignment_id,ld_date_earned);
1310: lc_descfield4 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD4',lr_emp_rec.assignment_id,ld_date_earned);
1311: lc_descfield5 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD5',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1312: --
1313: lc_description1 := lc_descfield || lc_descfield2 || lc_descfield3;

Line 1310: lc_descfield4 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD4',lr_emp_rec.assignment_id,ld_date_earned);

1306: --
1307: lc_descfield := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1308: lc_descfield2 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD2',lr_emp_rec.assignment_id,ld_date_earned);
1309: lc_descfield3 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD3',lr_emp_rec.assignment_id,ld_date_earned);
1310: lc_descfield4 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD4',lr_emp_rec.assignment_id,ld_date_earned);
1311: lc_descfield5 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD5',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1312: --
1313: lc_description1 := lc_descfield || lc_descfield2 || lc_descfield3;
1314: lc_description2 := lc_descfield4 || lc_descfield5;

Line 1311: lc_descfield5 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD5',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191

1307: lc_descfield := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1308: lc_descfield2 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD2',lr_emp_rec.assignment_id,ld_date_earned);
1309: lc_descfield3 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD3',lr_emp_rec.assignment_id,ld_date_earned);
1310: lc_descfield4 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD4',lr_emp_rec.assignment_id,ld_date_earned);
1311: lc_descfield5 := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD5',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191
1312: --
1313: lc_description1 := lc_descfield || lc_descfield2 || lc_descfield3;
1314: lc_description2 := lc_descfield4 || lc_descfield5;
1315:

Line 1319: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY_SPC_EXC',NULL,'JP')

1315:
1316: l_value := 0;
1317: lc_description_temp := '';
1318:
1319: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY_SPC_EXC',NULL,'JP')
1320: ,ln_term_ass_act_id),0)
1321: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND_SPC_EXC',NULL,'JP')
1322: ,ln_term_ass_act_id),0);
1323:

Line 1321: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND_SPC_EXC',NULL,'JP')

1317: lc_description_temp := '';
1318:
1319: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY_SPC_EXC',NULL,'JP')
1320: ,ln_term_ass_act_id),0)
1321: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND_SPC_EXC',NULL,'JP')
1322: ,ln_term_ass_act_id),0);
1323:
1324: IF l_value > 0 THEN
1325:

Line 1333: l_yos := nvl(pay_jp_balance_pkg.get_entry_value_number('TRM_SPECIFIC_EXEC','YOS',lr_emp_rec.assignment_id,ld_date_earned),0);

1329: l_allow_str := fnd_message.get;
1330: lc_description_temp := l_allow_str;
1331: END IF;
1332:
1333: l_yos := nvl(pay_jp_balance_pkg.get_entry_value_number('TRM_SPECIFIC_EXEC','YOS',lr_emp_rec.assignment_id,ld_date_earned),0);
1334:
1335: IF l_yos > 0 THEN
1336: fnd_message.set_name('PAY','PAY_JP_TRM_SPC_EXC_YOS');
1337: fnd_message.set_token('NUM',l_yos);

Line 1342: l_st_date := pay_jp_balance_pkg.get_entry_value_date('TRM_SPECIFIC_EXEC','EXC_START_DATE',lr_emp_rec.assignment_id,ld_date_earned);

1338: l_yos_str := fnd_message.get;
1339: lc_description_temp := lc_description_temp || l_yos_str;
1340: END IF;
1341:
1342: l_st_date := pay_jp_balance_pkg.get_entry_value_date('TRM_SPECIFIC_EXEC','EXC_START_DATE',lr_emp_rec.assignment_id,ld_date_earned);
1343: l_end_date := pay_jp_balance_pkg.get_entry_value_date('TRM_SPECIFIC_EXEC','EXC_END_DATE',lr_emp_rec.assignment_id,ld_date_earned);
1344:
1345: IF l_yos > 0 AND l_st_date IS NOT NULL AND l_end_date IS NOT NULL THEN
1346:

Line 1343: l_end_date := pay_jp_balance_pkg.get_entry_value_date('TRM_SPECIFIC_EXEC','EXC_END_DATE',lr_emp_rec.assignment_id,ld_date_earned);

1339: lc_description_temp := lc_description_temp || l_yos_str;
1340: END IF;
1341:
1342: l_st_date := pay_jp_balance_pkg.get_entry_value_date('TRM_SPECIFIC_EXEC','EXC_START_DATE',lr_emp_rec.assignment_id,ld_date_earned);
1343: l_end_date := pay_jp_balance_pkg.get_entry_value_date('TRM_SPECIFIC_EXEC','EXC_END_DATE',lr_emp_rec.assignment_id,ld_date_earned);
1344:
1345: IF l_yos > 0 AND l_st_date IS NOT NULL AND l_end_date IS NOT NULL THEN
1346:
1347: OPEN get_date_string(l_st_date,l_end_date);

Line 1355: l_ovr_yos := nvl(pay_jp_balance_pkg.get_entry_value_number('TRM_SPECIFIC_EXEC','OVR_YOS',lr_emp_rec.assignment_id,ld_date_earned),0);

1351: lc_description_temp := lc_description_temp || '(' || l_date_range_str || ')';
1352:
1353: END IF;
1354:
1355: l_ovr_yos := nvl(pay_jp_balance_pkg.get_entry_value_number('TRM_SPECIFIC_EXEC','OVR_YOS',lr_emp_rec.assignment_id,ld_date_earned),0);
1356:
1357: IF l_ovr_yos > 0 THEN
1358: fnd_message.set_name('PAY','PAY_JP_TRM_SPC_EXC_OVR_YOS');
1359: fnd_message.set_token('NUM',l_ovr_yos);