DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_PRD_OPERATIONS_PVT

Line 1857: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

1853:
1854: PROCEDURE get_op_resource_req
1855: (
1856: p_workorder_rec IN prd_workorder_rec,
1857: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
1858: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
1859: )
1860: AS
1861:

Line 2070: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

2066:
2067: PROCEDURE get_rt_resource_req
2068: (
2069: p_workorder_rec IN prd_workorder_rec,
2070: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
2071: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
2072: )
2073: AS
2074:

Line 2825: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

2821:
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: )

Line 3074: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

3070:
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:

Line 3466: p_x_operations_tbl IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl

3462:
3463: PROCEDURE get_operations
3464: (
3465: p_workorder_rec IN prd_workorder_rec,
3466: p_x_operations_tbl IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl
3467: )
3468: AS
3469: CURSOR get_route_operations(c_route_id NUMBER)
3470: IS

Line 3733: x_operation_tbl OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

3729: x_msg_count OUT NOCOPY NUMBER,
3730: x_msg_data OUT NOCOPY VARCHAR2,
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

Line 4169: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations . Total Operations : '|| x_operation_tbl.COUNT );

4165: p_x_operations_tbl => x_operation_tbl
4166: );
4167:
4168: IF ( G_DEBUG = 'Y' ) THEN
4169: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations . Total Operations : '|| x_operation_tbl.COUNT );
4170: END IF;
4171:
4172: AHL_PRD_OPERATIONS_PVT.process_operations
4173: (

Line 4172: AHL_PRD_OPERATIONS_PVT.process_operations

4168: IF ( G_DEBUG = 'Y' ) THEN
4169: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations . Total Operations : '|| x_operation_tbl.COUNT );
4170: END IF;
4171:
4172: AHL_PRD_OPERATIONS_PVT.process_operations
4173: (
4174: p_api_version => 1.0,
4175: p_init_msg_list => FND_API.G_TRUE,
4176: p_commit => FND_API.G_FALSE,

Line 4392: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;

4388: l_msg_count NUMBER;
4389: l_msg_data VARCHAR2(2000);
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;

Line 4587: L_OPERATION_TBL AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;

4583: l_resource_seq_num NUMBER;
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

Line 5351: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations' );

5347:
5348: END LOOP;
5349:
5350: IF ( G_DEBUG = 'Y' ) THEN
5351: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations' );
5352: END IF;
5353:
5354: AHL_PRD_OPERATIONS_PVT.process_operations
5355: (

Line 5354: AHL_PRD_OPERATIONS_PVT.process_operations

5350: IF ( G_DEBUG = 'Y' ) THEN
5351: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations' );
5352: END IF;
5353:
5354: AHL_PRD_OPERATIONS_PVT.process_operations
5355: (
5356: p_api_version =>1.0,
5357: p_init_msg_list =>FND_API.G_TRUE,
5358: p_commit =>FND_API.G_FALSE,

Line 6290: l_operation_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;

6286: l_msg_data VARCHAR2(2000);
6287: l_return_status VARCHAR2(1);
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;

Line 10938: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;

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;
10942: