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_DU_DO_DATAPUMP dependencies on HR_DU_DI_INSERT

Line 600: hr_du_di_insert.g_current_delimiter := ':';

596:
597: -- now work out the size of the user key separated by : loop around
598: -- getting it and then glue them on to a string
599:
600: hr_du_di_insert.g_current_delimiter := ':';
601:
602: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
603: g_values_table(l_array_pos).r_user_key_pval);
604:

Line 602: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

598: -- getting it and then glue them on to a string
599:
600: hr_du_di_insert.g_current_delimiter := ':';
601:
602: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
603: g_values_table(l_array_pos).r_user_key_pval);
604:
605: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(
606: g_values_table(l_array_pos).r_user_key_pval);

Line 605: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(

601:
602: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
603: g_values_table(l_array_pos).r_user_key_pval);
604:
605: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(
606: g_values_table(l_array_pos).r_user_key_pval);
607:
608: IF g_values_table(l_array_pos).r_user_key_pval IS NOT NULL THEN
609: --

Line 612: l_single_key := hr_du_di_insert.Return_Word(

608: IF g_values_table(l_array_pos).r_user_key_pval IS NOT NULL THEN
609: --
610: FOR j IN 1..l_number_keys LOOP
611:
612: l_single_key := hr_du_di_insert.Return_Word(
613: g_values_table(l_array_pos).r_user_key_pval, j);
614:
615: l_position := INSTRB( l_single_key, '%');
616:

Line 619: hr_du_di_insert.g_current_delimiter := '%';

615: l_position := INSTRB( l_single_key, '%');
616:
617: IF l_position > 0 THEN
618: --adds user stated strings to the user_key
619: hr_du_di_insert.g_current_delimiter := '%';
620:
621: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
622: Num_Delimiters(l_single_key);
623: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);

Line 621: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.

617: IF l_position > 0 THEN
618: --adds user stated strings to the user_key
619: hr_du_di_insert.g_current_delimiter := '%';
620:
621: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
622: Num_Delimiters(l_single_key);
623: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
624: l_actual_user_key := l_actual_user_key || ':' || '''' ||
625: l_single_key || '''';

Line 623: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);

619: hr_du_di_insert.g_current_delimiter := '%';
620:
621: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
622: Num_Delimiters(l_single_key);
623: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
624: l_actual_user_key := l_actual_user_key || ':' || '''' ||
625: l_single_key || '''';
626: ELSE
627: --adds column values to the user_key

Line 755: hr_du_di_insert.g_current_delimiter := ':';

751:
752: -- now work out the size of the user key separated by : loop around
753: -- getting it and then glue them on to a string
754:
755: hr_du_di_insert.g_current_delimiter := ':';
756:
757: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
758: g_values_table(l_array_pos).r_user_key_pval);
759:

Line 757: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

753: -- getting it and then glue them on to a string
754:
755: hr_du_di_insert.g_current_delimiter := ':';
756:
757: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
758: g_values_table(l_array_pos).r_user_key_pval);
759:
760: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(
761: g_values_table(l_array_pos).r_user_key_pval);

Line 760: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(

756:
757: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
758: g_values_table(l_array_pos).r_user_key_pval);
759:
760: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(
761: g_values_table(l_array_pos).r_user_key_pval);
762:
763: IF g_values_table(l_array_pos).r_user_key_pval IS NOT NULL THEN
764: --

