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.OTA_TRAINING_PLAN_UPGRADE dependencies on HR_DFLEX_UTILITY

Line 532: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

528: and lpst.name = p_name
529: and lps.business_group_id = p_business_group_id
530: and (lps.person_id = p_person_id OR lps.contact_id = p_contact_id);
531:
532: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
533: hr_dflex_utility.l_ignore_dfcode_varray();
534:
535:
536: BEGIN

Line 533: hr_dflex_utility.l_ignore_dfcode_varray();

529: and lps.business_group_id = p_business_group_id
530: and (lps.person_id = p_person_id OR lps.contact_id = p_contact_id);
531:
532: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
533: hr_dflex_utility.l_ignore_dfcode_varray();
534:
535:
536: BEGIN
537: l_add_struct_d.extend(1);

Line 539: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);

535:
536: BEGIN
537: l_add_struct_d.extend(1);
538: l_add_struct_d(l_add_struct_d.count) := 'OTA_LEARNING_PATHS';
539: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
540:
541: open csr_get_dup_lps_rec(p_name,p_business_group_id, p_person_id, p_contact_id);
542: fetch csr_get_dup_lps_rec into l_learning_path_id;
543: if csr_get_dup_lps_rec%notfound then

Line 586: hr_dflex_utility.remove_ignore_df_validation;

582: end if;
583: close csr_get_dup_lps_rec;
584: p_learning_path_id := l_learning_path_id;
585: p_object_version_number := l_object_version_number;
586: hr_dflex_utility.remove_ignore_df_validation;
587: End create_learning_path;
588:
589: -- ----------------------------------------------------------------------------
590: -- |---------------------------< create_lp_sections >----------------------|

Line 621: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

617: and lpct.language=userenv('LANG')
618: and lpc.learning_path_id = p_learning_path_id
619: and lpct.name = p_section_name ;
620:
621: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
622: hr_dflex_utility.l_ignore_dfcode_varray();
623:
624:
625: BEGIN

Line 622: hr_dflex_utility.l_ignore_dfcode_varray();

618: and lpc.learning_path_id = p_learning_path_id
619: and lpct.name = p_section_name ;
620:
621: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
622: hr_dflex_utility.l_ignore_dfcode_varray();
623:
624:
625: BEGIN
626: l_add_struct_d.extend(1);

Line 628: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);

624:
625: BEGIN
626: l_add_struct_d.extend(1);
627: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';
628: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
629:
630: open csr_get_dup_lpc_rec(p_learning_path_id, p_section_name);
631: fetch csr_get_dup_lpc_rec into l_learning_path_section_id;
632: if csr_get_dup_lpc_rec%notfound then

Line 664: hr_dflex_utility.remove_ignore_df_validation;

660: End;
661: end if;
662: close csr_get_dup_lpc_rec;
663: p_learning_path_section_id := l_learning_path_section_id;
664: hr_dflex_utility.remove_ignore_df_validation;
665: End create_lp_sections;
666:
667: -- ----------------------------------------------------------------------------
668: -- |---------------------< create_learning_path_members >---------------------|

Line 694: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

690: l_err_msg varchar2(2000);
691: l_number number;
692:
693:
694: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
695: hr_dflex_utility.l_ignore_dfcode_varray();
696:
697:
698: BEGIN

Line 695: hr_dflex_utility.l_ignore_dfcode_varray();

691: l_number number;
692:
693:
694: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
695: hr_dflex_utility.l_ignore_dfcode_varray();
696:
697:
698: BEGIN
699: l_add_struct_d.extend(1);

Line 701: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);

697:
698: BEGIN
699: l_add_struct_d.extend(1);
700: l_add_struct_d(l_add_struct_d.count) := 'OTA_LEARNING_PATH_MEMBERS';
701: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
702:
703:
704:
705: if not is_lp_mem_migrated(p_learning_path_id, p_activity_version_id

Line 745: hr_dflex_utility.remove_ignore_df_validation;

741:
742: p_learning_path_member_id := l_learning_path_member_id;
743: p_object_version_number := l_object_version_number;
744:
745: hr_dflex_utility.remove_ignore_df_validation;
746: END create_learning_path_members;
747:
748: -- ----------------------------------------------------------------------------
749: -- |---------------------< create_lp_member_enrollment >---------------------|

Line 809: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

805: l_err_code varchar2(72);
806: l_err_msg varchar2(2000);
807: l_number number;
808:
809: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
810: hr_dflex_utility.l_ignore_dfcode_varray();
811:
812:
813: BEGIN

Line 810: hr_dflex_utility.l_ignore_dfcode_varray();

806: l_err_msg varchar2(2000);
807: l_number number;
808:
809: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
810: hr_dflex_utility.l_ignore_dfcode_varray();
811:
812:
813: BEGIN
814: l_add_struct_d.extend(1);

Line 816: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);

812:
813: BEGIN
814: l_add_struct_d.extend(1);
815: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_MEMBER_ENROLLMENTS';
816: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
817:
818:
819: if not is_lp_mem_enr_migrated(p_training_plan_member_id) then
820: l_date_status_changed := null;

Line 898: hr_dflex_utility.remove_ignore_df_validation;

894: l_lp_member_enrollment_id := get_lp_mem_enr_map(p_training_plan_member_id);
895: end if;
896: --close csr_get_dup_lpme_rec;
897: p_lp_member_enrollment_id := l_lp_member_enrollment_id;
898: hr_dflex_utility.remove_ignore_df_validation;
899: end create_lp_member_enrollment;
900:
901:
902: -- ----------------------------------------------------------------------------

Line 962: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

958: l_err_msg varchar2(2000);
959: l_number number;
960:
961: --
962: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
963: hr_dflex_utility.l_ignore_dfcode_varray();
964:
965:
966: BEGIN

Line 963: hr_dflex_utility.l_ignore_dfcode_varray();

959: l_number number;
960:
961: --
962: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
963: hr_dflex_utility.l_ignore_dfcode_varray();
964:
965:
966: BEGIN
967: l_add_struct_d.extend(1);

Line 969: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);

965:
966: BEGIN
967: l_add_struct_d.extend(1);
968: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_ENROLLMENTS';
969: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
970:
971:
972: if not is_lp_enr_migrated(p_training_plan_id
973: ,p_source_id, p_source_function, p_assignment_id) then

Line 1047: hr_dflex_utility.remove_ignore_df_validation;

1043: ,p_assignment_id);
1044: end if;
1045: -- close csr_get_dup_lpe_rec;
1046: p_lp_enrollment_id := l_lp_enrollment_id;
1047: hr_dflex_utility.remove_ignore_df_validation;
1048: end create_lp_enrollment;
1049: -- ----------------------------------------------------------------------------
1050: -- |-------------------------< upg_cat_lp_to_section >------------------------|
1051: -- ----------------------------------------------------------------------------

Line 1090: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

1086: and lpct.language=userenv('LANG')
1087: and lpc.learning_path_id = p_learning_path_id
1088: and lpct.name = p_section_name ;
1089:
1090: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
1091: hr_dflex_utility.l_ignore_dfcode_varray();
1092:
1093:
1094:

Line 1091: hr_dflex_utility.l_ignore_dfcode_varray();

1087: and lpc.learning_path_id = p_learning_path_id
1088: and lpct.name = p_section_name ;
1089:
1090: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
1091: hr_dflex_utility.l_ignore_dfcode_varray();
1092:
1093:
1094:
1095: BEGIN

Line 1123: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);

1119: FOR lp_rec IN csr_get_lp LOOP
1120: l_learning_path_id := lp_rec.learning_path_id;
1121: l_add_struct_d.extend(1);
1122: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';
1123: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
1124:
1125: open csr_get_dup_lpc_rec(l_learning_path_id, lp_rec.name);
1126: fetch csr_get_dup_lpc_rec into l_learning_path_section_id;
1127: if csr_get_dup_lpc_rec%notfound then

Line 1184: hr_dflex_utility.remove_ignore_df_validation;

1180:
1181: End;
1182: end if;
1183: close csr_get_dup_lpc_rec;
1184: hr_dflex_utility.remove_ignore_df_validation;
1185:
1186:
1187:
1188: