eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_PROCESS_WO_PUB

Line 1275: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1271: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1272: , x_return_status OUT NOCOPY VARCHAR2
1273: )
1274: IS
1275: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1276: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1276: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1272: , x_return_status OUT NOCOPY VARCHAR2
1273: )
1274: IS
1275: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1276: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1273: )
1274: IS
1275: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1276: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1274: IS
1275: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1276: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1275: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1276: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1283:

Line 1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1276: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1283:
1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1277: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1283:
1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1278: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1279: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1283:
1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1280: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1283:
1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1281: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1283:
1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1282: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1283:
1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1283:
1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1291: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1284: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1291: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1292:

Line 1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1285: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1291: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1292:
1293: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1286: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1291: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1292:
1293: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1294: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;

Line 1291: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1287: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1288: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1289: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1291: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1292:
1293: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1294: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1295:

Line 1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type

1452: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
1453: p_estimate_id IN NUMBER
1454: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1455: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

Line 1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type

1453: p_estimate_id IN NUMBER
1454: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1455: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

Line 1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type

1454: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1455: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1462: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

Line 1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

1455: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1462: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1463: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

Line 1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1462: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1463: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1464: , x_return_status OUT NOCOPY VARCHAR2)

Line 1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1462: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1463: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1464: , x_return_status OUT NOCOPY VARCHAR2)
1465: IS

Line 1462: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1462: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1463: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1464: , x_return_status OUT NOCOPY VARCHAR2)
1465: IS
1466:

Line 1750: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type

1746: x_return_status := 'E';
1747: debug('In to Others exception in POPULATE_CE_WORK_ORDER_LINES');
1748: END POPULATE_CE_WORK_ORDER_LINES;
1749:
1750: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1751: IS
1752: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1753: BEGIN
1754: RETURN l_eam_op_tbl;

Line 1752: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1748: END POPULATE_CE_WORK_ORDER_LINES;
1749:
1750: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1751: IS
1752: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1753: BEGIN
1754: RETURN l_eam_op_tbl;
1755: END INIT_EAM_OP_TBL_TYPE;
1756:

Line 1757: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type

1753: BEGIN
1754: RETURN l_eam_op_tbl;
1755: END INIT_EAM_OP_TBL_TYPE;
1756:
1757: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1758: IS
1759: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1760: BEGIN
1761: RETURN l_eam_op_network_tbl;

Line 1759: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1755: END INIT_EAM_OP_TBL_TYPE;
1756:
1757: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1758: IS
1759: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1760: BEGIN
1761: RETURN l_eam_op_network_tbl;
1762: END INIT_EAM_OP_NTK_TBL_TYPE;
1763:

Line 1764: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type

1760: BEGIN
1761: RETURN l_eam_op_network_tbl;
1762: END INIT_EAM_OP_NTK_TBL_TYPE;
1763:
1764: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1765: IS
1766: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1767: BEGIN
1768: RETURN l_eam_res_tbl;

Line 1766: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1762: END INIT_EAM_OP_NTK_TBL_TYPE;
1763:
1764: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1765: IS
1766: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1767: BEGIN
1768: RETURN l_eam_res_tbl;
1769: END INIT_EAM_RES_TBL_TYPE;
1770:

Line 1771: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

1767: BEGIN
1768: RETURN l_eam_res_tbl;
1769: END INIT_EAM_RES_TBL_TYPE;
1770:
1771: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1772: IS
1773: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1774: BEGIN
1775: RETURN l_eam_res_inst_tbl;

Line 1773: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1769: END INIT_EAM_RES_TBL_TYPE;
1770:
1771: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1772: IS
1773: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1774: BEGIN
1775: RETURN l_eam_res_inst_tbl;
1776: END INIT_EAM_RES_INST_TBL_TYPE;
1777:

Line 1778: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

1774: BEGIN
1775: RETURN l_eam_res_inst_tbl;
1776: END INIT_EAM_RES_INST_TBL_TYPE;
1777:
1778: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1779: IS
1780: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1781: BEGIN
1782: RETURN l_eam_sub_res_tbl;

Line 1780: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1776: END INIT_EAM_RES_INST_TBL_TYPE;
1777:
1778: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1779: IS
1780: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1781: BEGIN
1782: RETURN l_eam_sub_res_tbl;
1783: END INIT_EAM_SUB_RES_TBL_TYPE;
1784:

Line 1785: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

1781: BEGIN
1782: RETURN l_eam_sub_res_tbl;
1783: END INIT_EAM_SUB_RES_TBL_TYPE;
1784:
1785: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1786: IS
1787: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1788: BEGIN
1789: RETURN l_eam_res_usage_tbl;

Line 1787: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1783: END INIT_EAM_SUB_RES_TBL_TYPE;
1784:
1785: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1786: IS
1787: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1788: BEGIN
1789: RETURN l_eam_res_usage_tbl;
1790: END INIT_EAM_RES_USG_TBL_TYPE;
1791:

Line 1792: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

1788: BEGIN
1789: RETURN l_eam_res_usage_tbl;
1790: END INIT_EAM_RES_USG_TBL_TYPE;
1791:
1792: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1793: IS
1794: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1795: BEGIN
1796: RETURN l_eam_mat_req_tbl;

Line 1794: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1790: END INIT_EAM_RES_USG_TBL_TYPE;
1791:
1792: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1793: IS
1794: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1795: BEGIN
1796: RETURN l_eam_mat_req_tbl;
1797: END INIT_EAM_MAT_REQ_TBL_TYPE;
1798:

Line 3516: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3512: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3513: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
3514: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3515:
3516: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3517: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

Line 3517: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3513: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
3514: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3515:
3516: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3517: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;

Line 3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3514: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3515:
3516: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3517: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

Line 3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

3515:
3516: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3517: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

Line 3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

3516: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3517: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3524:

Line 3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;

3517: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3524:
3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

3518: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3524:
3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

3519: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3520: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3524:
3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3521: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3524:
3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

3522: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3524:
3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

3523: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3524:
3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

3524:
3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

3525: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

3526: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

3527: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

3528: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3529: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

3530: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

3531: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

3532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

3533: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

3534: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3542:

Line 3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

3535: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3542:
3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3536: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3542:
3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

3537: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3538: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3542:
3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3539: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3542:
3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3546:
3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3540: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3542:
3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3546:
3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3541: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3542:
3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3546:
3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3543: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3546:
3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3544: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3546:
3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3545: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3546:
3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3546:
3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3547: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3548: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3549: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3550: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3551: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3552: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3553: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3554: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3555: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3556: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3557: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3565: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3558: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3565: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3566: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3559: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3565: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3566: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3567: l_wip_entity_id NUMBER;

Line 3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3560: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3565: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3566: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3567: l_wip_entity_id NUMBER;
3568: l_wip_entity_name VARCHAR2(240);

Line 3565: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3561: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3565: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3566: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3567: l_wip_entity_id NUMBER;
3568: l_wip_entity_name VARCHAR2(240);
3569:

Line 3566: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3562: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3563: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3564: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3565: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3566: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3567: l_wip_entity_id NUMBER;
3568: l_wip_entity_name VARCHAR2(240);
3569:
3570: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 3570: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

3566: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3567: l_wip_entity_id NUMBER;
3568: l_wip_entity_name VARCHAR2(240);
3569:
3570: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3571: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3572: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3574:

Line 3571: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

3567: l_wip_entity_id NUMBER;
3568: l_wip_entity_name VARCHAR2(240);
3569:
3570: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3571: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3572: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3574:
3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 3572: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

3568: l_wip_entity_name VARCHAR2(240);
3569:
3570: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3571: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3572: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3574:
3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;

