APPS.PER_US_ETH_ORIG_MIG_PKG dependencies on V$PARAMETER

Line 105: l_temp_utl v$parameter.value%type; -- #12800711 increased to 1000

101: lv_file UTL_FILE.FILE_TYPE;
102: lv_line VARCHAR2(4000); --#12800711 increased to 4000
103: lv_warning VARCHAR2(1000); --#12800711 increased to 1000
104: l_eit_exists_flag VARCHAR2(2);
105: l_temp_utl v$parameter.value%type; -- #12800711 increased to 1000
106: -- #13031928 increased to 4000
107: -- #13106407 altered to v$parameter.value%type
108: l_payroll_action_id NUMBER;
109: l_request_id NUMBER;

Line 107: -- #13106407 altered to v$parameter.value%type

103: lv_warning VARCHAR2(1000); --#12800711 increased to 1000
104: l_eit_exists_flag VARCHAR2(2);
105: l_temp_utl v$parameter.value%type; -- #12800711 increased to 1000
106: -- #13031928 increased to 4000
107: -- #13106407 altered to v$parameter.value%type
108: l_payroll_action_id NUMBER;
109: l_request_id NUMBER;
110: lv_procedure_name VARCHAR2(50);
111:

Line 117: v$parameter*/

113: lv_procedure_name := 'upgrade_ethnic_origin';
114:
115: hr_utility.set_location('Entering ' || gv_package_name ||lv_procedure_name,5);
116: /* CSV file generated would be created in the first directory mentioned in
117: v$parameter*/
118: gv_emp_count := gv_emp_count +1;
119: SELECT TRANSLATE(LTRIM(value),',',' ') -- #13031928 Added substr
120: -- #13106407 Removed substr
121: INTO l_temp_utl

Line 122: FROM v$parameter

118: gv_emp_count := gv_emp_count +1;
119: SELECT TRANSLATE(LTRIM(value),',',' ') -- #13031928 Added substr
120: -- #13106407 Removed substr
121: INTO l_temp_utl
122: FROM v$parameter
123: WHERE name = 'utl_file_dir';
124:
125: hr_utility.set_location(gv_package_name ||lv_procedure_name,10);
126: