APPS.PAY_JP_DEF_SS dependencies on FND_NUMBER

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

357: p_entry_value3 => p_rec.widow_type,
358: p_entry_value4 => p_rec.working_student_type,
359: p_entry_value5 => p_rec.spouse_dep_type,
360: p_entry_value6 => p_rec.spouse_disability_type,
361: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
362: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
363: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),

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

358: p_entry_value4 => p_rec.working_student_type,
359: p_entry_value5 => p_rec.spouse_dep_type,
360: p_entry_value6 => p_rec.spouse_disability_type,
361: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
362: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
363: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),

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

359: p_entry_value5 => p_rec.spouse_dep_type,
360: p_entry_value6 => p_rec.spouse_disability_type,
361: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
362: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
363: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
367: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

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

360: p_entry_value6 => p_rec.spouse_disability_type,
361: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
362: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
363: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
367: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
368: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

Line 365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),

361: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
362: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
363: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
367: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
368: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
369: p_element_entry_id => p_rec.element_entry_id,

Line 366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),

362: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
363: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
367: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
368: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
369: p_element_entry_id => p_rec.element_entry_id,
370: p_object_version_number => p_rec.ee_object_version_number,

Line 367: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

363: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
367: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
368: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
369: p_element_entry_id => p_rec.element_entry_id,
370: p_object_version_number => p_rec.ee_object_version_number,
371: p_effective_start_date => l_esd,

Line 368: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

364: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
365: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
366: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
367: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
368: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
369: p_element_entry_id => p_rec.element_entry_id,
370: p_object_version_number => p_rec.ee_object_version_number,
371: p_effective_start_date => l_esd,
372: p_effective_end_date => l_eed,

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

419: p_entry_value3 => p_rec.widow_type,
420: p_entry_value4 => p_rec.working_student_type,
421: p_entry_value5 => p_rec.spouse_dep_type,
422: p_entry_value6 => p_rec.spouse_disability_type,
423: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
424: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
425: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),

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

420: p_entry_value4 => p_rec.working_student_type,
421: p_entry_value5 => p_rec.spouse_dep_type,
422: p_entry_value6 => p_rec.spouse_disability_type,
423: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
424: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
425: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),

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

421: p_entry_value5 => p_rec.spouse_dep_type,
422: p_entry_value6 => p_rec.spouse_disability_type,
423: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
424: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
425: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
429: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

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

422: p_entry_value6 => p_rec.spouse_disability_type,
423: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
424: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
425: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
429: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
430: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

Line 427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),

423: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps),
424: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
425: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
429: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
430: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
431: -- Aged Type can be defaulted to '0' after 2005/01/01

Line 428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),

424: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds),
425: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
429: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
430: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
431: -- Aged Type can be defaulted to '0' after 2005/01/01
432: -- even user enterable is "No".

Line 429: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),

425: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt),
426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
429: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
430: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
431: -- Aged Type can be defaulted to '0' after 2005/01/01
432: -- even user enterable is "No".
433: p_override_user_ent_chk => 'Y',

Line 430: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),

426: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds),
427: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps),
428: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds),
429: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds),
430: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt),
431: -- Aged Type can be defaulted to '0' after 2005/01/01
432: -- even user enterable is "No".
433: p_override_user_ent_chk => 'Y',
434: p_effective_start_date => l_esd,

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

514: p_entry_value3 => p_rec.widow_type_o,
515: p_entry_value4 => p_rec.working_student_type_o,
516: p_entry_value5 => p_rec.spouse_dep_type_o,
517: p_entry_value6 => p_rec.spouse_disability_type_o,
518: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
519: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
520: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),

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

515: p_entry_value4 => p_rec.working_student_type_o,
516: p_entry_value5 => p_rec.spouse_dep_type_o,
517: p_entry_value6 => p_rec.spouse_disability_type_o,
518: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
519: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
520: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),
523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),

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

516: p_entry_value5 => p_rec.spouse_dep_type_o,
517: p_entry_value6 => p_rec.spouse_disability_type_o,
518: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
519: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
520: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),
523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
524: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),

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

517: p_entry_value6 => p_rec.spouse_disability_type_o,
518: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
519: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
520: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),
523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
524: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
525: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),

Line 522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),

518: p_entry_value7 => fnd_number.number_to_canonical(p_rec.num_deps_o),
519: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
520: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),
523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
524: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
525: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
526: -- Aged Type could be defaulted to '0' after 2005/01/01

Line 523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),

519: p_entry_value8 => fnd_number.number_to_canonical(p_rec.num_ageds_o),
520: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),
523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
524: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
525: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
526: -- Aged Type could be defaulted to '0' after 2005/01/01
527: -- even user enterable is "No".

Line 524: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),

520: p_entry_value9 => fnd_number.number_to_canonical(p_rec.num_aged_parents_lt_o),
521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),
523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
524: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
525: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
526: -- Aged Type could be defaulted to '0' after 2005/01/01
527: -- even user enterable is "No".
528: p_override_user_ent_chk => 'Y',

Line 525: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),

521: p_entry_value10 => fnd_number.number_to_canonical(p_rec.num_specifieds_o),
522: p_entry_value11 => fnd_number.number_to_canonical(p_dep_rec.num_junior_deps_o),
523: p_entry_value12 => fnd_number.number_to_canonical(p_rec.num_disableds_o),
524: p_entry_value13 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_o),
525: p_entry_value14 => fnd_number.number_to_canonical(p_rec.num_svr_disableds_lt_o),
526: -- Aged Type could be defaulted to '0' after 2005/01/01
527: -- even user enterable is "No".
528: p_override_user_ent_chk => 'Y',
529: p_effective_start_date => l_esd,

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

595: p_contact_relationship_id => p_rec.contact_relationship_id,
596: p_information_type => 'JP_ITAX_DEPENDENT',
597: p_cei_information_category => 'JP_ITAX_DEPENDENT',
598: p_cei_information2 => p_rec.occupation,
599: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),
600: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
601: p_cei_information5 => p_rec.change_reason,
602: p_cei_information6 => p_rec.disability_type,
603: p_cei_information7 => p_rec.disability_details,

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

630: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
631: p_cei_information5 => p_rec.change_reason,
632: p_cei_information8 => p_rec.dep_type,
633: p_cei_information2 => p_rec.occupation,
634: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),
635: p_cei_information6 => p_rec.disability_type,
636: p_cei_information7 => p_rec.disability_details,
637: p_effective_start_date => l_esd,
638: p_effective_end_date => l_eed);

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

716: p_object_version_number => p_rec.cei_object_version_number,
717: -- Rollback change_date/change_reason is not supported for CORRECTION mode.
718: p_cei_information8 => p_rec.dep_type_o,
719: p_cei_information2 => p_rec.occupation_o,
720: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income_o),
721: p_cei_information6 => p_rec.disability_type_o,
722: p_cei_information7 => p_rec.disability_details_o,
723: p_effective_start_date => l_esd,
724: p_effective_end_date => l_eed);

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

775: p_contact_relationship_id => p_rec.contact_relationship_id,
776: p_information_type => 'JP_ITAX_DEPENDENT',
777: p_cei_information_category => 'JP_ITAX_DEPENDENT',
778: p_cei_information2 => p_rec.occupation_o,
779: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income_o),
780: p_cei_information6 => p_rec.disability_type_o,
781: p_cei_information7 => p_rec.disability_details_o,
782: p_cei_information8 => p_rec.dep_type_o,
783: p_contact_extra_info_id => p_rec.contact_extra_info_id,

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

827: p_cei_information_category => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
828: p_cei_information1 => p_rec.occupation,
829: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
830: p_cei_information3 => p_rec.change_reason,
831: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
832: p_contact_extra_info_id => p_rec.contact_extra_info_id,
833: p_object_version_number => p_rec.cei_object_version_number,
834: p_effective_start_date => l_esd,
835: p_effective_end_date => l_eed);

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

853: p_object_version_number => p_rec.cei_object_version_number,
854: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
855: p_cei_information3 => p_rec.change_reason,
856: p_cei_information1 => p_rec.occupation,
857: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
858: p_effective_start_date => l_esd,
859: p_effective_end_date => l_eed);
860: --
861: p_rec.status := 'U';

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

936: p_contact_extra_info_id => p_rec.contact_extra_info_id,
937: p_object_version_number => p_rec.cei_object_version_number,
938: -- Rollback change_date/change_reason is not supported for CORRECTION mode.
939: p_cei_information1 => p_rec.occupation_o,
940: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id_o),
941: p_effective_start_date => l_esd,
942: p_effective_end_date => l_eed);
943: else
944: --

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

993: p_contact_relationship_id => p_rec.contact_relationship_id,
994: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
995: p_cei_information_category => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
996: p_cei_information1 => p_rec.occupation_o,
997: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id_o),
998: p_contact_extra_info_id => p_rec.contact_extra_info_id,
999: p_object_version_number => p_rec.cei_object_version_number,
1000: p_effective_start_date => l_esd,
1001: p_effective_end_date => l_eed);

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

1632: adrc.address_line1 || adrc.address_line2 || adrc.address_line3,
1633: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) ADDRESS,
1634: cei.cei_information8 DEP_TYPE,
1635: cei.cei_information2 OCCUPATION,
1636: fnd_number.canonical_to_number(cei.cei_information3) ESTIMATED_ANNUAL_INCOME,
1637: cei.cei_information6 DISABILITY_TYPE,
1638: cei.cei_information7 DISABILITY_DETAILS
1639: from per_contact_relationships ctr,
1640: per_contact_extra_info_f cei,

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