3569:
3570: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3571: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3572: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3574:
3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3577: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3571: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3572: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3574:
3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3577: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3578:
3579: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3572: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3574:
3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3577: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3578:
3579: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3580: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3577: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3573: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3574:
3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3577: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3578:
3579: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3580: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3581:

Line 3579: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3575: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3577: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3578:
3579: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3580: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3581:
3582: CURSOR c_ecwl IS
3583: SELECT *

Line 3580: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3576: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3577: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3578:
3579: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3580: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3581:
3582: CURSOR c_ecwl IS
3583: SELECT *
3584: FROM EAM_CE_WORK_ORDER_LINES

Line 3858: EAM_PROCESS_WO_PUB.Process_Master_Child_WO

3854: END IF;
3855:
3856: l_eam_wo_tbl(1) := l_eam_wo_rec;
3857: --dbms_output.put_line('Calling WO API for parent');
3858: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
3859: ( p_bo_identifier => 'EAM'
3860: , p_init_msg_list => TRUE
3861: , p_api_version_number => 1.0
3862: , p_eam_wo_tbl => l_eam_wo_tbl

Line 4011: l_eam_relation_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

4007: l_eam_relation_rec.child_object_type_id := 1;
4008: l_eam_relation_rec.child_header_id :=wo;
4009: l_eam_relation_rec.child_object_id :=wo;
4010: l_eam_relation_rec.parent_relationship_type := 1;
4011: l_eam_relation_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4012:
4013: l_eam_wo_relations_tbl(wo) := l_eam_relation_rec;
4014:
4015: END IF;

Line 4166: EAM_PROCESS_WO_PUB.Process_Master_Child_WO

4162: --dbms_output.put_line('l_eam_wo_tbl(1).name...' || l_eam_wo_tbl(1).wip_entity_name);
4163: --dbms_output.put_line('l_eam_wo_tbl(2).name...' || l_eam_wo_tbl(2).wip_entity_name);
4164: --dbms_output.put_line('l_eam_op_tbl(1).header...' || l_eam_op_tbl(1).header_id);
4165: --dbms_output.put_line('l_eam_op_tbl(2).header...' || l_eam_op_tbl(2).header_id);*/
4166: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
4167: ( p_bo_identifier => 'EAM'
4168: , p_init_msg_list => TRUE
4169: , p_api_version_number => 1.0
4170: , p_eam_wo_tbl => l_eam_wo_tbl

Line 4297: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

4293: procedure populate_WO(
4294: p_parent_wo IN NUMBER
4295: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4296: , p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4297: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
4298: , x_return_status OUT NOCOPY VARCHAR2
4299: , x_msg_count OUT NOCOPY NUMBER
4300: , x_msg_data OUT NOCOPY VARCHAR2
4301: ) IS

Line 4303: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

4299: , x_msg_count OUT NOCOPY NUMBER
4300: , x_msg_data OUT NOCOPY VARCHAR2
4301: ) IS
4302:
4303: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
4304: l_stmt_num NUMBER := 0;
4305: l_string VARCHAR2(2000);
4306: l_item_id NUMBER;
4307: l_eam_item NUMBER;

Line 4465: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type

4461:
4462: procedure POPULATE_OPERATION(
4463: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4464: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4465: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type
4466: , x_return_status OUT NOCOPY VARCHAR2
4467: , x_msg_count OUT NOCOPY NUMBER
4468: , x_msg_data OUT NOCOPY VARCHAR2
4469: ) IS

Line 4471: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

4467: , x_msg_count OUT NOCOPY NUMBER
4468: , x_msg_data OUT NOCOPY VARCHAR2
4469: ) IS
4470:
4471: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
4472: l_stmt_num NUMBER := 0;
4473: BEGIN
4474:
4475: IF fnd_api.to_Boolean(p_init_msg_list) then

Line 4492: l_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

4488: l_eam_op_rec.description := p_ce_line_rec.op_description;
4489: l_eam_op_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4490: l_eam_op_rec.completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);
4491: l_eam_op_rec.long_description := p_ce_line_rec.op_long_description;
4492: l_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4493:
4494:
4495:
4496: x_eam_op_rec := l_eam_op_rec;

Line 4549: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type

4545:
4546: procedure POPULATE_RESOURCE(
4547: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4548: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4549: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type
4550: , x_return_status OUT NOCOPY VARCHAR2
4551: , x_msg_count OUT NOCOPY NUMBER
4552: , x_msg_data OUT NOCOPY VARCHAR2
4553: ) IS

Line 4555: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;

4551: , x_msg_count OUT NOCOPY NUMBER
4552: , x_msg_data OUT NOCOPY VARCHAR2
4553: ) IS
4554:
4555: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
4556: l_stmt_num NUMBER := 0;
4557: l_autocharge NUMBER;
4558: BEGIN
4559:

Line 4580: l_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

4576: l_eam_res_rec.usage_rate_or_amount := p_ce_line_rec.required_quantity;
4577: l_eam_res_rec.assigned_units := nvl(p_ce_line_rec.res_assigned_units,1);
4578: l_eam_res_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4579: l_eam_res_rec.completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);
4580: l_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4581:
4582: /* Get Charge Type: Ideally this should be copied into the CE table as part of the Activity explosion -
4583: but since the charge type was not included in the data model, deriving it here. In future this may be
4584: a good ebhancement */

Line 4658: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

4654:
4655: procedure POPULATE_MATERIAL(
4656: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4657: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4658: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
4659: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
4660: , x_return_status OUT NOCOPY VARCHAR2
4661: , x_msg_count OUT NOCOPY NUMBER
4662: , x_msg_data OUT NOCOPY VARCHAR2

Line 4659: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type

4655: procedure POPULATE_MATERIAL(
4656: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4657: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4658: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
4659: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
4660: , x_return_status OUT NOCOPY VARCHAR2
4661: , x_msg_count OUT NOCOPY NUMBER
4662: , x_msg_data OUT NOCOPY VARCHAR2
4663: ) IS

Line 4665: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

4661: , x_msg_count OUT NOCOPY NUMBER
4662: , x_msg_data OUT NOCOPY VARCHAR2
4663: ) IS
4664:
4665: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
4666: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
4667: l_stmt_num NUMBER := 0;
4668: BEGIN
4669:

Line 4666: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

4662: , x_msg_data OUT NOCOPY VARCHAR2
4663: ) IS
4664:
4665: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
4666: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
4667: l_stmt_num NUMBER := 0;
4668: BEGIN
4669:
4670: IF fnd_api.to_Boolean(p_init_msg_list) then

Line 4694: l_eam_mat_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

4690: l_eam_mat_rec.comments := p_ce_line_rec.item_comments;
4691: l_eam_mat_rec.SUGGESTED_VENDOR_NAME := p_ce_line_rec.SUGGESTED_VENDOR_NAME;
4692: l_eam_mat_rec.vendor_id := p_ce_line_rec.suggested_vendor_id;
4693: --l_eam_mat_rec.unit_price := p_ce_line_rec.item_comments;
4694: l_eam_mat_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4695:
4696: ELSE
4697: l_eam_direct_rec.organization_id := p_ce_line_rec.organization_id;
4698: l_eam_direct_rec.description := p_ce_line_rec.di_description;

Line 4711: l_eam_direct_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

4707: --l_eam_direct_rec.unit_price := p_ce_line_rec.SUGGESTED_VENDOR_ID;
4708: l_eam_direct_rec.required_quantity := p_ce_line_rec.required_quantity;
4709: --l_eam_direct_rec.uom := p_ce_line_rec.SUGGESTED_VENDOR_SITE;
4710: l_eam_direct_rec.need_by_date := p_ce_line_rec.di_need_by_date;
4711: l_eam_direct_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4712:
4713: END IF; --stockable or non-stockable item
4714:
4715: