92: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 25);
93: hr_du_utility.message('INFO','l_parent_user_key : ' || l_parent_user_key , 30);
94: hr_du_utility.message('INFO','l_foreign_user_key : '||l_foreign_user_key , 35);
95:
96: hr_du_di_insert.g_current_delimiter := ',';
97:
98: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
99: p_values_table.r_pval_parent_line_id);
100:
94: hr_du_utility.message('INFO','l_foreign_user_key : '||l_foreign_user_key , 35);
95:
96: hr_du_di_insert.g_current_delimiter := ',';
97:
98: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
99: p_values_table.r_pval_parent_line_id);
100:
101: -- *********************************************************************************************************************
102: /*
99: p_values_table.r_pval_parent_line_id);
100:
101: -- *********************************************************************************************************************
102: /*
103: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
104: p_values_table.r_pval_parent_line_id);
105:
106: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
107: p_values_table.r_pval_parent_line_id , 40);
116: --references will take the last values in the loop
117: l_parent_user_key_2 := null;
118: l_foreign_user_key_2 := null;
119:
120: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
121: p_values_table.r_pval_parent_line_id );
122:
123: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
124: p_values_table.r_pval_parent_line_id , j);
119:
120: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
121: p_values_table.r_pval_parent_line_id );
122:
123: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
124: p_values_table.r_pval_parent_line_id , j);
125:
126:
127: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
123: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
124: p_values_table.r_pval_parent_line_id , j);
125:
126:
127: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
128: p_values_table.r_parent_api_module_number);
129:
130: l_parent_api_module_number := hr_du_di_insert.Return_Word(
131: p_values_table.r_parent_api_module_number , j);
126:
127: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
128: p_values_table.r_parent_api_module_number);
129:
130: l_parent_api_module_number := hr_du_di_insert.Return_Word(
131: p_values_table.r_parent_api_module_number , j);
132:
133: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
134: l_pval_parent_line_id , 50);
339: l_parent_user_key , 20);
340: hr_du_utility.message('INFO', 'l_foreign_user_key : ' ||
341: l_foreign_user_key , 25);
342:
343: hr_du_di_insert.g_current_delimiter := ',';
344:
345: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
346: p_values_table.r_pval_parent_line_id);
347:
341: l_foreign_user_key , 25);
342:
343: hr_du_di_insert.g_current_delimiter := ',';
344:
345: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
346: p_values_table.r_pval_parent_line_id);
347:
348: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
349: p_values_table.r_pval_parent_line_id);
344:
345: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
346: p_values_table.r_pval_parent_line_id);
347:
348: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
349: p_values_table.r_pval_parent_line_id);
350:
351: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||
352: p_values_table.r_pval_parent_line_id , 30);
361: --references will take the last values in the loop
362: l_parent_user_key_2 := null;
363: l_foreign_user_key_2 := null;
364:
365: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
366: p_values_table.r_pval_parent_line_id);
367:
368: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
369: p_values_table.r_pval_parent_line_id , j);
364:
365: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
366: p_values_table.r_pval_parent_line_id);
367:
368: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
369: p_values_table.r_pval_parent_line_id , j);
370:
371:
372: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
368: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
369: p_values_table.r_pval_parent_line_id , j);
370:
371:
372: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
373: p_values_table.r_parent_api_module_number);
374:
375: l_parent_api_module_number := hr_du_di_insert.Return_Word(
376: p_values_table.r_parent_api_module_number, j);
371:
372: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
373: p_values_table.r_parent_api_module_number);
374:
375: l_parent_api_module_number := hr_du_di_insert.Return_Word(
376: p_values_table.r_parent_api_module_number, j);
377:
378:
379: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
375: l_parent_api_module_number := hr_du_di_insert.Return_Word(
376: p_values_table.r_parent_api_module_number, j);
377:
378:
379: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
380: p_values_table.r_pval_api_module_number);
381:
382: l_pval_api_module_number := hr_du_di_insert.Return_Word(
383: p_values_table.r_pval_api_module_number , j);
378:
379: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
380: p_values_table.r_pval_api_module_number);
381:
382: l_pval_api_module_number := hr_du_di_insert.Return_Word(
383: p_values_table.r_pval_api_module_number , j);
384:
385: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
386: l_pval_parent_line_id , 40);
593: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 15);
594: hr_du_utility.message('INFO', 'l_parent_user_key : ' || l_parent_user_key , 20);
595: hr_du_utility.message('INFO', 'l_foreign_user_key : ' || l_foreign_user_key, 25);
596:
597: hr_du_di_insert.g_current_delimiter := ',';
598:
599: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
600: p_values_table.r_pval_parent_line_id);
601:
595: hr_du_utility.message('INFO', 'l_foreign_user_key : ' || l_foreign_user_key, 25);
596:
597: hr_du_di_insert.g_current_delimiter := ',';
598:
599: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
600: p_values_table.r_pval_parent_line_id);
601:
602: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
603: p_values_table.r_pval_parent_line_id);
598:
599: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
600: p_values_table.r_pval_parent_line_id);
601:
602: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
603: p_values_table.r_pval_parent_line_id);
604:
605: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
606: p_values_table.r_pval_parent_line_id , 30);
615: --references will take the last values in the loop
616: l_parent_user_key_2 := null;
617: l_foreign_user_key_2 := null;
618:
619: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
620: p_values_table.r_pval_parent_line_id);
621:
622: l_pval_parent_line_id :=hr_du_di_insert.Return_Word(
623: p_values_table.r_pval_parent_line_id , j);
618:
619: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
620: p_values_table.r_pval_parent_line_id);
621:
622: l_pval_parent_line_id :=hr_du_di_insert.Return_Word(
623: p_values_table.r_pval_parent_line_id , j);
624:
625:
626: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
622: l_pval_parent_line_id :=hr_du_di_insert.Return_Word(
623: p_values_table.r_pval_parent_line_id , j);
624:
625:
626: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
627: p_values_table.r_parent_api_module_number);
628:
629: l_parent_api_module_number := hr_du_di_insert.Return_Word(
630: p_values_table.r_parent_api_module_number, j);
625:
626: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
627: p_values_table.r_parent_api_module_number);
628:
629: l_parent_api_module_number := hr_du_di_insert.Return_Word(
630: p_values_table.r_parent_api_module_number, j);
631:
632:
633: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
629: l_parent_api_module_number := hr_du_di_insert.Return_Word(
630: p_values_table.r_parent_api_module_number, j);
631:
632:
633: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
634: p_values_table.r_pval_api_module_number);
635:
636: l_pval_api_module_number := hr_du_di_insert.Return_Word(
637: p_values_table.r_pval_api_module_number , j);
632:
633: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
634: p_values_table.r_pval_api_module_number);
635:
636: l_pval_api_module_number := hr_du_di_insert.Return_Word(
637: p_values_table.r_pval_api_module_number , j);
638:
639: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
640: l_pval_parent_line_id , 40);
831: CLOSE csr_line_id;
832:
833: hr_du_utility.message('INFO', 'l_row_id : ' || l_row_id , 15);
834:
835: hr_du_di_insert.g_current_delimiter := ',';
836:
837: -- no delimeters as we have 'none' as the user key
838: hr_du_di_insert.g_delimiter_count := 0;
839:
834:
835: hr_du_di_insert.g_current_delimiter := ',';
836:
837: -- no delimeters as we have 'none' as the user key
838: hr_du_di_insert.g_delimiter_count := 0;
839:
840: --
841: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
842: p_values_table.r_pval_parent_line_id);
837: -- no delimeters as we have 'none' as the user key
838: hr_du_di_insert.g_delimiter_count := 0;
839:
840: --
841: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
842: p_values_table.r_pval_parent_line_id);
843:
844: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||
845: p_values_table.r_pval_parent_line_id , 30);
854: --references will take the last values in the loop
855: l_parent_user_key_2 := null;
856: l_foreign_user_key_2 := null;
857:
858: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
859: p_values_table.r_pval_parent_line_id);
860:
861: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
862: p_values_table.r_pval_parent_line_id , j);
857:
858: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
859: p_values_table.r_pval_parent_line_id);
860:
861: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
862: p_values_table.r_pval_parent_line_id , j);
863:
864: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
865: p_values_table.r_parent_api_module_number);
860:
861: l_pval_parent_line_id := hr_du_di_insert.Return_Word(
862: p_values_table.r_pval_parent_line_id , j);
863:
864: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
865: p_values_table.r_parent_api_module_number);
866: l_parent_api_module_number := hr_du_di_insert.Return_Word(
867: p_values_table.r_parent_api_module_number, j);
868:
862: p_values_table.r_pval_parent_line_id , j);
863:
864: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
865: p_values_table.r_parent_api_module_number);
866: l_parent_api_module_number := hr_du_di_insert.Return_Word(
867: p_values_table.r_parent_api_module_number, j);
868:
869: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
870: p_values_table.r_pval_api_module_number);
865: p_values_table.r_parent_api_module_number);
866: l_parent_api_module_number := hr_du_di_insert.Return_Word(
867: p_values_table.r_parent_api_module_number, j);
868:
869: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
870: p_values_table.r_pval_api_module_number);
871:
872: l_pval_api_module_number := hr_du_di_insert.Return_Word(
873: p_values_table.r_pval_api_module_number , j);
868:
869: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
870: p_values_table.r_pval_api_module_number);
871:
872: l_pval_api_module_number := hr_du_di_insert.Return_Word(
873: p_values_table.r_pval_api_module_number , j);
874:
875: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
876: l_pval_parent_line_id , 40);