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_DEF_SS dependencies on FND_NUMBER

Line 350: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),

346: p_entry_value3 => p_rec.widow_type,
347: p_entry_value4 => p_rec.working_student_type,
348: p_entry_value5 => p_rec.spouse_dep_type,
349: p_entry_value6 => p_rec.spouse_disability_type,
350: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
351: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),

Line 351: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),

347: p_entry_value4 => p_rec.working_student_type,
348: p_entry_value5 => p_rec.spouse_dep_type,
349: p_entry_value6 => p_rec.spouse_disability_type,
350: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
351: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
355: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

Line 352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),

348: p_entry_value5 => p_rec.spouse_dep_type,
349: p_entry_value6 => p_rec.spouse_disability_type,
350: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
351: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
355: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
356: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

Line 353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),

349: p_entry_value6 => p_rec.spouse_disability_type,
350: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
351: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
355: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
356: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
357: p_element_entry_id => p_rec.element_entry_id,

Line 354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),

350: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
351: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
355: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
356: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
357: p_element_entry_id => p_rec.element_entry_id,
358: p_object_version_number => p_rec.ee_object_version_number,

Line 355: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

351: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
355: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
356: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
357: p_element_entry_id => p_rec.element_entry_id,
358: p_object_version_number => p_rec.ee_object_version_number,
359: p_effective_start_date => l_esd,

Line 356: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

352: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
353: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
354: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
355: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
356: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
357: p_element_entry_id => p_rec.element_entry_id,
358: p_object_version_number => p_rec.ee_object_version_number,
359: p_effective_start_date => l_esd,
360: p_effective_end_date => l_eed,

Line 409: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),

405: p_entry_value3 => p_rec.widow_type,
406: p_entry_value4 => p_rec.working_student_type,
407: p_entry_value5 => p_rec.spouse_dep_type,
408: p_entry_value6 => p_rec.spouse_disability_type,
409: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
410: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),

Line 410: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),

406: p_entry_value4 => p_rec.working_student_type,
407: p_entry_value5 => p_rec.spouse_dep_type,
408: p_entry_value6 => p_rec.spouse_disability_type,
409: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
410: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
414: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

Line 411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),

407: p_entry_value5 => p_rec.spouse_dep_type,
408: p_entry_value6 => p_rec.spouse_disability_type,
409: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
410: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
414: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
415: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

Line 412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),

408: p_entry_value6 => p_rec.spouse_disability_type,
409: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
410: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
414: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
415: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
416: -- Aged Type can be defaulted to '0' after 2005/01/01

Line 413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),

409: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
410: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
414: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
415: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
416: -- Aged Type can be defaulted to '0' after 2005/01/01
417: -- even user enterable is "No".

Line 414: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

410: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
414: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
415: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
416: -- Aged Type can be defaulted to '0' after 2005/01/01
417: -- even user enterable is "No".
418: p_override_user_ent_chk => 'Y',

Line 415: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

411: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
412: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
413: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds),
414: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
415: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
416: -- Aged Type can be defaulted to '0' after 2005/01/01
417: -- even user enterable is "No".
418: p_override_user_ent_chk => 'Y',
419: p_effective_start_date => l_esd,

Line 499: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),

495: p_entry_value3 => p_rec.widow_type_o,
496: p_entry_value4 => p_rec.working_student_type_o,
497: p_entry_value5 => p_rec.spouse_dep_type_o,
498: p_entry_value6 => p_rec.spouse_disability_type_o,
499: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
500: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),

Line 500: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),

496: p_entry_value4 => p_rec.working_student_type_o,
497: p_entry_value5 => p_rec.spouse_dep_type_o,
498: p_entry_value6 => p_rec.spouse_disability_type_o,
499: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
500: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
504: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),

Line 501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),

497: p_entry_value5 => p_rec.spouse_dep_type_o,
498: p_entry_value6 => p_rec.spouse_disability_type_o,
499: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
500: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
504: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
505: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),

Line 502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),

498: p_entry_value6 => p_rec.spouse_disability_type_o,
499: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
500: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
504: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
505: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
506: -- Aged Type could be defaulted to '0' after 2005/01/01

Line 503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),

499: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
500: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
504: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
505: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
506: -- Aged Type could be defaulted to '0' after 2005/01/01
507: -- even user enterable is "No".

Line 504: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),

500: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
504: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
505: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
506: -- Aged Type could be defaulted to '0' after 2005/01/01
507: -- even user enterable is "No".
508: p_override_user_ent_chk => 'Y',

Line 505: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),

501: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
502: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
503: p_entry_value11 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
504: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
505: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
506: -- Aged Type could be defaulted to '0' after 2005/01/01
507: -- even user enterable is "No".
508: p_override_user_ent_chk => 'Y',
509: p_effective_start_date => l_esd,

Line 579: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),

575: p_contact_relationship_id => p_rec.contact_relationship_id,
576: p_information_type => 'JP_ITAX_DEPENDENT',
577: p_cei_information_category => 'JP_ITAX_DEPENDENT',
578: p_cei_information2 => p_rec.occupation,
579: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),
580: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
581: p_cei_information5 => p_rec.change_reason,
582: p_cei_information6 => p_rec.disability_type,
583: p_cei_information7 => p_rec.disability_details,

Line 614: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),

610: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
611: p_cei_information5 => p_rec.change_reason,
612: p_cei_information8 => p_rec.dep_type,
613: p_cei_information2 => p_rec.occupation,
614: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),
615: p_cei_information6 => p_rec.disability_type,
616: p_cei_information7 => p_rec.disability_details,
617: p_effective_start_date => l_esd,
618: p_effective_end_date => l_eed);

Line 700: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income_o),

696: p_object_version_number => p_rec.cei_object_version_number,
697: -- Rollback change_date/change_reason is not supported for CORRECTION mode.
698: p_cei_information8 => p_rec.dep_type_o,
699: p_cei_information2 => p_rec.occupation_o,
700: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income_o),
701: p_cei_information6 => p_rec.disability_type_o,
702: p_cei_information7 => p_rec.disability_details_o,
703: p_effective_start_date => l_esd,
704: p_effective_end_date => l_eed);

Line 759: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income_o),

755: p_contact_relationship_id => p_rec.contact_relationship_id,
756: p_information_type => 'JP_ITAX_DEPENDENT',
757: p_cei_information_category => 'JP_ITAX_DEPENDENT',
758: p_cei_information2 => p_rec.occupation_o,
759: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income_o),
760: p_cei_information6 => p_rec.disability_type_o,
761: p_cei_information7 => p_rec.disability_details_o,
762: p_cei_information8 => p_rec.dep_type_o,
763: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 811: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),

807: p_cei_information_category => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
808: p_cei_information1 => p_rec.occupation,
809: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
810: p_cei_information3 => p_rec.change_reason,
811: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
812: p_contact_extra_info_id => p_rec.contact_extra_info_id,
813: p_object_version_number => p_rec.cei_object_version_number,
814: p_effective_start_date => l_esd,
815: p_effective_end_date => l_eed);

Line 837: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),

833: p_object_version_number => p_rec.cei_object_version_number,
834: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
835: p_cei_information3 => p_rec.change_reason,
836: p_cei_information1 => p_rec.occupation,
837: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
838: p_effective_start_date => l_esd,
839: p_effective_end_date => l_eed);
840: --
841: p_rec.status := 'U';

Line 920: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id_o),

916: p_contact_extra_info_id => p_rec.contact_extra_info_id,
917: p_object_version_number => p_rec.cei_object_version_number,
918: -- Rollback change_date/change_reason is not supported for CORRECTION mode.
919: p_cei_information1 => p_rec.occupation_o,
920: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id_o),
921: p_effective_start_date => l_esd,
922: p_effective_end_date => l_eed);
923: else
924: --

Line 977: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id_o),

973: p_contact_relationship_id => p_rec.contact_relationship_id,
974: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
975: p_cei_information_category => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
976: p_cei_information1 => p_rec.occupation_o,
977: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id_o),
978: p_contact_extra_info_id => p_rec.contact_extra_info_id,
979: p_object_version_number => p_rec.cei_object_version_number,
980: p_effective_start_date => l_esd,
981: p_effective_end_date => l_eed);

Line 1373: fnd_number.canonical_to_number(cei.cei_information3) ESTIMATED_ANNUAL_INCOME,

1369: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240))
1370: ADDRESS,
1371: cei.cei_information8 DEP_TYPE,
1372: cei.cei_information2 OCCUPATION,
1373: fnd_number.canonical_to_number(cei.cei_information3) ESTIMATED_ANNUAL_INCOME,
1374: cei.cei_information6 DISABILITY_TYPE,
1375: cei.cei_information7 DISABILITY_DETAILS
1376: from per_all_people_f per,
1377: per_addresses adrc,

Line 1423: fnd_number.canonical_to_number(cei.cei_information5) OE_CONTACT_RELATIONSHIP_ID_O,

1419: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240))
1420: ADDRESS,
1421: cei.cei_information1 OCCUPATION,
1422: -- Do not return contact_relationship_id
1423: fnd_number.canonical_to_number(cei.cei_information5) OE_CONTACT_RELATIONSHIP_ID_O,
1424: ctr2.contact_relationship_id OE_CONTACT_RELATIONSHIP_ID,
1425: ctr2.contact_person_id OE_CONTACT_PERSON_ID,
1426: ctr2.contact_type OE_CONTACT_TYPE,
1427: trim(substrb(decode(adrr2.address_id, null,

Line 1457: and ctr2.contact_relationship_id(+) = fnd_number.canonical_to_number(cei.cei_information5)

1453: /* CEI guarantees that person record exists as of effective_date */
1454: and p_effective_date
1455: between per.effective_start_date and per.effective_end_date
1456: /* No need to check date range of CTR */
1457: and ctr2.contact_relationship_id(+) = fnd_number.canonical_to_number(cei.cei_information5)
1458: and adrr2.person_id(+) = ctr2.contact_person_id
1459: and adrr2.address_type(+) = 'JP_R'
1460: and p_effective_date
1461: between adrr2.date_from(+) and nvl(adrr2.date_to(+), p_effective_date)

Line 1584: l_entry_rec.num_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1580: l_entry_rec.spouse_dep_type_o := l_rec.screen_entry_value;
1581: elsif l_rec.input_value_id = c_spouse_disability_type_iv then
1582: l_entry_rec.spouse_disability_type_o := l_rec.screen_entry_value;
1583: elsif l_rec.input_value_id = c_num_deps_iv then
1584: l_entry_rec.num_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1585: elsif l_rec.input_value_id = c_num_ageds_iv then
1586: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1587: elsif l_rec.input_value_id = c_num_aged_parents_iv then
1588: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

Line 1586: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1582: l_entry_rec.spouse_disability_type_o := l_rec.screen_entry_value;
1583: elsif l_rec.input_value_id = c_num_deps_iv then
1584: l_entry_rec.num_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1585: elsif l_rec.input_value_id = c_num_ageds_iv then
1586: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1587: elsif l_rec.input_value_id = c_num_aged_parents_iv then
1588: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1589: elsif l_rec.input_value_id = c_num_specifieds_iv then
1590: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

Line 1588: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1584: l_entry_rec.num_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1585: elsif l_rec.input_value_id = c_num_ageds_iv then
1586: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1587: elsif l_rec.input_value_id = c_num_aged_parents_iv then
1588: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1589: elsif l_rec.input_value_id = c_num_specifieds_iv then
1590: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1591: elsif l_rec.input_value_id = c_num_disableds_iv then
1592: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

Line 1590: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1586: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1587: elsif l_rec.input_value_id = c_num_aged_parents_iv then
1588: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1589: elsif l_rec.input_value_id = c_num_specifieds_iv then
1590: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1591: elsif l_rec.input_value_id = c_num_disableds_iv then
1592: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1593: elsif l_rec.input_value_id = c_num_svr_disableds_iv then
1594: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

Line 1592: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1588: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1589: elsif l_rec.input_value_id = c_num_specifieds_iv then
1590: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1591: elsif l_rec.input_value_id = c_num_disableds_iv then
1592: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1593: elsif l_rec.input_value_id = c_num_svr_disableds_iv then
1594: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1595: elsif l_rec.input_value_id = c_num_svr_disableds_lt_iv then
1596: l_entry_rec.num_svr_disableds_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

Line 1594: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1590: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1591: elsif l_rec.input_value_id = c_num_disableds_iv then
1592: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1593: elsif l_rec.input_value_id = c_num_svr_disableds_iv then
1594: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1595: elsif l_rec.input_value_id = c_num_svr_disableds_lt_iv then
1596: l_entry_rec.num_svr_disableds_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1597: end if;
1598: end loop;

Line 1596: l_entry_rec.num_svr_disableds_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1592: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1593: elsif l_rec.input_value_id = c_num_svr_disableds_iv then
1594: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1595: elsif l_rec.input_value_id = c_num_svr_disableds_lt_iv then
1596: l_entry_rec.num_svr_disableds_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1597: end if;
1598: end loop;
1599: --
1600: pay_jp_def_api.create_entry(

Line 2228: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);

2224: errbuf out nocopy varchar2,
2225: retcode out nocopy varchar2,
2226: p_payroll_action_id in varchar2)
2227: is
2228: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
2229: cursor csr_assact is
2230: select aif.action_information_id,
2231: aif.object_version_number
2232: from pay_jp_def_assact_v aif,

Line 2465: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);

2461: retcode out nocopy varchar2,
2462: p_payroll_action_id in varchar2)
2463: is
2464: l_effective_date date;
2465: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
2466: --
2467: cursor csr_assact is
2468: select assact.action_information_id,
2469: assact.object_version_number,

Line 3139: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);

3135: errbuf out nocopy varchar2,
3136: retcode out nocopy varchar2,
3137: p_payroll_action_id in varchar2)
3138: is
3139: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
3140: cursor csr_assact is
3141: select paa.assignment_action_id
3142: from pay_jp_def_assact_v aif,
3143: pay_assignment_actions paa