APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 2153: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type

2149: PROCEDURE get_op_material_req
2150: (
2151: p_workorder_rec IN prd_workorder_rec,
2152: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
2153: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type
2154: )
2155: AS
2156:
2157: -- For Getting the Material Requirements for an Operation

Line 2281: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type

2277: PROCEDURE get_rt_material_req
2278: (
2279: p_workorder_rec IN prd_workorder_rec,
2280: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
2281: p_x_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type
2282: )
2283: AS
2284:
2285: -- For Getting the Material Requirements for a Route or Operation

Line 2826: x_material_tbl OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type

2822: p_wip_load_flag IN VARCHAR2 := 'Y', -- Change to N
2823: p_x_prd_workorder_rec IN OUT NOCOPY prd_workorder_rec,
2824: x_operation_tbl OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
2825: x_resource_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
2826: x_material_tbl OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type
2827: )
2828: AS
2829: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_JOB';
2830: l_api_version CONSTANT NUMBER := 1.0;

Line 3203: AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials

3199: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_rt_material_req' );
3200: END IF;
3201: --Code changes made by Srini
3202:
3203: AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials
3204: (
3205: p_api_version => 1.0,
3206: p_init_msg_list => Fnd_Api.G_TRUE,
3207: p_commit => Fnd_Api.G_FALSE,

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

3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;
3220:
3221: IF ( G_DEBUG = 'Y' ) THEN
3222: AHL_DEBUG_PUB.debug( l_api_name || ' - After AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );
3223: END IF;
3224:
3225: END IF;
3226:

Line 3349: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;

3345: l_return_status VARCHAR2(1);
3346: l_job_return_status VARCHAR2(1);
3347: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
3348: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
3349: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
3350: l_parent_workorder_rec prd_workorder_rec;
3351: l_parent_workoper_tbl prd_workoper_tbl;
3352: l_wo_status VARCHAR2(80);
3353: l_wo_status_code VARCHAR2(30);

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

4035: p_x_material_tbl => l_material_tbl
4036: );
4037:
4038: IF ( G_DEBUG = 'Y' ) THEN
4039: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.create_material_reqst' );
4040: END IF;
4041:
4042: IF ( l_material_tbl.COUNT > 0 ) THEN
4043: AHL_PP_MATERIALS_PVT.create_material_reqst

Line 4043: AHL_PP_MATERIALS_PVT.create_material_reqst

4039: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.create_material_reqst' );
4040: END IF;
4041:
4042: IF ( l_material_tbl.COUNT > 0 ) THEN
4043: AHL_PP_MATERIALS_PVT.create_material_reqst
4044: (
4045: p_api_version => 1.0,
4046: p_init_msg_list => FND_API.G_TRUE,
4047: p_commit => FND_API.G_FALSE,

Line 4522: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;

4518: l_return_status VARCHAR2(1);
4519: l_dummy_op_tbl prd_workoper_tbl;
4520: l_operation_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
4521: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
4522: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
4523: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
4524: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
4525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
4526: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;