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.HRDU_DO_API_TRANSLATE dependencies on UTL_FILE

Line 110: PROCEDURE hrdu_get_api_columns( p_filehandle IN UTL_FILE.FILE_TYPE, p_api_name IN Varchar2 )

106: -- should be outputted to
107: -- p_api_name - Database name of the API to find columns for
108: --
109: -- -------------------------------------------------------------------------
110: PROCEDURE hrdu_get_api_columns( p_filehandle IN UTL_FILE.FILE_TYPE, p_api_name IN Varchar2 )
111: IS
112:
113: cursor columns_csr is
114: select distinct column_id, lower( substr(column_name, 3, length(column_name) - 2) ) column_headings

Line 121: l_scripthandle UTL_FILE.FILE_TYPE;

117: and column_name like 'P_%'
118: order by column_headings;
119:
120: columns_rec columns_csr%rowtype;
121: l_scripthandle UTL_FILE.FILE_TYPE;
122: l_location VARCHAR2(2000);
123:
124: BEGIN
125: -- Fill in first column of the csv file

Line 126: utl_file.put(p_filehandle, 'ID' );

122: l_location VARCHAR2(2000);
123:
124: BEGIN
125: -- Fill in first column of the csv file
126: utl_file.put(p_filehandle, 'ID' );
127:
128: -- Open the new script file for writing
129: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
130: l_scripthandle := utl_file.fopen(l_location, 'hrdu_' || LOWER(p_api_name) || '.sql', 'w', 32767);

Line 130: l_scripthandle := utl_file.fopen(l_location, 'hrdu_' || LOWER(p_api_name) || '.sql', 'w', 32767);

126: utl_file.put(p_filehandle, 'ID' );
127:
128: -- Open the new script file for writing
129: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
130: l_scripthandle := utl_file.fopen(l_location, 'hrdu_' || LOWER(p_api_name) || '.sql', 'w', 32767);
131:
132: -- First create the header for the new script file
133: utl_file.put_line(l_scripthandle, 'REM /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */' );
134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );

Line 133: utl_file.put_line(l_scripthandle, 'REM /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */' );

129: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
130: l_scripthandle := utl_file.fopen(l_location, 'hrdu_' || LOWER(p_api_name) || '.sql', 'w', 32767);
131:
132: -- First create the header for the new script file
133: utl_file.put_line(l_scripthandle, 'REM /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */' );
134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );
136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );

Line 134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );

130: l_scripthandle := utl_file.fopen(l_location, 'hrdu_' || LOWER(p_api_name) || '.sql', 'w', 32767);
131:
132: -- First create the header for the new script file
133: utl_file.put_line(l_scripthandle, 'REM /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */' );
134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );
136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );

Line 135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );

131:
132: -- First create the header for the new script file
133: utl_file.put_line(l_scripthandle, 'REM /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */' );
134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );
136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );

Line 136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );

132: -- First create the header for the new script file
133: utl_file.put_line(l_scripthandle, 'REM /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */' );
134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );
136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );

Line 137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );

133: utl_file.put_line(l_scripthandle, 'REM /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */' );
134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );
136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );

Line 138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );

134: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );
136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);

Line 139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );

135: utl_file.put_line(l_scripthandle, 'REM | Copyright (c) 2000 Oracle Corporation UK Ltd | ' );
136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );

Line 140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );

136: utl_file.put_line(l_scripthandle, 'REM | Reading, Berkshire, England | ' );
137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );

Line 141: utl_file.put_line(l_scripthandle, 'REM ' );

137: utl_file.put_line(l_scripthandle, 'REM | All rights reserved. | ' );
138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );

Line 142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);

138: utl_file.put_line(l_scripthandle, 'REM +======================================================================+' );
139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );

Line 143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );

139: utl_file.put_line(l_scripthandle, 'REM API for translation : ' || upper(p_api_name) );
140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );

Line 144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );

140: utl_file.put_line(l_scripthandle, 'REM Data pump view name : ' || substr( upper( 'HRDPV_' || p_api_name ), 1, 30 ) );
141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );

Line 145: utl_file.put_line(l_scripthandle, 'REM ' );

141: utl_file.put_line(l_scripthandle, 'REM ' );
142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );

Line 146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );

142: utl_file.put_line(l_scripthandle, 'REM Description: Script created to load the API: ' || p_api_name);
143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );

Line 147: utl_file.put_line(l_scripthandle, 'REM ============ ' );

143: utl_file.put_line(l_scripthandle, 'REM into the HRMS Data Uploader. Edit the script then run it to' );
144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );
151: utl_file.put_line(l_scripthandle, 'REM' );

Line 148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );

144: utl_file.put_line(l_scripthandle, 'REM populate the data uploader tables.' );
145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );
151: utl_file.put_line(l_scripthandle, 'REM' );
152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );

Line 149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );

145: utl_file.put_line(l_scripthandle, 'REM ' );
146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );
151: utl_file.put_line(l_scripthandle, 'REM' );
152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );
153: utl_file.new_line(l_scripthandle, 1 );

Line 150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );

146: utl_file.put_line(l_scripthandle, 'REM Change List: ' );
147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );
151: utl_file.put_line(l_scripthandle, 'REM' );
152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );
153: utl_file.new_line(l_scripthandle, 1 );
154:

Line 151: utl_file.put_line(l_scripthandle, 'REM' );

147: utl_file.put_line(l_scripthandle, 'REM ============ ' );
148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );
151: utl_file.put_line(l_scripthandle, 'REM' );
152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );
153: utl_file.new_line(l_scripthandle, 1 );
154:
155: -- Create list of columns that are probably going to need to be changed

Line 152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );

148: utl_file.put_line(l_scripthandle, 'REM Name Date Version Bug Text ' );
149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );
151: utl_file.put_line(l_scripthandle, 'REM' );
152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );
153: utl_file.new_line(l_scripthandle, 1 );
154:
155: -- Create list of columns that are probably going to need to be changed
156: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );

Line 153: utl_file.new_line(l_scripthandle, 1 );

149: utl_file.put_line(l_scripthandle, 'REM -------------- ----------- ------- ------- -----------------------------' );
150: utl_file.put_line(l_scripthandle, 'REM ' || to_char(sysdate, 'DD-Mon-RRRR') || ' 1 - Auto generated code' );
151: utl_file.put_line(l_scripthandle, 'REM' );
152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );
153: utl_file.new_line(l_scripthandle, 1 );
154:
155: -- Create list of columns that are probably going to need to be changed
156: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
157: utl_file.put_line(l_scripthandle, 'REM Columns which are most likely to need editing to include references to' );

Line 156: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );

152: utl_file.put_line(l_scripthandle, 'REM ========================================================================' );
153: utl_file.new_line(l_scripthandle, 1 );
154:
155: -- Create list of columns that are probably going to need to be changed
156: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
157: utl_file.put_line(l_scripthandle, 'REM Columns which are most likely to need editing to include references to' );
158: utl_file.put_line(l_scripthandle, 'REM other API''s are shown below :-' );
159: utl_file.put_line(l_scripthandle, 'REM ' );
160:

Line 157: utl_file.put_line(l_scripthandle, 'REM Columns which are most likely to need editing to include references to' );

153: utl_file.new_line(l_scripthandle, 1 );
154:
155: -- Create list of columns that are probably going to need to be changed
156: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
157: utl_file.put_line(l_scripthandle, 'REM Columns which are most likely to need editing to include references to' );
158: utl_file.put_line(l_scripthandle, 'REM other API''s are shown below :-' );
159: utl_file.put_line(l_scripthandle, 'REM ' );
160:
161: -- Get a list of most common columns that need changing

Line 158: utl_file.put_line(l_scripthandle, 'REM other API''s are shown below :-' );

154:
155: -- Create list of columns that are probably going to need to be changed
156: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
157: utl_file.put_line(l_scripthandle, 'REM Columns which are most likely to need editing to include references to' );
158: utl_file.put_line(l_scripthandle, 'REM other API''s are shown below :-' );
159: utl_file.put_line(l_scripthandle, 'REM ' );
160:
161: -- Get a list of most common columns that need changing
162: for columns_rec in columns_csr loop

Line 159: utl_file.put_line(l_scripthandle, 'REM ' );

155: -- Create list of columns that are probably going to need to be changed
156: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
157: utl_file.put_line(l_scripthandle, 'REM Columns which are most likely to need editing to include references to' );
158: utl_file.put_line(l_scripthandle, 'REM other API''s are shown below :-' );
159: utl_file.put_line(l_scripthandle, 'REM ' );
160:
161: -- Get a list of most common columns that need changing
162: for columns_rec in columns_csr loop
163: IF ( ( substr( columns_rec.column_headings, length(columns_rec.column_headings) - 2, 3 ) = '_id' ) OR

Line 165: utl_file.put_line(l_scripthandle, 'REM * ' || columns_rec.column_headings );

161: -- Get a list of most common columns that need changing
162: for columns_rec in columns_csr loop
163: IF ( ( substr( columns_rec.column_headings, length(columns_rec.column_headings) - 2, 3 ) = '_id' ) OR
164: ( columns_rec.column_headings like '%user%key%' ) ) THEN
165: utl_file.put_line(l_scripthandle, 'REM * ' || columns_rec.column_headings );
166: END IF;
167: end loop;
168:
169: utl_file.put_line(l_scripthandle, 'REM ' );

Line 169: utl_file.put_line(l_scripthandle, 'REM ' );

165: utl_file.put_line(l_scripthandle, 'REM * ' || columns_rec.column_headings );
166: END IF;
167: end loop;
168:
169: utl_file.put_line(l_scripthandle, 'REM ' );
170: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );
172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );

Line 170: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );

166: END IF;
167: end loop;
168:
169: utl_file.put_line(l_scripthandle, 'REM ' );
170: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );
172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );

Line 171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );

167: end loop;
168:
169: utl_file.put_line(l_scripthandle, 'REM ' );
170: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );
172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );

Line 172: utl_file.put_line(l_scripthandle, 'REM ' );

168:
169: utl_file.put_line(l_scripthandle, 'REM ' );
170: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );
172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');

Line 173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );

169: utl_file.put_line(l_scripthandle, 'REM ' );
170: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );
172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );

Line 174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );

170: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );
172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );

Line 175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );

171: utl_file.put_line(l_scripthandle, 'REM Example of a modified column entry:' );
172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );

Line 176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');

172: utl_file.put_line(l_scripthandle, 'REM ' );
173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );

Line 177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );

173: utl_file.put_line(l_scripthandle, 'REM HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );

Line 178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );

174: utl_file.put_line(l_scripthandle, 'REM p_api_module => ''' || p_api_name || ''',' );
175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );

Line 179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );

175: utl_file.put_line(l_scripthandle, 'REM p_column_name => ''person_id'',' );
176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );
183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );

Line 180: utl_file.put_line(l_scripthandle, 'REM ' );

176: utl_file.put_line(l_scripthandle, 'REM p_mapped_to_name => ''p_person_id'',');
177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );
183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );
184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );

Line 181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );

177: utl_file.put_line(l_scripthandle, 'REM p_mapping_type => ''R'',' );
178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );
183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );
184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );
185: utl_file.new_line(l_scripthandle, 1 );

Line 182: utl_file.new_line(l_scripthandle, 1 );

178: utl_file.put_line(l_scripthandle, 'REM p_parent_api_module => ''create_us_employee'',' );
179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );
183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );
184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );
185: utl_file.new_line(l_scripthandle, 1 );
186:

Line 183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );

179: utl_file.put_line(l_scripthandle, 'REM p_parent_table => null);' );
180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );
183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );
184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );
185: utl_file.new_line(l_scripthandle, 1 );
186:
187: utl_file.put_line(l_scripthandle, 'DECLARE' );

Line 184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );

180: utl_file.put_line(l_scripthandle, 'REM ' );
181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );
183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );
184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );
185: utl_file.new_line(l_scripthandle, 1 );
186:
187: utl_file.put_line(l_scripthandle, 'DECLARE' );
188: utl_file.new_line(l_scripthandle, 1 );

Line 185: utl_file.new_line(l_scripthandle, 1 );

181: utl_file.put_line(l_scripthandle, 'REM ------------------------------------------------------------------------' );
182: utl_file.new_line(l_scripthandle, 1 );
183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );
184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );
185: utl_file.new_line(l_scripthandle, 1 );
186:
187: utl_file.put_line(l_scripthandle, 'DECLARE' );
188: utl_file.new_line(l_scripthandle, 1 );
189: utl_file.put_line(l_scripthandle, 'BEGIN' );

Line 187: utl_file.put_line(l_scripthandle, 'DECLARE' );

183: utl_file.put_line(l_scripthandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK; ' );
184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );
185: utl_file.new_line(l_scripthandle, 1 );
186:
187: utl_file.put_line(l_scripthandle, 'DECLARE' );
188: utl_file.new_line(l_scripthandle, 1 );
189: utl_file.put_line(l_scripthandle, 'BEGIN' );
190: utl_file.new_line(l_scripthandle, 1 );
191:

Line 188: utl_file.new_line(l_scripthandle, 1 );

184: utl_file.put_line(l_scripthandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK; ' );
185: utl_file.new_line(l_scripthandle, 1 );
186:
187: utl_file.put_line(l_scripthandle, 'DECLARE' );
188: utl_file.new_line(l_scripthandle, 1 );
189: utl_file.put_line(l_scripthandle, 'BEGIN' );
190: utl_file.new_line(l_scripthandle, 1 );
191:
192: for columns_rec in columns_csr loop

Line 189: utl_file.put_line(l_scripthandle, 'BEGIN' );

185: utl_file.new_line(l_scripthandle, 1 );
186:
187: utl_file.put_line(l_scripthandle, 'DECLARE' );
188: utl_file.new_line(l_scripthandle, 1 );
189: utl_file.put_line(l_scripthandle, 'BEGIN' );
190: utl_file.new_line(l_scripthandle, 1 );
191:
192: for columns_rec in columns_csr loop
193: -- Fill in csv file

Line 190: utl_file.new_line(l_scripthandle, 1 );

186:
187: utl_file.put_line(l_scripthandle, 'DECLARE' );
188: utl_file.new_line(l_scripthandle, 1 );
189: utl_file.put_line(l_scripthandle, 'BEGIN' );
190: utl_file.new_line(l_scripthandle, 1 );
191:
192: for columns_rec in columns_csr loop
193: -- Fill in csv file
194: IF lower(columns_rec.column_headings) not like '%user%key%' THEN

Line 195: utl_file.put(p_filehandle, ',' || lower(columns_rec.column_headings) );

191:
192: for columns_rec in columns_csr loop
193: -- Fill in csv file
194: IF lower(columns_rec.column_headings) not like '%user%key%' THEN
195: utl_file.put(p_filehandle, ',' || lower(columns_rec.column_headings) );
196: END IF;
197:
198: -- Fill in sql file
199: utl_file.put_line(l_scripthandle, ' HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );

Line 199: utl_file.put_line(l_scripthandle, ' HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );

195: utl_file.put(p_filehandle, ',' || lower(columns_rec.column_headings) );
196: END IF;
197:
198: -- Fill in sql file
199: utl_file.put_line(l_scripthandle, ' HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
200: utl_file.put_line(l_scripthandle, ' p_api_module => ''' || p_api_name || ''',' );
201: IF lower(columns_rec.column_headings) like '%user%key%' THEN
202: utl_file.put_line(l_scripthandle, ' p_mapping_type => ''U'',' );
203: END IF;

Line 200: utl_file.put_line(l_scripthandle, ' p_api_module => ''' || p_api_name || ''',' );

196: END IF;
197:
198: -- Fill in sql file
199: utl_file.put_line(l_scripthandle, ' HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
200: utl_file.put_line(l_scripthandle, ' p_api_module => ''' || p_api_name || ''',' );
201: IF lower(columns_rec.column_headings) like '%user%key%' THEN
202: utl_file.put_line(l_scripthandle, ' p_mapping_type => ''U'',' );
203: END IF;
204: utl_file.put_line(l_scripthandle, ' p_column_name => ''' || columns_rec.column_headings || ''',' );

Line 202: utl_file.put_line(l_scripthandle, ' p_mapping_type => ''U'',' );

198: -- Fill in sql file
199: utl_file.put_line(l_scripthandle, ' HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );
200: utl_file.put_line(l_scripthandle, ' p_api_module => ''' || p_api_name || ''',' );
201: IF lower(columns_rec.column_headings) like '%user%key%' THEN
202: utl_file.put_line(l_scripthandle, ' p_mapping_type => ''U'',' );
203: END IF;
204: utl_file.put_line(l_scripthandle, ' p_column_name => ''' || columns_rec.column_headings || ''',' );
205: utl_file.put_line(l_scripthandle, ' p_mapped_to_name => ''' || 'p_' || columns_rec.column_headings || ''');' );
206: utl_file.new_line(l_scripthandle, 1 );

Line 204: utl_file.put_line(l_scripthandle, ' p_column_name => ''' || columns_rec.column_headings || ''',' );

200: utl_file.put_line(l_scripthandle, ' p_api_module => ''' || p_api_name || ''',' );
201: IF lower(columns_rec.column_headings) like '%user%key%' THEN
202: utl_file.put_line(l_scripthandle, ' p_mapping_type => ''U'',' );
203: END IF;
204: utl_file.put_line(l_scripthandle, ' p_column_name => ''' || columns_rec.column_headings || ''',' );
205: utl_file.put_line(l_scripthandle, ' p_mapped_to_name => ''' || 'p_' || columns_rec.column_headings || ''');' );
206: utl_file.new_line(l_scripthandle, 1 );
207: end loop;
208:

Line 205: utl_file.put_line(l_scripthandle, ' p_mapped_to_name => ''' || 'p_' || columns_rec.column_headings || ''');' );

201: IF lower(columns_rec.column_headings) like '%user%key%' THEN
202: utl_file.put_line(l_scripthandle, ' p_mapping_type => ''U'',' );
203: END IF;
204: utl_file.put_line(l_scripthandle, ' p_column_name => ''' || columns_rec.column_headings || ''',' );
205: utl_file.put_line(l_scripthandle, ' p_mapped_to_name => ''' || 'p_' || columns_rec.column_headings || ''');' );
206: utl_file.new_line(l_scripthandle, 1 );
207: end loop;
208:
209: utl_file.new_line(l_scripthandle, 1 );

Line 206: utl_file.new_line(l_scripthandle, 1 );

202: utl_file.put_line(l_scripthandle, ' p_mapping_type => ''U'',' );
203: END IF;
204: utl_file.put_line(l_scripthandle, ' p_column_name => ''' || columns_rec.column_headings || ''',' );
205: utl_file.put_line(l_scripthandle, ' p_mapped_to_name => ''' || 'p_' || columns_rec.column_headings || ''');' );
206: utl_file.new_line(l_scripthandle, 1 );
207: end loop;
208:
209: utl_file.new_line(l_scripthandle, 1 );
210: utl_file.put_line(l_scripthandle, 'END;' );

Line 209: utl_file.new_line(l_scripthandle, 1 );

205: utl_file.put_line(l_scripthandle, ' p_mapped_to_name => ''' || 'p_' || columns_rec.column_headings || ''');' );
206: utl_file.new_line(l_scripthandle, 1 );
207: end loop;
208:
209: utl_file.new_line(l_scripthandle, 1 );
210: utl_file.put_line(l_scripthandle, 'END;' );
211: utl_file.put_line(l_scripthandle, '/' );
212: utl_file.new_line(l_scripthandle, 1 );
213: utl_file.put_line(l_scripthandle, 'COMMIT;' );

Line 210: utl_file.put_line(l_scripthandle, 'END;' );

206: utl_file.new_line(l_scripthandle, 1 );
207: end loop;
208:
209: utl_file.new_line(l_scripthandle, 1 );
210: utl_file.put_line(l_scripthandle, 'END;' );
211: utl_file.put_line(l_scripthandle, '/' );
212: utl_file.new_line(l_scripthandle, 1 );
213: utl_file.put_line(l_scripthandle, 'COMMIT;' );
214: utl_file.put_line(l_scripthandle, 'EXIT;' );

Line 211: utl_file.put_line(l_scripthandle, '/' );

207: end loop;
208:
209: utl_file.new_line(l_scripthandle, 1 );
210: utl_file.put_line(l_scripthandle, 'END;' );
211: utl_file.put_line(l_scripthandle, '/' );
212: utl_file.new_line(l_scripthandle, 1 );
213: utl_file.put_line(l_scripthandle, 'COMMIT;' );
214: utl_file.put_line(l_scripthandle, 'EXIT;' );
215:

Line 212: utl_file.new_line(l_scripthandle, 1 );

208:
209: utl_file.new_line(l_scripthandle, 1 );
210: utl_file.put_line(l_scripthandle, 'END;' );
211: utl_file.put_line(l_scripthandle, '/' );
212: utl_file.new_line(l_scripthandle, 1 );
213: utl_file.put_line(l_scripthandle, 'COMMIT;' );
214: utl_file.put_line(l_scripthandle, 'EXIT;' );
215:
216: -- Close Script file

Line 213: utl_file.put_line(l_scripthandle, 'COMMIT;' );

209: utl_file.new_line(l_scripthandle, 1 );
210: utl_file.put_line(l_scripthandle, 'END;' );
211: utl_file.put_line(l_scripthandle, '/' );
212: utl_file.new_line(l_scripthandle, 1 );
213: utl_file.put_line(l_scripthandle, 'COMMIT;' );
214: utl_file.put_line(l_scripthandle, 'EXIT;' );
215:
216: -- Close Script file
217: utl_file.fclose(l_scripthandle);

Line 214: utl_file.put_line(l_scripthandle, 'EXIT;' );

210: utl_file.put_line(l_scripthandle, 'END;' );
211: utl_file.put_line(l_scripthandle, '/' );
212: utl_file.new_line(l_scripthandle, 1 );
213: utl_file.put_line(l_scripthandle, 'COMMIT;' );
214: utl_file.put_line(l_scripthandle, 'EXIT;' );
215:
216: -- Close Script file
217: utl_file.fclose(l_scripthandle);
218:

Line 217: utl_file.fclose(l_scripthandle);

213: utl_file.put_line(l_scripthandle, 'COMMIT;' );
214: utl_file.put_line(l_scripthandle, 'EXIT;' );
215:
216: -- Close Script file
217: utl_file.fclose(l_scripthandle);
218:
219: utl_file.new_line(p_filehandle, 1 );
220: EXCEPTION
221:

Line 219: utl_file.new_line(p_filehandle, 1 );

215:
216: -- Close Script file
217: utl_file.fclose(l_scripthandle);
218:
219: utl_file.new_line(p_filehandle, 1 );
220: EXCEPTION
221:
222: WHEN OTHERS THEN
223: raise_application_error( -20000, 'Exception occurred in hrdu_get_api_columns - ' || substr(SQLERRM,1,200));

Line 253: l_filehandle UTL_FILE.FILE_TYPE;

249: from hr_api_modules
250: where module_name = upper(p_api_name);
251:
252: l_api_id Number(15);
253: l_filehandle UTL_FILE.FILE_TYPE;
254: l_location VARCHAR2(2000);
255:
256: BEGIN
257: -- Get the API id for the module

Line 266: l_filehandle := utl_file.fopen(l_location, p_file_name, 'w', 32767);

262: IF l_api_id is not null THEN
263:
264: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
265:
266: l_filehandle := utl_file.fopen(l_location, p_file_name, 'w', 32767);
267:
268: utl_file.put_line(l_filehandle, 'Descriptor,Start');
269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);
270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);

Line 268: utl_file.put_line(l_filehandle, 'Descriptor,Start');

264: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
265:
266: l_filehandle := utl_file.fopen(l_location, p_file_name, 'w', 32767);
267:
268: utl_file.put_line(l_filehandle, 'Descriptor,Start');
269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);
270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);
271: utl_file.put_line(l_filehandle, 'Process Order,');
272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);

Line 269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);

265:
266: l_filehandle := utl_file.fopen(l_location, p_file_name, 'w', 32767);
267:
268: utl_file.put_line(l_filehandle, 'Descriptor,Start');
269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);
270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);
271: utl_file.put_line(l_filehandle, 'Process Order,');
272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);
273: utl_file.put_line(l_filehandle, 'Descriptor,End');

Line 270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);

266: l_filehandle := utl_file.fopen(l_location, p_file_name, 'w', 32767);
267:
268: utl_file.put_line(l_filehandle, 'Descriptor,Start');
269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);
270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);
271: utl_file.put_line(l_filehandle, 'Process Order,');
272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);
273: utl_file.put_line(l_filehandle, 'Descriptor,End');
274:

Line 271: utl_file.put_line(l_filehandle, 'Process Order,');

267:
268: utl_file.put_line(l_filehandle, 'Descriptor,Start');
269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);
270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);
271: utl_file.put_line(l_filehandle, 'Process Order,');
272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);
273: utl_file.put_line(l_filehandle, 'Descriptor,End');
274:
275: utl_file.new_line(l_filehandle);

Line 272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);

268: utl_file.put_line(l_filehandle, 'Descriptor,Start');
269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);
270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);
271: utl_file.put_line(l_filehandle, 'Process Order,');
272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);
273: utl_file.put_line(l_filehandle, 'Descriptor,End');
274:
275: utl_file.new_line(l_filehandle);
276:

Line 273: utl_file.put_line(l_filehandle, 'Descriptor,End');

269: utl_file.put_line(l_filehandle, 'API,' || p_api_name);
270: utl_file.put_line(l_filehandle, 'Title,' || p_title_name);
271: utl_file.put_line(l_filehandle, 'Process Order,');
272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);
273: utl_file.put_line(l_filehandle, 'Descriptor,End');
274:
275: utl_file.new_line(l_filehandle);
276:
277: utl_file.put_line(l_filehandle, 'Data,Start');

Line 275: utl_file.new_line(l_filehandle);

271: utl_file.put_line(l_filehandle, 'Process Order,');
272: utl_file.put_line(l_filehandle, 'User Key,' || p_user_key);
273: utl_file.put_line(l_filehandle, 'Descriptor,End');
274:
275: utl_file.new_line(l_filehandle);
276:
277: utl_file.put_line(l_filehandle, 'Data,Start');
278: hrdu_get_api_columns( l_filehandle, p_api_name );
279: utl_file.put_line(l_filehandle, 'Data,End');

Line 277: utl_file.put_line(l_filehandle, 'Data,Start');

273: utl_file.put_line(l_filehandle, 'Descriptor,End');
274:
275: utl_file.new_line(l_filehandle);
276:
277: utl_file.put_line(l_filehandle, 'Data,Start');
278: hrdu_get_api_columns( l_filehandle, p_api_name );
279: utl_file.put_line(l_filehandle, 'Data,End');
280:
281: -- close file

Line 279: utl_file.put_line(l_filehandle, 'Data,End');

275: utl_file.new_line(l_filehandle);
276:
277: utl_file.put_line(l_filehandle, 'Data,Start');
278: hrdu_get_api_columns( l_filehandle, p_api_name );
279: utl_file.put_line(l_filehandle, 'Data,End');
280:
281: -- close file
282: utl_file.fclose(l_filehandle);
283:

Line 282: utl_file.fclose(l_filehandle);

278: hrdu_get_api_columns( l_filehandle, p_api_name );
279: utl_file.put_line(l_filehandle, 'Data,End');
280:
281: -- close file
282: utl_file.fclose(l_filehandle);
283:
284: ELSE
285:
286: raise_application_error( -20000, 'API: ' || p_api_name || ' does not exist!' );