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_ENTITIES dependencies on HR_DU_UPLOAD_LINES

Line 21: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES

17: --
18: -- p_process_order - Number to tell data pump the order in which
19: -- to process the record
20: --
21: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES
22: -- table that holds all the data to be
23: -- pushed into the HR_PUMP_BATCH_LINES
24: --
25: -- p_pump_batch_line_id - Identifies the Pump batch line to be used

Line 57: FROM hr_du_upload_lines

53: l_rows_processed INT;
54:
55: CURSOR csr_line_id IS
56: SELECT PVAl001
57: FROM hr_du_upload_lines
58: WHERE UPLOAD_LINE_ID = p_upload_line_id;
59:
60:
61: BEGIN

Line 144: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

140: --then it is
141: IF l_parent_api_module_number IS NOT NULL THEN
142: --want to extract the value in the id column
143: l_temp_id := hr_du_dp_pc_conversion.return_field_value
144: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
145: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
146:
147: hr_du_utility.message('INFO','l_temp_id 1 : ' || l_temp_id , 65);
148:

Line 169: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

165: --generic column
166: ELSE
167: --want to extract both the table and id values
168: l_temp_id := hr_du_dp_pc_conversion.return_field_value
169: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
170: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
171:
172: hr_du_utility.message('INFO','l_temp_id 2 : ' || l_temp_id , 90);
173:

Line 178: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

174: -- Check to see if there's a value with in the reference column
175: --of that api_module
176: IF l_temp_id IS NOT NULL THEN
177: l_temp_api_module := hr_du_dp_pc_conversion.return_field_value
178: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
179: 'UPLOAD_LINE_ID', l_pval_api_module_number);
180:
181: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 95);
182:

Line 226: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||

222: '''' ||l_parent_user_key || ''',' ||
223: '''' ||l_parent_user_key || ':ASG' || ''',';
224:
225: l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;
226: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
227: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
228:
229: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
230:

Line 267: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES

263: --
264: -- p_process_order - Number to tell data pump the order in which
265: -- to process the record
266: --
267: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES
268: -- table that holds all the data to be
269: -- pushed into the HR_PUMP_BATCH_LINES
270: --
271: -- p_pump_batch_line_id - Identifies the Pump batch line to be used

Line 303: FROM hr_du_upload_lines

299: l_rows_processed INT;
300:
301: CURSOR csr_line_id IS
302: SELECT PVAl001
303: FROM hr_du_upload_lines
304: WHERE UPLOAD_LINE_ID = p_upload_line_id;
305:
306: BEGIN
307:

Line 396: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

392:
393: IF l_parent_api_module_number IS NOT NULL THEN
394: --want to extract the value in the id column
395: l_temp_id := hr_du_dp_pc_conversion.return_field_value
396: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
397: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
398:
399: --Check to see if there's a value with in the reference column of
400: --the api_module

Line 421: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

417: --generic column
418: ELSE
419: --want to extract both the table and id values
420: l_temp_id := hr_du_dp_pc_conversion.return_field_value
421: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
422: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
423:
424: -- Check to see if there's a value with in the reference column
425: --of that api_module

Line 428: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

424: -- Check to see if there's a value with in the reference column
425: --of that api_module
426: IF l_temp_id IS NOT NULL THEN
427: l_temp_api_module := hr_du_dp_pc_conversion.return_field_value
428: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
429: 'UPLOAD_LINE_ID', l_pval_api_module_number);
430:
431:
432: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(

Line 480: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||

476: END IF;
477:
478: l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;
479:
480: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
481: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
482:
483: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
484:

Line 522: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES

518: --
519: -- p_process_order - Number to tell data pump the order in which
520: -- to process the record
521: --
522: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES
523: -- table that holds all the data to be
524: -- pushed into the HR_PUMP_BATCH_LINES
525: --
526: -- p_pump_batch_line_id - Identifies the Pump batch line to be used

Line 560: FROM hr_du_upload_lines

556: l_rows_processed INT;
557:
558: CURSOR csr_line_id IS
559: SELECT PVAl001
560: FROM hr_du_upload_lines
561: WHERE UPLOAD_LINE_ID = p_upload_line_id;
562:
563: BEGIN
564:

Line 651: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

647: --then it is
648: IF l_parent_api_module_number IS NOT NULL THEN
649: --want to extract the value in the id column
650: l_temp_id := hr_du_dp_pc_conversion.return_field_value
651: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
652: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
653:
654: --Check to see if there's a value with in the reference column of
655: --the api_module

Line 674: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

670: --generic column
671: ELSE
672: --want to extract both the table and id values
673: l_temp_id := hr_du_dp_pc_conversion.return_field_value
674: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
675: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
676:
677: --Check to see if there's a value with in the reference column
678: --of that api_module

Line 681: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

677: --Check to see if there's a value with in the reference column
678: --of that api_module
679: IF l_temp_id IS NOT NULL THEN
680: l_temp_api_module := hr_du_dp_pc_conversion.return_field_value
681: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
682: 'UPLOAD_LINE_ID', l_pval_api_module_number);
683:
684: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 75);
685:

Line 727: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||

723: p_process_order || ',' || '1' || ',' ||
724: '''' ||l_parent_user_key_2 || ':ASG' || ''',';
725:
726: l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;
727: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
728: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
729:
730: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
731: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

Line 767: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES

763: --
764: -- p_process_order - Number to tell data pump the order in which
765: -- to process the record
766: --
767: -- p_upload_line_id - ID of the line in the HR_DU_UPLOAD_LINES
768: -- table that holds all the data to be
769: -- pushed into the HR_PUMP_BATCH_LINES
770: --
771: -- p_pump_batch_line_id - Identifies the Pump batch line to be used

Line 803: FROM hr_du_upload_lines

799: l_rows_processed INT;
800:
801: CURSOR csr_line_id IS
802: SELECT PVAl001
803: FROM hr_du_upload_lines
804: WHERE UPLOAD_LINE_ID = p_upload_line_id;
805:
806:
807: BEGIN

Line 887: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

883: --then it is
884: IF l_parent_api_module_number IS NOT NULL THEN
885: --want to extract the value in the id column
886: l_temp_id := hr_du_dp_pc_conversion.return_field_value
887: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
888: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
889:
890: hr_du_utility.message('INFO','l_temp_id 1 : ' || l_temp_id , 55);
891:

Line 914: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

910: ELSE
911:
912: --want to extract both the table and id values
913: l_temp_id := hr_du_dp_pc_conversion.return_field_value
914: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
915: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
916:
917: -- Check to see if there's a value with in the reference column
918: --of that api_module

Line 921: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

917: -- Check to see if there's a value with in the reference column
918: --of that api_module
919: IF l_temp_id IS NOT NULL THEN
920: l_temp_api_module := hr_du_dp_pc_conversion.return_field_value
921: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
922: 'UPLOAD_LINE_ID', l_pval_api_module_number);
923:
924: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module,
925: 80);

Line 974: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||

970: END IF;
971:
972: l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;
973:
974: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
975: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
976:
977: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
978: