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 387: select fnd_date.canonical_to_date(aei.aei_information4)

383: FUNCTION override_date(p_assignment_id in number) RETURN DATE IS
384: --
385: l_override_date date;
386: cursor csr_override_date (c_assignment_id in number) is
387: select fnd_date.canonical_to_date(aei.aei_information4)
388: from per_assignment_extra_info aei
389: where aei.assignment_id = c_assignment_id
390: and aei.information_type = 'GB_P45';
391: --

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

498: l_found := csr_getdate%found;
499: CLOSE csr_getdate;
500: IF l_found THEN
501: IF ((l_end_date IS NULL) OR
502: (fnd_date.canonical_to_date(l_end_date) > l_term_date)) THEN
503: l_flag := 'Y';
504: hr_utility.trace('changing flag to: ' || l_flag);
505: hr_utility.trace('end date is <' || l_end_date || '>');
506: END IF;

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

538: where addr.PERSON_ID = X_PERSON_ID
539: and addr.PRIMARY_FLAG = 'Y'
540: and p_effective_date between
541: addr.DATE_FROM and
542: nvl(addr.DATE_TO,fnd_date.canonical_to_date('4712/12/31'));
543:
544: cursor get_country(p_code in varchar2) is
545: select ftv.territory_short_name
546: from fnd_territories_vl ftv

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

990: begin
991: --
992: hr_utility.trace('DATE_EARN ' || x_date_earned);
993: hr_utility.trace('X_PERSON_ID ' || X_PERSON_ID);
994: hr_utility.trace('X_ASSIGNMENT_END_DATE ' || fnd_date.date_to_displaydate(X_ASSIGNMENT_END_DATE));
995: hr_utility.trace('X_TRANSFER_DATE ' || fnd_date.date_to_displaydate(X_TRANSFER_DATE));
996: l_asg_action_exists := FALSE;
997: open agg_paye(X_PERSON_ID, X_ASSIGNMENT_END_DATE);
998: fetch agg_paye into l_agg_paye_flag;

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

991: --
992: hr_utility.trace('DATE_EARN ' || x_date_earned);
993: hr_utility.trace('X_PERSON_ID ' || X_PERSON_ID);
994: hr_utility.trace('X_ASSIGNMENT_END_DATE ' || fnd_date.date_to_displaydate(X_ASSIGNMENT_END_DATE));
995: hr_utility.trace('X_TRANSFER_DATE ' || fnd_date.date_to_displaydate(X_TRANSFER_DATE));
996: l_asg_action_exists := FALSE;
997: open agg_paye(X_PERSON_ID, X_ASSIGNMENT_END_DATE);
998: fetch agg_paye into l_agg_paye_flag;
999: close agg_paye;

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

1001: --9794457 Begin
1002: OPEN csr_get_term_tax_year_start;
1003: FETCH csr_get_term_tax_year_start INTO l_termination_ty_start;
1004: CLOSE csr_get_term_tax_year_start;
1005: hr_utility.trace('After csr_get_term_tax_year_start, l_termination_ty_start='||fnd_date.date_to_displaydate(l_termination_ty_start));
1006: --9794457 End
1007:
1008: hr_utility.trace('Agg PAYE in ff data:'||l_agg_paye_flag);
1009: hr_utility.trace(to_char(X_TRANSFER_DATE));

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

1012: -- 5144323: get_aggregation end date
1013: OPEN get_aggregation_end;
1014: FETCH get_aggregation_end INTO l_aggregation_end;
1015: CLOSE get_aggregation_end;
1016: hr_utility.trace('After get_aggregation_end, l_aggregation_end='||fnd_date.date_to_displaydate(l_aggregation_end));
1017: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
1018: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
1019: --
1020: -- bug 9910054, consider asg actions with non zero taxable pay or PAYE.

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

1154: /* Moved this above so that can be used in c_act
1155: OPEN csr_get_term_tax_year_start;
1156: FETCH csr_get_term_tax_year_start INTO l_termination_ty_start;
1157: CLOSE csr_get_term_tax_year_start;
1158: hr_utility.trace('After csr_get_term_tax_year_start, l_termination_ty_start='||fnd_date.date_to_displaydate(l_termination_ty_start));
1159: */
1160: --
1161: OPEN csr_get_action_tax_year_start(l_asg_action_id);
1162: FETCH csr_get_action_tax_year_start INTO l_latest_action_ty_start;

Line 1164: 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));

1160: --
1161: OPEN csr_get_action_tax_year_start(l_asg_action_id);
1162: FETCH csr_get_action_tax_year_start INTO l_latest_action_ty_start;
1163: CLOSE csr_get_action_tax_year_start;
1164: 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));
1165: --
1166: -- Bug 2332796. Use the least of date paid and override
1167: -- date to get the time period for EOY expiry check.
1168: --

Line 1544: fnd_date.canonical_to_date

1540: --
1541: CURSOR csr_get_p45_start_end_date(p_payroll_action_id NUMBER) IS
1542: SELECT
1543: start_date,
1544: fnd_date.canonical_to_date
1545: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1546: 'DATE_TO')) end_date
1547: FROM pay_payroll_actions
1548: WHERE payroll_action_id = p_payroll_action_id;

Line 1556: fnd_date.canonical_to_date

1552: --
1553:
1554: CURSOR csr_get_p45_EDI_start_end_date(p_payroll_action_id NUMBER) IS
1555: SELECT
1556: fnd_date.canonical_to_date
1557: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1558: 'DATE_FROM')) start_date,
1559: fnd_date.canonical_to_date
1560: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 1559: fnd_date.canonical_to_date

1555: SELECT
1556: fnd_date.canonical_to_date
1557: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1558: 'DATE_FROM')) start_date,
1559: fnd_date.canonical_to_date
1560: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1561: 'END_DATE')) end_date
1562: FROM pay_payroll_actions
1563: WHERE payroll_action_id = p_payroll_action_id;

Line 2215: fnd_date.canonical_to_date

2211: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2212: 'TAX_REF'),1,20) tax_ref,
2213: start_date,
2214: effective_date,
2215: fnd_date.canonical_to_date
2216: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
2217: 'DATE_TO')) end_date,
2218: business_group_id
2219: FROM pay_payroll_actions

Line 2511: fnd_date.date_to_displaydate(l_agg_start_date)||

2507: FETCH get_agg_end INTO l_agg_end_date;
2508: CLOSE get_agg_end;
2509: --
2510: hr_utility.trace('l_agg_start_date='||
2511: fnd_date.date_to_displaydate(l_agg_start_date)||
2512: ', l_agg_end_date='||
2513: fnd_date.date_to_displaydate(l_agg_end_date));
2514: --
2515: -- Loop through all OTHER assignments in this aggregation

Line 2513: fnd_date.date_to_displaydate(l_agg_end_date));

2509: --
2510: hr_utility.trace('l_agg_start_date='||
2511: fnd_date.date_to_displaydate(l_agg_start_date)||
2512: ', l_agg_end_date='||
2513: fnd_date.date_to_displaydate(l_agg_end_date));
2514: --
2515: -- Loop through all OTHER assignments in this aggregation
2516: -- for further checks. Set a flag if rec_asg.assignment_id
2517: -- cannot be archived.

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

2692: --
2693: ff_archive_api.create_archive_item
2694: (p_archive_item_id => l_archive_item_id,
2695: p_user_entity_id => g_termination_date_eid,
2696: p_archive_value => fnd_date.date_to_canonical(rec_asg.asg_end_date),
2697: p_archive_type => 'AAC',
2698: p_action_id => l_actid,
2699: p_legislation_code => 'GB',
2700: p_object_version_number => l_ovn,

Line 3197: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3193:
3194: --
3195: cursor csr_asg_act_info(p_asgactid NUMBER) IS
3196: SELECT act.assignment_id,
3197: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3198: (act.assignment_action_id,
3199: g_termination_date_eid)) term_date,
3200: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3201: g_tax_ref_transfer_eid) tax_ref_transfer

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

