APPS.CSP_EXCESS_PARTS_PVT dependencies on CSP_EXCESS_PARTS_PVT

Line 1: PACKAGE BODY CSP_EXCESS_PARTS_PVT AS

1: PACKAGE BODY CSP_EXCESS_PARTS_PVT AS
2: /* $Header: cspvpexb.pls 120.3 2006/06/08 20:35:15 ajosephg noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_EXCESS_PARTS_PVT';
4: G_FILE_NAME CONSTANT VARCHAR2(30):='cspvpexb.pls';
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_EXCESS_PARTS_PVT';

1: PACKAGE BODY CSP_EXCESS_PARTS_PVT AS
2: /* $Header: cspvpexb.pls 120.3 2006/06/08 20:35:15 ajosephg noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_EXCESS_PARTS_PVT';
4: G_FILE_NAME CONSTANT VARCHAR2(30):='cspvpexb.pls';
5:
6: g_node_level_id Varchar2(2000):= 1;
7:

Line 558: l_onhand := csp_excess_parts_pvt.onhand(

554: l_demand := 0;
555: l_excess := 0;
556:
557: --for cos in c_org_subinventories(coi.inventory_item_id) loop
558: l_onhand := csp_excess_parts_pvt.onhand(
559: p_organization_id => p_organization_id,
560: p_inventory_item_id => coi.inventory_item_id,
561: --p_subinventory_code => cos.subinventory_code,
562: p_subinventory_code => NULL,

Line 570: l_demand := csp_excess_parts_pvt.demand(

566:
567: l_total_onhand := l_total_onhand + l_onhand;
568: --end loop;
569:
570: l_demand := csp_excess_parts_pvt.demand(
571: p_organization_id => p_organization_id,
572: p_inventory_item_id => coi.inventory_item_id,
573: p_subinventory_code => null,
574: p_include_nonnet => p_include_nonnet,

Line 647: l_onhand := csp_excess_parts_pvt.onhand(

643: -- SUBINVENTORY Level
644: if l_level = 2 then
645: for curs in c_subinventories loop
646: for csin in c_sub_items(curs.secondary_inventory_name) loop
647: l_onhand := csp_excess_parts_pvt.onhand(
648: p_organization_id => p_organization_id,
649: p_inventory_item_id => csin.inventory_item_id,
650: p_subinventory_code => curs.secondary_inventory_name,
651: p_revision_qty_control_code => csin.revision_qty_control_code,

Line 655: l_demand := csp_excess_parts_pvt.demand(

651: p_revision_qty_control_code => csin.revision_qty_control_code,
652: p_include_nonnet => p_include_nonnet,
653: p_planning_level => l_level);
654:
655: l_demand := csp_excess_parts_pvt.demand(
656: p_organization_id => p_organization_id,
657: p_inventory_item_id => csin.inventory_item_id,
658: p_subinventory_code => curs.secondary_inventory_name,
659: p_include_nonnet => p_include_nonnet,

Line 734: csp_excess_parts_pvt.apply_business_rules(

730: p_organization_id => p_organization_id,
731: p_subinventory_code => p_subinventory_code);
732:
733: if l_excess_rule_id is not null then
734: csp_excess_parts_pvt.apply_business_rules(
735: p_organization_id => p_organization_id,
736: p_subinventory_code => p_subinventory_code,
737: p_excess_rule_id => l_excess_rule_id);
738: else