Line 767: l_single_key := hr_du_di_insert.Return_Word(

763: IF g_values_table(l_array_pos).r_user_key_pval IS NOT NULL THEN
764: --
765: FOR j IN 1..l_number_keys LOOP
766:
767: l_single_key := hr_du_di_insert.Return_Word(
768: g_values_table(l_array_pos).r_user_key_pval, j);
769:
770: l_position := INSTRB( l_single_key, '%');
771:

Line 774: hr_du_di_insert.g_current_delimiter := '%';

770: l_position := INSTRB( l_single_key, '%');
771:
772: IF l_position > 0 THEN
773: --adds user stated strings to the user_key
774: hr_du_di_insert.g_current_delimiter := '%';
775:
776: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
777: Num_Delimiters(l_single_key);
778:

Line 776: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.

772: IF l_position > 0 THEN
773: --adds user stated strings to the user_key
774: hr_du_di_insert.g_current_delimiter := '%';
775:
776: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
777: Num_Delimiters(l_single_key);
778:
779: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
780: l_actual_user_key := l_actual_user_key || ':' || '''' ||

Line 779: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);

775:
776: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
777: Num_Delimiters(l_single_key);
778:
779: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
780: l_actual_user_key := l_actual_user_key || ':' || '''' ||
781: l_single_key || '''';
782: ELSE
783: --adds column values to the user_key

Line 873: hr_du_di_insert.g_current_delimiter := ',';

869: 10);
870: --
871:
872:
873: hr_du_di_insert.g_current_delimiter := ',';
874:
875: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
876: g_values_table(p_table_pos).r_insert_string);
877:

Line 875: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

871:
872:
873: hr_du_di_insert.g_current_delimiter := ',';
874:
875: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
876: g_values_table(p_table_pos).r_insert_string);
877:
878: l_number_names := hr_du_di_insert.WORDS_ON_LINE(
879: g_values_table(p_table_pos).r_insert_string);

Line 878: l_number_names := hr_du_di_insert.WORDS_ON_LINE(

874:
875: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
876: g_values_table(p_table_pos).r_insert_string);
877:
878: l_number_names := hr_du_di_insert.WORDS_ON_LINE(
879: g_values_table(p_table_pos).r_insert_string);
880:
881: FOR j IN 1..l_number_names LOOP
882: --

Line 883: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

879: g_values_table(p_table_pos).r_insert_string);
880:
881: FOR j IN 1..l_number_names LOOP
882: --
883: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
884: g_values_table(p_table_pos).r_insert_string);
885:
886: l_single_name := hr_du_di_insert.Return_Word(
887: g_values_table(p_table_pos).r_insert_string, j);

Line 886: l_single_name := hr_du_di_insert.Return_Word(

882: --
883: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
884: g_values_table(p_table_pos).r_insert_string);
885:
886: l_single_name := hr_du_di_insert.Return_Word(
887: g_values_table(p_table_pos).r_insert_string, j);
888:
889: IF l_single_name = p_mapped_name THEN
890: --

Line 891: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

887: g_values_table(p_table_pos).r_insert_string, j);
888:
889: IF l_single_name = p_mapped_name THEN
890: --
891: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
892: g_values_table(p_table_pos).r_PVAL_string);
893:
894: l_pval:= hr_du_di_insert.Return_Word(
895: g_values_table(p_table_pos).r_PVAL_string, j);

Line 894: l_pval:= hr_du_di_insert.Return_Word(

890: --
891: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
892: g_values_table(p_table_pos).r_PVAL_string);
893:
894: l_pval:= hr_du_di_insert.Return_Word(
895: g_values_table(p_table_pos).r_PVAL_string, j);
896: EXIT;
897: --
898: END IF;

Line 1130: hr_du_di_insert.g_current_delimiter := ':';

1126: l_user_key := EXTRACT_USER_KEY(p_upload_id, l_counter);
1127: hr_du_utility.message('INFO', 'API Module id : ' ||
1128: g_values_table(l_counter).r_api_id, 25);
1129:
1130: hr_du_di_insert.g_current_delimiter := ':';
1131:
1132: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
1133: Num_Delimiters(l_user_key);
1134: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(l_user_key);

Line 1132: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.

1128: g_values_table(l_counter).r_api_id, 25);
1129:
1130: hr_du_di_insert.g_current_delimiter := ':';
1131:
1132: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
1133: Num_Delimiters(l_user_key);
1134: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(l_user_key);
1135:
1136: FOR j IN 1..l_number_keys LOOP

Line 1134: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(l_user_key);

1130: hr_du_di_insert.g_current_delimiter := ':';
1131:
1132: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.
1133: Num_Delimiters(l_user_key);
1134: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(l_user_key);
1135:
1136: FOR j IN 1..l_number_keys LOOP
1137: l_key_pval := null;
1138: hr_du_di_insert.g_current_delimiter := ':';

Line 1138: hr_du_di_insert.g_current_delimiter := ':';

1134: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(l_user_key);
1135:
1136: FOR j IN 1..l_number_keys LOOP
1137: l_key_pval := null;
1138: hr_du_di_insert.g_current_delimiter := ':';
1139:
1140: l_single_key := hr_du_di_insert.Return_Word(l_user_key, j);
1141:
1142: l_position := INSTRB(l_single_key, '%');

Line 1140: l_single_key := hr_du_di_insert.Return_Word(l_user_key, j);

1136: FOR j IN 1..l_number_keys LOOP
1137: l_key_pval := null;
1138: hr_du_di_insert.g_current_delimiter := ':';
1139:
1140: l_single_key := hr_du_di_insert.Return_Word(l_user_key, j);
1141:
1142: l_position := INSTRB(l_single_key, '%');
1143:
1144: --No comments so compared to the column mappings

Line 1170: hr_du_di_insert.g_current_delimiter := '%';

1166:
1167: --
1168: --Comments exist so it's a special case user key
1169: ELSE
1170: hr_du_di_insert.g_current_delimiter := '%';
1171: hr_du_di_insert.g_delimiter_count :=
1172: hr_du_di_insert.Num_Delimiters(l_single_key);
1173: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
1174:

Line 1171: hr_du_di_insert.g_delimiter_count :=

1167: --
1168: --Comments exist so it's a special case user key
1169: ELSE
1170: hr_du_di_insert.g_current_delimiter := '%';
1171: hr_du_di_insert.g_delimiter_count :=
1172: hr_du_di_insert.Num_Delimiters(l_single_key);
1173: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
1174:
1175: --Checks begin to see if there are any pointers to DESCRIPTORS

Line 1172: hr_du_di_insert.Num_Delimiters(l_single_key);

1168: --Comments exist so it's a special case user key
1169: ELSE
1170: hr_du_di_insert.g_current_delimiter := '%';
1171: hr_du_di_insert.g_delimiter_count :=
1172: hr_du_di_insert.Num_Delimiters(l_single_key);
1173: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
1174:
1175: --Checks begin to see if there are any pointers to DESCRIPTORS
1176: l_position := INSTRB(l_single_key, '$');

Line 1173: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);

1169: ELSE
1170: hr_du_di_insert.g_current_delimiter := '%';
1171: hr_du_di_insert.g_delimiter_count :=
1172: hr_du_di_insert.Num_Delimiters(l_single_key);
1173: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
1174:
1175: --Checks begin to see if there are any pointers to DESCRIPTORS
1176: l_position := INSTRB(l_single_key, '$');
1177: --

Line 1180: hr_du_di_insert.g_current_delimiter := '$';

1176: l_position := INSTRB(l_single_key, '$');
1177: --
1178: IF l_position = 1 THEN
1179: --
1180: hr_du_di_insert.g_current_delimiter := '$';
1181: hr_du_di_insert.g_delimiter_count :=
1182: hr_du_di_insert.Num_Delimiters(l_single_key);
1183:
1184: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);

Line 1181: hr_du_di_insert.g_delimiter_count :=

1177: --
1178: IF l_position = 1 THEN
1179: --
1180: hr_du_di_insert.g_current_delimiter := '$';
1181: hr_du_di_insert.g_delimiter_count :=
1182: hr_du_di_insert.Num_Delimiters(l_single_key);
1183:
1184: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
1185:

Line 1182: hr_du_di_insert.Num_Delimiters(l_single_key);

1178: IF l_position = 1 THEN
1179: --
1180: hr_du_di_insert.g_current_delimiter := '$';
1181: hr_du_di_insert.g_delimiter_count :=
1182: hr_du_di_insert.Num_Delimiters(l_single_key);
1183:
1184: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
1185:
1186: OPEN csr_dollar_key;

Line 1184: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);

1180: hr_du_di_insert.g_current_delimiter := '$';
1181: hr_du_di_insert.g_delimiter_count :=
1182: hr_du_di_insert.Num_Delimiters(l_single_key);
1183:
1184: l_single_key := hr_du_di_insert.Return_Word(l_single_key, 2);
1185:
1186: OPEN csr_dollar_key;
1187: FETCH csr_dollar_key INTO l_temp;
1188: IF csr_dollar_key%NOTFOUND THEN