DBA Data[Home] [Help]

APPS.MRP_PARAMETER_MRPFSETA dependencies on HTF

Line 178: param(i).Value := htf.formSelectOpen( 'P_ORG' );

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;

Line 179: -- param(i).Value := htf.formSelectOpen( 'P_ORG', cattributes=>'onChange="setPoplists()"' );

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;

Line 181: param(i).Value := param(i).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.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;
184:
185: END MRPFSETA_Parameter_PrintOrg;

Line 183: param(i).Value := param(i).Value || htf.formSelectClose;

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(

Line 194: param(i).Value := htf.formSelectOpen( 'P_TARGET' );

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;

Line 197: htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );

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;

Line 199: param(i).Value := param(i).Value || htf.formSelectClose;

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(

Line 210: param(i).Value := htf.formSelectOpen( 'P_PERIOD' );

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;

Line 213: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );

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;

Line 215: param(i).Value := param(i).Value || htf.formSelectClose;

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(

Line 231: param(i).Value := htf.formSelectOpen( 'P_FROM_FORECAST' );

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;

Line 234: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );

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 || ' - ' ||

Line 236: param(i).Value := param(i).Value || htf.formSelectClose;

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

Line 239: htf.formSelectOpen( 'P_TO_FORECAST' );

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;

Line 242: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );

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;

Line 244: param(i).Value := param(i).Value || htf.formSelectClose;

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: /*

Line 398: params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );

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

Line 401: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );

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;

Line 403: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.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;
406: params(1).Value := params(1).Value || htf.formSelectClose;
407:

Line 406: params(1).Value := params(1).Value || htf.formSelectClose;

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:

Line 412: params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );

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

Line 415: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );

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;

Line 417: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );

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:

Line 420: params(2).Value := params(2).Value || htf.formSelectClose;

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' );

Line 425: params(3).Value := htf.formSelectOpen('P_PLAN1');

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;

Line 427: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );

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

Line 429: params(3).Value := params(3).Value || htf.formSelectClose;

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;

Line 430: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );

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;

Line 432: 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;
435:
436:

Line 434: 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:
437: /* PERIOD TYPE */
438:

Line 440: params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );

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;

Line 443: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);

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(

Line 445: params(4).Value := params(4).Value || htf.formSelectClose;

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: