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.HR_USER_ACCT_EMP_EXTRACT dependencies on DBMS_SQL

Line 668: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1

664: -- 6. Fetch 1 row in buffer
665: -- 7. Get 1 row from buffer
666: -- 8. Close dynamic cursor
667: --
668: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
669:
670: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
671: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
672: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp

Line 677: dbms_sql.parse(l_dynamic_cursor_id, l_sql_clause, dbms_sql.v7); -- Step 2

673: THEN
674: BEGIN
675: hr_utility.set_location('In executing create user dynamic sql..', 35);
676:
677: dbms_sql.parse(l_dynamic_cursor_id, l_sql_clause, dbms_sql.v7); -- Step 2
678: -- ************************************************************************
679: -- NOTE:If we retrieve extra column,need to set the l_index accordingly.
680: -- ************************************************************************
681: --

Line 685: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);

681: --
682: l_index := 1;
683: --
684: -- Define the Person ID column
685: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
686: --
687: -- Now define Person record Effective Start Date
688: l_index := l_index + 1;
689: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 689: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

685: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
686: --
687: -- Now define Person record Effective Start Date
688: l_index := l_index + 1;
689: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
690: --
691: -- Now define Person record Effective End Date
692: l_index := l_index + 1;
693: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 693: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

689: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
690: --
691: -- Now define Person record Effective End Date
692: l_index := l_index + 1;
693: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
694: --
695: -- Define the Assignment ID column
696: l_index := l_index + 1;
697: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);

Line 697: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);

693: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
694: --
695: -- Define the Assignment ID column
696: l_index := l_index + 1;
697: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
698: --
699: -- Now define Assignment record Effective Start Date
700: l_index := l_index + 1;
701: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 701: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

697: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
698: --
699: -- Now define Assignment record Effective Start Date
700: l_index := l_index + 1;
701: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
702: --
703: -- Now define Assignment record Effective End Date
704: l_index := l_index + 1;
705: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 705: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

701: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
702: --
703: -- Now define Assignment record Effective End Date
704: l_index := l_index + 1;
705: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
706: --
707: -- Now define the Hire Date column
708: l_index := l_index + 1;
709: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 709: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

705: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
706: --
707: -- Now define the Hire Date column
708: l_index := l_index + 1;
709: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
710: --
711: --
712: EXCEPTION
713: WHEN OTHERS THEN

Line 718: l_rows := dbms_sql.execute(l_dynamic_cursor_id); -- Step 5

714: null;
715: END;
716: --
717: l_new_user_count := 0;
718: l_rows := dbms_sql.execute(l_dynamic_cursor_id); -- Step 5
719: --
720: -- Initialize the prev fields before entering the loop
721: l_prev_per_id := null;
722: l_prev_eff_start_date := null;

Line 729: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6

725: l_prev_asg_eff_start_date := null;
726: l_prev_asg_eff_end_date := null;
727: l_prev_hire_date := null;
728:
729: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
730: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);

Line 730: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);

726: l_prev_asg_eff_end_date := null;
727: l_prev_hire_date := null;
728:
729: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
730: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);

Line 731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);

727: l_prev_hire_date := null;
728:
729: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
730: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
735: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);

Line 732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);

728:
729: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
730: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
735: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
736: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_hire_date);

Line 733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);

729: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
730: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
735: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
736: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_hire_date);
737: --

Line 734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);

730: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
735: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
736: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_hire_date);
737: --
738: -- We only want to create the batch header when there is record retreived

Line 735: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);

731: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
735: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
736: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_hire_date);
737: --
738: -- We only want to create the batch header when there is record retreived
739: -- from the dynamic sql statement. Otherwise, we won't create a header.

Line 736: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_hire_date);

732: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
733: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
734: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
735: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
736: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_hire_date);
737: --
738: -- We only want to create the batch header when there is record retreived
739: -- from the dynamic sql statement. Otherwise, we won't create a header.
740: IF l_batch_id IS NOT NULL

Line 858: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1

854: IF upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
855: upper(p_run_type) = hr_user_acct_utility.g_inactivate_user
856: THEN
857: l_dynamic_cursor_id := 0;
858: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
859:
860: BEGIN
861:
862: hr_utility.set_location('In executing inactivate user dynamic sql..', 37);

Line 864: dbms_sql.parse(l_dynamic_cursor_id, l_inactivate_user_sql_clause

860: BEGIN
861:
862: hr_utility.set_location('In executing inactivate user dynamic sql..', 37);
863:
864: dbms_sql.parse(l_dynamic_cursor_id, l_inactivate_user_sql_clause
865: ,dbms_sql.v7); -- Step 2
866: -- ************************************************************************
867: -- NOTE:If we retrieve extra column,need to set the l_index accordingly.
868: -- ************************************************************************

Line 865: ,dbms_sql.v7); -- Step 2

861:
862: hr_utility.set_location('In executing inactivate user dynamic sql..', 37);
863:
864: dbms_sql.parse(l_dynamic_cursor_id, l_inactivate_user_sql_clause
865: ,dbms_sql.v7); -- Step 2
866: -- ************************************************************************
867: -- NOTE:If we retrieve extra column,need to set the l_index accordingly.
868: -- ************************************************************************
869: --

Line 873: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);

869: --
870: l_index := 1;
871: --
872: -- Define the Person Id column
873: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
874: --
875: -- Now define Person record Effective Start Date
876: l_index := l_index + 1;
877: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 877: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

873: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
874: --
875: -- Now define Person record Effective Start Date
876: l_index := l_index + 1;
877: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
878: --
879: -- Now define Person record Effective End Date
880: l_index := l_index + 1;
881: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 881: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

877: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
878: --
879: -- Now define Person record Effective End Date
880: l_index := l_index + 1;
881: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
882: --
883: -- Define the Assignment Id column
884: l_index := l_index + 1;
885: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);

Line 885: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);

881: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
882: --
883: -- Define the Assignment Id column
884: l_index := l_index + 1;
885: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
886: --
887: -- Now define Assignment record Effective Start Date
888: l_index := l_index + 1;
889: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 889: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

885: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_temp);
886: --
887: -- Now define Assignment record Effective Start Date
888: l_index := l_index + 1;
889: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
890: --
891: -- Now define Assignment record Effective End Date
892: l_index := l_index + 1;
893: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 893: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

889: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
890: --
891: -- Now define Assignment record Effective End Date
892: l_index := l_index + 1;
893: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
894: --
895: -- Now define the Term Date column
896: l_index := l_index + 1;
897: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

Line 897: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);

893: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
894: --
895: -- Now define the Term Date column
896: l_index := l_index + 1;
897: dbms_sql.define_column(l_dynamic_cursor_id, l_index, l_date_temp);
898: --
899: EXCEPTION
900: WHEN OTHERS THEN
901: null;

Line 905: l_rows := dbms_sql.execute(l_dynamic_cursor_id); -- Step 5

901: null;
902: END;
903: --
904: l_inactivate_user_count := 0;
905: l_rows := dbms_sql.execute(l_dynamic_cursor_id); -- Step 5
906: --
907: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);

Line 907: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6

903: --
904: l_inactivate_user_count := 0;
905: l_rows := dbms_sql.execute(l_dynamic_cursor_id); -- Step 5
906: --
907: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);

Line 908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);

904: l_inactivate_user_count := 0;
905: l_rows := dbms_sql.execute(l_dynamic_cursor_id); -- Step 5
906: --
907: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);

Line 909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);

905: l_rows := dbms_sql.execute(l_dynamic_cursor_id); -- Step 5
906: --
907: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
913: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);

Line 910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);

906: --
907: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
913: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
914: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_term_date);

Line 911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);

907: WHILE dbms_sql.fetch_rows(l_dynamic_cursor_id) > 0 LOOP -- Step 6
908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
913: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
914: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_term_date);
915: --

Line 912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);

908: dbms_sql.column_value(l_dynamic_cursor_id, 1, l_person_id);
909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
913: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
914: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_term_date);
915: --
916: -- We only want to create the batch header when there is record retreived

Line 913: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);

909: dbms_sql.column_value(l_dynamic_cursor_id, 2, l_effective_start_date);
910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
913: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
914: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_term_date);
915: --
916: -- We only want to create the batch header when there is record retreived
917: -- from the dynamic sql statement. Otherwise, we won't create a header.

Line 914: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_term_date);

910: dbms_sql.column_value(l_dynamic_cursor_id, 3, l_effective_end_date);
911: dbms_sql.column_value(l_dynamic_cursor_id, 4, l_asg_id);
912: dbms_sql.column_value(l_dynamic_cursor_id, 5, l_asg_eff_start_date);
913: dbms_sql.column_value(l_dynamic_cursor_id, 6, l_asg_eff_end_date);
914: dbms_sql.column_value(l_dynamic_cursor_id, 7, l_term_date);
915: --
916: -- We only want to create the batch header when there is record retreived
917: -- from the dynamic sql statement. Otherwise, we won't create a header.
918: IF l_batch_id IS NOT NULL