DBA Data[Home] [Help]

APPS.WIP_EAMWORKORDER_PVT dependencies on EAM_PROCESS_WO_PUB

Line 45: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

41: l_asset_number VARCHAR2(255) := NULL;
42:
43: /* added for calling WO API */
44:
45: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
46: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 46: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

42:
43: /* added for calling WO API */
44:
45: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
46: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

43: /* added for calling WO API */
44:
45: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
46: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

44:
45: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
46: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

45: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
46: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

46: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

47: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55:

Line 52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

48: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55:
56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55:
56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

50: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
51: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55:
56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

52: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55:
56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

53: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55:
56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

54: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55:
56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

55:
56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
63: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

56: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
63: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

57: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
63: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
65:

Line 62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

58: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
63: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
65:
66: BEGIN

Line 63: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

59: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
63: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
65:
66: BEGIN
67: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

Line 64: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

60: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
61: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
62: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
63: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
65:
66: BEGIN
67: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
68: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start of ' || l_module);

Line 306: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;

302: l_eam_wo_rec.program_application_id := p_work_order_rec.program_application_id;
303: l_eam_wo_rec.source_line_id := p_work_order_rec.source_line_id;
304: l_eam_wo_rec.source_code := p_work_order_rec.source_code;
305: -- l_eam_wo_rec.return_status :=
306: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
307:
308: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
309: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Calling work order API');
310: end if;

Line 311: EAM_PROCESS_WO_PUB.Process_WO

307:
308: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
309: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Calling work order API');
310: end if;
311: EAM_PROCESS_WO_PUB.Process_WO
312: ( p_bo_identifier => 'EAM'
313: , p_init_msg_list => TRUE
314: , p_api_version_number => 1.0
315: , p_commit => 'N'