DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on AHL_PRD_DISP_MTL_TXN_PVT

Line 1: PACKAGE BODY AHL_PRD_DISP_MTL_TXN_PVT AS

1: PACKAGE BODY AHL_PRD_DISP_MTL_TXN_PVT AS
2: /* $Header: AHLVDMTB.pls 120.4.12020000.3 2012/12/14 07:58:44 shnatu ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_Prd_Disp_Mtl_Txn_Pvt';
4: G_LOG_PREFIX VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.';
5:

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

1: PACKAGE BODY AHL_PRD_DISP_MTL_TXN_PVT AS
2: /* $Header: AHLVDMTB.pls 120.4.12020000.3 2012/12/14 07:58:44 shnatu ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_Prd_Disp_Mtl_Txn_Pvt';
4: G_LOG_PREFIX VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.';
5:
6: ------------------------
7: -- Declare Procedures --

Line 31: p_x_disp_mtl_txn_tbl IN OUT NOCOPY AHL_PRD_DISP_MTL_TXN_PVT.Disp_Mtl_Txn_Tbl_Type)

27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_module IN VARCHAR2,
31: p_x_disp_mtl_txn_tbl IN OUT NOCOPY AHL_PRD_DISP_MTL_TXN_PVT.Disp_Mtl_Txn_Tbl_Type)
32: IS
33:
34: --Begin Performance Tuning
35: -- Begin fix bug 4097556

Line 85: l_disp_mx_rec AHL_PRD_DISP_MTL_TXN_PVT.disp_mtl_txn_rec_type;

81: FROM AHL_PRD_DISPOSITIONS_B disp
82: WHERE disp.disposition_id = p_disposition_id;
83: --
84: l_old_disp_mx_rec get_disp_mtl_txn_rec_csr%ROWTYPE;
85: l_disp_mx_rec AHL_PRD_DISP_MTL_TXN_PVT.disp_mtl_txn_rec_type;
86:
87: l_api_version CONSTANT NUMBER := 1.0;
88: l_api_name CONSTANT VARCHAR2(30) := 'Process_Disp_Mtl_Txn';
89:

Line 1140: End AHL_PRD_DISP_MTL_TXN_PVT;

1136: CLOSE get_assoc_qty_csr;
1137: RETURN l_txn_qty;
1138: END Get_Assoc_Quantity;
1139:
1140: End AHL_PRD_DISP_MTL_TXN_PVT;