44: l_eam_item_type NUMBER;
45:
46: /* added for calling WO API */
47:
48: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
49: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
50: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
45:
46: /* added for calling WO API */
47:
48: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
49: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
50: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
46: /* added for calling WO API */
47:
48: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
49: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
50: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
47:
48: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
49: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
50: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
48: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
49: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
50: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
49: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
50: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
50: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
58:
51: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
58:
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
52: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
58:
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
53: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
58:
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
55: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
58:
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
56: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
58:
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
58:
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
65: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
58:
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
65: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
66: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
59: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
65: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
66: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
67: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
60: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
65: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
66: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
67: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
68:
61: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
65: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
66: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
67: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
68:
69: BEGIN
62: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
65: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
66: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
67: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
68:
69: BEGIN
70: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
63: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
64: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
65: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
66: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
67: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
68:
69: BEGIN
70: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start of ' || l_module);
345: l_eam_wo_rec.program_application_id := p_work_order_rec.program_application_id;
346: l_eam_wo_rec.source_line_id := p_work_order_rec.source_line_id;
347: l_eam_wo_rec.source_code := p_work_order_rec.source_code;
348: -- l_eam_wo_rec.return_status :=
349: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
350:
351: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Calling work order API');
353: end if;
350:
351: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Calling work order API');
353: end if;
354: EAM_PROCESS_WO_PUB.Process_WO
355: ( p_bo_identifier => 'EAM'
356: , p_init_msg_list => TRUE
357: , p_api_version_number => 1.0
358: , p_commit => 'N'