1: PACKAGE ahl_prd_mtltxn_pvt AS
2: /*$Header: AHLVMTXS.pls 120.4.12010000.4 2008/11/26 11:28:43 jkjain 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 AS
2: /*$Header: AHLVMTXS.pls 120.4.12010000.4 2008/11/26 11:28:43 jkjain 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 AS
2: /*$Header: AHLVMTXS.pls 120.4.12010000.4 2008/11/26 11:28:43 jkjain 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,