215:
216: /* ORGANIZATION */
217:
218: params(1).Label := fnd_message.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL' );
219: params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );
220: FOR c1 in c_orgs LOOP
221: if( c1.organization_id = L_ORGANIZATION_ID ) then
222: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
223: else
218: params(1).Label := fnd_message.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL' );
219: params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );
220: FOR c1 in c_orgs LOOP
221: if( c1.organization_id = L_ORGANIZATION_ID ) then
222: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
223: else
224: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
225: end if;
226: END LOOP;
220: FOR c1 in c_orgs LOOP
221: if( c1.organization_id = L_ORGANIZATION_ID ) then
222: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
223: else
224: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
225: end if;
226: END LOOP;
227: params(1).Value := params(1).Value || htf.formSelectClose;
228:
223: else
224: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
225: end if;
226: END LOOP;
227: params(1).Value := params(1).Value || htf.formSelectClose;
228:
229:
230: /* BUSINESS PLAN */
231:
229:
230: /* BUSINESS PLAN */
231:
232: params(2).Label := fnd_message.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL' );
233: params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );
234: FOR c1 in c_business_plans LOOP
235: if( c1.plan_id = L_BUSINESS_PLAN_ID ) then
236: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );
237: else
232: params(2).Label := fnd_message.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL' );
233: params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );
234: FOR c1 in c_business_plans LOOP
235: if( c1.plan_id = L_BUSINESS_PLAN_ID ) then
236: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );
237: else
238: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
239: end if;
240: END LOOP;
234: FOR c1 in c_business_plans LOOP
235: if( c1.plan_id = L_BUSINESS_PLAN_ID ) then
236: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );
237: else
238: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
239: end if;
240: END LOOP;
241: params(2).Value := params(2).Value || htf.formSelectClose;
242:
237: else
238: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
239: end if;
240: END LOOP;
241: params(2).Value := params(2).Value || htf.formSelectClose;
242:
243: /* MRP PLANS */
244:
245: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_PLAN_NAME_LABEL' );
242:
243: /* MRP PLANS */
244:
245: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_PLAN_NAME_LABEL' );
246: params(3).Value := htf.formSelectOpen('P_PLAN1');
247: FOR c1 in c_plans LOOP
248: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
249: END LOOP;
250: params(3).Value := params(3).Value || htf.formSelectClose;
244:
245: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_PLAN_NAME_LABEL' );
246: params(3).Value := htf.formSelectOpen('P_PLAN1');
247: FOR c1 in c_plans LOOP
248: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
249: END LOOP;
250: params(3).Value := params(3).Value || htf.formSelectClose;
251: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
252: FOR c1 in c_plans LOOP
246: params(3).Value := htf.formSelectOpen('P_PLAN1');
247: FOR c1 in c_plans LOOP
248: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
249: END LOOP;
250: params(3).Value := params(3).Value || htf.formSelectClose;
251: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
252: FOR c1 in c_plans LOOP
253: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
254: END LOOP;
247: FOR c1 in c_plans LOOP
248: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
249: END LOOP;
250: params(3).Value := params(3).Value || htf.formSelectClose;
251: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
252: FOR c1 in c_plans LOOP
253: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
254: END LOOP;
255: params(3).Value := params(3).Value || htf.formSelectClose;
249: END LOOP;
250: params(3).Value := params(3).Value || htf.formSelectClose;
251: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
252: FOR c1 in c_plans LOOP
253: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
254: END LOOP;
255: params(3).Value := params(3).Value || htf.formSelectClose;
256:
257:
251: params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );
252: FOR c1 in c_plans LOOP
253: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
254: END LOOP;
255: params(3).Value := params(3).Value || htf.formSelectClose;
256:
257:
258: /* PERIOD TYPE */
259:
257:
258: /* PERIOD TYPE */
259:
260: params(4).Label := fnd_message.get_string( 'MRP', 'MRP_PERIOD_TYPE_LABEL' );
261: params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );
262: FOR c1 in c_period_types LOOP
263: params(4).Value := params(4).Value ||
264: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);
265: END LOOP;
260: params(4).Label := fnd_message.get_string( 'MRP', 'MRP_PERIOD_TYPE_LABEL' );
261: params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );
262: FOR c1 in c_period_types LOOP
263: params(4).Value := params(4).Value ||
264: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);
265: END LOOP;
266: params(4).Value := params(4).Value || htf.formSelectClose;
267:
268: BIS_UTILITIES_PUB.Build_Parameter_Form(
262: FOR c1 in c_period_types LOOP
263: params(4).Value := params(4).Value ||
264: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);
265: END LOOP;
266: params(4).Value := params(4).Value || htf.formSelectClose;
267:
268: BIS_UTILITIES_PUB.Build_Parameter_Form(
269: 'NAME="param" ACTION="MRP_PARAMETER_MRPEPPS.Parameter_ActionView_MRPEPPS" METHOD="GET" ', params );
270: