APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_PP_RESRC_REQUIRE_PVT

Line 1688: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type

1684: PROCEDURE get_op_resource_req
1685: (
1686: p_workorder_rec IN prd_workorder_rec,
1687: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
1688: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
1689: )
1690: AS
1691:
1692: -- For Getting Resource Requirements defined for Operation

Line 1870: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type

1866: PROCEDURE get_rt_resource_req
1867: (
1868: p_workorder_rec IN prd_workorder_rec,
1869: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
1870: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
1871: )
1872: AS
1873:
1874: -- For Getting Resource Requirements defined for Route or Operation

Line 2825: x_resource_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,

2821: x_msg_data OUT NOCOPY VARCHAR2,
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';

Line 3175: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );

3171:
3172: IF ( x_resource_tbl.COUNT > 0 ) THEN
3173:
3174: IF ( G_DEBUG = 'Y' ) THEN
3175: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
3176: END IF;
3177:
3178: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
3179: (

Line 3178: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

3174: IF ( G_DEBUG = 'Y' ) THEN
3175: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
3176: END IF;
3177:
3178: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
3179: (
3180: p_api_version => 1.0,
3181: p_init_msg_list => FND_API.G_TRUE,
3182: p_commit => FND_API.G_FALSE,

Line 3348: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

3344: l_msg_data VARCHAR2(2000);
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);

Line 4002: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );

3998: p_x_resource_tbl => l_resource_tbl
3999: );
4000:
4001: IF ( G_DEBUG = 'Y' ) THEN
4002: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
4003: END IF;
4004:
4005: IF ( l_resource_tbl.COUNT > 0 ) THEN
4006: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

Line 4006: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

4002: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
4003: END IF;
4004:
4005: IF ( l_resource_tbl.COUNT > 0 ) THEN
4006: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
4007: (
4008: p_api_version => 1.0,
4009: p_init_msg_list => FND_API.G_TRUE,
4010: p_commit => FND_API.G_FALSE,

Line 4521: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

4517: l_msg_data VARCHAR2(2000);
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;