60: g_report_name := p_report_name;
61:
62: -- Generate initial HTML
63:
64: htp.htmlOpen;
65: htp.headOpen;
66:
67: -- Generate JavaScript functions for cross-validation between
68: -- Geography dimension level LOV and Geography values LOV
61:
62: -- Generate initial HTML
63:
64: htp.htmlOpen;
65: htp.headOpen;
66:
67: -- Generate JavaScript functions for cross-validation between
68: -- Geography dimension level LOV and Geography values LOV
69:
78: END IF;
79:
80: -- Finish heading, start body of HTML
81:
82: htp.headClose;
83: htp.bodyOpen;
84:
85: -- Open the HTML form
86:
79:
80: -- Finish heading, start body of HTML
81:
82: htp.headClose;
83: htp.bodyOpen;
84:
85: -- Open the HTML form
86:
87: htp.formOpen ('HRI_Parameters.Param_ActionView', 'GET',NULL,NULL, 'name="params" ');
83: htp.bodyOpen;
84:
85: -- Open the HTML form
86:
87: htp.formOpen ('HRI_Parameters.Param_ActionView', 'GET',NULL,NULL, 'name="params" ');
88:
89: -- Create each parameter displayed in the HTML form
90:
91: paramnum := 1;
93: IF instr(p_param_request,'EMPAPL,') > 0 then
94: Build_Employee_Applicant(params,paramnum);
95: paramnum := paramnum + 1;
96: ELSE
97: htp.formHidden('EMPAPL', '');
98: END IF;
99:
100: IF instr(p_param_request,'ORG_ID,') > 0 then
101:
107: Build_LOV(params,paramnum, 1, 'P_ORGANIZATION_ID', 'ORGANIZATION');
108: paramnum := paramnum + 1;
109:
110: ELSE
111: htp.formHidden('P_ORGANIZATION_ID', '');
112: htp.formHidden('P_ORGANIZATION_NAME', '');
113: END IF;
114:
115: IF instr(p_param_request,'ORGPRC1,') > 0 then
108: paramnum := paramnum + 1;
109:
110: ELSE
111: htp.formHidden('P_ORGANIZATION_ID', '');
112: htp.formHidden('P_ORGANIZATION_NAME', '');
113: END IF;
114:
115: IF instr(p_param_request,'ORGPRC1,') > 0 then
116: Build_Incl_Subord(params,paramnum,1);
121: ELSIF instr(p_param_request,'ORGPRC3,') > 0 then
122: Build_Incl_Subord(params,paramnum,3);
123: paramnum := paramnum + 1;
124: ELSE
125: htp.formHidden('ORGPRC', '');
126: END IF;
127:
128: IF instr(p_param_request,'BPL_ID,') > 0 then
129: Build_Business_Plan(params,paramnum);
128: IF instr(p_param_request,'BPL_ID,') > 0 then
129: Build_Business_Plan(params,paramnum);
130: paramnum := paramnum + 1;
131: ELSE
132: htp.formHidden('BPL_ID', '-1');
133: END IF;
134:
135: IF instr(p_param_request,'GEOGID,') > 0 then
136: Build_Geog_Level(params,paramnum);
136: Build_Geog_Level(params,paramnum);
137: Build_Geog_Value(params,paramnum);
138: paramnum := paramnum + 1;
139: ELSE
140: htp.formHidden('GEOLVL', '');
141: htp.formHidden('GEOVAL', '');
142: END IF;
143:
144: IF instr(p_param_request,'LOC_ID,') > 0 then
137: Build_Geog_Value(params,paramnum);
138: paramnum := paramnum + 1;
139: ELSE
140: htp.formHidden('GEOLVL', '');
141: htp.formHidden('GEOVAL', '');
142: END IF;
143:
144: IF instr(p_param_request,'LOC_ID,') > 0 then
145:
151: Build_LOV(params,paramnum, 1, 'P_LOCATION_ID', 'LOCATION');
152: paramnum := paramnum + 1;
153:
154: ELSE
155: htp.formHidden('P_LOCATION_ID', '-1');
156: htp.formHidden('P_LOCATION_NAME', '');
157: END IF;
158:
159: IF instr(p_param_request,'PRODID,') > 0 then
152: paramnum := paramnum + 1;
153:
154: ELSE
155: htp.formHidden('P_LOCATION_ID', '-1');
156: htp.formHidden('P_LOCATION_NAME', '');
157: END IF;
158:
159: IF instr(p_param_request,'PRODID,') > 0 then
160: Build_Product(params,paramnum);
159: IF instr(p_param_request,'PRODID,') > 0 then
160: Build_Product(params,paramnum);
161: paramnum := paramnum + 1;
162: ELSE
163: htp.formHidden('PRODID', '');
164: END IF;
165:
166: IF instr(p_param_request,'JOBCAT,') > 0 then
167: Build_Job_Category(params,paramnum,0);
165:
166: IF instr(p_param_request,'JOBCAT,') > 0 then
167: Build_Job_Category(params,paramnum,0);
168: paramnum := paramnum + 1;
169: htp.formHidden('JOBCAT1', '');
170: htp.formHidden('JOBCAT2', '');
171: htp.formHidden('JOBCAT3', '');
172: ELSIF instr(p_param_request,'JOBCAT+,') > 0 then
173: Build_Job_Category(params,paramnum,1);
166: IF instr(p_param_request,'JOBCAT,') > 0 then
167: Build_Job_Category(params,paramnum,0);
168: paramnum := paramnum + 1;
169: htp.formHidden('JOBCAT1', '');
170: htp.formHidden('JOBCAT2', '');
171: htp.formHidden('JOBCAT3', '');
172: ELSIF instr(p_param_request,'JOBCAT+,') > 0 then
173: Build_Job_Category(params,paramnum,1);
174: paramnum := paramnum + 1;
167: Build_Job_Category(params,paramnum,0);
168: paramnum := paramnum + 1;
169: htp.formHidden('JOBCAT1', '');
170: htp.formHidden('JOBCAT2', '');
171: htp.formHidden('JOBCAT3', '');
172: ELSIF instr(p_param_request,'JOBCAT+,') > 0 then
173: Build_Job_Category(params,paramnum,1);
174: paramnum := paramnum + 1;
175: htp.formHidden('JOBCAT', '');
171: htp.formHidden('JOBCAT3', '');
172: ELSIF instr(p_param_request,'JOBCAT+,') > 0 then
173: Build_Job_Category(params,paramnum,1);
174: paramnum := paramnum + 1;
175: htp.formHidden('JOBCAT', '');
176: ELSE
177: htp.formHidden('JOBCAT', '');
178: htp.formHidden('JOBCAT1', '');
179: htp.formHidden('JOBCAT2', '');
173: Build_Job_Category(params,paramnum,1);
174: paramnum := paramnum + 1;
175: htp.formHidden('JOBCAT', '');
176: ELSE
177: htp.formHidden('JOBCAT', '');
178: htp.formHidden('JOBCAT1', '');
179: htp.formHidden('JOBCAT2', '');
180: htp.formHidden('JOBCAT3', '');
181: END IF;
174: paramnum := paramnum + 1;
175: htp.formHidden('JOBCAT', '');
176: ELSE
177: htp.formHidden('JOBCAT', '');
178: htp.formHidden('JOBCAT1', '');
179: htp.formHidden('JOBCAT2', '');
180: htp.formHidden('JOBCAT3', '');
181: END IF;
182:
175: htp.formHidden('JOBCAT', '');
176: ELSE
177: htp.formHidden('JOBCAT', '');
178: htp.formHidden('JOBCAT1', '');
179: htp.formHidden('JOBCAT2', '');
180: htp.formHidden('JOBCAT3', '');
181: END IF;
182:
183: IF instr(p_param_request,'JOB_ID,') > 0 then
176: ELSE
177: htp.formHidden('JOBCAT', '');
178: htp.formHidden('JOBCAT1', '');
179: htp.formHidden('JOBCAT2', '');
180: htp.formHidden('JOBCAT3', '');
181: END IF;
182:
183: IF instr(p_param_request,'JOB_ID,') > 0 then
184:
192:
193: If l_req_check = 0 THEN
194: -- no jobs are set up
195:
196: htp.formHidden('JOB_ID', '*');
197:
198: l_param_missing_req_val_name := 'JOB_ID';
199: Raise e_missing_required_parameter;
200: ELSE
197:
198: l_param_missing_req_val_name := 'JOB_ID';
199: Raise e_missing_required_parameter;
200: ELSE
201: htp.formHidden('P_JOB_NAME', '');
202: paramnum := paramnum + 1;
203: END IF;
204:
205: ELSE
219:
220: If l_req_check = 0 THEN
221: -- no jobs are set up
222:
223: htp.formHidden('JOB_ID', '*');
224:
225: l_param_missing_req_val_name := 'JOB_ID';
226: Raise e_missing_required_parameter;
227: ELSE
224:
225: l_param_missing_req_val_name := 'JOB_ID';
226: Raise e_missing_required_parameter;
227: ELSE
228: htp.formHidden('P_JOB_NAME', '');
229: paramnum := paramnum + 1;
230: END IF;
231:
232: ELSE
233: Build_LOV(params,paramnum, 1, 'P_JOB_ID', 'JOB');
234: paramnum := paramnum + 1;
235: END IF;
236: ELSE
237: htp.formHidden('P_JOB_ID', '');
238: htp.formHidden('P_JOB_NAME', '');
239: END IF;
240:
241: IF instr(p_param_request,'GRD_ID,') > 0 then
234: paramnum := paramnum + 1;
235: END IF;
236: ELSE
237: htp.formHidden('P_JOB_ID', '');
238: htp.formHidden('P_JOB_NAME', '');
239: END IF;
240:
241: IF instr(p_param_request,'GRD_ID,') > 0 then
242: --Build_Grade_ID(params,paramnum);
242: --Build_Grade_ID(params,paramnum);
243: Build_LOV(params,paramnum,1,'P_GRADE_ID','GRADE');
244: paramnum := paramnum + 1;
245: ELSE
246: htp.formHidden('P_GRADE_ID', '');
247: htp.formHidden('P_GRADE_NAME','');
248: END IF;
249:
250: IF instr(p_param_request,'PERFRT,') > 0 then
243: Build_LOV(params,paramnum,1,'P_GRADE_ID','GRADE');
244: paramnum := paramnum + 1;
245: ELSE
246: htp.formHidden('P_GRADE_ID', '');
247: htp.formHidden('P_GRADE_NAME','');
248: END IF;
249:
250: IF instr(p_param_request,'PERFRT,') > 0 then
251: Build_lookup_param(params,paramnum, 'HR_BIS_PERFORMANCE_RATING','PERFRT','PERFORMANCE_RATING','-1');
250: IF instr(p_param_request,'PERFRT,') > 0 then
251: Build_lookup_param(params,paramnum, 'HR_BIS_PERFORMANCE_RATING','PERFRT','PERFORMANCE_RATING','-1');
252: paramnum := paramnum + 1;
253: ELSE
254: htp.formHidden('PERFRT', '');
255: END IF;
256:
257: IF instr(p_param_request,'COMPID,') > 0 then
258:
260:
261: -- bug fix: 1269713
262: IF l_req_check = 0 THEN
263: -- a required parameter had no values found on db to populate the drop down list
264: htp.formHidden('COMPID', '*');
265:
266: l_param_missing_req_val_name := 'COMPID';
267: Raise e_missing_required_parameter;
268: END IF;
269:
270: paramnum := paramnum + 1;
271:
272: ELSE
273: htp.formHidden('COMPID', '');
274: END IF;
275:
276: IF instr(p_param_request,'PFMEAS,') > 0 then
277: Build_Proficiency_Measure(params,paramnum);
276: IF instr(p_param_request,'PFMEAS,') > 0 then
277: Build_Proficiency_Measure(params,paramnum);
278: paramnum := paramnum + 1;
279: ELSE
280: htp.formHidden('PFMEAS', '');
281: END IF;
282:
283: IF instr(p_param_request,'PAYRLL,') > 0 then
284:
286:
287: -- bug fix: 1269713
288: IF l_req_check = 0 THEN
289: -- a required parameter had no values found on db to populate the drop down list
290: htp.formHidden('PAYRLL', '*');
291:
292: l_param_missing_req_val_name := 'PAYRLL';
293: Raise e_missing_required_parameter;
294: END IF;
300:
301: -- bug fix: 1269713
302: IF l_req_check = 0 THEN
303: -- a required parameter had no values found on db to populate the drop down list
304: htp.formHidden('PAYRLL', '*');
305:
306: l_param_missing_req_val_name := 'PAYRLL';
307: Raise e_missing_required_parameter;
308: END IF;
309:
310: paramnum := paramnum + 1;
311:
312: ELSE
313: htp.formHidden('PAYRLL', '');
314: END IF;
315:
316: if instr(p_param_request, 'BGT_ID,') > 0 then
317: htp.comment('called Build_Budget');
313: htp.formHidden('PAYRLL', '');
314: END IF;
315:
316: if instr(p_param_request, 'BGT_ID,') > 0 then
317: htp.comment('called Build_Budget');
318: Build_Budget(params,paramnum,l_req_check);
319:
320: -- bug fix: 1269713
321: IF l_req_check = 0 THEN
319:
320: -- bug fix: 1269713
321: IF l_req_check = 0 THEN
322: -- a required parameter had no values found on db to populate the drop down list
323: htp.formHidden('BGT_ID', '*');
324:
325: l_param_missing_req_val_name := 'BGT_ID';
326: Raise e_missing_required_parameter;
327: END IF;
329: paramnum := paramnum+1;
330:
331: elsif instr(p_param_request, 'BGT_PQH_ID,') > 0 then
332: Build_pqh_Budget(params,paramnum,l_req_check);
333: htp.comment('called Build_pqh_Budget');
334:
335: -- bug fix: 1269713
336: IF l_req_check = 0 THEN
337: -- a required parameter had no values found on db to populate the drop down list
334:
335: -- bug fix: 1269713
336: IF l_req_check = 0 THEN
337: -- a required parameter had no values found on db to populate the drop down list
338: htp.formHidden('BGT_ID', '*');
339:
340: l_param_missing_req_val_name := 'BGT_ID';
341: Raise e_missing_required_parameter;
342: END IF;
342: END IF;
343:
344: paramnum := paramnum+1;
345: ELSE
346: htp.formHidden('BGT_ID', '');
347: END IF;
348:
349: IF instr(p_param_request, 'BGTTYP,') > 0 then
350: Build_lookup_param(params,paramnum, 'HR_BIS_BGTTYP','BGTTYP','BUDGET_MEASUREMENT_TYPE','');
349: IF instr(p_param_request, 'BGTTYP,') > 0 then
350: Build_lookup_param(params,paramnum, 'HR_BIS_BGTTYP','BGTTYP','BUDGET_MEASUREMENT_TYPE','');
351: paramnum := paramnum + 1;
352: ELSE
353: htp.formHidden('BGTTYP', '');
354: END IF;
355:
356: IF instr(p_param_request,'PROPRN,') > 0 then
357: Build_lookup_param(params,paramnum, 'HR_BIS_PROPOSAL_REASON', 'PROPRN', 'PROPOSAL_REASON', '');
356: IF instr(p_param_request,'PROPRN,') > 0 then
357: Build_lookup_param(params,paramnum, 'HR_BIS_PROPOSAL_REASON', 'PROPRN', 'PROPOSAL_REASON', '');
358: paramnum := paramnum + 1;
359: ELSE
360: htp.formHidden('PROPRN', '');
361: END IF;
362:
363: IF instr(p_param_request,'SEPRSN,') > 0 then
364: Build_lookup_param(params,paramnum, 'HR_BIS_SEPARATION_REASON', 'SEPRSN', 'LEAV_REAS', 'BIS_ALL');
363: IF instr(p_param_request,'SEPRSN,') > 0 then
364: Build_lookup_param(params,paramnum, 'HR_BIS_SEPARATION_REASON', 'SEPRSN', 'LEAV_REAS', 'BIS_ALL');
365: paramnum := paramnum + 1;
366: ELSE
367: htp.formHidden('SEPRSN', '');
368: END IF;
369:
370: IF instr(p_param_request,'VIEWBY1,') > 0 then
371: Build_View_By(params,paramnum,1);
376: ELSIF instr(p_param_request,'VIEWBY3,') > 0 then
377: Build_View_By(params,paramnum,3);
378: paramnum := paramnum + 1;
379: ELSE
380: htp.formHidden('VIEWBY', '');
381: END IF;
382:
383: IF instr(p_param_request,'DISPLY,') > 0 then
384: Build_Display_By(params,paramnum);
383: IF instr(p_param_request,'DISPLY,') > 0 then
384: Build_Display_By(params,paramnum);
385: paramnum := paramnum + 1;
386: ELSE
387: htp.formHidden('DISPLY', '');
388: htp.formHidden('DCOUNT', '');
389: END IF;
390:
391: IF instr(p_param_request,'ORDERB1,') > 0 then
384: Build_Display_By(params,paramnum);
385: paramnum := paramnum + 1;
386: ELSE
387: htp.formHidden('DISPLY', '');
388: htp.formHidden('DCOUNT', '');
389: END IF;
390:
391: IF instr(p_param_request,'ORDERB1,') > 0 then
392: Build_Order_By(params,paramnum,1);
394: ELSIF instr(p_param_request,'ORDERB2,') > 0 then
395: Build_Order_By(params,paramnum,2);
396: paramnum := paramnum + 1;
397: ELSE
398: htp.formHidden('ORDERB', '');
399: END IF;
400:
401: IF instr(p_param_request,'CURRCD,') > 0 then
402: Build_Report_Currency(params,paramnum);
401: IF instr(p_param_request,'CURRCD,') > 0 then
402: Build_Report_Currency(params,paramnum);
403: paramnum := paramnum + 1;
404: ELSE
405: htp.formHidden('CURRCD', '');
406: END IF;
407:
408: IF instr(p_param_request,'EXCCUR,') > 0 then
409: Build_Exclude_Currency(params,paramnum);
408: IF instr(p_param_request,'EXCCUR,') > 0 then
409: Build_Exclude_Currency(params,paramnum);
410: paramnum := paramnum + 1;
411: ELSE
412: htp.formHidden('EXCCUR', '');
413: END IF;
414:
415: IF instr(p_param_request,'FRQNCY,') > 0 then
416: Build_Frequency(params,paramnum);
415: IF instr(p_param_request,'FRQNCY,') > 0 then
416: Build_Frequency(params,paramnum);
417: paramnum := paramnum + 1;
418: ELSE
419: htp.formHidden('FRQNCY', 'CM');
420: END IF;
421:
422: IF instr(p_param_request,'DATE1,') > 0 then
423: Build_Rep_Dates(params,paramnum,1);
422: IF instr(p_param_request,'DATE1,') > 0 then
423: Build_Rep_Dates(params,paramnum,1);
424: paramnum := paramnum + 1;
425: ELSE
426: htp.formHidden('P_REPORT_DATE_V', '');
427: END IF;
428:
429: IF instr(p_param_request,'DATE2,') > 0 then
430: Build_Rep_Dates(params,paramnum,2);
429: IF instr(p_param_request,'DATE2,') > 0 then
430: Build_Rep_Dates(params,paramnum,2);
431: paramnum := paramnum + 1;
432: ELSE
433: htp.formHidden('P_START_DATE_V', '*');
434: htp.formHidden('P_END_DATE_V', '*');
435: END IF;
436:
437: -- Create hidden fields for Business Group ID and Organization Version
430: Build_Rep_Dates(params,paramnum,2);
431: paramnum := paramnum + 1;
432: ELSE
433: htp.formHidden('P_START_DATE_V', '*');
434: htp.formHidden('P_END_DATE_V', '*');
435: END IF;
436:
437: -- Create hidden fields for Business Group ID and Organization Version
438:
435: END IF;
436:
437: -- Create hidden fields for Business Group ID and Organization Version
438:
439: htp.formHidden('BUS_ID', g_bus_id);
440: htp.formHidden('ORGVER', g_orgver);
441: htp.formHidden('RPNAME', p_report_name);
442:
443: -- Build Parameter Form
436:
437: -- Create hidden fields for Business Group ID and Organization Version
438:
439: htp.formHidden('BUS_ID', g_bus_id);
440: htp.formHidden('ORGVER', g_orgver);
441: htp.formHidden('RPNAME', p_report_name);
442:
443: -- Build Parameter Form
444:
437: -- Create hidden fields for Business Group ID and Organization Version
438:
439: htp.formHidden('BUS_ID', g_bus_id);
440: htp.formHidden('ORGVER', g_orgver);
441: htp.formHidden('RPNAME', p_report_name);
442:
443: -- Build Parameter Form
444:
445: BIS_UTILITIES_PUB.Build_Parameter_Form('NAME="'
445: BIS_UTILITIES_PUB.Build_Parameter_Form('NAME="'
446: || p_report_name || '"
447: ACTION="HRI_Parameters.Param_ActionView" METHOD="GET"', params);
448:
449: htp.formClose;
450: htp.bodyClose;
451: htp.htmlClose;
452:
453: EXCEPTION
446: || p_report_name || '"
447: ACTION="HRI_Parameters.Param_ActionView" METHOD="GET"', params);
448:
449: htp.formClose;
450: htp.bodyClose;
451: htp.htmlClose;
452:
453: EXCEPTION
454: WHEN e_missing_required_parameter THEN
447: ACTION="HRI_Parameters.Param_ActionView" METHOD="GET"', params);
448:
449: htp.formClose;
450: htp.bodyClose;
451: htp.htmlClose;
452:
453: EXCEPTION
454: WHEN e_missing_required_parameter THEN
455: BEGIN
476:
477: fnd_message.set_name('HRI','HR_BIS_PLSQL_CART_REQ_PARAM');
478: fnd_message.set_token('PARAMETER',l_param_missing_req_label);
479:
480: htp.br;
481: htp.br;
482: htp.br;
483: htp.bold(fnd_message.get);
484: htp.formClose;
477: fnd_message.set_name('HRI','HR_BIS_PLSQL_CART_REQ_PARAM');
478: fnd_message.set_token('PARAMETER',l_param_missing_req_label);
479:
480: htp.br;
481: htp.br;
482: htp.br;
483: htp.bold(fnd_message.get);
484: htp.formClose;
485: htp.bodyClose;
478: fnd_message.set_token('PARAMETER',l_param_missing_req_label);
479:
480: htp.br;
481: htp.br;
482: htp.br;
483: htp.bold(fnd_message.get);
484: htp.formClose;
485: htp.bodyClose;
486: htp.htmlClose;
479:
480: htp.br;
481: htp.br;
482: htp.br;
483: htp.bold(fnd_message.get);
484: htp.formClose;
485: htp.bodyClose;
486: htp.htmlClose;
487:
480: htp.br;
481: htp.br;
482: htp.br;
483: htp.bold(fnd_message.get);
484: htp.formClose;
485: htp.bodyClose;
486: htp.htmlClose;
487:
488:
481: htp.br;
482: htp.br;
483: htp.bold(fnd_message.get);
484: htp.formClose;
485: htp.bodyClose;
486: htp.htmlClose;
487:
488:
489: END;
482: htp.br;
483: htp.bold(fnd_message.get);
484: htp.formClose;
485: htp.bodyClose;
486: htp.htmlClose;
487:
488:
489: END;
490: