DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on EAM_PROCESS_WO_PUB

Line 6293: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

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;
6297: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 6294: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

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;
6297: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
6298:

Line 6295: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

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;
6297: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
6298:
6299: l_wo_rel_rec_found BOOLEAN := FALSE;

Line 6296: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_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;
6297: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
6298:
6299: l_wo_rel_rec_found BOOLEAN := FALSE;
6300: total_mr_workorders NUMBER := 0;

Line 6297: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_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;
6297: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
6298:
6299: l_wo_rel_rec_found BOOLEAN := FALSE;
6300: total_mr_workorders NUMBER := 0;
6301: total_operations NUMBER := 0;

Line 8345: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

8341: l_wip_entity_id NUMBER;
8342: l_ue_wip_entity_id NUMBER;
8343: l_status_code VARCHAR2(30);
8344: l_status_meaning VARCHAR2(80);
8345: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
8346: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
8347: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
8348: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
8349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 8346: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

8342: l_ue_wip_entity_id NUMBER;
8343: l_status_code VARCHAR2(30);
8344: l_status_meaning VARCHAR2(80);
8345: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
8346: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
8347: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
8348: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
8349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
8350: l_rel_found BOOLEAN := FALSE;

Line 8347: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

8343: l_status_code VARCHAR2(30);
8344: l_status_meaning VARCHAR2(80);
8345: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
8346: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
8347: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
8348: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
8349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
8350: l_rel_found BOOLEAN := FALSE;
8351:

Line 8348: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

8344: l_status_meaning VARCHAR2(80);
8345: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
8346: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
8347: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
8348: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
8349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
8350: l_rel_found BOOLEAN := FALSE;
8351:
8352: l_wo_id NUMBER;

Line 8349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

8345: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
8346: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
8347: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
8348: l_eam_res_req_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
8349: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
8350: l_rel_found BOOLEAN := FALSE;
8351:
8352: l_wo_id NUMBER;
8353: l_ovn NUMBER;