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 146: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_WF_OPR_UPDATE;

142:
143: --commenting for bug 10149577
144: --l_workorder_rec.user_id := fnd_global.user_id;
145: --l_workorder_rec.responsibility_id := fnd_global.resp_id;
146: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_WF_OPR_UPDATE;
147: l_workorder_rec.header_id := l_wip_entity_Id;
148: l_workorder_rec.batch_id := 1;
149: l_workorder_rec.wip_entity_id := l_wip_entity_Id;
150: l_workorder_rec.organization_id := l_organization_id;

Line 156: EAM_PROCESS_WO_PUB.PROCESS_WO

152: l_workorder_rec.user_defined_status_id := l_new_wo_status;
153: l_workorder_rec.pending_flag := 'N';
154:
155:
156: EAM_PROCESS_WO_PUB.PROCESS_WO
157: ( p_init_msg_list =>TRUE
158: , p_commit => 'N'
159: , p_eam_wo_rec => l_workorder_rec
160: , p_eam_op_tbl => l_eam_op_tbl

Line 237: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

233: l_err_msg varchar2(2000);
234: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
235: l_status_error EXCEPTION;
236:
237: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
238: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 238: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

234: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
235: l_status_error EXCEPTION;
236:
237: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
238: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

235: l_status_error EXCEPTION;
236:
237: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
238: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

236:
237: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
238: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

237: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
238: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

238: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
246:

Line 243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

239: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
246:
247:

Line 244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

240: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
246:
247:
248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

241: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
242: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
243: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
246:
247:
248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

244: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
246:
247:
248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

245: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
246:
247:
248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

246:
247:
248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

247:
248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
255: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

248: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
255: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
256: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

249: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
255: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
256: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
257:

Line 254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

250: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
255: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
256: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
257:
258: l_output_dir VARCHAR2(512);

Line 255: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

251: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
255: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
256: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
257:
258: l_output_dir VARCHAR2(512);
259: l_return_status VARCHAR2(1);

Line 256: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

252: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
253: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
254: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
255: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
256: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
257:
258: l_output_dir VARCHAR2(512);
259: l_return_status VARCHAR2(1);
260: l_msg_count NUMBER;

Line 274: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_WF_OPR_UPDATE;

270:
271: --commenting for bug 10149577
272: --l_workorder_rec.user_id := fnd_global.user_id;
273: --l_workorder_rec.responsibility_id := fnd_global.resp_id;
274: l_workorder_rec.transaction_type := EAM_PROCESS_WO_PUB.G_WF_OPR_UPDATE;
275: l_workorder_rec.header_id := l_wip_entity_Id;
276: l_workorder_rec.batch_id := 1;
277: l_workorder_rec.wip_entity_id := l_wip_entity_Id;
278: l_workorder_rec.organization_id := l_organization_id;

Line 283: EAM_PROCESS_WO_PUB.PROCESS_WO

279: l_workorder_rec.status_type :=7; --Cancelled
280: l_workorder_rec.user_defined_status_id := 99; --Cancelled by Approver
281: l_workorder_rec.pending_flag := 'N';
282:
283: EAM_PROCESS_WO_PUB.PROCESS_WO
284: ( p_init_msg_list =>TRUE
285: , p_commit => 'N'
286: , p_eam_wo_rec => l_workorder_rec
287: , p_eam_op_tbl => l_eam_op_tbl

Line 557: p_old_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,

553: This procedure will launch the seeded workflow when status is changed to Released
554: */
555: PROCEDURE Is_Approval_Required_Released
556: (
557: p_old_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
558: p_new_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
559: x_approval_required OUT NOCOPY BOOLEAN,
560: x_workflow_name OUT NOCOPY VARCHAR2,
561: x_workflow_process OUT NOCOPY VARCHAR2

Line 558: p_new_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,

554: */
555: PROCEDURE Is_Approval_Required_Released
556: (
557: p_old_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
558: p_new_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type,
559: x_approval_required OUT NOCOPY BOOLEAN,
560: x_workflow_name OUT NOCOPY VARCHAR2,
561: x_workflow_process OUT NOCOPY VARCHAR2
562: )

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

563: IS
564: BEGIN
565:
566: IF(p_new_wo_rec.status_type =3 AND --status is released
567: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_CREATE) OR
568: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_UPDATE) AND
569: ((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) ) ) )
570: )THEN
571: x_approval_required := TRUE;

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

564: BEGIN
565:
566: IF(p_new_wo_rec.status_type =3 AND --status is released
567: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_CREATE) OR
568: ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_UPDATE) AND
569: ((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) ) ) )
570: )THEN
571: x_approval_required := TRUE;
572: x_workflow_name := 'EAMWOREL';