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 1361: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1357: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1358: , x_return_status OUT NOCOPY VARCHAR2
1359: )
1360: IS
1361: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1362: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1362: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1358: , x_return_status OUT NOCOPY VARCHAR2
1359: )
1360: IS
1361: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1362: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1359: )
1360: IS
1361: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1362: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1360: IS
1361: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1362: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1361: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1362: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1369:

Line 1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1362: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1369:
1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1363: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1369:
1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1364: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1365: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1369:
1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1366: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1369:
1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1367: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1369:
1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1368: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1369:
1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1369:
1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1377: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1370: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1377: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1378:

Line 1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1371: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1377: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1378:
1379: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1372: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1377: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1378:
1379: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1380: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;

Line 1377: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1373: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1374: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1375: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1377: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1378:
1379: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1380: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1381:

Line 1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type

1557: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
1558: p_estimate_id IN NUMBER
1559: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1560: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

Line 1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type

1558: p_estimate_id IN NUMBER
1559: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1560: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

Line 1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type

1559: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1560: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1567: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

Line 1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

1560: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1567: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1568: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

Line 1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1567: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1568: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1569: , x_return_status OUT NOCOPY VARCHAR2)

Line 1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1567: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1568: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1569: , x_return_status OUT NOCOPY VARCHAR2)
1570: IS

Line 1567: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1567: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1568: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1569: , x_return_status OUT NOCOPY VARCHAR2)
1570: IS
1571:

Line 1885: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type

1881: x_return_status := 'E';
1882: debug('In to Others exception in POPULATE_CE_WORK_ORDER_LINES');
1883: END POPULATE_CE_WORK_ORDER_LINES;
1884:
1885: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1886: IS
1887: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1888: BEGIN
1889: RETURN l_eam_op_tbl;

Line 1887: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1883: END POPULATE_CE_WORK_ORDER_LINES;
1884:
1885: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1886: IS
1887: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1888: BEGIN
1889: RETURN l_eam_op_tbl;
1890: END INIT_EAM_OP_TBL_TYPE;
1891:

Line 1892: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type

1888: BEGIN
1889: RETURN l_eam_op_tbl;
1890: END INIT_EAM_OP_TBL_TYPE;
1891:
1892: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1893: IS
1894: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1895: BEGIN
1896: RETURN l_eam_op_network_tbl;

Line 1894: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1890: END INIT_EAM_OP_TBL_TYPE;
1891:
1892: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1893: IS
1894: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1895: BEGIN
1896: RETURN l_eam_op_network_tbl;
1897: END INIT_EAM_OP_NTK_TBL_TYPE;
1898:

Line 1899: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type

1895: BEGIN
1896: RETURN l_eam_op_network_tbl;
1897: END INIT_EAM_OP_NTK_TBL_TYPE;
1898:
1899: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1900: IS
1901: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1902: BEGIN
1903: RETURN l_eam_res_tbl;

Line 1901: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1897: END INIT_EAM_OP_NTK_TBL_TYPE;
1898:
1899: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1900: IS
1901: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1902: BEGIN
1903: RETURN l_eam_res_tbl;
1904: END INIT_EAM_RES_TBL_TYPE;
1905:

Line 1906: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

1902: BEGIN
1903: RETURN l_eam_res_tbl;
1904: END INIT_EAM_RES_TBL_TYPE;
1905:
1906: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1907: IS
1908: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1909: BEGIN
1910: RETURN l_eam_res_inst_tbl;

Line 1908: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1904: END INIT_EAM_RES_TBL_TYPE;
1905:
1906: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1907: IS
1908: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1909: BEGIN
1910: RETURN l_eam_res_inst_tbl;
1911: END INIT_EAM_RES_INST_TBL_TYPE;
1912:

Line 1913: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

1909: BEGIN
1910: RETURN l_eam_res_inst_tbl;
1911: END INIT_EAM_RES_INST_TBL_TYPE;
1912:
1913: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1914: IS
1915: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1916: BEGIN
1917: RETURN l_eam_sub_res_tbl;

Line 1915: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1911: END INIT_EAM_RES_INST_TBL_TYPE;
1912:
1913: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1914: IS
1915: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1916: BEGIN
1917: RETURN l_eam_sub_res_tbl;
1918: END INIT_EAM_SUB_RES_TBL_TYPE;
1919:

Line 1920: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

1916: BEGIN
1917: RETURN l_eam_sub_res_tbl;
1918: END INIT_EAM_SUB_RES_TBL_TYPE;
1919:
1920: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1921: IS
1922: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1923: BEGIN
1924: RETURN l_eam_res_usage_tbl;

Line 1922: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1918: END INIT_EAM_SUB_RES_TBL_TYPE;
1919:
1920: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1921: IS
1922: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1923: BEGIN
1924: RETURN l_eam_res_usage_tbl;
1925: END INIT_EAM_RES_USG_TBL_TYPE;
1926:

Line 1927: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

1923: BEGIN
1924: RETURN l_eam_res_usage_tbl;
1925: END INIT_EAM_RES_USG_TBL_TYPE;
1926:
1927: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1928: IS
1929: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1930: BEGIN
1931: RETURN l_eam_mat_req_tbl;

