DBA Data[Home] [Help]

APPS.MRP_SOURCING_RULE_PUB dependencies on MRP_SOURCING_RULE_PUB

Line 1: PACKAGE BODY MRP_Sourcing_Rule_PUB AS

1: PACKAGE BODY MRP_Sourcing_Rule_PUB AS
2: /* $Header: MRPPSRLB.pls 120.1 2005/06/16 12:39:47 ichoudhu noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Sourcing_Rule_PUB';

2: /* $Header: MRPPSRLB.pls 120.1 2005/06/16 12:39:47 ichoudhu noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Sourcing_Rule_PUB';
7:
8: -- Forward declaration of Procedure Id_To_Value
9:
10: PROCEDURE Id_To_Value

Line 458: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;

454: IS
455: l_api_version_number CONSTANT NUMBER := 1.0;
456: l_api_name CONSTANT VARCHAR2(30):= 'Get_Sourcing_Rule';
457: l_Sourcing_Rule_Id NUMBER := p_Sourcing_Rule_Id;
458: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
459: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

Line 459: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;

455: l_api_version_number CONSTANT NUMBER := 1.0;
456: l_api_name CONSTANT VARCHAR2(30):= 'Get_Sourcing_Rule';
457: l_Sourcing_Rule_Id NUMBER := p_Sourcing_Rule_Id;
458: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
459: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;

Line 460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;

456: l_api_name CONSTANT VARCHAR2(30):= 'Get_Sourcing_Rule';
457: l_Sourcing_Rule_Id NUMBER := p_Sourcing_Rule_Id;
458: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
459: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
464: l_x_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

Line 461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;

457: l_Sourcing_Rule_Id NUMBER := p_Sourcing_Rule_Id;
458: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
459: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
464: l_x_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
465: l_x_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;

Line 462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

458: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
459: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
464: l_x_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
465: l_x_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
466: BEGIN

Line 463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;

459: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
464: l_x_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
465: l_x_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
466: BEGIN
467:

Line 464: l_x_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

460: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
464: l_x_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
465: l_x_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
466: BEGIN
467:
468: -- Standard call to check for call compatibility

Line 465: l_x_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;

461: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
462: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
463: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
464: l_x_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
465: l_x_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
466: BEGIN
467:
468: -- Standard call to check for call compatibility
469:

Line 763: END MRP_Sourcing_Rule_PUB;

759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760:
761: END Value_To_Id;
762:
763: END MRP_Sourcing_Rule_PUB;