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 1093: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));

1089: l_submission_date := check_submission_period(p_action_information_id);
1090: --
1091: if g_debug then
1092: hr_utility.set_location(l_proc,10);
1093: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1094: end if;
1095: --
1096: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1097: --

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

1205: l_submission_date := check_submission_period(p_action_information_id);
1206: --
1207: if g_debug then
1208: hr_utility.set_location(l_proc,10);
1209: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1210: end if;
1211: --
1212: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1213: --

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

2558: l_submission_date := check_submission_period(p_action_information_id);
2559: --
2560: if g_debug then
2561: hr_utility.set_location(l_proc,10);
2562: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
2563: end if;
2564: --
2565: -- unnecessary to lock
2566: select *

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

2722: l_submission_date := check_submission_period(p_action_information_id);
2723: --
2724: if g_debug then
2725: hr_utility.set_location(l_proc,10);
2726: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
2727: end if;
2728: --
2729: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2730: --

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

2964: --pay_jp_isdf_dml_pkg.update_assact(
2965: -- p_action_information_id => l_assact_rec.assignment_action_id,
2966: -- p_object_version_number => p_object_version_number,
2967: -- p_transaction_status => 'F',
2968: -- p_finalized_date => fnd_date.date_to_canonical(l_submission_date),
2969: -- p_finalized_by => fnd_number.number_to_canonical(fnd_global.user_id),
2970: -- p_user_comments => p_user_comments,
2971: -- p_admin_comments => l_assact_rec.admin_comments,
2972: -- p_transfer_status => l_assact_rec.transfer_status,

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

2974: -- p_expiry_date => l_assact_rec.expiry_date);
2975: update pay_jp_isdf_assact_dml_v
2976: set object_version_number = p_object_version_number,
2977: transaction_status = 'F',
2978: finalized_date = fnd_date.date_to_canonical(l_submission_date),
2979: finalized_by = fnd_number.number_to_canonical(fnd_global.user_id),
2980: user_comments = p_user_comments
2981: where row_id = l_assact_rec.row_id;
2982: --

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

3009: l_submission_date := check_submission_period(p_action_information_id);
3010: --
3011: if g_debug then
3012: hr_utility.set_location(l_proc,10);
3013: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3014: end if;
3015: --
3016: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3017: --

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

3096: l_submission_date := check_submission_period(p_action_information_id);
3097: --
3098: if g_debug then
3099: hr_utility.set_location(l_proc,10);
3100: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3101: end if;
3102: --
3103: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3104: --

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

3862: p_information_type => 'JP_ASS_LIG_INFO',
3863: p_aei_information_category => 'JP_ASS_LIG_INFO',
3864: p_aei_information1 => p_rec.gen_ins_class,
3865: p_aei_information2 => p_rec.gen_ins_company_code,
3866: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
3867: p_aei_information4 => '',
3868: p_aei_information5 => p_rec.ins_type,
3869: p_aei_information6 => p_rec.ins_period,
3870: p_aei_information7 => p_rec.contractor_name,

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

3967: p_aei_information_category => 'JP_ASS_LIG_INFO',
3968: p_aei_information1 => l_csr_aei.aei_information1,
3969: p_aei_information2 => l_csr_aei.aei_information2,
3970: p_aei_information3 => l_csr_aei.aei_information3,
3971: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
3972: p_aei_information5 => p_rec.ins_type,
3973: p_aei_information6 => p_rec.ins_period,
3974: p_aei_information7 => p_rec.contractor_name,
3975: p_aei_information8 => p_rec.beneficiary_name,

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

4042: p_information_type => 'JP_ASS_LIP_INFO',
4043: p_aei_information_category => 'JP_ASS_LIP_INFO',
4044: p_aei_information1 => p_rec.pens_ins_class,
4045: p_aei_information2 => p_rec.pens_ins_company_code,
4046: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
4047: p_aei_information4 => '',
4048: p_aei_information5 => p_rec.ins_type,
4049: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4050: p_aei_information7 => p_rec.ins_period,

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

