eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 2826: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type,

2822: PROCEDURE get_op_material_req
2823: (
2824: p_workorder_rec IN prd_workorder_rec,
2825: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
2826: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type,
2827: --sukhwsin::SB Effectivity - added return status paramter
2828: x_return_status OUT NOCOPY VARCHAR2
2829: )
2830: AS

Line 3075: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type

3071: PROCEDURE get_rt_material_req
3072: (
3073: p_workorder_rec IN prd_workorder_rec,
3074: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
3075: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type
3076: )
3077: AS
3078:
3079: -- For Getting the Material Requirements for a Route or Operation

Line 3735: x_material_tbl OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type

3731: p_wip_load_flag IN VARCHAR2 := 'Y', -- Change to N
3732: p_x_prd_workorder_rec IN OUT NOCOPY prd_workorder_rec,
3733: x_operation_tbl OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
3734: x_resource_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
3735: x_material_tbl OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type
3736: )
3737: AS
3738: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_JOB';
3739: l_api_version CONSTANT NUMBER := 1.0;

Line 4244: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );

4240: IF ( p_x_prd_workorder_rec.route_id IS NOT NULL OR
4241: NVL(l_is_stage_workorder, 'N') = 'Y' ) THEN
4242:
4243: IF ( G_DEBUG = 'Y' ) THEN
4244: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );
4245: END IF;
4246: --Code changes made by Srini
4247:
4248: AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials

Line 4248: AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials

4244: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );
4245: END IF;
4246: --Code changes made by Srini
4247:
4248: AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials
4249: (
4250: p_api_version => 1.0,
4251: p_init_msg_list => Fnd_Api.G_TRUE,
4252: p_commit => Fnd_Api.G_FALSE,

Line 4267: AHL_DEBUG_PUB.debug( l_api_name || ' - After AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );

4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;
4265:
4266: IF ( G_DEBUG = 'Y' ) THEN
4267: AHL_DEBUG_PUB.debug( l_api_name || ' - After AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );
4268: END IF;
4269:
4270: END IF;
4271:

Line 4394: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;

4390: l_return_status VARCHAR2(1);
4391: l_job_return_status VARCHAR2(1);
4392: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
4393: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
4394: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
4395: l_parent_workorder_rec prd_workorder_rec;
4396: l_parent_workoper_tbl prd_workoper_tbl;
4397: l_wo_status VARCHAR2(80);
4398: l_wo_status_code VARCHAR2(30);

Line 4588: L_MATERIAL_REQ_TBL AHL_PP_MATERIALS_PVT.REQ_MATERIAL_TBL_TYPE;

4584: l_workorder_name ahl_workorders.workorder_name%TYPE;
4585:
4586: L_X_PRD_WORKORDER_REC AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
4587: L_OPERATION_TBL AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
4588: L_MATERIAL_REQ_TBL AHL_PP_MATERIALS_PVT.REQ_MATERIAL_TBL_TYPE;
4589: L_RESOURCE_REQ_TBL AHL_PP_RESRC_REQUIRE_PVT.RESRC_REQUIRE_TBL_TYPE;
4590:
4591: -- Begin OGMA Issue # 105 - Balaji
4592: -- cursor for checking if given task is planned task created form forecasted UE.

Line 5459: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.create_material_reqst' );

5455: END IF;
5456: --sukhwsin::SB Effectivity - Code Changes for UOM Conversion -ends
5457:
5458: IF ( G_DEBUG = 'Y' ) THEN
5459: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.create_material_reqst' );
5460: END IF;
5461:
5462: IF ( l_material_tbl.COUNT > 0 ) THEN
5463: AHL_PP_MATERIALS_PVT.create_material_reqst

Line 5463: AHL_PP_MATERIALS_PVT.create_material_reqst

5459: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.create_material_reqst' );
5460: END IF;
5461:
5462: IF ( l_material_tbl.COUNT > 0 ) THEN
5463: AHL_PP_MATERIALS_PVT.create_material_reqst
5464: (
5465: p_api_version => 1.0,
5466: p_init_msg_list => FND_API.G_TRUE,
5467: p_commit => FND_API.G_FALSE,

Line 6292: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;

6288: l_mr_workorder_tbl prd_workorder_tbl;
6289: l_dummy_op_tbl prd_workoper_tbl;
6290: l_operation_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
6291: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6292: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
6293: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
6294: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
6295: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
6296: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 10937: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;

10933: );
10934:
10935: l_x_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
10936: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
10937: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
10938: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
10939:
10940: l_parent_wo_st_date DATE;
10941: l_parent_wo_end_date DATE;