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

Line 339: select fnd_date.canonical_to_date(aei.aei_information4)

335: FUNCTION override_date(p_assignment_id in number) RETURN DATE IS
336: --
337: l_override_date date;
338: cursor csr_override_date (c_assignment_id in number) is
339: select fnd_date.canonical_to_date(aei.aei_information4)
340: from per_assignment_extra_info aei
341: where aei.assignment_id = c_assignment_id
342: and aei.information_type = 'GB_P45';
343: --

Line 454: (fnd_date.canonical_to_date(l_end_date) > l_term_date)) THEN

450: l_found := csr_getdate%found;
451: CLOSE csr_getdate;
452: IF l_found THEN
453: IF ((l_end_date IS NULL) OR
454: (fnd_date.canonical_to_date(l_end_date) > l_term_date)) THEN
455: l_flag := 'Y';
456: hr_utility.trace('changing flag to: ' || l_flag);
457: hr_utility.trace('end date is <' || l_end_date || '>');
458: END IF;

Line 494: nvl(addr.DATE_TO,fnd_date.canonical_to_date('4712/12/31'));

490: where addr.PERSON_ID = X_PERSON_ID
491: and addr.PRIMARY_FLAG = 'Y'
492: and X_SESSION_DATE between
493: addr.DATE_FROM and
494: nvl(addr.DATE_TO,fnd_date.canonical_to_date('4712/12/31'));
495:
496: cursor get_country(p_code in varchar2) is
497: select ftv.territory_short_name
498: from fnd_territories_vl ftv

Line 916: hr_utility.trace('X_ASSIGNMENT_END_DATE ' || fnd_date.date_to_displaydate(X_ASSIGNMENT_END_DATE));

912: begin
913: --
914: hr_utility.trace('DATE_EARN ' || x_date_earned);
915: hr_utility.trace('X_PERSON_ID ' || X_PERSON_ID);
916: hr_utility.trace('X_ASSIGNMENT_END_DATE ' || fnd_date.date_to_displaydate(X_ASSIGNMENT_END_DATE));
917: hr_utility.trace('X_TRANSFER_DATE ' || fnd_date.date_to_displaydate(X_TRANSFER_DATE));
918: l_asg_action_exists := FALSE;
919: open agg_paye(X_PERSON_ID, X_ASSIGNMENT_END_DATE);
920: fetch agg_paye into l_agg_paye_flag;

Line 917: hr_utility.trace('X_TRANSFER_DATE ' || fnd_date.date_to_displaydate(X_TRANSFER_DATE));

913: --
914: hr_utility.trace('DATE_EARN ' || x_date_earned);
915: hr_utility.trace('X_PERSON_ID ' || X_PERSON_ID);
916: hr_utility.trace('X_ASSIGNMENT_END_DATE ' || fnd_date.date_to_displaydate(X_ASSIGNMENT_END_DATE));
917: hr_utility.trace('X_TRANSFER_DATE ' || fnd_date.date_to_displaydate(X_TRANSFER_DATE));
918: l_asg_action_exists := FALSE;
919: open agg_paye(X_PERSON_ID, X_ASSIGNMENT_END_DATE);
920: fetch agg_paye into l_agg_paye_flag;
921: close agg_paye;

Line 931: hr_utility.trace('After get_aggregation_end, l_aggregation_end='||fnd_date.date_to_displaydate(l_aggregation_end));

927: -- 5144323: get_aggregation end date
928: OPEN get_aggregation_end;
929: FETCH get_aggregation_end INTO l_aggregation_end;
930: CLOSE get_aggregation_end;
931: hr_utility.trace('After get_aggregation_end, l_aggregation_end='||fnd_date.date_to_displaydate(l_aggregation_end));
932: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
933: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
934: --
935: -- 5144343: Get aggregated action within the aggregation period only

Line 1052: hr_utility.trace('After csr_get_term_tax_year_start, l_termination_ty_start='||fnd_date.date_to_displaydate(l_termination_ty_start));

1048: -- Bug 5478073: Get tax year start for termination and latest action
1049: OPEN csr_get_term_tax_year_start;
1050: FETCH csr_get_term_tax_year_start INTO l_termination_ty_start;
1051: CLOSE csr_get_term_tax_year_start;
1052: hr_utility.trace('After csr_get_term_tax_year_start, l_termination_ty_start='||fnd_date.date_to_displaydate(l_termination_ty_start));
1053: --
1054: OPEN csr_get_action_tax_year_start(l_asg_action_id);
1055: FETCH csr_get_action_tax_year_start INTO l_latest_action_ty_start;
1056: CLOSE csr_get_action_tax_year_start;

Line 1057: hr_utility.trace('After csr_get_action_tax_year_start, l_latest_action_ty_start='||fnd_date.date_to_displaydate(l_latest_action_ty_start));

1053: --
1054: OPEN csr_get_action_tax_year_start(l_asg_action_id);
1055: FETCH csr_get_action_tax_year_start INTO l_latest_action_ty_start;
1056: CLOSE csr_get_action_tax_year_start;
1057: hr_utility.trace('After csr_get_action_tax_year_start, l_latest_action_ty_start='||fnd_date.date_to_displaydate(l_latest_action_ty_start));
1058: --
1059: -- Bug 2332796. Use the least of date paid and override
1060: -- date to get the time period for EOY expiry check.
1061: --

Line 1427: fnd_date.canonical_to_date

1423: --
1424: CURSOR csr_get_p45_start_end_date(p_payroll_action_id NUMBER) IS
1425: SELECT
1426: start_date,
1427: fnd_date.canonical_to_date
1428: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1429: 'DATE_TO')) end_date
1430: FROM pay_payroll_actions
1431: WHERE payroll_action_id = p_payroll_action_id;

Line 1439: fnd_date.canonical_to_date

1435: --
1436:
1437: CURSOR csr_get_p45_EDI_start_end_date(p_payroll_action_id NUMBER) IS
1438: SELECT
1439: fnd_date.canonical_to_date
1440: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1441: 'DATE_FROM')) start_date,
1442: fnd_date.canonical_to_date
1443: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 1442: fnd_date.canonical_to_date

1438: SELECT
1439: fnd_date.canonical_to_date
1440: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1441: 'DATE_FROM')) start_date,
1442: fnd_date.canonical_to_date
1443: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1444: 'END_DATE')) end_date
1445: FROM pay_payroll_actions
1446: WHERE payroll_action_id = p_payroll_action_id;

Line 2088: fnd_date.canonical_to_date

2084: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2085: 'TAX_REF'),1,20) tax_ref,
2086: start_date,
2087: effective_date,
2088: fnd_date.canonical_to_date
2089: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
2090: 'DATE_TO')) end_date,
2091: business_group_id
2092: FROM pay_payroll_actions

Line 2375: fnd_date.date_to_displaydate(l_agg_start_date)||

2371: FETCH get_agg_end INTO l_agg_end_date;
2372: CLOSE get_agg_end;
2373: --
2374: hr_utility.trace('l_agg_start_date='||
2375: fnd_date.date_to_displaydate(l_agg_start_date)||
2376: ', l_agg_end_date='||
2377: fnd_date.date_to_displaydate(l_agg_end_date));
2378: --
2379: -- Loop through all OTHER assignments in this aggregation

Line 2377: fnd_date.date_to_displaydate(l_agg_end_date));

2373: --
2374: hr_utility.trace('l_agg_start_date='||
2375: fnd_date.date_to_displaydate(l_agg_start_date)||
2376: ', l_agg_end_date='||
2377: fnd_date.date_to_displaydate(l_agg_end_date));
2378: --
2379: -- Loop through all OTHER assignments in this aggregation
2380: -- for further checks. Set a flag if rec_asg.assignment_id
2381: -- cannot be archived.

Line 2560: p_archive_value => fnd_date.date_to_canonical(rec_asg.asg_end_date),

2556: --
2557: ff_archive_api.create_archive_item
2558: (p_archive_item_id => l_archive_item_id,
2559: p_user_entity_id => g_termination_date_eid,
2560: p_archive_value => fnd_date.date_to_canonical(rec_asg.asg_end_date),
2561: p_archive_type => 'AAC',
2562: p_action_id => l_actid,
2563: p_legislation_code => 'GB',
2564: p_object_version_number => l_ovn,

Line 2831: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

2827: l_final_process_date date;
2828: --
2829: cursor csr_asg_act_info(p_asgactid NUMBER) IS
2830: SELECT act.assignment_id,
2831: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
2832: (act.assignment_action_id,
2833: g_termination_date_eid)) term_date,
2834: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
2835: g_tax_ref_transfer_eid) tax_ref_transfer

Line 3068: archive_asg_info(g_effective_end_date_eid, fnd_date.date_to_canonical(l_asg_effective_end_date));

3064: archive_asg_info(g_assignment_number_eid, l_assignment_number);
3065: archive_asg_info(g_deceased_flag_eid, l_deceased_flag);
3066: archive_asg_info(g_aggregated_paye_flag_eid, l_agg_paye_flag);
3067: archive_asg_info(g_period_of_service_eid, l_period_of_service_id);
3068: archive_asg_info(g_effective_end_date_eid, fnd_date.date_to_canonical(l_asg_effective_end_date));
3069: archive_asg_info(g_organization_name_eid, l_org_name);
3070: archive_asg_info(g_last_name_eid, l_last_name);
3071: archive_asg_info(g_title_eid, l_title);
3072: archive_asg_info(g_first_name_eid, l_first_name);

Line 3075: archive_asg_info(g_date_of_birth_eid, fnd_date.date_to_canonical(l_date_of_birth));

3071: archive_asg_info(g_title_eid, l_title);
3072: archive_asg_info(g_first_name_eid, l_first_name);
3073: archive_asg_info(g_middle_name_eid, l_middle_name); /*Bug 6710229*/
3074: archive_asg_info(g_ni_number_eid, l_ni_number);
3075: archive_asg_info(g_date_of_birth_eid, fnd_date.date_to_canonical(l_date_of_birth));
3076: archive_asg_info(g_sex_eid, l_sex);
3077: IF g_payroll_id IS NULL THEN
3078: -- archive not restricted by payroll so stamp asg with payroll id.
3079: archive_asg_info(g_payroll_id_eid,

Line 3082: archive_asg_info(g_issue_date_eid, nvl(fnd_date.date_to_canonical(p_effective_date), fnd_date.date_to_canonical(sysdate)));

3078: -- archive not restricted by payroll so stamp asg with payroll id.
3079: archive_asg_info(g_payroll_id_eid,
3080: fnd_number.number_to_canonical(l_payroll_id));
3081: END IF;
3082: archive_asg_info(g_issue_date_eid, nvl(fnd_date.date_to_canonical(p_effective_date), fnd_date.date_to_canonical(sysdate)));
3083: --
3084: PAY_P45_PKG.get_data
3085: (X_PERSON_ID => l_person_id,
3086: X_SESSION_DATE => sysdate,

Line 3165: hr_utility.trace('After csr_get_term_period_no, l_termination_date='||fnd_date.date_to_displaydate(l_termination_date));

3161: IF l_last_asg_action_id = -9999 THEN
3162: OPEN csr_get_term_period_no(l_termination_date, l_payroll_id);
3163: FETCH csr_get_term_period_no INTO l_period_no;
3164: CLOSE csr_get_term_period_no;
3165: hr_utility.trace('After csr_get_term_period_no, l_termination_date='||fnd_date.date_to_displaydate(l_termination_date));
3166: hr_utility.trace('l_payroll_id='||l_payroll_id);
3167: hr_utility.trace('l_period_no='||l_period_no);
3168: ELSE
3169: OPEN csr_period_number(l_last_pay_action_id);

Line 3510: fnd_date.canonical_to_date

3506: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3507: 'PAYROLL_ID')) payroll_id,
3508: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3509: 'TAX_REF'),1,20) tax_ref,
3510: fnd_date.canonical_to_date
3511: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
3512: 'DATE_FROM')) start_date,
3513: effective_date end_date,
3514: business_group_id