4045: p_aei_information2 => p_rec.pens_ins_company_code,
4046: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
4047: p_aei_information4 => '',
4048: p_aei_information5 => p_rec.ins_type,
4049: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4050: p_aei_information7 => p_rec.ins_period,
4051: p_aei_information8 => p_rec.contractor_name,
4052: p_aei_information9 => p_rec.beneficiary_name,
4053: p_aei_information10 => p_rec.beneficiary_relship,

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

4080: -- support only update in case eit exists at the transfer time.
4081: if l_csr_aei.assignment_extra_info_id is not null then
4082: --
4083: if changed(p_rec.ins_type,l_csr_aei.aei_information5)
4084: or changed(fnd_date.date_to_canonical(p_rec.ins_period_start_date),l_csr_aei.aei_information6)
4085: or changed(p_rec.ins_period,l_csr_aei.aei_information7)
4086: or changed(p_rec.contractor_name,l_csr_aei.aei_information8)
4087: or changed(p_rec.beneficiary_name,l_csr_aei.aei_information9)
4088: or changed(p_rec.beneficiary_relship,l_csr_aei.aei_information10) then

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

4102: p_aei_information2 => l_csr_aei.aei_information2,
4103: p_aei_information3 => l_csr_aei.aei_information3,
4104: p_aei_information4 => l_csr_aei.aei_information4,
4105: p_aei_information5 => p_rec.ins_type,
4106: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4107: p_aei_information7 => p_rec.ins_period,
4108: p_aei_information8 => p_rec.contractor_name,
4109: p_aei_information9 => p_rec.beneficiary_name,
4110: p_aei_information10 => p_rec.beneficiary_relship,

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

4149: p_aei_information_category => 'JP_ASS_LIP_INFO',
4150: p_aei_information1 => l_csr_aei.aei_information1,
4151: p_aei_information2 => l_csr_aei.aei_information2,
4152: p_aei_information3 => l_csr_aei.aei_information3,
4153: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
4154: p_aei_information5 => p_rec.ins_type,
4155: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4156: p_aei_information7 => p_rec.ins_period,
4157: p_aei_information8 => p_rec.contractor_name,

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

4151: p_aei_information2 => l_csr_aei.aei_information2,
4152: p_aei_information3 => l_csr_aei.aei_information3,
4153: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
4154: p_aei_information5 => p_rec.ins_type,
4155: p_aei_information6 => fnd_date.date_to_canonical(p_rec.ins_period_start_date),
4156: p_aei_information7 => p_rec.ins_period,
4157: p_aei_information8 => p_rec.contractor_name,
4158: p_aei_information9 => p_rec.beneficiary_name,
4159: p_aei_information10 => p_rec.beneficiary_relship,

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

4225: p_information_type => 'JP_ASS_AI_INFO',
4226: p_aei_information_category => 'JP_ASS_AI_INFO',
4227: p_aei_information1 => p_rec.nonlife_ins_term_type,
4228: p_aei_information2 => p_rec.nonlife_ins_company_code,
4229: p_aei_information3 => fnd_date.date_to_canonical(l_effective_date),
4230: p_aei_information4 => '',
4231: p_aei_information5 => p_rec.ins_type,
4232: p_aei_information6 => p_rec.ins_period,
4233: p_aei_information7 => p_rec.contractor_name,

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

4334: p_aei_information_category => 'JP_ASS_AI_INFO',
4335: p_aei_information1 => l_csr_aei.aei_information1,
4336: p_aei_information2 => l_csr_aei.aei_information2,
4337: p_aei_information3 => l_csr_aei.aei_information3,
4338: p_aei_information4 => fnd_date.date_to_canonical(l_effective_date-1),
4339: p_aei_information5 => p_rec.ins_type,
4340: p_aei_information6 => p_rec.ins_period,
4341: p_aei_information7 => p_rec.contractor_name,
4342: p_aei_information8 => p_rec.beneficiary_name,

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

4509: if l_effective_date < l_assact_rec.effective_date
4510: or l_effective_date < l_dec_first_date
4511: or l_effective_date > l_year_end_date then
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4517: end if;

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

4510: or l_effective_date < l_dec_first_date
4511: or l_effective_date > l_year_end_date then
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4517: end if;
4518: --

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

4511: or l_effective_date > l_year_end_date then
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4517: end if;
4518: --
4519: -- for api use

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

4609: -- p_finalized_by => l_assact_rec.finalized_by,
4610: -- p_user_comments => l_assact_rec.user_comments,
4611: -- p_admin_comments => l_assact_rec.admin_comments,
4612: -- p_transfer_status => 'T',
4613: -- p_transfer_date => fnd_date.date_to_canonical(l_effective_date),
4614: -- p_expiry_date => l_assact_rec.expiry_date);
4615: update pay_jp_isdf_assact_dml_v
4616: set object_version_number = p_object_version_number,
4617: transfer_status = 'T',

Line 4618: transfer_date = fnd_date.date_to_canonical(l_effective_date)

4614: -- p_expiry_date => l_assact_rec.expiry_date);
4615: update pay_jp_isdf_assact_dml_v
4616: set object_version_number = p_object_version_number,
4617: transfer_status = 'T',
4618: transfer_date = fnd_date.date_to_canonical(l_effective_date)
4619: where row_id = l_assact_rec.row_id;
4620: --
4621: if g_debug then
4622: hr_utility.trace('end update_assact');

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

4709: if p_expiry_date < l_assact_rec.effective_date
4710: or p_expiry_date < l_assact_rec.transfer_date
4711: or p_expiry_date > l_year_end_date then
4712: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
4713: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
4714: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4715: fnd_message.raise_error;
4716: end if;
4717: --

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

4710: or p_expiry_date < l_assact_rec.transfer_date
4711: or p_expiry_date > l_year_end_date then
4712: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
4713: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
4714: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4715: fnd_message.raise_error;
4716: end if;
4717: --
4718: -- l_dec_first_date or effective_date <= l_transfer_date <= l_year_end_date

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

4814: -- p_user_comments => l_assact_rec.user_comments,
4815: -- p_admin_comments => l_assact_rec.admin_comments,
4816: -- p_transfer_status => 'E',
4817: -- p_transfer_date => l_assact_rec.transfer_date,
4818: -- p_expiry_date => fnd_date.date_to_canonical(p_expiry_date));
4819: update pay_jp_isdf_assact_dml_v
4820: set object_version_number = p_object_version_number,
4821: transfer_status = 'E',
4822: expiry_date = fnd_date.date_to_canonical(p_expiry_date)

Line 4822: expiry_date = fnd_date.date_to_canonical(p_expiry_date)

4818: -- p_expiry_date => fnd_date.date_to_canonical(p_expiry_date));
4819: update pay_jp_isdf_assact_dml_v
4820: set object_version_number = p_object_version_number,
4821: transfer_status = 'E',
4822: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
4823: where row_id = l_assact_rec.row_id;
4824: --
4825: if g_debug then
4826: hr_utility.trace('end update_assact');

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

5070: from pay_jp_isdf_pact_v
5071: where payroll_action_id = p_payroll_action_id;
5072: --
5073: if p_transfer_date is not null then
5074: l_effective_date := fnd_date.canonical_to_date(p_transfer_date);
5075: end if;
5076: --
5077: insert_session(l_effective_date);
5078: commit;

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

5164: from pay_jp_isdf_pact_v
5165: where payroll_action_id = p_payroll_action_id;
5166: --
5167: if p_expiry_date is not null then
5168: l_effective_date := fnd_date.canonical_to_date(p_expiry_date);
5169: end if;
5170: --
5171: insert_session(l_effective_date);
5172: commit;