APPS.MRP_FORECAST dependencies on MRP_FORM_QUERY

Line 183: INSERT INTO mrp_form_query

179: END IF;
180:
181: LOOP
182:
183: INSERT INTO mrp_form_query
184: (QUERY_ID,
185: LAST_UPDATE_DATE,
186: LAST_UPDATED_BY,
187: CREATION_DATE,

Line 223: INSERT INTO mrp_form_query

219: --COMMIT WORK;
220:
221: END LOOP fc_loop;
222: ELSE /* no entires were found, insert a psuedo one */
223: INSERT INTO mrp_form_query
224: (QUERY_ID,
225: LAST_UPDATE_DATE,
226: LAST_UPDATED_BY,
227: CREATION_DATE,

Line 265: FUNCTION FC_MRP_FORM_QUERY( arg_org_id IN NUMBER,

261: dbms_output.put_line(sqlerrm);
262: */
263: END BUCKET_FC_DESIG;
264:
265: FUNCTION FC_MRP_FORM_QUERY( arg_org_id IN NUMBER,
266: arg_query_id IN NUMBER,
267: arg_secondary_query_id IN NUMBER,
268: arg_bucket_type IN NUMBER,
269: arg_past_due IN NUMBER,

Line 274: INSERT INTO mrp_form_query

270: arg_cutoff_date IN DATE,
271: arg_bucket_start_date IN DATE) RETURN BOOLEAN IS
272: BEGIN
273: IF arg_bucket_type = TYPE_DAILY_BUCKET THEN
274: INSERT INTO mrp_form_query
275: (QUERY_ID,
276: LAST_UPDATE_DATE,
277: LAST_UPDATED_BY,
278: CREATION_DATE,

Line 369: MRP_FORM_QUERY MRP_FQ

365: MRP_FQ.NUMBER1, /* (added for web inquiries) */
366: MRP_FQ.CHAR1 /* (added for web inquiries) */
367: FROM BOM_CALENDAR_DATES DATES,
368: MTL_PARAMETERS PARAM,
369: MRP_FORM_QUERY MRP_FQ
370: WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
371: AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
372: AND DATES.SEQ_NUM is not NULL
373: AND DATES.CALENDAR_DATE BETWEEN arg_bucket_start_date

Line 386: INSERT INTO mrp_form_query

382: DATES.CALENDAR_DATE,
383: DATES.NEXT_DATE;
384:
385: ELSIF arg_bucket_type = TYPE_WEEKLY_BUCKET THEN
386: INSERT INTO mrp_form_query
387: (QUERY_ID,
388: LAST_UPDATE_DATE,
389: LAST_UPDATED_BY,
390: CREATION_DATE,

Line 509: MRP_FORM_QUERY MRP_FQ

505: MRP_FQ.NUMBER1, /* (added for web inquiries) */
506: MRP_FQ.CHAR1 /* (added for web inquiries) */
507: FROM BOM_CAL_WEEK_START_DATES DATES,
508: MTL_PARAMETERS PARAM,
509: MRP_FORM_QUERY MRP_FQ
510: WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
511: AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
512: AND DATES.WEEK_START_DATE BETWEEN arg_bucket_start_date
513: AND arg_cutoff_date

Line 524: INSERT INTO mrp_form_query

520: MRP_FQ.CHAR1, /* (added for web inquiries) */
521: DATES.WEEK_START_DATE,
522: DATES.NEXT_DATE;
523: ELSE
524: INSERT INTO mrp_form_query
525: (QUERY_ID,
526: LAST_UPDATE_DATE,
527: LAST_UPDATED_BY,
528: CREATION_DATE,

Line 647: MRP_FORM_QUERY MRP_FQ

643: MRP_FQ.NUMBER1, /* (added for web inquiries) */
644: MRP_FQ.CHAR1 /* (added for web inquiries) */
645: FROM MTL_PARAMETERS PARAM,
646: BOM_PERIOD_START_DATES DATES,
647: MRP_FORM_QUERY MRP_FQ
648: WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
649: AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
650: AND PARAM.ORGANIZATION_ID = arg_org_id
651: AND MRP_FQ.query_id = arg_query_id

Line 671: END FC_MRP_FORM_QUERY;

667: return FALSE;
668: WHEN OTHERS THEN
669: dbms_output.put_line(sqlerrm);
670: */
671: END FC_MRP_FORM_QUERY;
672:
673: /*---------------------------- PUBLIC ROUTINES ------------------------------*/
674: PROCEDURE BUCKET_ENTRIES( arg_form_mode IN NUMBER,
675: arg_org_id IN NUMBER,

Line 782: /*bucket the entries into mrp_form_query */

778: END;
779: END IF;
780: END IF;
781:
782: /*bucket the entries into mrp_form_query */
783: var_return_value := fc_mrp_form_query(
784: arg_org_id,
785: arg_query_id,
786: arg_secondary_query_id,

Line 783: var_return_value := fc_mrp_form_query(

779: END IF;
780: END IF;
781:
782: /*bucket the entries into mrp_form_query */
783: var_return_value := fc_mrp_form_query(
784: arg_org_id,
785: arg_query_id,
786: arg_secondary_query_id,
787: arg_bucket_type,