DBA Data[Home] [Help]

APPS.HR_DU_DO_ENTITIES dependencies on HR_DU_DI_INSERT

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

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:

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

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: /*

Line 103: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(

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);

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

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);

Line 123: l_pval_parent_line_id := hr_du_di_insert.Return_Word(

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(

Line 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);

Line 130: l_parent_api_module_number := hr_du_di_insert.Return_Word(

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);

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

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:

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

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);

Line 348: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(

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);

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

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);

Line 368: l_pval_parent_line_id := hr_du_di_insert.Return_Word(

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(

Line 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);

Line 375: l_parent_api_module_number := hr_du_di_insert.Return_Word(

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(

Line 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);

Line 382: l_pval_api_module_number := hr_du_di_insert.Return_Word(

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);

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

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:

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

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);

Line 602: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(

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);

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

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);

Line 622: l_pval_parent_line_id :=hr_du_di_insert.Return_Word(

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(

Line 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);

Line 629: l_parent_api_module_number := hr_du_di_insert.Return_Word(

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(

Line 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);

Line 636: l_pval_api_module_number := hr_du_di_insert.Return_Word(

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);

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

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:

Line 838: hr_du_di_insert.g_delimiter_count := 0;

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);

Line 841: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(

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);

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

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);

Line 861: l_pval_parent_line_id := hr_du_di_insert.Return_Word(

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);

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

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:

Line 866: l_parent_api_module_number := 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:
869: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
870: p_values_table.r_pval_api_module_number);

Line 869: 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);
871:
872: l_pval_api_module_number := hr_du_di_insert.Return_Word(
873: p_values_table.r_pval_api_module_number , j);

Line 872: l_pval_api_module_number := hr_du_di_insert.Return_Word(

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);