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.BEN_PROCESS_COBRA_PERSON_SS dependencies on HR_TRANSACTION_SS

Line 559: --l_new_ler_lf_evt_ocrd_dt := to_char(l_ler_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);

555: ,p_subflow_mode => l_subflow_mode
556: ,p_life_event_name => l_life_event_name
557: );
558:
559: --l_new_ler_lf_evt_ocrd_dt := to_char(l_ler_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
560:
561: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
562: (p_validate => false
563: ,p_ptnl_ler_for_per_id => l_dummy_num -- out number

Line 594: ,p_mnl_dt => to_char(l_ptnl_ler.mnl_dt,hr_transaction_ss.g_date_format) -- in date default null

590: ,p_csd_by_ptnl_ler_for_per_id => to_char(l_ptnl_ler.csd_by_ptnl_ler_for_per_id) -- in number default null
591: ,p_lf_evt_ocrd_dt => l_new_ler_lf_evt_ocrd_dt -- in out date
592: ,p_ptnl_ler_for_per_stat_cd => l_ptnl_ler.ptnl_ler_for_per_stat_cd -- in varchar2 default null
593: ,p_ptnl_ler_for_per_src_cd => l_ptnl_ler.ptnl_ler_for_per_src_cd -- in varchar2 default null
594: ,p_mnl_dt => to_char(l_ptnl_ler.mnl_dt,hr_transaction_ss.g_date_format) -- in date default null
595: ,p_enrt_perd_id => to_char(l_ptnl_ler.enrt_perd_id) -- in number default null
596: ,p_ler_id => to_char(l_ptnl_ler.ler_id) -- in number default null
597: ,p_person_id => to_char(l_person_id) -- in number default null
598: ,p_business_group_id => to_char(l_ptnl_ler.business_group_id) -- in number default null

Line 599: ,p_dtctd_dt => to_char(l_ptnl_ler.dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null

595: ,p_enrt_perd_id => to_char(l_ptnl_ler.enrt_perd_id) -- in number default null
596: ,p_ler_id => to_char(l_ptnl_ler.ler_id) -- in number default null
597: ,p_person_id => to_char(l_person_id) -- in number default null
598: ,p_business_group_id => to_char(l_ptnl_ler.business_group_id) -- in number default null
599: ,p_dtctd_dt => to_char(l_ptnl_ler.dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
600: ,p_procd_dt => to_char(l_ptnl_ler.procd_dt,hr_transaction_ss.g_date_format) -- in date default null
601: ,p_unprocd_dt => to_char(l_ptnl_ler.unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
602: ,p_voidd_dt => to_char(l_ptnl_ler.voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
603: ,p_mnlo_dt => to_char(l_ptnl_ler.mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null

Line 600: ,p_procd_dt => to_char(l_ptnl_ler.procd_dt,hr_transaction_ss.g_date_format) -- in date default null

596: ,p_ler_id => to_char(l_ptnl_ler.ler_id) -- in number default null
597: ,p_person_id => to_char(l_person_id) -- in number default null
598: ,p_business_group_id => to_char(l_ptnl_ler.business_group_id) -- in number default null
599: ,p_dtctd_dt => to_char(l_ptnl_ler.dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
600: ,p_procd_dt => to_char(l_ptnl_ler.procd_dt,hr_transaction_ss.g_date_format) -- in date default null
601: ,p_unprocd_dt => to_char(l_ptnl_ler.unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
602: ,p_voidd_dt => to_char(l_ptnl_ler.voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
603: ,p_mnlo_dt => to_char(l_ptnl_ler.mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
604: ,p_ntfn_dt => to_char(l_ptnl_ler.ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null

Line 601: ,p_unprocd_dt => to_char(l_ptnl_ler.unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null

597: ,p_person_id => to_char(l_person_id) -- in number default null
598: ,p_business_group_id => to_char(l_ptnl_ler.business_group_id) -- in number default null
599: ,p_dtctd_dt => to_char(l_ptnl_ler.dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
600: ,p_procd_dt => to_char(l_ptnl_ler.procd_dt,hr_transaction_ss.g_date_format) -- in date default null
601: ,p_unprocd_dt => to_char(l_ptnl_ler.unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
602: ,p_voidd_dt => to_char(l_ptnl_ler.voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
603: ,p_mnlo_dt => to_char(l_ptnl_ler.mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
604: ,p_ntfn_dt => to_char(l_ptnl_ler.ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
605: ,p_request_id => to_char(l_ptnl_ler.request_id) -- in number default null

Line 602: ,p_voidd_dt => to_char(l_ptnl_ler.voidd_dt,hr_transaction_ss.g_date_format) -- in date default null

598: ,p_business_group_id => to_char(l_ptnl_ler.business_group_id) -- in number default null
599: ,p_dtctd_dt => to_char(l_ptnl_ler.dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
600: ,p_procd_dt => to_char(l_ptnl_ler.procd_dt,hr_transaction_ss.g_date_format) -- in date default null
601: ,p_unprocd_dt => to_char(l_ptnl_ler.unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
602: ,p_voidd_dt => to_char(l_ptnl_ler.voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
603: ,p_mnlo_dt => to_char(l_ptnl_ler.mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
604: ,p_ntfn_dt => to_char(l_ptnl_ler.ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
605: ,p_request_id => to_char(l_ptnl_ler.request_id) -- in number default null
606: ,p_program_application_id => to_char(l_ptnl_ler.program_application_id) -- in number default null

Line 603: ,p_mnlo_dt => to_char(l_ptnl_ler.mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null

599: ,p_dtctd_dt => to_char(l_ptnl_ler.dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
600: ,p_procd_dt => to_char(l_ptnl_ler.procd_dt,hr_transaction_ss.g_date_format) -- in date default null
601: ,p_unprocd_dt => to_char(l_ptnl_ler.unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
602: ,p_voidd_dt => to_char(l_ptnl_ler.voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
603: ,p_mnlo_dt => to_char(l_ptnl_ler.mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
604: ,p_ntfn_dt => to_char(l_ptnl_ler.ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
605: ,p_request_id => to_char(l_ptnl_ler.request_id) -- in number default null
606: ,p_program_application_id => to_char(l_ptnl_ler.program_application_id) -- in number default null
607: ,p_program_id => to_char(l_ptnl_ler.program_id) -- in number default null

Line 604: ,p_ntfn_dt => to_char(l_ptnl_ler.ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null

600: ,p_procd_dt => to_char(l_ptnl_ler.procd_dt,hr_transaction_ss.g_date_format) -- in date default null
601: ,p_unprocd_dt => to_char(l_ptnl_ler.unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
602: ,p_voidd_dt => to_char(l_ptnl_ler.voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
603: ,p_mnlo_dt => to_char(l_ptnl_ler.mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
604: ,p_ntfn_dt => to_char(l_ptnl_ler.ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
605: ,p_request_id => to_char(l_ptnl_ler.request_id) -- in number default null
606: ,p_program_application_id => to_char(l_ptnl_ler.program_application_id) -- in number default null
607: ,p_program_id => to_char(l_ptnl_ler.program_id) -- in number default null
608: ,p_program_update_date => to_char(l_ptnl_ler.program_update_date,hr_transaction_ss.g_date_format) -- in date default null

Line 608: ,p_program_update_date => to_char(l_ptnl_ler.program_update_date,hr_transaction_ss.g_date_format) -- in date default null

604: ,p_ntfn_dt => to_char(l_ptnl_ler.ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
605: ,p_request_id => to_char(l_ptnl_ler.request_id) -- in number default null
606: ,p_program_application_id => to_char(l_ptnl_ler.program_application_id) -- in number default null
607: ,p_program_id => to_char(l_ptnl_ler.program_id) -- in number default null
608: ,p_program_update_date => to_char(l_ptnl_ler.program_update_date,hr_transaction_ss.g_date_format) -- in date default null
609: ,p_object_version_number => l_life_event_ovn -- out number
610: ,p_effective_date => to_char(l_life_event_eff_date,hr_transaction_ss.g_date_format) --in date
611: ,p_item_type => l_item_type
612: ,p_item_key => l_item_key

Line 610: ,p_effective_date => to_char(l_life_event_eff_date,hr_transaction_ss.g_date_format) --in date

606: ,p_program_application_id => to_char(l_ptnl_ler.program_application_id) -- in number default null
607: ,p_program_id => to_char(l_ptnl_ler.program_id) -- in number default null
608: ,p_program_update_date => to_char(l_ptnl_ler.program_update_date,hr_transaction_ss.g_date_format) -- in date default null
609: ,p_object_version_number => l_life_event_ovn -- out number
610: ,p_effective_date => to_char(l_life_event_eff_date,hr_transaction_ss.g_date_format) --in date
611: ,p_item_type => l_item_type
612: ,p_item_key => l_item_key
613: ,p_activity_id => null
614: ,p_flow_mode => l_flow_mode

Line 890: l_transaction_table hr_transaction_ss.transaction_table;

886: l_transaction_id number default null;
887: l_transaction_step_id number default null;
888: l_trans_obj_vers_num number default null;
889: l_count integer default 0;
890: l_transaction_table hr_transaction_ss.transaction_table;
891: l_review_item_name varchar2(50);
892: --
893: l_full_name_duplicate_flag varchar2(1) default null;
894: l_result varchar2(50);

Line 977: if (to_date(p_hire_date,hr_transaction_ss.g_date_format) > p_effective_date) then

973: end if;
974:
975: -- start cobra codes
976: if p_flow_name = 'Cobra' then
977: if (to_date(p_hire_date,hr_transaction_ss.g_date_format) > p_effective_date) then
978: l_hire_date := p_effective_date;
979: else
980: l_hire_date := to_date(p_hire_date,hr_transaction_ss.g_date_format);
981: end if;

Line 980: l_hire_date := to_date(p_hire_date,hr_transaction_ss.g_date_format);

976: if p_flow_name = 'Cobra' then
977: if (to_date(p_hire_date,hr_transaction_ss.g_date_format) > p_effective_date) then
978: l_hire_date := p_effective_date;
979: else
980: l_hire_date := to_date(p_hire_date,hr_transaction_ss.g_date_format);
981: end if;
982: hr_contact_api.create_person
983: (p_validate => false --in boolean default false
984: ,p_start_date => l_hire_date

Line 1109: l_transaction_id := hr_transaction_ss.get_transaction_id

1105: rollback to create_cobra_person;
1106: --
1107: -- First, check if transaction id exists or not
1108: --
1109: l_transaction_id := hr_transaction_ss.get_transaction_id
1110: (p_item_type => p_item_type
1111: ,p_item_key => p_item_key);
1112: --
1113: if l_transaction_id is null then

Line 1115: hr_transaction_ss.start_transaction

1111: ,p_item_key => p_item_key);
1112: --
1113: if l_transaction_id is null then
1114: -- Start a Transaction
1115: hr_transaction_ss.start_transaction
1116: (itemtype => p_item_type
1117: ,itemkey => p_item_key
1118: ,actid => p_actid
1119: ,funmode => 'RUN'

Line 1123: l_transaction_id := hr_transaction_ss.get_transaction_id

1119: ,funmode => 'RUN'
1120: ,p_login_person_id => p_login_person_id --nvl(p_login_person_id, p_parent_id)
1121: ,result => l_result);
1122:
1123: l_transaction_id := hr_transaction_ss.get_transaction_id
1124: (p_item_type => p_item_type
1125: ,p_item_key => p_item_key);
1126: end if;
1127: ------------------+

Line 1188: l_transaction_table(l_count).param_value := to_char(l_hire_date,hr_transaction_ss.g_date_format);

1184: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1185: --
1186: l_count := l_count + 1;
1187: l_transaction_table(l_count).param_name := 'P_DATE_START';
1188: l_transaction_table(l_count).param_value := to_char(l_hire_date,hr_transaction_ss.g_date_format);
1189: l_transaction_table(l_count).param_data_type := 'DATE';
1190: --
1191: -- We don't want to derive the business_group_id because we want to save a
1192: -- db sql statement call to improve the performance.

Line 1221: hr_transaction_ss.g_date_format);

1217: --
1218: l_count := l_count + 1;
1219: l_transaction_table(l_count).param_name := 'P_DATE_EMPLOYEE_DATA_VERIFIED';
1220: l_transaction_table(l_count).param_value := to_char(p_date_employee_data_verified,
1221: hr_transaction_ss.g_date_format);
1222: l_transaction_table(l_count).param_data_type := 'DATE';
1223: --
1224: l_count := l_count + 1;
1225: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';

Line 1227: hr_transaction_ss.g_date_format);

1223: --
1224: l_count := l_count + 1;
1225: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';
1226: l_transaction_table(l_count).param_value := to_char(p_date_of_birth,
1227: hr_transaction_ss.g_date_format);
1228: l_transaction_table(l_count).param_data_type := 'DATE';
1229: --
1230: l_count := l_count + 1;
1231: l_transaction_table(l_count).param_name := 'P_EMAIL_ADDRESS';

Line 1610: ,hr_transaction_ss.g_date_format);

1606: l_count := l_count + 1;
1607: l_transaction_table(l_count).param_name := 'P_DATE_OF_DEATH';
1608: l_transaction_table(l_count).param_value := to_char
1609: (p_date_of_death
1610: ,hr_transaction_ss.g_date_format);
1611: l_transaction_table(l_count).param_data_type := 'DATE';
1612: --
1613: l_count := l_count + 1;
1614: l_transaction_table(l_count).param_name := 'P_BACKGROUND_CHECK_STATUS';

Line 1622: ,hr_transaction_ss.g_date_format);

1618: l_count := l_count + 1;
1619: l_transaction_table(l_count).param_name := 'P_BACKGROUND_DATE_CHECK';
1620: l_transaction_table(l_count).param_value := to_char
1621: (p_background_date_check
1622: ,hr_transaction_ss.g_date_format);
1623: l_transaction_table(l_count).param_data_type := 'DATE';
1624: --
1625: l_count := l_count + 1;
1626: l_transaction_table(l_count).param_name := 'P_BLOOD_TYPE';

Line 1664: ,hr_transaction_ss.g_date_format);

1660: l_count := l_count + 1;
1661: l_transaction_table(l_count).param_name := 'P_LAST_MEDICAL_TEST_DATE';
1662: l_transaction_table(l_count).param_value := to_char
1663: (p_last_medical_test_date
1664: ,hr_transaction_ss.g_date_format);
1665: l_transaction_table(l_count).param_data_type := 'DATE';
1666: --
1667: l_count := l_count + 1;
1668: l_transaction_table(l_count).param_name := 'P_MAILSTOP';

Line 1691: ,hr_transaction_ss.g_date_format);

1687: l_count := l_count + 1;
1688: l_transaction_table(l_count).param_name := 'P_PROJECTED_START_DATE';
1689: l_transaction_table(l_count).param_value := to_char
1690: (p_projected_start_date
1691: ,hr_transaction_ss.g_date_format);
1692: l_transaction_table(l_count).param_data_type := 'DATE';
1693: --
1694: l_count := l_count + 1;
1695: l_transaction_table(l_count).param_name := 'P_RESUME_EXISTS';

Line 1703: ,hr_transaction_ss.g_date_format);

1699: l_count := l_count + 1;
1700: l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';
1701: l_transaction_table(l_count).param_value := to_char
1702: (p_resume_last_updated
1703: ,hr_transaction_ss.g_date_format);
1704: l_transaction_table(l_count).param_data_type := 'DATE';
1705: --
1706: l_count := l_count + 1;
1707: l_transaction_table(l_count).param_name := 'P_SECOND_PASSPORT_EXISTS';

Line 1735: ,hr_transaction_ss.g_date_format);

1731: l_count := l_count + 1;
1732: l_transaction_table(l_count).param_name := 'P_RECEIPT_OF_DEATH_CERT_DATE';
1733: l_transaction_table(l_count).param_value := to_char
1734: (p_receipt_of_death_cert_date
1735: ,hr_transaction_ss.g_date_format);
1736: l_transaction_table(l_count).param_data_type := 'DATE';
1737: --
1738: l_count := l_count + 1;
1739: l_transaction_table(l_count).param_name := 'P_COORD_BEN_MED_PLN_NO';

Line 1757: ,hr_transaction_ss.g_date_format);

1753: l_count := l_count + 1;
1754: l_transaction_table(l_count).param_name := 'P_DPDNT_ADOPTION_DATE';
1755: l_transaction_table(l_count).param_value := to_char
1756: (p_dpdnt_adoption_date
1757: ,hr_transaction_ss.g_date_format);
1758: l_transaction_table(l_count).param_data_type := 'DATE';
1759: --
1760: l_count := l_count + 1;
1761: l_transaction_table(l_count).param_name := 'P_DPDNT_VLNTRY_SVCE_FLAG';

Line 1769: ,hr_transaction_ss.g_date_format);

1765: l_count := l_count + 1;
1766: l_transaction_table(l_count).param_name := 'P_ORIGINAL_DATE_OF_HIRE';
1767: l_transaction_table(l_count).param_value := to_char
1768: (p_original_date_of_hire
1769: ,hr_transaction_ss.g_date_format);
1770: l_transaction_table(l_count).param_data_type := 'DATE';
1771: --
1772: l_count := l_count + 1;
1773: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';

Line 1776: ,hr_transaction_ss.g_date_format);

1772: l_count := l_count + 1;
1773: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';
1774: l_transaction_table(l_count).param_value := to_char
1775: (p_adjusted_svc_date
1776: ,hr_transaction_ss.g_date_format);
1777: l_transaction_table(l_count).param_data_type := 'DATE';
1778: --
1779: l_count := l_count + 1;
1780: l_transaction_table(l_count).param_name := 'P_TOWN_OF_BIRTH';

Line 1823: ,hr_transaction_ss.g_date_format);

1819: l_count := l_count + 1;
1820: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_START_DATE';
1821: l_transaction_table(l_count).param_value := to_char
1822: (p_per_effective_start_date
1823: ,hr_transaction_ss.g_date_format);
1824: l_transaction_table(l_count).param_data_type := 'DATE';
1825: --
1826: l_count := l_count + 1;
1827: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_END_DATE';

Line 1830: ,hr_transaction_ss.g_date_format);

1826: l_count := l_count + 1;
1827: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_END_DATE';
1828: l_transaction_table(l_count).param_value := to_char
1829: (p_per_effective_end_date
1830: ,hr_transaction_ss.g_date_format);
1831: l_transaction_table(l_count).param_data_type := 'DATE';
1832: --
1833: l_count := l_count + 1;
1834: l_transaction_table(l_count).param_name := 'P_REVIEW_PROC_CALL';

Line 1846: hr_transaction_ss.g_date_format);

1842: --
1843: l_count := l_count + 1;
1844: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
1845: l_transaction_table(l_count).param_value := to_char(p_effective_date,
1846: hr_transaction_ss.g_date_format);
1847: l_transaction_table(l_count).param_data_type := 'DATE';
1848: --
1849: l_count := l_count + 1;
1850: l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';

Line 1878: ,hr_transaction_ss.g_date_format);

1874: l_count := l_count + 1;
1875: l_transaction_table(l_count).param_name := 'P_HOLD_APPLICANT_DATE_UNTIL';
1876: l_transaction_table(l_count).param_value := to_char
1877: (p_hold_applicant_date_until
1878: ,hr_transaction_ss.g_date_format);
1879: l_transaction_table(l_count).param_data_type := 'DATE';
1880: --
1881: l_count := l_count + 1;
1882: l_transaction_table(l_count).param_name := 'P_REHIRE_AUTHORIZOR';

Line 1907: hr_transaction_ss.save_transaction_step

1903: l_transaction_table(l_count).param_value := p_flow_name;
1904: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1905: --
1906:
1907: hr_transaction_ss.save_transaction_step
1908: (p_item_type => p_item_type
1909: ,p_item_key => p_item_key
1910: ,p_actid => p_actid
1911: ,p_login_person_id => p_login_person_id