387: v_created_by number;
388: v_updated_by number;
389:
390: -- WORK ORDERS TABLES
391: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
392: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
393: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
394: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
395:
388: v_updated_by number;
389:
390: -- WORK ORDERS TABLES
391: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
392: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
393: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
394: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
395:
396: -- OPERATIONS TABLES
389:
390: -- WORK ORDERS TABLES
391: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
392: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
393: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
394: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
395:
396: -- OPERATIONS TABLES
397: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
390: -- WORK ORDERS TABLES
391: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
392: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
393: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
394: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
395:
396: -- OPERATIONS TABLES
397: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
398: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
393: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
394: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
395:
396: -- OPERATIONS TABLES
397: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
398: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
399: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
400: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
401:
394: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
395:
396: -- OPERATIONS TABLES
397: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
398: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
399: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
400: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
401:
402: -- RESOURCE TABLES
395:
396: -- OPERATIONS TABLES
397: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
398: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
399: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
400: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
401:
402: -- RESOURCE TABLES
403: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
396: -- OPERATIONS TABLES
397: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
398: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
399: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
400: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
401:
402: -- RESOURCE TABLES
403: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
404: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
399: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
400: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
401:
402: -- RESOURCE TABLES
403: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
404: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
405: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
406: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
407:
400: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
401:
402: -- RESOURCE TABLES
403: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
404: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
405: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
406: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
407:
408: -- MATERIAL REQ TABLES
401:
402: -- RESOURCE TABLES
403: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
404: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
405: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
406: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
407:
408: -- MATERIAL REQ TABLES
409: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
402: -- RESOURCE TABLES
403: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
404: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
405: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
406: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
407:
408: -- MATERIAL REQ TABLES
409: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
410: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
405: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
406: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
407:
408: -- MATERIAL REQ TABLES
409: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
410: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
411: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
412: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
413:
406: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
407:
408: -- MATERIAL REQ TABLES
409: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
410: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
411: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
412: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
413:
414:
407:
408: -- MATERIAL REQ TABLES
409: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
410: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
411: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
412: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
413:
414:
415: -- OTHER TABLES
408: -- MATERIAL REQ TABLES
409: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
410: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
411: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
412: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
413:
414:
415: -- OTHER TABLES
416: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
412: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
413:
414:
415: -- OTHER TABLES
416: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
417: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
418: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
419: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
413:
414:
415: -- OTHER TABLES
416: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
417: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
418: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
419: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
414:
415: -- OTHER TABLES
416: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
417: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
418: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
419: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
415: -- OTHER TABLES
416: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
417: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
418: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
419: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
423:
416: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
417: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
418: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
419: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
423:
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
417: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
418: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
419: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
423:
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
418: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
419: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
423:
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
420: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
423:
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
421: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
423:
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
422: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
423:
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
423:
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
424: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
425: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
426: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
427: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
428: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
429: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
430: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
431: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
439: --Extra variables for extended call to process_master_child_Wo
432: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
439: --Extra variables for extended call to process_master_child_Wo
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
433: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
439: --Extra variables for extended call to process_master_child_Wo
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
434: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
435: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
439: --Extra variables for extended call to process_master_child_Wo
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
436: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
439: --Extra variables for extended call to process_master_child_Wo
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
437: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
439: --Extra variables for extended call to process_master_child_Wo
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
438: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
439: --Extra variables for extended call to process_master_child_Wo
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
439: --Extra variables for extended call to process_master_child_Wo
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
440: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
441: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
442: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
443: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
444: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
445: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
453: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
446: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
453: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
454: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
447: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
453: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
454: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
455: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
448: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
453: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
454: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
455: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
456:
449: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
453: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
454: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
455: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
456:
457: -- VARIABLES
450: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
453: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
454: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
455: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
456:
457: -- VARIABLES
458: l_x_return_status VARCHAR2(30);
451: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
452: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
453: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
454: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
455: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
456:
457: -- VARIABLES
458: l_x_return_status VARCHAR2(30);
459: l_x_msg_data VARCHAR2(1000);
897: savepoint EAMCALL;
898:
899: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
900: 'Calling API '||
901: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
902: FND_MSG_PUB.initialize;
903: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO (
904: P_BO_IDENTIFIER => 'EAM'
905: , P_API_VERSION_NUMBER => 1.0
899: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
900: 'Calling API '||
901: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
902: FND_MSG_PUB.initialize;
903: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO (
904: P_BO_IDENTIFIER => 'EAM'
905: , P_API_VERSION_NUMBER => 1.0
906: , P_INIT_MSG_LIST => FALSE -- FND_API.G_FALSE , this is boolean
907: , P_EAM_WO_RELATIONS_TBL => L_EAM_WO_RELATIONS_TBL
973: IF(l_x_return_status = FND_API.G_RET_STS_SUCCESS)
974: THEN
975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
977: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
978: ' returns SUCCESS');
979: -- fnd_file.put_line(FND_FILE.OUTPUT, var_buf);
980: var_buf := 'Group ID : '||g_group_id;
981:
1082: g_retcode := MSC_UTIL.G_WARNING;
1083: END IF;
1084: */ ELSE
1085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1086: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
1087: 'FAILED');
1088: g_retcode := MSC_UTIL.G_WARNING;
1089: END IF;
1090:
1124: v_created_by number;
1125: v_updated_by number;
1126:
1127: -- WORK ORDERS TABLES
1128: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1129: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1130: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1131: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1132:
1125: v_updated_by number;
1126:
1127: -- WORK ORDERS TABLES
1128: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1129: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1130: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1131: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1132:
1133: -- OPERATIONS TABLES
1126:
1127: -- WORK ORDERS TABLES
1128: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1129: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1130: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1131: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1132:
1133: -- OPERATIONS TABLES
1134: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1127: -- WORK ORDERS TABLES
1128: L_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1129: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1130: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1131: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1132:
1133: -- OPERATIONS TABLES
1134: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1135: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1130: L_X_EAM_WO_TBL EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE /*:=
1131: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1132:
1133: -- OPERATIONS TABLES
1134: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1135: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1136: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1137: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1138:
1131: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_TBL */;
1132:
1133: -- OPERATIONS TABLES
1134: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1135: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1136: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1137: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1138:
1139: -- RESOURCE TABLES
1132:
1133: -- OPERATIONS TABLES
1134: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1135: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1136: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1137: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1138:
1139: -- RESOURCE TABLES
1140: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1133: -- OPERATIONS TABLES
1134: L_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1135: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1136: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1137: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1138:
1139: -- RESOURCE TABLES
1140: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1141: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1136: L_X_EAM_OP_TBL EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE /*:=
1137: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1138:
1139: -- RESOURCE TABLES
1140: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1141: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1142: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1143: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1144:
1137: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_TBL */;
1138:
1139: -- RESOURCE TABLES
1140: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1141: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1142: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1143: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1144:
1145: -- MATERIAL REQ TABLES
1138:
1139: -- RESOURCE TABLES
1140: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1141: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1142: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1143: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1144:
1145: -- MATERIAL REQ TABLES
1146: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
1139: -- RESOURCE TABLES
1140: L_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1141: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1142: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1143: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1144:
1145: -- MATERIAL REQ TABLES
1146: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
1147: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1142: L_X_EAM_RES_TBL EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE /*:=
1143: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1144:
1145: -- MATERIAL REQ TABLES
1146: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
1147: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1148: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
1149: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1150:
1143: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_TBL */;
1144:
1145: -- MATERIAL REQ TABLES
1146: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
1147: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1148: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
1149: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1150:
1151:
1144:
1145: -- MATERIAL REQ TABLES
1146: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
1147: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1148: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
1149: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1150:
1151:
1152: -- OTHER TABLES
1145: -- MATERIAL REQ TABLES
1146: L_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /* :=
1147: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1148: L_X_EAM_MAT_TBL EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE /*:=
1149: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1150:
1151:
1152: -- OTHER TABLES
1153: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1149: EAM_PROCESS_WO_PUB.G_MISS_EAM_MAT_REQ_TBL*/;
1150:
1151:
1152: -- OTHER TABLES
1153: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1154: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
1155: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1156: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1150:
1151:
1152: -- OTHER TABLES
1153: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1154: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
1155: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1156: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1151:
1152: -- OTHER TABLES
1153: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1154: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
1155: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1156: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1152: -- OTHER TABLES
1153: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1154: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
1155: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1156: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1160:
1153: L_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1154: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
1155: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1156: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1160:
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1154: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/ ;
1155: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1156: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1160:
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1155: L_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1156: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL */;
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1160:
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1157: L_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1160:
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1158: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1160:
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1159: L_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE;
1160:
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1160:
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1161: L_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1162: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1163: L_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1164: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1165: L_X_EAM_WO_RELATIONS_TBL EAM_PROCESS_WO_PUB.EAM_WO_RELATIONS_TBL_TYPE /*:=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1166: EAM_PROCESS_WO_PUB.G_MISS_EAM_WO_RELATIONS_TBL*/;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1167: L_X_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.EAM_OP_NETWORK_TBL_TYPE /*:=
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1168: EAM_PROCESS_WO_PUB.G_MISS_EAM_OP_NETWORK_TBL*/;
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1176: --Extra variables for extended call to process_master_child_Wo
1169: L_X_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE /*:=
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1176: --Extra variables for extended call to process_master_child_Wo
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1170: EAM_PROCESS_WO_PUB.G_MISS_EAM_RES_INST_TBL*/ ;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1176: --Extra variables for extended call to process_master_child_Wo
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1171: L_X_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.EAM_SUB_RES_TBL_TYPE /*:=
1172: EAM_PROCESS_WO_PUB.G_MISS_EAM_SUB_RES_TBL */;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1176: --Extra variables for extended call to process_master_child_Wo
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1173: L_X_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_TBL_TYPE/* :=
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1176: --Extra variables for extended call to process_master_child_Wo
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1174: EAM_PROCESS_WO_PUB.G_MISS_EAM_DIRECT_ITEMS_TBL */ ;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1176: --Extra variables for extended call to process_master_child_Wo
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1175: L_X_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE ;
1176: --Extra variables for extended call to process_master_child_Wo
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1176: --Extra variables for extended call to process_master_child_Wo
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1177: L_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1178: L_X_EAM_WO_COMP_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1179: L_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1180: L_X_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.EAM_WO_QUALITY_TBL_TYPE ;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1181: L_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1182: L_X_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.EAM_METER_READING_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1190: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1183: L_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1190: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1191: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1184: L_X_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.EAM_COUNTER_PROP_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1190: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1191: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1192: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1185: L_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1190: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1191: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1192: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1193:
1186: L_X_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_REBUILD_TBL_TYPE;
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1190: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1191: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1192: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1193:
1194: -- VARIABLES
1187: L_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1190: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1191: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1192: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1193:
1194: -- VARIABLES
1195: l_x_return_status VARCHAR2(30);
1188: L_X_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.EAM_WO_COMP_MR_READ_TBL_TYPE;
1189: L_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1190: L_X_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.EAM_OP_COMP_TBL_TYPE;
1191: L_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1192: L_X_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.EAM_REQUEST_TBL_TYPE;
1193:
1194: -- VARIABLES
1195: l_x_return_status VARCHAR2(30);
1196: l_x_msg_data VARCHAR2(1000);
1564: savepoint EAMCALL;
1565:
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1567: 'Calling API '||
1568: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
1569: FND_MSG_PUB.initialize;
1570: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO (
1571: P_BO_IDENTIFIER => 'EAM'
1572: , P_API_VERSION_NUMBER => 1.0
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1567: 'Calling API '||
1568: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
1569: FND_MSG_PUB.initialize;
1570: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO (
1571: P_BO_IDENTIFIER => 'EAM'
1572: , P_API_VERSION_NUMBER => 1.0
1573: , P_INIT_MSG_LIST => FALSE -- FND_API.G_FALSE , this is boolean
1574: , P_EAM_WO_RELATIONS_TBL => L_EAM_WO_RELATIONS_TBL
1640: IF(l_x_return_status = FND_API.G_RET_STS_SUCCESS)
1641: THEN
1642:
1643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1644: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO returns SUCCESS');
1645: -- fnd_file.put_line(FND_FILE.OUTPUT, var_buf);
1646: var_buf := 'Group ID : '||g_group_id;
1647:
1648: log_output(' '||rpad(L_EAM_WO_TBL(1).WIP_ENTITY_NAME, 9)||' '||
1652:
1653:
1654: ELSE
1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1656: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO FAILED');
1657: g_retcode := MSC_UTIL.G_WARNING;
1658: END IF;
1659:
1660: IF((l_x_return_status <> FND_API.G_RET_STS_SUCCESS) )
1687: ************************************************************************/
1688:
1689:
1690: PROCEDURE GET_WO_DETAIL (V_WIP_ENTITY_ID IN NUMBER, V_ORGANIZATION_ID IN NUMBER,
1691: L_EAM_WO_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE)
1692: IS
1693: L_JOB_START_DATE DATE ;
1694: L_JOB_STMT VARCHAR2(2000);
1695:
1817: ***************************************************************************/
1818:
1819: PROCEDURE GET_OP_DETAIL (V_WIP_ENTITY_ID IN NUMBER ,
1820: V_ORGANIZATION_ID IN NUMBER ,
1821: L_EAM_OP_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE
1822: )
1823: IS
1824:
1825: l_op_index NUMBER :=1;
1942: ***************************************************************************/
1943:
1944: PROCEDURE GET_RES_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,
1945: V_ORGANIZATION_ID IN NUMBER,
1946: L_EAM_RES_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE ) IS
1947:
1948: l_res_index NUMBER :=1;
1949: lv_stmt2 VARCHAR2(2000) ;
1950: RES_CUR CurTyp;
2030:
2031: ***************************************************************************/
2032:
2033: PROCEDURE GET_MAT_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,V_ORGANIZATION_ID IN NUMBER,
2034: L_EAM_MAT_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE ) IS
2035:
2036: lv_stmt2 VARCHAR2(2000) ;
2037: MAT_CUR CurTyp;
2038: MAT_CUR_TBL MAT_CUR_TBL_TYPE ;
2109:
2110: ***************************************************************************/
2111:
2112: PROCEDURE GET_SUB_MAT_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,V_ORGANIZATION_ID IN NUMBER,
2113: L_EAM_MAT_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE ) IS
2114:
2115: l_mat_index NUMBER :=1;
2116: lv_stmt2 VARCHAR2(2000) ;
2117: MAT_CUR CurTyp;
2252: ***************************************************************************/
2253:
2254: PROCEDURE GET_RES_INST_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,
2255: V_ORGANIZATION_ID IN NUMBER,
2256: L_EAM_RES_INST_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE) IS
2257:
2258: l_res_index NUMBER :=1;
2259: lv_stmt2 VARCHAR2(2000) ;
2260: lv_res_inst_count number;
2320:
2321: END GET_RES_INST_DETAIL;
2322:
2323: PROCEDURE GET_RES_USAGE_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,V_ORGANIZATION_ID IN NUMBER,
2324: L_EAM_RES_USAGE_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE) IS
2325: l_res_usage_index NUMBER :=1;
2326: lv_stmt2 VARCHAR2(2000) ;
2327: RES_USAGE_CUR CurTyp;
2328: RES_USAGE_CUR_TBL RES_USAGE_CUR_TBL_TYPE ;