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

Line 7: -- HR_DU_DESCRIPTORS table, and is matched to the api name in header sheet

3:
4:
5: -- ------------------------- API_PRESENT_AND_CORRECT -----------------------
6: -- Description: Double checks that the API name exists in the
7: -- HR_DU_DESCRIPTORS table, and is matched to the api name in header sheet
8: --
9: -- Input Parameters
10: --
11: -- p_upload_header_id - Identifies the API's file for which the process

Line 21: FROM hr_du_descriptors

17:
18: --This cursor extracts the api name from the descriptors
19: CURSOR csr_api_name IS
20: SELECT upper(VALUE)
21: FROM hr_du_descriptors
22: WHERE upper(DESCRIPTOR) = 'API'
23: AND UPLOAD_HEADER_ID = p_upload_header_id;
24:
25: --checks the header descriptors to check that the API name matches

Line 28: FROM hr_du_descriptors

24:
25: --checks the header descriptors to check that the API name matches
26: CURSOR csr_api_header IS
27: SELECT upper(DESCRIPTOR)
28: FROM hr_du_descriptors
29: WHERE DESCRIPTOR_TYPE = 'F'
30: AND UPLOAD_ID = p_upload_id
31: AND upload_header_id IS NULL;
32:

Line 95: -- HR_DU_DESCRIPTORS table.

91:
92:
93: -- ------------------------- PROCESS_ORDER_PRESENT ------------------------
94: -- Description: Double checks that the process order exists in the
95: -- HR_DU_DESCRIPTORS table.
96: --
97: -- Input Parameters
98: --
99: -- p_upload_header_id - Identifies the API's file for which the process

Line 108: FROM hr_du_descriptors

104:
105: --This cursor extracts the Process Order from the descriptors
106: CURSOR csr_process_order IS
107: SELECT VALUE
108: FROM hr_du_descriptors
109: WHERE upper(DESCRIPTOR) = 'PROCESS ORDER'
110: AND UPLOAD_HEADER_ID = p_upload_header_id;
111:
112: e_fatal_error EXCEPTION;

Line 169: FROM hr_du_descriptors des1,

165: IS
166:
167: CURSOR csr_api_file IS
168: SELECT des2.value
169: FROM hr_du_descriptors des1,
170: hr_du_descriptors des2,
171: hr_du_upload_headers head,
172: hr_du_uploads uplo
173: WHERE head.upload_header_id = p_upload_header_id

Line 170: hr_du_descriptors des2,

166:
167: CURSOR csr_api_file IS
168: SELECT des2.value
169: FROM hr_du_descriptors des1,
170: hr_du_descriptors des2,
171: hr_du_upload_headers head,
172: hr_du_uploads uplo
173: WHERE head.upload_header_id = p_upload_header_id
174: AND head.upload_id = uplo.upload_id

Line 241: FROM hr_du_descriptors

237:
238: --This cursor extracts the user key from the upload table
239: CURSOR csr_user_key IS
240: SELECT VALUE
241: FROM hr_du_descriptors
242: WHERE upper(DESCRIPTOR) = 'USER KEY'
243: AND UPLOAD_HEADER_ID = p_upload_header_id;
244:
245: e_fatal_error EXCEPTION;

Line 261: INSERT INTO HR_DU_DESCRIPTORS(

257: OPEN csr_user_key;
258: FETCH csr_user_key INTO l_user_key;
259: IF csr_user_key%NOTFOUND THEN
260: --
261: INSERT INTO HR_DU_DESCRIPTORS(
262: DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
263: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
264: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
265: CREATION_DATE)

Line 267: HR_DU_DESCRIPTORS_S.nextval,

263: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
264: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
265: CREATION_DATE)
266: VALUES(
267: HR_DU_DESCRIPTORS_S.nextval,
268: p_upload_id,
269: p_upload_header_id,
270: 'USER KEY',
271: '%NONE%',

Line 331: FROM hr_du_descriptors des,

327: --Cursor compares the user key word to HR_DU_COLUMN_MAPPINGS
328: --in the main header for all API's
329: CURSOR csr_dollar_key IS
330: SELECT des.VALUE
331: FROM hr_du_descriptors des,
332: hr_du_upload_headers head
333: WHERE head.upload_header_id = p_upload_header_id
334: AND head.upload_id = des.upload_id
335: AND des.upload_header_id IS NULL

Line 342: FROM hr_du_descriptors

338: --Cursor compares the user key word to HR_DU_COLUMN_MAPPINGS
339: --in the specific API header
340: CURSOR csr_dollar_key_api IS
341: SELECT VALUE
342: FROM hr_du_descriptors
343: WHERE upload_header_id = p_upload_header_id
344: AND upper(descriptor) = upper(l_pval_value);
345:
346:

Line 472: FROM hr_du_descriptors

468: --This cursor extracts the starting point from the descriptors if its
469: --present
470: CURSOR csr_starting_point IS
471: SELECT VALUE
472: FROM hr_du_descriptors
473: WHERE upper(DESCRIPTOR) = 'STARTING POINT'
474: AND UPLOAD_header_ID = p_upload_header_id;
475:
476:

Line 494: INSERT INTO HR_DU_DESCRIPTORS(

490: OPEN csr_starting_point;
491: FETCH csr_starting_point INTO l_starting_point;
492: IF csr_starting_point%NOTFOUND THEN
493: --
494: INSERT INTO HR_DU_DESCRIPTORS(
495: DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
496: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
497: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
498: CREATION_DATE)

Line 500: HR_DU_DESCRIPTORS_S.nextval,

496: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
497: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
498: CREATION_DATE)
499: VALUES(
500: HR_DU_DESCRIPTORS_S.nextval,
501: p_upload_id,
502: p_upload_header_id,
503: 'STARTING POINT',
504: 'NO',

Line 558: FROM hr_du_descriptors

554: --This cursor extracts the Referencing value from the descriptors if its
555: --present
556: CURSOR csr_referencing IS
557: SELECT VALUE
558: FROM hr_du_descriptors
559: WHERE upper(DESCRIPTOR) = 'REFERENCING'
560: AND UPLOAD_header_ID = p_upload_header_id;
561:
562: --exception to raise

Line 580: INSERT INTO HR_DU_DESCRIPTORS(

576: OPEN csr_referencing;
577: FETCH csr_referencing INTO l_referencing;
578: IF csr_referencing%NOTFOUND THEN
579: --
580: INSERT INTO HR_DU_DESCRIPTORS(
581: DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
582: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
583: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
584: CREATION_DATE)

Line 586: HR_DU_DESCRIPTORS_S.nextval,

582: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
583: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
584: CREATION_DATE)
585: VALUES(
586: HR_DU_DESCRIPTORS_S.nextval,
587: p_upload_id,
588: p_upload_header_id,
589: 'REFERENCING',
590: 'CP',