Line 1929: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1925: END INIT_EAM_RES_USG_TBL_TYPE;
1926:
1927: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1928: IS
1929: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1930: BEGIN
1931: RETURN l_eam_mat_req_tbl;
1932: END INIT_EAM_MAT_REQ_TBL_TYPE;
1933:

Line 3695: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3691: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3692: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
3693: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3694:
3695: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3696: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

Line 3696: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3692: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
3693: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3694:
3695: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3696: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;

Line 3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3693: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3694:
3695: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3696: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

Line 3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

3694:
3695: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3696: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

Line 3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

3695: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3696: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3703:

Line 3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;

3696: l_eam_empty_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3703:
3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

3697: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3703:
3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

3698: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3699: l_eam_empty_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3703:
3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3700: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3703:
3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

3701: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3703:
3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

3702: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
3703:
3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

3703:
3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

3704: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

3705: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

3706: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

3707: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3708: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

3709: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

3710: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

3711: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

3712: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

3713: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3721:

Line 3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

3714: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3721:
3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3715: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3721:
3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

3716: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3717: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3721:
3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3718: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3721:
3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3725:
3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3719: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3721:
3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3725:
3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3720: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3721:
3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3725:
3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3722: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3725:
3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3723: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3725:
3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3724: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3725:
3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3725:
3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3726: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3727: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3729: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3730: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3731: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3732: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3733: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3734: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3735: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3736: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3744: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3737: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3744: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3745: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3738: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3744: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3745: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3746: l_wip_entity_id NUMBER;

Line 3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3739: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3744: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3745: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3746: l_wip_entity_id NUMBER;
3747: l_wip_entity_name VARCHAR2(240);

Line 3744: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3740: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3744: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3745: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3746: l_wip_entity_id NUMBER;
3747: l_wip_entity_name VARCHAR2(240);
3748:

Line 3745: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3741: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3742: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3743: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3744: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3745: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3746: l_wip_entity_id NUMBER;
3747: l_wip_entity_name VARCHAR2(240);
3748:
3749: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 3749: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

3745: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3746: l_wip_entity_id NUMBER;
3747: l_wip_entity_name VARCHAR2(240);
3748:
3749: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3750: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3751: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3753:

Line 3750: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

3746: l_wip_entity_id NUMBER;
3747: l_wip_entity_name VARCHAR2(240);
3748:
3749: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3750: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3751: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3753:
3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 3751: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

3747: l_wip_entity_name VARCHAR2(240);
3748:
3749: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3750: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3751: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3753:
3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;

3748:
3749: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3750: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3751: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3753:
3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3756: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3750: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3751: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3753:
3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3756: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3757:
3758: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3751: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3753:
3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3756: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3757:
3758: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3759: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3756: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

3752: l_eam_relation_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3753:
3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3756: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3757:
3758: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3759: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3760:

Line 3758: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3754: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3756: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3757:
3758: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3759: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3760:
3761: CURSOR c_ecwl IS
3762: SELECT *

Line 3759: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3755: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3756: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3757:
3758: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3759: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3760:
3761: CURSOR c_ecwl IS
3762: SELECT *
3763: FROM EAM_CE_WORK_ORDER_LINES

Line 4037: EAM_PROCESS_WO_PUB.Process_Master_Child_WO

4033: END IF;
4034:
4035: l_eam_wo_tbl(1) := l_eam_wo_rec;
4036: --dbms_output.put_line('Calling WO API for parent');
4037: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
4038: ( p_bo_identifier => 'EAM'
4039: , p_init_msg_list => TRUE
4040: , p_api_version_number => 1.0
4041: , p_eam_wo_tbl => l_eam_wo_tbl

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

4188: l_eam_relation_rec.child_object_type_id := 1;
4189: l_eam_relation_rec.child_header_id :=wo;
4190: l_eam_relation_rec.child_object_id :=wo;
4191: l_eam_relation_rec.parent_relationship_type := 1;
4192: l_eam_relation_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4193:
4194: l_eam_wo_relations_tbl(wo) := l_eam_relation_rec;
4195:
4196: END IF;

Line 4350: EAM_PROCESS_WO_PUB.Process_Master_Child_WO

4346: --dbms_output.put_line('l_eam_op_tbl(2).header...' || l_eam_op_tbl(2).header_id);*/
4347: l_stmt_num := 400;
4348: IF l_eam_wo_tbl.count > 0 THEN
4349: l_stmt_num := 401;
4350: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
4351: ( p_bo_identifier => 'EAM'
4352: , p_init_msg_list => TRUE
4353: , p_api_version_number => 1.0
4354: , p_eam_wo_tbl => l_eam_wo_tbl

Line 4483: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

4479: procedure populate_WO(
4480: p_parent_wo IN NUMBER
4481: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4482: , p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4483: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
4484: , x_return_status OUT NOCOPY VARCHAR2
4485: , x_msg_count OUT NOCOPY NUMBER
4486: , x_msg_data OUT NOCOPY VARCHAR2
4487: ) IS

Line 4489: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

4485: , x_msg_count OUT NOCOPY NUMBER
4486: , x_msg_data OUT NOCOPY VARCHAR2
4487: ) IS
4488:
4489: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
4490: l_stmt_num NUMBER := 0;
4491: l_string VARCHAR2(2000);
4492: l_item_id NUMBER;
4493: l_eam_item NUMBER;

Line 4652: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type

4648:
4649: procedure POPULATE_OPERATION(
4650: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4651: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4652: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type
4653: , x_return_status OUT NOCOPY VARCHAR2
4654: , x_msg_count OUT NOCOPY NUMBER
4655: , x_msg_data OUT NOCOPY VARCHAR2
4656: ) IS

Line 4658: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

4654: , x_msg_count OUT NOCOPY NUMBER
4655: , x_msg_data OUT NOCOPY VARCHAR2
4656: ) IS
4657:
4658: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
4659: l_stmt_num NUMBER := 0;
4660: BEGIN
4661:
4662: IF fnd_api.to_Boolean(p_init_msg_list) then

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

