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 882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;

878:
879: l_date_chk_return_status VARCHAR2(1);
880: l_output_dir VARCHAR2(512);
881:
882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

880: l_output_dir VARCHAR2(512);
881:
882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

881:
882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:

Line 898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:

Line 918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:
922:

Line 919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:
922:
923: BEGIN

Line 920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:
922:
923: BEGIN
924:

Line 948: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(

944: l_eam_wo_rec.DUE_DATE := p_required_due_date;
945:
946: -- insert into the table
947: l_eam_wo_tbl(1) := l_eam_wo_rec;
948: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
949: p_bo_identifier => 'EAM'
950: , p_init_msg_list => TRUE
951: , p_api_version_number => 1.0
952: , p_eam_wo_tbl => l_eam_wo_tbl

Line 1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1056:
1057: l_other_message VARCHAR2(20000);
1058: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

Line 1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1057: l_other_message VARCHAR2(20000);
1058: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

Line 1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;

1058: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

Line 1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

Line 1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

Line 1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:

Line 1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:
1070: l_prior_workorder VARCHAR2(240);

Line 1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:
1070: l_prior_workorder VARCHAR2(240);
1071: l_next_workorder VARCHAR2(240);

Line 1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:
1070: l_prior_workorder VARCHAR2(240);
1071: l_next_workorder VARCHAR2(240);
1072:

Line 1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1267: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1268: l_other_message VARCHAR2(20000);
1269: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

Line 1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1268: l_other_message VARCHAR2(20000);
1269: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

Line 1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;

1269: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

Line 1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

Line 1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

Line 1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:

Line 1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);

Line 1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);
1282: l_next_workorder VARCHAR2(240);

Line 1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);
1282: l_next_workorder VARCHAR2(240);
1283: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

Line 1283: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);
1282: l_next_workorder VARCHAR2(240);
1283: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
1284:
1285: BEGIN
1286:
1287:

Line 1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1686:
1687: l_other_message VARCHAR2(20000);
1688: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

Line 1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1687: l_other_message VARCHAR2(20000);
1688: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

Line 1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;

1688: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

Line 1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

Line 1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;

1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

Line 1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;

1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:

Line 1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;

1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:
1700: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;

Line 1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;

1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:
1700: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1701: l_constraining_children l_relationship_records;

Line 1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;

1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:
1700: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1701: l_constraining_children l_relationship_records;
1702: l_relationship_record WIP_SCHED_RELATIONSHIPS%ROWTYPE;