DBA Data[Home] [Help]

APPS.EAM_COPY_BOM_PKG dependencies on EAM_PROCESS_WO_PUB

Line 85: l_material_req_table EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

81: l_msg_count NUMBER;
82: i NUMBER;
83: l_output_dir VARCHAR2(512);
84:
85: l_material_req_table EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
86:
87: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 87: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

83: l_output_dir VARCHAR2(512);
84:
85: l_material_req_table EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
86:
87: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

84:
85: l_material_req_table EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
86:
87: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

85: l_material_req_table EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
86:
87: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

86:
87: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

87: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

88: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

89: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

90: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

91: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

92: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

93: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
103:

Line 100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
103:
104:

Line 101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
103:
104:
105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
103:
104:
105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
103:
104:
105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

102: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
103:
104:
105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

103:
104:
105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

104:
105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

105: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

106: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

107: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

108: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

109: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

110: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

111: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

112: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

113: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

114: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
122: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

115: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
122: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
123: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

116: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
122: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
123: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
124:

Line 121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

117: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
122: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
123: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
124:
125: BEGIN

Line 122: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

118: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
122: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
123: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
124:
125: BEGIN
126: /* get output directory path from database */

Line 123: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

119: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
120: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
121: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
122: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
123: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
124:
125: BEGIN
126: /* get output directory path from database */
127: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);

Line 132: --Copy the information from the input table to table type of EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

128:
129:
130: i := 1;
131:
132: --Copy the information from the input table to table type of EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
133: l_index := p_bom_table.FIRST;
134: loop
135:
136: l_material_req_table(i).batch_id := 1;

Line 138: l_material_req_table(i).transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

134: loop
135:
136: l_material_req_table(i).batch_id := 1;
137: l_material_req_table(i).header_id :=p_wip_entity_id;
138: l_material_req_table(i).transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
139: l_material_req_table(i).wip_entity_id := p_wip_entity_id;
140: l_material_req_table(i).organization_id := p_organization_id;
141: l_material_req_table(i).operation_seq_num := p_operation_seq_num;
142: l_material_req_table(i).inventory_item_id :=p_bom_table(l_index).component_item_id;

Line 171: EAM_PROCESS_WO_PUB.Process_Master_Child_WO

167: i := i+1;
168: end loop;
169:
170:
171: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
172: ( p_bo_identifier => 'EAM'
173: , p_init_msg_list => TRUE
174: , p_api_version_number => 1.0
175: , p_eam_wo_tbl => l_eam_wo_tbl