APPS.MRP_EPI dependencies on MRP_EPI

Line 1: PACKAGE BODY mrp_epi AS

1: PACKAGE BODY mrp_epi AS
2: /* $Header: MRPCINVB.pls 120.3 2005/09/12 08:31:26 gmalhotr noship $ */
3: PROCEDURE inventory_turns(errbuf OUT NOCOPY VARCHAR2, --2663505
4: retcode OUT NOCOPY NUMBER, --2663505
5: p_owning_org_id IN NUMBER,

Line 289: errbuf := 'Error in mrp_epi.inventory_turns function' ||

285: retcode := G_SUCCESS;
286:
287: EXCEPTION
288: WHEN OTHERS THEN
289: errbuf := 'Error in mrp_epi.inventory_turns function' ||
290: ' Cursor: ' || l_cursor ||
291: ' SQL error: ' || sqlerrm;
292: retcode := G_ERROR;
293:

Line 324: return mrp_epi.mrp_item_cost(arg_item_id, arg_org_id);

320:
321: return arg_price;
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: return mrp_epi.mrp_item_cost(arg_item_id, arg_org_id);
325: END mrp_item_selling_price;
326:
327: -- New function for the APS
328: -- It's a copy from mrp_item_selling_price without the discount.

Line 358: return mrp_epi.mrp_item_cost(arg_item_id, arg_org_id);

354:
355: return arg_price;
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN
358: return mrp_epi.mrp_item_cost(arg_item_id, arg_org_id);
359: END mrp_item_list_price;
360:
361: FUNCTION mrp_item_cost(p_item_id in number,
362: p_org_id in number)

Line 675: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,

671: dates.original_forecast_quantity,
672: sum(md.primary_uom_quantity),
673: sum(md.completed_quantity),
674: dates.original_forecast_quantity *
675: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
676: dates.organization_id),
677: sum(md.primary_uom_quantity) *
678: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
679: dates.organization_id),

Line 678: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,

674: dates.original_forecast_quantity *
675: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
676: dates.organization_id),
677: sum(md.primary_uom_quantity) *
678: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
679: dates.organization_id),
680: sum(md.completed_quantity) *
681: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
682: dates.organization_id),

Line 681: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,

677: sum(md.primary_uom_quantity) *
678: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
679: dates.organization_id),
680: sum(md.completed_quantity) *
681: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
682: dates.organization_id),
683: avg(dates.confidence_percentage)
684: FROM org_organization_definitions org,
685: fnd_lookup_values ar,

Line 851: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,

847: sys.description, ar.meaning, desig.customer_id, PART.party_name,
848: desig.ship_id, LOC2.address1, LOC2.city, LOC2.state, LOC2.postal_code,
849: desig.bill_id, LOC1.address1, LOC1.city, LOC1.state, LOC1.postal_code,
850: cal.calendar_date,dates.original_forecast_quantity, dates.original_forecast_quantity *
851: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
852: dates.organization_id);
853:
854: -- bug2384395
855: -- Create Indexes after first insert

Line 976: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,

972: dates.original_forecast_quantity,
973: 0,
974: 0,
975: dates.original_forecast_quantity *
976: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
977: dates.organization_id),
978: 0,
979: 0,
980: dates.confidence_percentage

Line 1177: mrp_epi.mrp_item_selling_price(md.inventory_item_id,

1173: md.primary_uom_quantity,
1174: md.completed_quantity,
1175: 0,
1176: md.primary_uom_quantity *
1177: mrp_epi.mrp_item_selling_price(md.inventory_item_id,
1178: md.organization_id),
1179: md.completed_quantity *
1180: mrp_epi.mrp_item_selling_price(md.inventory_item_id,
1181: md.organization_id),

Line 1180: mrp_epi.mrp_item_selling_price(md.inventory_item_id,

1176: md.primary_uom_quantity *
1177: mrp_epi.mrp_item_selling_price(md.inventory_item_id,
1178: md.organization_id),
1179: md.completed_quantity *
1180: mrp_epi.mrp_item_selling_price(md.inventory_item_id,
1181: md.organization_id),
1182: 0
1183: FROM
1184: fnd_lookup_values ar,

Line 1556: END mrp_epi;

1552: delete from MRP_FORM_QUERY where query_id = l_query_id;
1553:
1554: END mrp_resource_util;
1555:
1556: END mrp_epi;