APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_PRD_MTLTXN_PVT

Line 2781: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;

2777: p_module_type in Varchar2,
2778: X_Return_Status Out NOCOPY Varchar2)
2779: IS
2780: --
2781: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;
2782: x_ahl_mtl_txn_id_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtl_Txn_Id_tbl;
2783: l_inventory_item_id number;
2784: l_organization_id number;
2785: L_revision varchar2(3);

Line 2782: x_ahl_mtl_txn_id_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtl_Txn_Id_tbl;

2778: X_Return_Status Out NOCOPY Varchar2)
2779: IS
2780: --
2781: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;
2782: x_ahl_mtl_txn_id_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtl_Txn_Id_tbl;
2783: l_inventory_item_id number;
2784: l_organization_id number;
2785: L_revision varchar2(3);
2786: l_quantity number;

Line 2878: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN

2874:
2875: --l_mtl_txn_tbl(1).Qa_Collection_Id := p_x_parts_rec.collection_id;
2876: l_mtl_txn_tbl(1).Reason_Id := p_x_parts_rec.removal_reason_id;
2877:
2878: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN
2879: (p_api_version => 1.0,
2880: p_module_type => null,--sending null because I am calling it internally
2881: p_create_sr => 'N',
2882: p_x_ahl_mtltxn_tbl=> l_mtl_txn_tbl,

Line 3129: x_ahl_mtltxn_rec OUT NOCOPY AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type)

3125: p_disposition_id IN NUMBER,
3126: x_return_status OUT NOCOPY VARCHAR2,
3127: x_msg_data OUT NOCOPY VARCHAR2,
3128: x_msg_count OUT NOCOPY NUMBER,
3129: x_ahl_mtltxn_rec OUT NOCOPY AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type)
3130: IS
3131: -- FND Logging Constants
3132: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3133: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 3163: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;

3159: from FND_USER
3160: WHERE user_id = p_user_id;
3161:
3162:
3163: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;
3164: l_disp_Mtl_Txn_Tbl AHL_PRD_DISP_MTL_TXN_PVT.Disp_Mtl_Txn_Tbl_Type;
3165:
3166: l_disposition_rec ahl_disp_csr%ROWTYPE;
3167: l_employee_id number;

Line 3273: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN (p_api_version => 1.0,

3269: CLOSE get_employee_id;
3270:
3271: l_mtl_txn_tbl(1).recepient_id := l_employee_id;
3272:
3273: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN (p_api_version => 1.0,
3274: p_module_type => null,
3275: p_create_sr => 'N', -- servicable return txn.
3276: p_x_ahl_mtltxn_tbl=> l_mtl_txn_tbl,
3277: x_return_status => x_return_status,

Line 3287: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Return status:' || x_return_status

3283: fnd_log.string
3284: (
3285: l_debug_stmt,
3286: l_debug_module,
3287: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Return status:' || x_return_status
3288: );
3289: fnd_log.string
3290: (
3291: l_debug_stmt,

Line 3293: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Error count:' || x_msg_count

3289: fnd_log.string
3290: (
3291: l_debug_stmt,
3292: l_debug_module,
3293: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Error count:' || x_msg_count
3294: );
3295: END IF;
3296:
3297: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN