eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WORKORDER_WORKFLOW_PVT dependencies on EAM_PROCESS_WO_PUB

Line 109: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

105: l_err_msg varchar2(2000);
106: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
107: l_status_error EXCEPTION;
108:
109: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
110: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 110: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

106: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
107: l_status_error EXCEPTION;
108:
109: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
110: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

107: l_status_error EXCEPTION;
108:
109: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
110: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

108:
109: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
110: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

109: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
110: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

110: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
118:

Line 115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

111: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
118:
119:

Line 116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

112: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
118:
119:
120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

113: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
114: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
115: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
118:
119:
120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

116: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
118:
119:
120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

117: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
118:
119:
120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

118:
119:
120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

119:
120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
127: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

120: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
127: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
128: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

121: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
127: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
128: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
129:

Line 126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

122: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
127: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
128: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
129:
130: l_output_dir VARCHAR2(512);

Line 127: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

123: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
127: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
128: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
129:
130: l_output_dir VARCHAR2(512);
131: l_return_status VARCHAR2(1);

Line 128: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

124: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
125: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
126: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
127: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
128: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
129:
130: l_output_dir VARCHAR2(512);
131: l_return_status VARCHAR2(1);
132: l_msg_count NUMBER;

Line 143: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

139: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
140:
141: l_workorder_rec.user_id := fnd_global.user_id;
142: l_workorder_rec.responsibility_id := fnd_global.resp_id;
143: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
144: l_workorder_rec.header_id := l_wip_entity_Id;
145: l_workorder_rec.batch_id := 1;
146: l_workorder_rec.wip_entity_id := l_wip_entity_Id;
147: l_workorder_rec.organization_id := l_organization_id;

Line 152: EAM_PROCESS_WO_PUB.PROCESS_WO

148: l_workorder_rec.status_type := l_new_system_status;
149: l_workorder_rec.user_defined_status_id := l_new_wo_status;
150: l_workorder_rec.pending_flag := 'N';
151:
152: EAM_PROCESS_WO_PUB.PROCESS_WO
153: ( p_init_msg_list =>TRUE
154: , p_commit => 'N'
155: , p_eam_wo_rec => l_workorder_rec
156: , p_eam_op_tbl => l_eam_op_tbl

Line 232: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

228: l_err_msg varchar2(2000);
229: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
230: l_status_error EXCEPTION;
231:
232: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
233: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 233: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

229: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
230: l_status_error EXCEPTION;
231:
232: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
233: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

230: l_status_error EXCEPTION;
231:
232: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
233: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

231:
232: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
233: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

232: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
233: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

233: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
241:

Line 238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

234: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
241:
242:

Line 239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

235: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
241:
242:
243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

236: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
237: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
238: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
241:
242:
243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

239: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
241:
242:
243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

240: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
241:
242:
243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

241:
242:
243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

242:
243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
250: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

243: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
250: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
251: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

244: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
250: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
251: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
252:

Line 249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

245: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
250: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
251: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
252:
253: l_output_dir VARCHAR2(512);

Line 250: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

246: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
250: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
251: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
252:
253: l_output_dir VARCHAR2(512);
254: l_return_status VARCHAR2(1);

Line 251: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

247: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
248: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
249: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
250: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
251: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
252:
253: l_output_dir VARCHAR2(512);
254: l_return_status VARCHAR2(1);
255: l_msg_count NUMBER;

Line 267: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

263: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
264:
265: l_workorder_rec.user_id := fnd_global.user_id;
266: l_workorder_rec.responsibility_id := fnd_global.resp_id;
267: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
268: l_workorder_rec.header_id := l_wip_entity_Id;
269: l_workorder_rec.batch_id := 1;
270: l_workorder_rec.wip_entity_id := l_wip_entity_Id;
271: l_workorder_rec.organization_id := l_organization_id;

Line 276: EAM_PROCESS_WO_PUB.PROCESS_WO

272: l_workorder_rec.status_type :=7; --Cancelled
273: l_workorder_rec.user_defined_status_id := 99; --Cancelled by Approver
274: l_workorder_rec.pending_flag := 'N';
275:
276: EAM_PROCESS_WO_PUB.PROCESS_WO
277: ( p_init_msg_list =>TRUE
278: , p_commit => 'N'
279: , p_eam_wo_rec => l_workorder_rec
280: , p_eam_op_tbl => l_eam_op_tbl

Line 483: p_old_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,

479: This procedure will launch the seeded workflow when status is changed to Released
480: */
481: PROCEDURE Is_Approval_Required_Released
482: (
483: p_old_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
484: p_new_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
485: x_approval_required OUT NOCOPY BOOLEAN,
486: x_workflow_name OUT NOCOPY VARCHAR2,
487: x_workflow_process OUT NOCOPY VARCHAR2

Line 484: p_new_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,

480: */
481: PROCEDURE Is_Approval_Required_Released
482: (
483: p_old_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
484: p_new_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
485: x_approval_required OUT NOCOPY BOOLEAN,
486: x_workflow_name OUT NOCOPY VARCHAR2,
487: x_workflow_process OUT NOCOPY VARCHAR2
488: )

Line 493: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_CREATE) OR

489: IS
490: BEGIN
491:
492: IF(p_new_wo_rec.status_type =3 AND --status is released
493: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_CREATE) OR
494: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_UPDATE) AND
495: ((p_old_wo_rec.status_type IN (1,17,7) ) OR (p_old_wo_rec.status_type=6 AND p_old_wo_rec.date_released IS NULL) ) ) )
496: )THEN
497: x_approval_required := TRUE;

Line 494: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_UPDATE) AND

490: BEGIN
491:
492: IF(p_new_wo_rec.status_type =3 AND --status is released
493: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_CREATE) OR
494: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_UPDATE) AND
495: ((p_old_wo_rec.status_type IN (1,17,7) ) OR (p_old_wo_rec.status_type=6 AND p_old_wo_rec.date_released IS NULL) ) ) )
496: )THEN
497: x_approval_required := TRUE;
498: x_workflow_name := 'EAMWOREL';