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_ISDF_SS_PKG dependencies on FND_DATE

Line 1494: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));

1490: l_submission_date := check_submission_period(p_action_information_id);
1491: --
1492: if g_debug then
1493: hr_utility.set_location(l_proc,10);
1494: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1495: end if;
1496: --
1497: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1498: --

Line 1610: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));

1606: l_submission_date := check_submission_period(p_action_information_id);
1607: --
1608: if g_debug then
1609: hr_utility.set_location(l_proc,10);
1610: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1611: end if;
1612: --
1613: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1614: --

Line 3118: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));

3114: l_submission_date := check_submission_period(p_action_information_id);
3115: --
3116: if g_debug then
3117: hr_utility.set_location(l_proc,10);
3118: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3119: end if;
3120: --
3121: -- unnecessary to lock
3122: select *

Line 3338: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));

3334: l_submission_date := check_submission_period(p_action_information_id);
3335: --
3336: if g_debug then
3337: hr_utility.set_location(l_proc,10);
3338: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3339: end if;
3340: --
3341: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3342: --

Line 3635: -- p_finalized_date => fnd_date.date_to_canonical(l_submission_date),

3631: --pay_jp_isdf_dml_pkg.update_assact(
3632: -- p_action_information_id => l_assact_rec.assignment_action_id,
3633: -- p_object_version_number => p_object_version_number,
3634: -- p_transaction_status => 'F',
3635: -- p_finalized_date => fnd_date.date_to_canonical(l_submission_date),
3636: -- p_finalized_by => fnd_number.number_to_canonical(fnd_global.user_id),
3637: -- p_user_comments => p_user_comments,
3638: -- p_admin_comments => l_assact_rec.admin_comments,
3639: -- p_transfer_status => l_assact_rec.transfer_status,

Line 3645: finalized_date = fnd_date.date_to_canonical(l_submission_date),

3641: -- p_expiry_date => l_assact_rec.expiry_date);
3642: update pay_jp_isdf_assact_dml_v
3643: set object_version_number = p_object_version_number,
3644: transaction_status = 'F',
3645: finalized_date = fnd_date.date_to_canonical(l_submission_date),
3646: finalized_by = fnd_number.number_to_canonical(fnd_global.user_id),
3647: user_comments = p_user_comments
3648: where row_id = l_assact_rec.row_id;
3649: --

Line 3680: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));

3676: l_submission_date := check_submission_period(p_action_information_id);
3677: --
3678: if g_debug then
3679: hr_utility.set_location(l_proc,10);
3680: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3681: end if;
3682: --
3683: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3684: --

Line 3767: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));

3763: l_submission_date := check_submission_period(p_action_information_id);
3764: --
3765: if g_debug then
3766: hr_utility.set_location(l_proc,10);
3767: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3768: end if;
3769: --
3770: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3771: --

Line 4566: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),

4562: p_information_type => 'JP_ASS_LIG_INFO',
4563: p_aei_information_category => 'JP_ASS_LIG_INFO',
4564: p_aei_information1 => p_rec.gen_ins_class,
4565: p_aei_information2 => p_rec.gen_ins_company_code,
4566: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
4567: p_aei_information4 => '',
4568: p_aei_information5 => p_rec.ins_type,
4569: p_aei_information6 => p_rec.ins_period,
4570: p_aei_information7 => p_rec.contractor_name,

Line 4674: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),

4670: p_aei_information_category => 'JP_ASS_LIG_INFO',
4671: p_aei_information1 => l_csr_aei.aei_information1,
4672: p_aei_information2 => l_csr_aei.aei_information2,
4673: p_aei_information3 => l_csr_aei.aei_information3,
4674: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
4675: p_aei_information5 => p_rec.ins_type,
4676: p_aei_information6 => p_rec.ins_period,
4677: p_aei_information7 => p_rec.contractor_name,
4678: p_aei_information8 => p_rec.beneficiary_name,

Line 4751: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),

4747: p_information_type => 'JP_ASS_CMI_INFO',
4748: p_aei_information_category => 'JP_ASS_CMI_INFO',
4749: p_aei_information1 => p_rec.care_ins_class,
4750: p_aei_information2 => p_rec.care_ins_company_code,
4751: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
4752: p_aei_information4 => '',
4753: p_aei_information5 => p_rec.ins_type,
4754: p_aei_information6 => p_rec.ins_period,
4755: p_aei_information7 => p_rec.contractor_name,

Line 4856: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),

