DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_PRD_OPERATIONS_PVT

Line 1687: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

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

Line 1869: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

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

Line 2152: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

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

Line 2280: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

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

Line 2664: p_x_operations_tbl IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl

2660:
2661: PROCEDURE get_operations
2662: (
2663: p_workorder_rec IN prd_workorder_rec,
2664: p_x_operations_tbl IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl
2665: )
2666: AS
2667: CURSOR get_route_operations(c_route_id NUMBER)
2668: IS

Line 2824: x_operation_tbl OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,

2820: x_msg_count OUT NOCOPY NUMBER,
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

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

3133: p_x_operations_tbl => x_operation_tbl
3134: );
3135:
3136: IF ( G_DEBUG = 'Y' ) THEN
3137: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations . Total Operations : '|| x_operation_tbl.COUNT );
3138: END IF;
3139:
3140: AHL_PRD_OPERATIONS_PVT.process_operations
3141: (

Line 3140: AHL_PRD_OPERATIONS_PVT.process_operations

3136: IF ( G_DEBUG = 'Y' ) THEN
3137: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations . Total Operations : '|| x_operation_tbl.COUNT );
3138: END IF;
3139:
3140: AHL_PRD_OPERATIONS_PVT.process_operations
3141: (
3142: p_api_version => 1.0,
3143: p_init_msg_list => FND_API.G_TRUE,
3144: p_commit => FND_API.G_FALSE,

Line 3347: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;

3343: l_msg_count NUMBER;
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;

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

3961:
3962: END LOOP;
3963:
3964: IF ( G_DEBUG = 'Y' ) THEN
3965: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations' );
3966: END IF;
3967:
3968: AHL_PRD_OPERATIONS_PVT.process_operations
3969: (

Line 3968: AHL_PRD_OPERATIONS_PVT.process_operations

3964: IF ( G_DEBUG = 'Y' ) THEN
3965: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations' );
3966: END IF;
3967:
3968: AHL_PRD_OPERATIONS_PVT.process_operations
3969: (
3970: p_api_version =>1.0,
3971: p_init_msg_list =>FND_API.G_TRUE,
3972: p_commit =>FND_API.G_FALSE,

Line 4520: l_operation_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;

4516: l_msg_count NUMBER;
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;