APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 3863: Material_Tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type ;

3859: x_msg_count OUT NOCOPY NUMBER,
3860: x_msg_data OUT NOCOPY VARCHAR2,
3861: x_ahl_sch_mtl_id OUT NOCOPY NUMBER)
3862: IS
3863: Material_Tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type ;
3864: x_tmp VARCHAR2(10);
3865: l_project_id NUMBER;
3866: l_project_Task_id NUMBER ;
3867: l_Visit_Id NUMBER;

Line 3881: -- Item description is not used in procedure AHL_PP_MATERIALS_PVT.Create_Material_Reqst.

3877: WHERE A.WORKORDER_ID = p_wo_id
3878: AND A.VISIT_TASK_ID = C.VISIT_TASK_ID
3879: AND C.VISIT_ID = B.VISIT_ID;
3880: -- Bug # 9373684 (FP for Bug # 9248655) -- start
3881: -- Item description is not used in procedure AHL_PP_MATERIALS_PVT.Create_Material_Reqst.
3882: /*
3883: --Query to select the item desccription
3884: CURSOR Item_Desc_Cur(p_org_id NUMBER, p_item_id NUMBER) IS
3885: SELECT DESCRIPTION

Line 3976: -- Item description is not used in procedure AHL_PP_MATERIALS_PVT.Create_Material_Reqst.

3972: --Material_Tbl(0).PROGRAM_ID :=
3973: --Material_Tbl(0).PROGRAM_UPDATE_DATE :=
3974: --Material_Tbl(0).LAST_UPDATED_DATE := SYSDATE;
3975: -- Bug # 9373684 (FP for Bug # 9248655) -- start
3976: -- Item description is not used in procedure AHL_PP_MATERIALS_PVT.Create_Material_Reqst.
3977: --Material_Tbl(0).DESCRIPTION := l_Item_Desc;
3978: -- Bug # 9373684 (FP for Bug # 9248655) -- end
3979: --Material_Tbl(0).DEPARTMENT_ID :=
3980: Material_Tbl(0).PROJECT_TASK_ID := l_project_Task_id;

Line 3986: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');

3982: --Material_Tbl(0).Req_Material_Rec_Type :=
3983:
3984:
3985: IF G_DEBUG='Y' THEN
3986: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');
3987:
3988: END IF;
3989: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,
3990: p_x_req_material_tbl => Material_Tbl,

Line 3989: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,

3985: IF G_DEBUG='Y' THEN
3986: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');
3987:
3988: END IF;
3989: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,
3990: p_x_req_material_tbl => Material_Tbl,
3991: --p_interface_flag => 'N',
3992: p_interface_flag => NULL,
3993: x_job_return_status => x_tmp,

Line 3998: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');

3994: x_return_status => x_return_status,
3995: x_msg_count => x_msg_count,
3996: x_msg_data => x_msg_data);
3997: IF G_DEBUG='Y' THEN
3998: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
3999:
4000: END IF;
4001: IF G_DEBUG='Y' THEN
4002: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');

Line 6007: AHL_PP_MATERIALS_PVT.GET_NET_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) Net_Total_Qty,

6003: MTL.DESCRIPTION,
6004: TXNS.SERIAL_NUMBER ,
6005: AHL_PRD_MTLTXN_PVT.GET_ISSUED_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) ISSUEQTY,
6006: -- JKJAIN FP ER # 6436303 - start
6007: AHL_PP_MATERIALS_PVT.GET_NET_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) Net_Total_Qty,
6008: -- JKJAIN FP ER # 6436303 - end
6009: TXNS.UOM,
6010: UOM.UNIT_OF_MEASURE,
6011: TXNS.RECEPIENT_ID,