3488: archive_asg_info(g_assignment_number_eid, l_assignment_number);
3489: archive_asg_info(g_deceased_flag_eid, l_deceased_flag);
3490: archive_asg_info(g_aggregated_paye_flag_eid, l_agg_paye_flag);
3491: archive_asg_info(g_period_of_service_eid, l_period_of_service_id);
3492: archive_asg_info(g_effective_end_date_eid, fnd_date.date_to_canonical(l_asg_effective_end_date));
3493: archive_asg_info(g_organization_name_eid, l_org_name);
3494: archive_asg_info(g_last_name_eid, l_last_name);
3495: archive_asg_info(g_title_eid, l_title);
3496: archive_asg_info(g_first_name_eid, l_first_name);

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

3495: archive_asg_info(g_title_eid, l_title);
3496: archive_asg_info(g_first_name_eid, l_first_name);
3497: archive_asg_info(g_middle_name_eid, l_middle_name); /*Bug 6710229*/
3498: archive_asg_info(g_ni_number_eid, l_ni_number);
3499: archive_asg_info(g_date_of_birth_eid, fnd_date.date_to_canonical(l_date_of_birth));
3500: archive_asg_info(g_sex_eid, l_sex);
3501: IF g_payroll_id IS NULL THEN
3502: -- archive not restricted by payroll so stamp asg with payroll id.
3503: archive_asg_info(g_payroll_id_eid,

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

3502: -- archive not restricted by payroll so stamp asg with payroll id.
3503: archive_asg_info(g_payroll_id_eid,
3504: fnd_number.number_to_canonical(l_payroll_id));
3505: END IF;
3506: archive_asg_info(g_issue_date_eid, nvl(fnd_date.date_to_canonical(p_effective_date), fnd_date.date_to_canonical(sysdate)));
3507: --
3508: PAY_P45_PKG.get_data
3509: (X_PERSON_ID => l_person_id,
3510: X_SESSION_DATE => sysdate,

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

3613: THEN
3614: l_period_no :=0;
3615: END IF;
3616:
3617: hr_utility.trace('After csr_get_term_period_no, l_termination_date='||fnd_date.date_to_displaydate(l_termination_date));
3618: hr_utility.trace('l_payroll_id='||l_payroll_id);
3619: hr_utility.trace('l_period_no='||l_period_no);
3620: ELSE
3621: OPEN csr_period_number(l_last_pay_action_id);

Line 4292: fnd_date.canonical_to_date

4288: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
4289: 'PAYROLL_ID')) payroll_id,
4290: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
4291: 'TAX_REF'),1,20) tax_ref,
4292: fnd_date.canonical_to_date
4293: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
4294: 'DATE_FROM')) start_date,
4295: effective_date end_date,
4296: business_group_id

Line 4557: 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,

4553: nvl(substr(max(decode(fue.user_entity_name,'X_NATIONAL_INSURANCE_NUMBER',fai.VALUE)),9,1),' ') NINO9,
4554: nvl(max(decode(fue.user_entity_name,'X_LAST_NAME',fai.VALUE)),' ') LAST_NAME,
4555: nvl(max(decode(fue.user_entity_name,'X_TITLE',fai.VALUE)),' ') TITLE,
4556: nvl(max(decode(fue.user_entity_name,'X_FIRST_NAME',fai.VALUE)),' ') FIRST_NAME,
4557: 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,
4558: 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,
4559: 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,
4560: nvl(max(decode(fue.user_entity_name,'X_TAX_CODE',fai.VALUE)),' ') TAX_CODE,
4561: nvl(max(decode(fue.user_entity_name,'X_W1_M1_INDICATOR',fai.VALUE)),' ') W1_M1_IND,

Line 4558: 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,

4554: nvl(max(decode(fue.user_entity_name,'X_LAST_NAME',fai.VALUE)),' ') LAST_NAME,
4555: nvl(max(decode(fue.user_entity_name,'X_TITLE',fai.VALUE)),' ') TITLE,
4556: nvl(max(decode(fue.user_entity_name,'X_FIRST_NAME',fai.VALUE)),' ') FIRST_NAME,
4557: 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,
4558: 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,
4559: 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,
4560: nvl(max(decode(fue.user_entity_name,'X_TAX_CODE',fai.VALUE)),' ') TAX_CODE,
4561: nvl(max(decode(fue.user_entity_name,'X_W1_M1_INDICATOR',fai.VALUE)),' ') W1_M1_IND,
4562: nvl(max(decode(fue.user_entity_name,'X_WEEK_NUMBER',fai.VALUE)),' ') WEEK_NO,

Line 4559: 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,

4555: nvl(max(decode(fue.user_entity_name,'X_TITLE',fai.VALUE)),' ') TITLE,
4556: nvl(max(decode(fue.user_entity_name,'X_FIRST_NAME',fai.VALUE)),' ') FIRST_NAME,
4557: 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,
4558: 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,
4559: 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,
4560: nvl(max(decode(fue.user_entity_name,'X_TAX_CODE',fai.VALUE)),' ') TAX_CODE,
4561: nvl(max(decode(fue.user_entity_name,'X_W1_M1_INDICATOR',fai.VALUE)),' ') W1_M1_IND,
4562: nvl(max(decode(fue.user_entity_name,'X_WEEK_NUMBER',fai.VALUE)),' ') WEEK_NO,
4563: nvl(max(decode(fue.user_entity_name,'X_MONTH_NUMBER',fai.VALUE)),' ') MONTH_NO,

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

4582: upper(nvl(max(decode(fue.user_entity_name,'X_TAX_REF_TRANSFER',fai.VALUE)),' ')) TAX_REF_TRANSFER,
4583: upper(nvl(max(decode(fue.user_entity_name,'X_STUDENT_LOAN_FLAG',fai.VALUE)),' ')) STUDENT_LOAN_FLAG,
4584: upper(nvl(max(decode(fue.user_entity_name,'X_COUNTRY',fai.VALUE)),' ')) COUNTRY,
4585: /*P45 A4 2008/09*/
4586: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),1,2),' ') DATE_OF_BIRTH_DD,
4587: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_BIRTH_MM,
4588: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_BIRTH_YY,
4589: nvl(max (decode(fue.user_entity_name,'X_SEX', substr(fai.value,1,1))),' ') SEX
4590: /*P45 A4 2008/09*/

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

4583: upper(nvl(max(decode(fue.user_entity_name,'X_STUDENT_LOAN_FLAG',fai.VALUE)),' ')) STUDENT_LOAN_FLAG,
4584: upper(nvl(max(decode(fue.user_entity_name,'X_COUNTRY',fai.VALUE)),' ')) COUNTRY,
4585: /*P45 A4 2008/09*/
4586: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),1,2),' ') DATE_OF_BIRTH_DD,
4587: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_BIRTH_MM,
4588: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_BIRTH_YY,
4589: nvl(max (decode(fue.user_entity_name,'X_SEX', substr(fai.value,1,1))),' ') SEX
4590: /*P45 A4 2008/09*/
4591: from ff_archive_items fai,

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

4584: upper(nvl(max(decode(fue.user_entity_name,'X_COUNTRY',fai.VALUE)),' ')) COUNTRY,
4585: /*P45 A4 2008/09*/
4586: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),1,2),' ') DATE_OF_BIRTH_DD,
4587: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_BIRTH_MM,
4588: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_BIRTH_YY,
4589: nvl(max (decode(fue.user_entity_name,'X_SEX', substr(fai.value,1,1))),' ') SEX
4590: /*P45 A4 2008/09*/
4591: from ff_archive_items fai,
4592: ff_user_entities fue

Line 4778: select fnd_date.canonical_to_date(aei_information3)

4774: FUNCTION get_p45_eit_manual_issue_dt(p_assignment_id in number) RETURN DATE IS
4775: --
4776: l_manual_issue_date date;
4777: CURSOR csr_get_p45_eit_dtls(c_assignment_id NUMBER) IS
4778: select fnd_date.canonical_to_date(aei_information3)
4779: from per_assignment_extra_info
4780: where assignment_id = c_assignment_id
4781: and information_type = 'GB_P45';
4782: --