DBA Data[Home] [Help]

APPS.HR_DU_MASTER dependencies on HR_DU_UPLOADS

Line 9: -- Description: Create the entry in hr_du_uploads for the migration

5: /*-------------------------- PRIVATE ROUTINES ----------------------------*/
6:
7:
8: -- -------------------------- create_upload -------------------------------
9: -- Description: Create the entry in hr_du_uploads for the migration
10: --
11: --
12: --
13: -- Input Parameters

Line 34: SELECT hr_du_uploads_s.currval

30: FROM hr_du_modules
31: WHERE module_name = 'Spreadsheet-to-lines';
32:
33: CURSOR csr_upload IS
34: SELECT hr_du_uploads_s.currval
35: FROM dual;
36:
37: l_module_id NUMBER;
38:

Line 53: INSERT INTO hr_du_uploads (

49: CLOSE csr_module;
50:
51: hr_du_utility.message('INFO','performing insert', 15);
52:
53: INSERT INTO hr_du_uploads (
54: UPLOAD_ID,
55: MODULE_ID,
56: BATCH_ID,
57: SOURCE,

Line 70: hr_du_uploads_s.nextval,

66: CREATED_BY,
67: CREATION_DATE
68: )
69: SELECT
70: hr_du_uploads_s.nextval,
71: l_module_id,
72: null,
73: r_upload_data.filename,
74: 'NS',

Line 165: -- create the entry in hr_du_uploads

161:
162: -- update record with filename
163: r_upload_data.filename := p_filename;
164:
165: -- create the entry in hr_du_uploads
166: create_upload(r_upload_data);
167:
168:
169: --From the spread sheet to the HR_DU_UPLOAD_LINES