DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on EAM_PROCESS_WO_PUB

Line 116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

112:
113: l_other_message VARCHAR2(20000);
114: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

Line 117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

113: l_other_message VARCHAR2(20000);
114: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

Line 118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;

114: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

Line 119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

Line 120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

Line 121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:

Line 122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);

Line 123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);
127: l_child_workorder VARCHAR2(240);

Line 124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);
127: l_child_workorder VARCHAR2(240);
128: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

Line 128: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);
127: l_child_workorder VARCHAR2(240);
128: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
129: BEGIN
130:
131: -- Standard Start of API savepoint
132: SAVEPOINT EAM_WN_ADD_WO;

Line 856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;

852:
853: l_date_chk_return_status VARCHAR2(1);
854: l_output_dir VARCHAR2(512);
855:
856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

854: l_output_dir VARCHAR2(512);
855:
856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

855:
856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:

Line 872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:

Line 892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:
896:

Line 893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:
896:
897: BEGIN

Line 894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:
896:
897: BEGIN
898:

Line 922: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(

918: l_eam_wo_rec.DUE_DATE := p_required_due_date;
919:
920: -- insert into the table
921: l_eam_wo_tbl(1) := l_eam_wo_rec;
922: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
923: p_bo_identifier => 'EAM'
924: , p_init_msg_list => TRUE
925: , p_api_version_number => 1.0
926: , p_eam_wo_tbl => l_eam_wo_tbl

Line 1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1030:
1031: l_other_message VARCHAR2(20000);
1032: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

Line 1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1031: l_other_message VARCHAR2(20000);
1032: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

Line 1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;

1032: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

Line 1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

Line 1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

Line 1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:

Line 1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:
1044: l_prior_workorder VARCHAR2(240);

Line 1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:
1044: l_prior_workorder VARCHAR2(240);
1045: l_next_workorder VARCHAR2(240);

Line 1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:
1044: l_prior_workorder VARCHAR2(240);
1045: l_next_workorder VARCHAR2(240);
1046:

Line 1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1241: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1242: l_other_message VARCHAR2(20000);
1243: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

Line 1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1242: l_other_message VARCHAR2(20000);
1243: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

Line 1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;

1243: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

Line 1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

Line 1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

Line 1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:

Line 1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);

Line 1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);
1256: l_next_workorder VARCHAR2(240);

Line 1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);
1256: l_next_workorder VARCHAR2(240);
1257: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

Line 1257: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);
1256: l_next_workorder VARCHAR2(240);
1257: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
1258:
1259: BEGIN
1260:
1261:

Line 1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1660:
1661: l_other_message VARCHAR2(20000);
1662: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

Line 1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1661: l_other_message VARCHAR2(20000);
1662: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

Line 1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;

1662: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

Line 1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

Line 1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

Line 1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:

Line 1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:
1674: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;

Line 1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:
1674: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1675: l_constraining_children l_relationship_records;

Line 1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:
1674: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1675: l_constraining_children l_relationship_records;
1676: l_relationship_record WIP_SCHED_RELATIONSHIPS%ROWTYPE;