APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_PRD_MTLTXN_PVT

Line 2724: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;

2720: p_module_type in Varchar2,
2721: X_Return_Status Out NOCOPY Varchar2)
2722: IS
2723: --
2724: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;
2725: x_ahl_mtl_txn_id_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtl_Txn_Id_tbl;
2726: l_inventory_item_id number;
2727: l_organization_id number;
2728: L_revision varchar2(3);

Line 2725: x_ahl_mtl_txn_id_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtl_Txn_Id_tbl;

2721: X_Return_Status Out NOCOPY Varchar2)
2722: IS
2723: --
2724: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;
2725: x_ahl_mtl_txn_id_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtl_Txn_Id_tbl;
2726: l_inventory_item_id number;
2727: l_organization_id number;
2728: L_revision varchar2(3);
2729: l_quantity number;

Line 2821: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN

2817:
2818: --l_mtl_txn_tbl(1).Qa_Collection_Id := p_x_parts_rec.collection_id;
2819: l_mtl_txn_tbl(1).Reason_Id := p_x_parts_rec.removal_reason_id;
2820:
2821: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN
2822: (p_api_version => 1.0,
2823: p_module_type => null,--sending null because I am calling it internally
2824: p_create_sr => 'N',
2825: p_x_ahl_mtltxn_tbl=> l_mtl_txn_tbl,

Line 3072: x_ahl_mtltxn_rec OUT NOCOPY AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type)

3068: p_disposition_id IN NUMBER,
3069: x_return_status OUT NOCOPY VARCHAR2,
3070: x_msg_data OUT NOCOPY VARCHAR2,
3071: x_msg_count OUT NOCOPY NUMBER,
3072: x_ahl_mtltxn_rec OUT NOCOPY AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type)
3073: IS
3074: -- FND Logging Constants
3075: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3076: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 3106: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;

3102: from FND_USER
3103: WHERE user_id = p_user_id;
3104:
3105:
3106: l_mtl_txn_tbl AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Tbl_Type;
3107: l_disp_Mtl_Txn_Tbl AHL_PRD_DISP_MTL_TXN_PVT.Disp_Mtl_Txn_Tbl_Type;
3108:
3109: l_disposition_rec ahl_disp_csr%ROWTYPE;
3110: l_employee_id number;

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

3212: CLOSE get_employee_id;
3213:
3214: l_mtl_txn_tbl(1).recepient_id := l_employee_id;
3215:
3216: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN (p_api_version => 1.0,
3217: p_module_type => null,
3218: p_create_sr => 'N', -- servicable return txn.
3219: p_x_ahl_mtltxn_tbl=> l_mtl_txn_tbl,
3220: x_return_status => x_return_status,

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

3226: fnd_log.string
3227: (
3228: l_debug_stmt,
3229: l_debug_module,
3230: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Return status:' || x_return_status
3231: );
3232: fnd_log.string
3233: (
3234: l_debug_stmt,

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

3232: fnd_log.string
3233: (
3234: l_debug_stmt,
3235: l_debug_module,
3236: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Error count:' || x_msg_count
3237: );
3238: END IF;
3239:
3240: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN