1: PACKAGE ahl_prd_mtltxn_pvt AUTHID CURRENT_USER AS
2: /*$Header: AHLVMTXS.pls 120.9.12020000.2 2012/12/07 00:50:22 sareepar ship $*/
3: G_AHL_SERVICEABLE_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE');
4: G_AHL_UNSERVICEABLE_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE');
5: G_AHL_MRB_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB');
6:
7: Type Ahl_Mtltxn_Rec_Type Is Record (
1: PACKAGE ahl_prd_mtltxn_pvt AUTHID CURRENT_USER AS
2: /*$Header: AHLVMTXS.pls 120.9.12020000.2 2012/12/07 00:50:22 sareepar ship $*/
3: G_AHL_SERVICEABLE_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE');
4: G_AHL_UNSERVICEABLE_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE');
5: G_AHL_MRB_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB');
6:
7: Type Ahl_Mtltxn_Rec_Type Is Record (
8: Ahl_mtltxn_Id NUMBER,
1: PACKAGE ahl_prd_mtltxn_pvt AUTHID CURRENT_USER AS
2: /*$Header: AHLVMTXS.pls 120.9.12020000.2 2012/12/07 00:50:22 sareepar ship $*/
3: G_AHL_SERVICEABLE_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE');
4: G_AHL_UNSERVICEABLE_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE');
5: G_AHL_MRB_CONDITION CONSTANT NUMBER := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB');
6:
7: Type Ahl_Mtltxn_Rec_Type Is Record (
8: Ahl_mtltxn_Id NUMBER,
9: Workorder_Id NUMBER,