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.22 2012/03/01 06:31:21 skathera 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 352: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(

348:
349: -- 4417550, make planned order can be released only when
350: -- child supply are on hand or make planned order
351:
352: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
353: p_plan_id, p_transaction_id);
354: if p_valid > 0 then
355: p_rel_error := p_rel_error ||' '||
356: FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');

Line 365: p_impl_as := msc_select_all_for_release_pub.get_implement_as(

361: if p_rel_error is null then
362: if p_order_type in (5,13,51,76,77,78,53) then
363: --pabram.srp.changes added 76,77,78
364:
365: p_impl_as := msc_select_all_for_release_pub.get_implement_as(
366: p_order_type,
367: p_org_id,
368: p_source_org_id,
369: p_supplier_id,

Line 911: END MSC_SELECT_ALL_FOR_RELEASE_PUB;

907:
908: return v_temp;
909: END child_supplies_onhand;
910:
911: END MSC_SELECT_ALL_FOR_RELEASE_PUB;