4675: l_eam_op_rec.description := p_ce_line_rec.op_description;
4676: l_eam_op_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4677: l_eam_op_rec.completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);
4678: l_eam_op_rec.long_description := p_ce_line_rec.op_long_description;
4679: l_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4680:
4681:
4682:
4683: x_eam_op_rec := l_eam_op_rec;

Line 4736: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type

4732:
4733: procedure POPULATE_RESOURCE(
4734: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4735: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4736: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type
4737: , x_return_status OUT NOCOPY VARCHAR2
4738: , x_msg_count OUT NOCOPY NUMBER
4739: , x_msg_data OUT NOCOPY VARCHAR2
4740: ) IS

Line 4742: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;

4738: , x_msg_count OUT NOCOPY NUMBER
4739: , x_msg_data OUT NOCOPY VARCHAR2
4740: ) IS
4741:
4742: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
4743: l_stmt_num NUMBER := 0;
4744: l_autocharge NUMBER;
4745: BEGIN
4746:

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

4763: l_eam_res_rec.usage_rate_or_amount := p_ce_line_rec.required_quantity;
4764: l_eam_res_rec.assigned_units := nvl(p_ce_line_rec.res_assigned_units,1);
4765: l_eam_res_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4766: l_eam_res_rec.completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);
4767: l_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4768:
4769: /* Get Charge Type: Ideally this should be copied into the CE table as part of the Activity explosion -
4770: but since the charge type was not included in the data model, deriving it here. In future this may be
4771: a good ebhancement */

Line 4845: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

4841:
4842: procedure POPULATE_MATERIAL(
4843: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4844: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4845: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
4846: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
4847: , x_return_status OUT NOCOPY VARCHAR2
4848: , x_msg_count OUT NOCOPY NUMBER
4849: , x_msg_data OUT NOCOPY VARCHAR2

Line 4846: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type

4842: procedure POPULATE_MATERIAL(
4843: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4844: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4845: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
4846: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
4847: , x_return_status OUT NOCOPY VARCHAR2
4848: , x_msg_count OUT NOCOPY NUMBER
4849: , x_msg_data OUT NOCOPY VARCHAR2
4850: ) IS

Line 4852: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

4848: , x_msg_count OUT NOCOPY NUMBER
4849: , x_msg_data OUT NOCOPY VARCHAR2
4850: ) IS
4851:
4852: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
4853: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
4854: l_stmt_num NUMBER := 0;
4855: BEGIN
4856:

Line 4853: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

4849: , x_msg_data OUT NOCOPY VARCHAR2
4850: ) IS
4851:
4852: l_eam_mat_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
4853: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
4854: l_stmt_num NUMBER := 0;
4855: BEGIN
4856:
4857: IF fnd_api.to_Boolean(p_init_msg_list) then

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

4878: l_eam_mat_rec.SUGGESTED_VENDOR_NAME := p_ce_line_rec.SUGGESTED_VENDOR_NAME;
4879: l_eam_mat_rec.vendor_id := p_ce_line_rec.suggested_vendor_id;
4880: --l_eam_mat_rec.unit_price := p_ce_line_rec.item_comments;
4881: l_eam_mat_rec.unit_price := p_ce_line_rec.unit_price; --bug # 12911560
4882: l_eam_mat_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4883:
4884: ELSE
4885: l_eam_direct_rec.organization_id := p_ce_line_rec.organization_id;
4886: l_eam_direct_rec.description := p_ce_line_rec.di_description;

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

4896: l_eam_mat_rec.unit_price := p_ce_line_rec.unit_price; --bug # 12911560
4897: l_eam_direct_rec.required_quantity := p_ce_line_rec.required_quantity;
4898: --l_eam_direct_rec.uom := p_ce_line_rec.SUGGESTED_VENDOR_SITE;
4899: l_eam_direct_rec.need_by_date := p_ce_line_rec.di_need_by_date;
4900: l_eam_direct_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
4901:
4902: END IF; --stockable or non-stockable item
4903:
4904: