APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_SELECT_ALL_FOR_RELEASE_PUB

Line 1: PACKAGE BODY MSC_SELECT_ALL_FOR_RELEASE_PUB AS

1: PACKAGE BODY MSC_SELECT_ALL_FOR_RELEASE_PUB AS
2: /* $Header: MSCSARPB.pls 120.15.12010000.2 2008/05/27 19:22:38 eychen ship $ */
3: TYPE numtab is table of Number index by binary_integer;
4: TYPE char240_tab is table of varchar2(240) index by binary_integer;
5: g_instance_id numtab;

Line 284: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(

280:
281: -- 4417550, make planned order can be released only when
282: -- child supply are on hand or make planned order
283:
284: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
285: p_plan_id, p_transaction_id);
286: if p_valid > 0 then
287: p_rel_error := p_rel_error ||' '||
288: FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');

Line 297: p_impl_as := msc_select_all_for_release_pub.get_implement_as(

293: if p_rel_error is null then
294: if p_order_type in (5,13,51,76,77,78) then
295: --pabram.srp.changes added 76,77,78
296:
297: p_impl_as := msc_select_all_for_release_pub.get_implement_as(
298: p_order_type,
299: p_org_id,
300: p_source_org_id,
301: p_supplier_id,

Line 771: END MSC_SELECT_ALL_FOR_RELEASE_PUB;

767:
768: return v_temp;
769: END child_supplies_onhand;
770:
771: END MSC_SELECT_ALL_FOR_RELEASE_PUB;