1682: adrc.address_line1 || adrc.address_line2 || adrc.address_line3,
1683: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) ADDRESS,
1684: cei.cei_information1 OCCUPATION,
1685: -- Do not return contact_relationship_id
1686: fnd_number.canonical_to_number(cei.cei_information5) OE_CONTACT_RELATIONSHIP_ID_O,
1687: ctr2.contact_relationship_id OE_CONTACT_RELATIONSHIP_ID,
1688: ctr2.contact_person_id OE_CONTACT_PERSON_ID,
1689: ctr2.contact_type OE_CONTACT_TYPE,
1690: trim(substrb(decode(adrr2.address_id, null,

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

1715: /* CEI guarantees that person record exists as of effective_date */
1716: and p_effective_date
1717: between per.effective_start_date and per.effective_end_date
1718: /* No need to check date range of CTR */
1719: and ctr2.contact_relationship_id(+) = fnd_number.canonical_to_number(cei.cei_information5)
1720: and adrr2.person_id(+) = ctr2.contact_person_id
1721: and adrr2.address_type(+) = 'JP_R'
1722: and p_effective_date
1723: between adrr2.date_from(+) and nvl(adrr2.date_to(+), p_effective_date)

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

1846: l_entry_rec.spouse_disability_type_o := l_rec.screen_entry_value;
1847: --
1848: elsif l_rec.input_value_id = c_num_deps_iv then
1849: --
1850: l_entry_rec.num_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1851: --
1852: elsif l_rec.input_value_id = c_num_ageds_iv then
1853: --
1854: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

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

1850: l_entry_rec.num_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1851: --
1852: elsif l_rec.input_value_id = c_num_ageds_iv then
1853: --
1854: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1855: --
1856: elsif l_rec.input_value_id = c_num_aged_parents_iv then
1857: --
1858: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

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

1854: l_entry_rec.num_ageds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1855: --
1856: elsif l_rec.input_value_id = c_num_aged_parents_iv then
1857: --
1858: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1859: --
1860: elsif l_rec.input_value_id = c_num_specifieds_iv then
1861: --
1862: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

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

1858: l_entry_rec.num_aged_parents_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1859: --
1860: elsif l_rec.input_value_id = c_num_specifieds_iv then
1861: --
1862: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1863: --
1864: elsif l_rec.input_value_id = c_num_junior_deps_iv then
1865: --
1866: l_entry_dep_rec.num_junior_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

Line 1866: l_entry_dep_rec.num_junior_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

1862: l_entry_rec.num_specifieds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1863: --
1864: elsif l_rec.input_value_id = c_num_junior_deps_iv then
1865: --
1866: l_entry_dep_rec.num_junior_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1867: --
1868: elsif l_rec.input_value_id = c_num_disableds_iv then
1869: --
1870: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

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

1866: l_entry_dep_rec.num_junior_deps_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1867: --
1868: elsif l_rec.input_value_id = c_num_disableds_iv then
1869: --
1870: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1871: --
1872: elsif l_rec.input_value_id = c_num_svr_disableds_iv then
1873: --
1874: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

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

1870: l_entry_rec.num_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1871: --
1872: elsif l_rec.input_value_id = c_num_svr_disableds_iv then
1873: --
1874: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1875: --
1876: elsif l_rec.input_value_id = c_num_svr_disableds_lt_iv then
1877: --
1878: l_entry_rec.num_svr_disableds_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);

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

1874: l_entry_rec.num_svr_disableds_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1875: --
1876: elsif l_rec.input_value_id = c_num_svr_disableds_lt_iv then
1877: --
1878: l_entry_rec.num_svr_disableds_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1879: --
1880: end if;
1881: --
1882: end loop;

Line 2030: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(p_assignment_id));

2026: --
2027: end if;
2028: --
2029: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2030: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(p_assignment_id));
2031: l_itax_organization_id := pay_balance_pkg.run_db_item(c_org_iv_name,g_leg_business_group_id,g_legislation_code);
2032: --
2033: if g_debug then
2034: hr_utility.set_location(l_proc,70);

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

2848: errbuf out nocopy varchar2,
2849: retcode out nocopy varchar2,
2850: p_payroll_action_id in varchar2)
2851: is
2852: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
2853: cursor csr_assact is
2854: select aif.action_information_id,
2855: aif.object_version_number
2856: from pay_jp_def_assact_v aif,

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

3167: retcode out nocopy varchar2,
3168: p_payroll_action_id in varchar2)
3169: is
3170: l_effective_date date;
3171: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
3172: --
3173: cursor csr_assact is
3174: select assact.action_information_id,
3175: assact.object_version_number,

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

4050: errbuf out nocopy varchar2,
4051: retcode out nocopy varchar2,
4052: p_payroll_action_id in varchar2)
4053: is
4054: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
4055: cursor csr_assact is
4056: select paa.assignment_action_id
4057: from pay_jp_def_assact_v aif,
4058: pay_assignment_actions paa