4852: p_aei_information_category => 'JP_ASS_CMI_INFO',
4853: p_aei_information1 => l_csr_aei.aei_information1,
4854: p_aei_information2 => l_csr_aei.aei_information2,
4855: p_aei_information3 => l_csr_aei.aei_information3,
4856: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
4857: p_aei_information5 => p_rec.ins_type,
4858: p_aei_information6 => p_rec.ins_period,
4859: p_aei_information7 => p_rec.contractor_name,
4860: p_aei_information8 => p_rec.beneficiary_name,

Line 4932: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),

4928: p_information_type => 'JP_ASS_LIP_INFO',
4929: p_aei_information_category => 'JP_ASS_LIP_INFO',
4930: p_aei_information1 => p_rec.pens_ins_class,
4931: p_aei_information2 => p_rec.pens_ins_company_code,
4932: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
4933: p_aei_information4 => '',
4934: p_aei_information5 => p_rec.ins_type,
4935: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4936: p_aei_information7 => p_rec.ins_period,

Line 4935: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),

4931: p_aei_information2 => p_rec.pens_ins_company_code,
4932: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
4933: p_aei_information4 => '',
4934: p_aei_information5 => p_rec.ins_type,
4935: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4936: p_aei_information7 => p_rec.ins_period,
4937: p_aei_information8 => p_rec.contractor_name,
4938: p_aei_information9 => p_rec.beneficiary_name,
4939: p_aei_information10 => p_rec.beneficiary_relship,

Line 4971: or changed(fnd_date.date_to_canonical(p_rec.ins_period_start_date),l_csr_aei.aei_information6)

4967: -- support only update in case eit exists at the transfer time.
4968: if l_csr_aei.assignment_extra_info_id is not null then
4969: --
4970: if changed(p_rec.ins_type,l_csr_aei.aei_information5)
4971: or changed(fnd_date.date_to_canonical(p_rec.ins_period_start_date),l_csr_aei.aei_information6)
4972: or changed(p_rec.ins_period,l_csr_aei.aei_information7)
4973: or changed(p_rec.contractor_name,l_csr_aei.aei_information8)
4974: or changed(p_rec.beneficiary_name,l_csr_aei.aei_information9)
4975: or changed(p_rec.beneficiary_relship,l_csr_aei.aei_information10)

Line 4994: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),

4990: p_aei_information2 => l_csr_aei.aei_information2,
4991: p_aei_information3 => l_csr_aei.aei_information3,
4992: p_aei_information4 => l_csr_aei.aei_information4,
4993: p_aei_information5 => p_rec.ins_type,
4994: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4995: p_aei_information7 => p_rec.ins_period,
4996: p_aei_information8 => p_rec.contractor_name,
4997: p_aei_information9 => p_rec.beneficiary_name,
4998: p_aei_information10 => p_rec.beneficiary_relship,

Line 5042: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),

5038: p_aei_information_category => 'JP_ASS_LIP_INFO',
5039: p_aei_information1 => l_csr_aei.aei_information1,
5040: p_aei_information2 => l_csr_aei.aei_information2,
5041: p_aei_information3 => l_csr_aei.aei_information3,
5042: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
5043: p_aei_information5 => p_rec.ins_type,
5044: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
5045: p_aei_information7 => p_rec.ins_period,
5046: p_aei_information8 => p_rec.contractor_name,

Line 5044: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),

5040: p_aei_information2 => l_csr_aei.aei_information2,
5041: p_aei_information3 => l_csr_aei.aei_information3,
5042: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
5043: p_aei_information5 => p_rec.ins_type,
5044: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
5045: p_aei_information7 => p_rec.ins_period,
5046: p_aei_information8 => p_rec.contractor_name,
5047: p_aei_information9 => p_rec.beneficiary_name,
5048: p_aei_information10 => p_rec.beneficiary_relship,

Line 5119: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),

5115: p_information_type => 'JP_ASS_AI_INFO',
5116: p_aei_information_category => 'JP_ASS_AI_INFO',
5117: p_aei_information1 => p_rec.nonlife_ins_term_type,
5118: p_aei_information2 => p_rec.nonlife_ins_company_code,
5119: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
5120: p_aei_information4 => '',
5121: p_aei_information5 => p_rec.ins_type,
5122: p_aei_information6 => p_rec.ins_period,
5123: p_aei_information7 => p_rec.contractor_name,

Line 5228: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),

5224: p_aei_information_category => 'JP_ASS_AI_INFO',
5225: p_aei_information1 => l_csr_aei.aei_information1,
5226: p_aei_information2 => l_csr_aei.aei_information2,
5227: p_aei_information3 => l_csr_aei.aei_information3,
5228: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
5229: p_aei_information5 => p_rec.ins_type,
5230: p_aei_information6 => p_rec.ins_period,
5231: p_aei_information7 => p_rec.contractor_name,
5232: p_aei_information8 => p_rec.beneficiary_name,

Line 5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));

5429: if l_effective_date < l_assact_rec.effective_date
5430: or l_effective_date < l_dec_first_date
5431: or l_effective_date > l_year_end_date then
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5437: end if;

Line 5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));

5430: or l_effective_date < l_dec_first_date
5431: or l_effective_date > l_year_end_date then
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5437: end if;
5438: --

Line 5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));

5431: or l_effective_date > l_year_end_date then
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5437: end if;
5438: --
5439: -- for api use

Line 5539: -- p_transfer_date => fnd_date.date_to_canonical(l_effective_date),

5535: -- p_finalized_by => l_assact_rec.finalized_by,
5536: -- p_user_comments => l_assact_rec.user_comments,
5537: -- p_admin_comments => l_assact_rec.admin_comments,
5538: -- p_transfer_status => 'T',
5539: -- p_transfer_date => fnd_date.date_to_canonical(l_effective_date),
5540: -- p_expiry_date => l_assact_rec.expiry_date);
5541: update pay_jp_isdf_assact_dml_v
5542: set object_version_number = p_object_version_number,
5543: transfer_status = 'T',

Line 5544: transfer_date = fnd_date.date_to_canonical(l_effective_date)

5540: -- p_expiry_date => l_assact_rec.expiry_date);
5541: update pay_jp_isdf_assact_dml_v
5542: set object_version_number = p_object_version_number,
5543: transfer_status = 'T',
5544: transfer_date = fnd_date.date_to_canonical(l_effective_date)
5545: where row_id = l_assact_rec.row_id;
5546: --
5547: if g_debug then
5548: hr_utility.trace('end update_assact');

Line 5639: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));

5635: if p_expiry_date < l_assact_rec.effective_date
5636: or p_expiry_date < l_assact_rec.transfer_date
5637: or p_expiry_date > l_year_end_date then
5638: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
5639: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
5640: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5641: fnd_message.raise_error;
5642: end if;
5643: --

Line 5640: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));

5636: or p_expiry_date < l_assact_rec.transfer_date
5637: or p_expiry_date > l_year_end_date then
5638: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
5639: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
5640: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5641: fnd_message.raise_error;
5642: end if;
5643: --
5644: -- l_dec_first_date or effective_date <= l_transfer_date <= l_year_end_date

Line 5744: -- p_expiry_date => fnd_date.date_to_canonical(p_expiry_date));

5740: -- p_user_comments => l_assact_rec.user_comments,
5741: -- p_admin_comments => l_assact_rec.admin_comments,
5742: -- p_transfer_status => 'E',
5743: -- p_transfer_date => l_assact_rec.transfer_date,
5744: -- p_expiry_date => fnd_date.date_to_canonical(p_expiry_date));
5745: update pay_jp_isdf_assact_dml_v
5746: set object_version_number = p_object_version_number,
5747: transfer_status = 'E',
5748: expiry_date = fnd_date.date_to_canonical(p_expiry_date)

Line 5748: expiry_date = fnd_date.date_to_canonical(p_expiry_date)

5744: -- p_expiry_date => fnd_date.date_to_canonical(p_expiry_date));
5745: update pay_jp_isdf_assact_dml_v
5746: set object_version_number = p_object_version_number,
5747: transfer_status = 'E',
5748: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
5749: where row_id = l_assact_rec.row_id;
5750: --
5751: if g_debug then
5752: hr_utility.trace('end update_assact');

Line 6000: l_effective_date := fnd_date.canonical_to_date(p_transfer_date);

5996: from pay_jp_isdf_pact_v
5997: where payroll_action_id = p_payroll_action_id;
5998: --
5999: if p_transfer_date is not null then
6000: l_effective_date := fnd_date.canonical_to_date(p_transfer_date);
6001: end if;
6002: --
6003: insert_session(l_effective_date);
6004: commit;

Line 6094: l_effective_date := fnd_date.canonical_to_date(p_expiry_date);

6090: from pay_jp_isdf_pact_v
6091: where payroll_action_id = p_payroll_action_id;
6092: --
6093: if p_expiry_date is not null then
6094: l_effective_date := fnd_date.canonical_to_date(p_expiry_date);
6095: end if;
6096: --
6097: insert_session(l_effective_date);
6098: commit;