Line 3770: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),1,2),' ') DATE_OF_LEAVING_DD,

3766: nvl(substr(max(decode(fue.user_entity_name,'X_NATIONAL_INSURANCE_NUMBER',fai.VALUE)),9,1),' ') NINO9,
3767: nvl(max(decode(fue.user_entity_name,'X_LAST_NAME',fai.VALUE)),' ') LAST_NAME,
3768: nvl(max(decode(fue.user_entity_name,'X_TITLE',fai.VALUE)),' ') TITLE,
3769: nvl(max(decode(fue.user_entity_name,'X_FIRST_NAME',fai.VALUE)),' ') FIRST_NAME,
3770: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),1,2),' ') DATE_OF_LEAVING_DD,
3771: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_LEAVING_MM,
3772: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_LEAVING_YY,
3773: nvl(max(decode(fue.user_entity_name,'X_TAX_CODE',fai.VALUE)),' ') TAX_CODE,
3774: nvl(max(decode(fue.user_entity_name,'X_W1_M1_INDICATOR',fai.VALUE)),' ') W1_M1_IND,

Line 3771: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_LEAVING_MM,

3767: nvl(max(decode(fue.user_entity_name,'X_LAST_NAME',fai.VALUE)),' ') LAST_NAME,
3768: nvl(max(decode(fue.user_entity_name,'X_TITLE',fai.VALUE)),' ') TITLE,
3769: nvl(max(decode(fue.user_entity_name,'X_FIRST_NAME',fai.VALUE)),' ') FIRST_NAME,
3770: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),1,2),' ') DATE_OF_LEAVING_DD,
3771: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_LEAVING_MM,
3772: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_LEAVING_YY,
3773: nvl(max(decode(fue.user_entity_name,'X_TAX_CODE',fai.VALUE)),' ') TAX_CODE,
3774: nvl(max(decode(fue.user_entity_name,'X_W1_M1_INDICATOR',fai.VALUE)),' ') W1_M1_IND,
3775: nvl(max(decode(fue.user_entity_name,'X_WEEK_NUMBER',fai.VALUE)),' ') WEEK_NO,

Line 3772: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_LEAVING_YY,

3768: nvl(max(decode(fue.user_entity_name,'X_TITLE',fai.VALUE)),' ') TITLE,
3769: nvl(max(decode(fue.user_entity_name,'X_FIRST_NAME',fai.VALUE)),' ') FIRST_NAME,
3770: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),1,2),' ') DATE_OF_LEAVING_DD,
3771: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_LEAVING_MM,
3772: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_TERMINATION_DATE',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_LEAVING_YY,
3773: nvl(max(decode(fue.user_entity_name,'X_TAX_CODE',fai.VALUE)),' ') TAX_CODE,
3774: nvl(max(decode(fue.user_entity_name,'X_W1_M1_INDICATOR',fai.VALUE)),' ') W1_M1_IND,
3775: nvl(max(decode(fue.user_entity_name,'X_WEEK_NUMBER',fai.VALUE)),' ') WEEK_NO,
3776: nvl(max(decode(fue.user_entity_name,'X_MONTH_NUMBER',fai.VALUE)),' ') MONTH_NO,

Line 3971: select fnd_date.canonical_to_date(aei_information3)

3967: FUNCTION get_p45_eit_manual_issue_dt(p_assignment_id in number) RETURN DATE IS
3968: --
3969: l_manual_issue_date date;
3970: CURSOR csr_get_p45_eit_dtls(c_assignment_id NUMBER) IS
3971: select fnd_date.canonical_to_date(aei_information3)
3972: from per_assignment_extra_info
3973: where assignment_id = c_assignment_id
3974: and information_type = 'GB_P45';
3975: --