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_DI_INSERT dependencies on HR_DU_DESCRIPTORS

Line 26: FROM hr_du_descriptors

22: l_file_name VARCHAR2(2000);
23:
24: CURSOR csr_unique_desc IS
25: SELECT count (descriptor)
26: FROM hr_du_descriptors
27: WHERE upload_id = p_upload_id
28: AND upload_header_id = p_upload_header_id;
29:
30: CURSOR csr_total_desc IS

Line 32: FROM hr_du_descriptors

28: AND upload_header_id = p_upload_header_id;
29:
30: CURSOR csr_total_desc IS
31: SELECT count(distinct descriptor)
32: FROM hr_du_descriptors
33: WHERE upload_id = p_upload_id
34: AND upload_header_id = p_upload_header_id;
35:
36: BEGIN

Line 109: FROM hr_du_descriptors

105:
106: --counts all headers
107: CURSOR csr_unique_desc IS
108: SELECT count (descriptor)
109: FROM hr_du_descriptors
110: WHERE upload_id = p_upload_id
111: AND upload_header_id IS NULL;
112:
113: --counts all unique headers

Line 116: FROM hr_du_descriptors

112:
113: --counts all unique headers
114: CURSOR csr_total_desc IS
115: SELECT count(distinct descriptor)
116: FROM hr_du_descriptors
117: WHERE upload_id = p_upload_id
118: AND upload_header_id IS NULL;
119:
120: BEGIN

Line 306: FROM hr_du_descriptors

302: l_fatal_error_message VARCHAR2(2000);
303:
304: CURSOR csr_total_count IS
305: SELECT count (value)
306: FROM hr_du_descriptors
307: WHERE upload_id = p_upload_id
308: AND DESCRIPTOR_TYPE = 'F';
309:
310: CURSOR csr_file_count IS

Line 312: FROM hr_du_descriptors

308: AND DESCRIPTOR_TYPE = 'F';
309:
310: CURSOR csr_file_count IS
311: SELECT count(distinct value)
312: FROM hr_du_descriptors
313: WHERE upload_id = p_upload_id
314: AND DESCRIPTOR_TYPE = 'F';
315:
316: BEGIN

Line 425: hr_du_descriptors des

421: CURSOR csr_API_name IS
422: SELECT upper(des.value)
423: FROM hr_du_upload_headers head,
424: hr_api_modules api,
425: hr_du_descriptors des
426: WHERE head.upload_header_id = p_upload_header_id
427: AND head.upload_header_id = des.upload_header_id
428: AND head.api_module_id = api.api_module_id
429: AND upper(api.module_name) = upper(des.value);

Line 885: -- Description: This procedure updates the HR_DU_DESCRIPTORS tables

881: END RETURN_WORD;
882:
883:
884: -- ------------------------- GENERAL_EXTRACT ------------------------------
885: -- Description: This procedure updates the HR_DU_DESCRIPTORS tables
886: -- by storing the API names and locations into table
887: --
888: -- Input Parameters
889: -- p_filehandle - the file to be worked on

Line 981: INSERT INTO HR_DU_DESCRIPTORS(

977: AND (UPPER(l_Col_two) = 'END');
978:
979: --insert into the descriptors table the values
980: hr_du_utility.message('INFO','Insert statement', 25);
981: INSERT INTO HR_DU_DESCRIPTORS(
982: DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
983: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
984: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
985: CREATION_DATE)

Line 987: HR_DU_DESCRIPTORS_S.nextval,

983: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
984: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
985: CREATION_DATE)
986: VALUES(
987: HR_DU_DESCRIPTORS_S.nextval,
988: p_upload_id,
989: p_upload_header_id,
990: UPPER(l_Col_one),
991: l_Col_two,

Line 1194: hr_du_descriptors des

1190: CURSOR csr_files IS
1191: SELECT des.descriptor_id, api.api_module_id, upper(api.module_NAME),
1192: des.VALUE
1193: FROM hr_api_modules api,
1194: hr_du_descriptors des
1195: WHERE upper(api.module_NAME) = upper(des.DESCRIPTOR)
1196: AND des.DESCRIPTOR_TYPE = 'F'
1197: AND des.upload_id = p_upload_id;
1198:

Line 1204: FROM hr_du_descriptors des

1200: --This cursor identifies the api_names that aren't spelt correctly
1201: --within the flat file.
1202: CURSOR csr_incorrect IS
1203: SELECT des.DESCRIPTOR
1204: FROM hr_du_descriptors des
1205: WHERE des.DESCRIPTOR_TYPE = 'F'
1206: AND des.upload_id = p_upload_id
1207: AND upper(des.DESCRIPTOR) NOT IN ( SELECT upper(des.DESCRIPTOR)
1208: FROM hr_api_modules api,

Line 1209: hr_du_descriptors des

1205: WHERE des.DESCRIPTOR_TYPE = 'F'
1206: AND des.upload_id = p_upload_id
1207: AND upper(des.DESCRIPTOR) NOT IN ( SELECT upper(des.DESCRIPTOR)
1208: FROM hr_api_modules api,
1209: hr_du_descriptors des
1210: WHERE upper(api.module_NAME) =
1211: upper(des.DESCRIPTOR)
1212: AND des.DESCRIPTOR_TYPE = 'F'
1213: AND des.upload_id = p_upload_id);

Line 1301: UPDATE hr_du_descriptors

1297: l_found_value := TRUE;
1298:
1299: --Here I'll set the API value in the descriptor table to null
1300: --so that it isn't retrieved in later searches
1301: UPDATE hr_du_descriptors
1302: SET value = NULL
1303: WHERE upload_header_id = l_original_upload_header_id
1304: AND descriptor = 'API';
1305:

Line 1372: FROM hr_du_descriptors

1368:
1369: --This cursor extracts the business group name from the upload table
1370: CURSOR csr_business_group IS
1371: SELECT VALUE
1372: FROM hr_du_descriptors
1373: WHERE DESCRIPTOR = 'BUSINESS GROUP'
1374: AND UPLOAD_ID = p_upload_id;
1375:
1376: --This cursor extracts the global data flag from the upload table

Line 1379: FROM hr_du_descriptors

1375:
1376: --This cursor extracts the global data flag from the upload table
1377: CURSOR csr_global_data IS
1378: SELECT VALUE
1379: FROM hr_du_descriptors
1380: WHERE DESCRIPTOR = 'GLOBAL DATA'
1381: AND UPLOAD_ID = p_upload_id;
1382:
1383: --This cursor extracts the batch name from the upload table

Line 1386: FROM hr_du_descriptors

1382:
1383: --This cursor extracts the batch name from the upload table
1384: CURSOR csr_batch_name IS
1385: SELECT VALUE
1386: FROM hr_du_descriptors
1387: WHERE DESCRIPTOR = 'BATCH NAME'
1388: AND UPLOAD_ID = p_upload_id;
1389:
1390: --This cursor extracts the business group name from the id value

Line 1457: UPDATE hr_du_descriptors

1453: SET BUSINESS_GROUP_NAME = l_business_group_name
1454: WHERE UPLOAD_ID = p_upload_id;
1455:
1456: -- update descriptors table to ensure that the correct value is used
1457: UPDATE hr_du_descriptors
1458: SET VALUE = l_business_group_name
1459: WHERE DESCRIPTOR = 'BUSINESS GROUP'
1460: AND UPLOAD_ID = p_upload_id;
1461:

Line 1464: INSERT INTO HR_DU_DESCRIPTORS(

1460: AND UPLOAD_ID = p_upload_id;
1461:
1462: -- check if a row has been updated, otherwise insert a record
1463: IF SQL%ROWCOUNT = 0 THEN
1464: INSERT INTO HR_DU_DESCRIPTORS(
1465: DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
1466: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
1467: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
1468: CREATION_DATE)

Line 1470: HR_DU_DESCRIPTORS_S.nextval,

1466: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
1467: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
1468: CREATION_DATE)
1469: VALUES(
1470: HR_DU_DESCRIPTORS_S.nextval,
1471: p_upload_id,
1472: null,
1473: 'BUSINESS GROUP',
1474: l_business_group_name,

Line 2072: DELETE FROM HR_DU_DESCRIPTORS

2068: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')',
2069: 10);
2070: --
2071:
2072: DELETE FROM HR_DU_DESCRIPTORS
2073: WHERE UPLOAD_ID = p_upload_id;
2074: COMMIT;
2075:
2076: DELETE FROM HR_DU_UPLOAD_LINES