174: ORDER BY organization_name;
175: BEGIN
176: -- htp.formHidden('p_org_id');
177: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL');
178: param(i).Value := htf.formSelectOpen( 'P_ORG' );
179: -- param(i).Value := htf.formSelectOpen( 'P_ORG', cattributes=>'onChange="setPoplists()"' );
180: FOR c1 in c_organizations LOOP
181: param(i).Value := param(i).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.org_id );
182: END LOOP;
175: BEGIN
176: -- htp.formHidden('p_org_id');
177: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL');
178: param(i).Value := htf.formSelectOpen( 'P_ORG' );
179: -- param(i).Value := htf.formSelectOpen( 'P_ORG', cattributes=>'onChange="setPoplists()"' );
180: FOR c1 in c_organizations LOOP
181: param(i).Value := param(i).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.org_id );
182: END LOOP;
183: param(i).Value := param(i).Value || htf.formSelectClose;
177: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL');
178: param(i).Value := htf.formSelectOpen( 'P_ORG' );
179: -- param(i).Value := htf.formSelectOpen( 'P_ORG', cattributes=>'onChange="setPoplists()"' );
180: FOR c1 in c_organizations LOOP
181: param(i).Value := param(i).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.org_id );
182: END LOOP;
183: param(i).Value := param(i).Value || htf.formSelectClose;
184:
185: END MRPFSETA_Parameter_PrintOrg;
179: -- param(i).Value := htf.formSelectOpen( 'P_ORG', cattributes=>'onChange="setPoplists()"' );
180: FOR c1 in c_organizations LOOP
181: param(i).Value := param(i).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.org_id );
182: END LOOP;
183: param(i).Value := param(i).Value || htf.formSelectClose;
184:
185: END MRPFSETA_Parameter_PrintOrg;
186:
187: PROCEDURE MRPFSETA_Parameter_PrintTrgt(
190: CURSOR c_business_plans IS
191: SELECT plan_id, name FROM bisbv_business_plans;
192: BEGIN
193: param(i).Label := FND_MESSAGE.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL');
194: param(i).Value := htf.formSelectOpen( 'P_TARGET' );
195: FOR c1 in c_business_plans LOOP
196: param(i).Value := param(i).Value ||
197: htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
198: END LOOP;
193: param(i).Label := FND_MESSAGE.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL');
194: param(i).Value := htf.formSelectOpen( 'P_TARGET' );
195: FOR c1 in c_business_plans LOOP
196: param(i).Value := param(i).Value ||
197: htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
198: END LOOP;
199: param(i).Value := param(i).Value || htf.formSelectClose;
200:
201: END MRPFSETA_Parameter_PrintTrgt;
195: FOR c1 in c_business_plans LOOP
196: param(i).Value := param(i).Value ||
197: htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
198: END LOOP;
199: param(i).Value := param(i).Value || htf.formSelectClose;
200:
201: END MRPFSETA_Parameter_PrintTrgt;
202:
203: PROCEDURE MRPFSETA_Parameter_PrintPer(
206: CURSOR c_period IS SELECT distinct period_type name, period_type id
207: FROM gl_periods;
208: BEGIN
209: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_PERIOD_LABEL');
210: param(i).Value := htf.formSelectOpen( 'P_PERIOD' );
211: FOR c1 in c_period LOOP
212: param(i).Value := param(i).Value ||
213: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
214: END LOOP;
209: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_PERIOD_LABEL');
210: param(i).Value := htf.formSelectOpen( 'P_PERIOD' );
211: FOR c1 in c_period LOOP
212: param(i).Value := param(i).Value ||
213: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
214: END LOOP;
215: param(i).Value := param(i).Value || htf.formSelectClose;
216:
217: END MRPFSETA_Parameter_PrintPer;
211: FOR c1 in c_period LOOP
212: param(i).Value := param(i).Value ||
213: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
214: END LOOP;
215: param(i).Value := param(i).Value || htf.formSelectClose;
216:
217: END MRPFSETA_Parameter_PrintPer;
218:
219: PROCEDURE MRPFSETA_Parameter_PrintFcst(
227: AND organization_id = 207
228: ORDER BY forecast_designator;
229: BEGIN
230: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_FORECAST_SET_LABEL');
231: param(i).Value := htf.formSelectOpen( 'P_FROM_FORECAST' );
232: FOR c1 in c_forecast LOOP
233: param(i).Value := param(i).Value ||
234: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
235: END LOOP;
230: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_FORECAST_SET_LABEL');
231: param(i).Value := htf.formSelectOpen( 'P_FROM_FORECAST' );
232: FOR c1 in c_forecast LOOP
233: param(i).Value := param(i).Value ||
234: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
235: END LOOP;
236: param(i).Value := param(i).Value || htf.formSelectClose;
237:
238: param(i).Value := param(i).Value || ' - ' ||
232: FOR c1 in c_forecast LOOP
233: param(i).Value := param(i).Value ||
234: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
235: END LOOP;
236: param(i).Value := param(i).Value || htf.formSelectClose;
237:
238: param(i).Value := param(i).Value || ' - ' ||
239: htf.formSelectOpen( 'P_TO_FORECAST' );
240: FOR c1 in c_forecast LOOP
235: END LOOP;
236: param(i).Value := param(i).Value || htf.formSelectClose;
237:
238: param(i).Value := param(i).Value || ' - ' ||
239: htf.formSelectOpen( 'P_TO_FORECAST' );
240: FOR c1 in c_forecast LOOP
241: param(i).Value := param(i).Value ||
242: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
243: END LOOP;
238: param(i).Value := param(i).Value || ' - ' ||
239: htf.formSelectOpen( 'P_TO_FORECAST' );
240: FOR c1 in c_forecast LOOP
241: param(i).Value := param(i).Value ||
242: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
243: END LOOP;
244: param(i).Value := param(i).Value || htf.formSelectClose;
245:
246: END MRPFSETA_Parameter_PrintFcst;
240: FOR c1 in c_forecast LOOP
241: param(i).Value := param(i).Value ||
242: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
243: END LOOP;
244: param(i).Value := param(i).Value || htf.formSelectClose;
245:
246: END MRPFSETA_Parameter_PrintFcst;
247:
248: /*
394:
395: /* ORGANIZATION */
396:
397: params(1).Label := fnd_message.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL' );
398: params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );
399: FOR c1 in c_orgs LOOP
400: if( c1.organization_id = L_ORGANIZATION_ID ) then
401: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
402: else
397: params(1).Label := fnd_message.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL' );
398: params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );
399: FOR c1 in c_orgs LOOP
400: if( c1.organization_id = L_ORGANIZATION_ID ) then
401: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
402: else
403: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
404: end if;
405: END LOOP;
399: FOR c1 in c_orgs LOOP
400: if( c1.organization_id = L_ORGANIZATION_ID ) then
401: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
402: else
403: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
404: end if;
405: END LOOP;
406: params(1).Value := params(1).Value || htf.formSelectClose;
407:
402: else
403: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
404: end if;
405: END LOOP;
406: params(1).Value := params(1).Value || htf.formSelectClose;
407:
408:
409: /* BUSINESS PLAN */
410:
408:
409: /* BUSINESS PLAN */
410:
411: params(2).Label := fnd_message.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL' );
412: params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );
413: FOR c1 in c_business_plans LOOP
414: if( c1.plan_id = L_BUSINESS_PLAN_ID ) then
415: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );
416: else
411: params(2).Label := fnd_message.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL' );
412: params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );
413: FOR c1 in c_business_plans LOOP
414: if( c1.plan_id = L_BUSINESS_PLAN_ID ) then
415: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );
416: else
417: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
418: end if;
419: END LOOP;
413: FOR c1 in c_business_plans LOOP
414: if( c1.plan_id = L_BUSINESS_PLAN_ID ) then
415: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );
416: else
417: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
418: end if;
419: END LOOP;
420: params(2).Value := params(2).Value || htf.formSelectClose;
421:
416: else
417: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
418: end if;
419: END LOOP;
420: params(2).Value := params(2).Value || htf.formSelectClose;
421:
422: /* MRP PLANS */
423:
424: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_FORECAST_SET_LABEL' );
421:
422: /* MRP PLANS */
423:
424: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_FORECAST_SET_LABEL' );
425: params(3).Value := htf.formSelectOpen('P_PLAN1');
426: FOR c1 in c_forecast LOOP
427: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
428: END LOOP;
429: params(3).Value := params(3).Value || htf.formSelectClose;
423:
424: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_FORECAST_SET_LABEL' );
425: params(3).Value := htf.formSelectOpen('P_PLAN1');
426: FOR c1 in c_forecast LOOP
427: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
428: END LOOP;
429: params(3).Value := params(3).Value || htf.formSelectClose;
430: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
431: FOR c1 in c_forecast LOOP
425: params(3).Value := htf.formSelectOpen('P_PLAN1');
426: FOR c1 in c_forecast LOOP
427: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
428: END LOOP;
429: params(3).Value := params(3).Value || htf.formSelectClose;
430: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
431: FOR c1 in c_forecast LOOP
432: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
433: END LOOP;
426: FOR c1 in c_forecast LOOP
427: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
428: END LOOP;
429: params(3).Value := params(3).Value || htf.formSelectClose;
430: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
431: FOR c1 in c_forecast LOOP
432: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
433: END LOOP;
434: params(3).Value := params(3).Value || htf.formSelectClose;
428: END LOOP;
429: params(3).Value := params(3).Value || htf.formSelectClose;
430: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
431: FOR c1 in c_forecast LOOP
432: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
433: END LOOP;
434: params(3).Value := params(3).Value || htf.formSelectClose;
435:
436:
430: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
431: FOR c1 in c_forecast LOOP
432: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
433: END LOOP;
434: params(3).Value := params(3).Value || htf.formSelectClose;
435:
436:
437: /* PERIOD TYPE */
438:
436:
437: /* PERIOD TYPE */
438:
439: params(4).Label := fnd_message.get_string( 'MRP', 'MRP_PERIOD_TYPE_LABEL' );
440: params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );
441: FOR c1 in c_period_types LOOP
442: params(4).Value := params(4).Value ||
443: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);
444: END LOOP;
439: params(4).Label := fnd_message.get_string( 'MRP', 'MRP_PERIOD_TYPE_LABEL' );
440: params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );
441: FOR c1 in c_period_types LOOP
442: params(4).Value := params(4).Value ||
443: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);
444: END LOOP;
445: params(4).Value := params(4).Value || htf.formSelectClose;
446:
447: BIS_UTILITIES_PUB.Build_Parameter_Form(
441: FOR c1 in c_period_types LOOP
442: params(4).Value := params(4).Value ||
443: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);
444: END LOOP;
445: params(4).Value := params(4).Value || htf.formSelectClose;
446:
447: BIS_UTILITIES_PUB.Build_Parameter_Form(
448: 'NAME="param" ACTION="MRP_PARAMETER_MRPFSETA.Parameter_ActionView_MRPFSETA" METHOD="GET" ', params );
449: