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_CREATEUPDATE_WO_PVT dependencies on EAM_PROCESS_WO_PUB

Line 37: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

33: , x_wip_entity_name OUT NOCOPY VARCHAR2
34: ,x_wip_entity_id OUT NOCOPY NUMBER
35: )
36: IS
37: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
38: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 38: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

34: ,x_wip_entity_id OUT NOCOPY NUMBER
35: )
36: IS
37: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
38: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

35: )
36: IS
37: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
38: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
43: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

36: IS
37: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
38: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
43: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
44: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

37: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
38: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
43: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
44: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
45: l_msg_count NUMBER;

Line 42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

38: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
43: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
44: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
45: l_msg_count NUMBER;
46:

Line 43: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

39: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
43: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
44: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
45: l_msg_count NUMBER;
46:
47: BEGIN

Line 44: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

40: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
41: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
42: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
43: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
44: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
45: l_msg_count NUMBER;
46:
47: BEGIN
48:

Line 51: EAM_PROCESS_WO_PUB.COPY_WORKORDER

47: BEGIN
48:
49: SAVEPOINT COPY_WO;
50:
51: EAM_PROCESS_WO_PUB.COPY_WORKORDER
52: ( p_bo_identifier =>'EAM'
53: , p_api_version_number =>1.0
54: , p_init_msg_list => p_init_msg_list
55: , p_commit => FND_API.G_FALSE

Line 96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

92: ************************************************/
93: PROCEDURE CREATE_UPDATE_WO
94: (
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

Line 97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

93: PROCEDURE CREATE_UPDATE_WO
94: (
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

Line 98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

94: (
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

Line 99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

Line 100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

Line 101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

Line 102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

Line 103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

Line 104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

100: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
108: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

Line 105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

101: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
108: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
109: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

Line 106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

102: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
108: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
109: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
110: p_prev_activity_id IN NUMBER,

Line 107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

103: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
108: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
109: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
110: p_prev_activity_id IN NUMBER,
111: p_failure_id IN NUMBER := null,

Line 108: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

104: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
108: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
109: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
110: p_prev_activity_id IN NUMBER,
111: p_failure_id IN NUMBER := null,
112: p_failure_date IN DATE := null,

Line 109: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

105: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
106: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
107: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
108: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
109: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
110: p_prev_activity_id IN NUMBER,
111: p_failure_id IN NUMBER := null,
112: p_failure_date IN DATE := null,
113: p_failure_entry_id IN NUMBER := null,

Line 124: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER
122: )
123: IS
124: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
125: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 125: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

121: x_msg_count OUT NOCOPY NUMBER
122: )
123: IS
124: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
125: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project

122: )
123: IS
124: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
125: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

123: IS
124: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
125: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

124: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
125: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

125: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

Line 130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

126: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
134:

Line 131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

127: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
134:
135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

128: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
134:
135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
130: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
134:
135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

131: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
134:
135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

132: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
134:
135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

133: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
134:
135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

134:
135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

135: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

136: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

137: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

138: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

139: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

140: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

141: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

142: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

143: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

144: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

145: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
153: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

146: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
153: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
154: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

Line 151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

147: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
153: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
154: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
155:

Line 152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

148: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
153: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
154: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
155:
156:

Line 153: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;

149: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
153: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
154: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
155:
156:
157: l_output_dir VARCHAR2(512);

Line 154: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

150: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
151: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
152: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
153: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
154: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
155:
156:
157: l_output_dir VARCHAR2(512);
158:

Line 653: IF(l_eam_res_tbl(i).transaction_type=EAM_PROCESS_WO_PUB.G_OPR_CREATE AND (l_eam_res_tbl(i).autocharge_type IS NULL)) THEN

649: --Set the auto_charge type to Manual/POReceipt for newly created workorders
650: l_eam_res_tbl := p_eam_res_tbl;
651: IF(l_eam_res_tbl IS NOT NULL AND l_eam_res_tbl.COUNT>0) THEN
652: FOR i IN l_eam_res_tbl.FIRST .. l_eam_res_tbl.LAST LOOP
653: IF(l_eam_res_tbl(i).transaction_type=EAM_PROCESS_WO_PUB.G_OPR_CREATE AND (l_eam_res_tbl(i).autocharge_type IS NULL)) THEN
654: OPEN resources(l_eam_res_tbl(i).resource_id,l_eam_res_tbl(i).organization_id);
655: FETCH resources INTO l_resources;
656: IF(resources%FOUND) THEN
657: IF(l_resources.autocharge_type=1 OR l_resources.autocharge_type=2) THEN

Line 836: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO(

832: x_wip_entity_id := NULL;
833:
834: IF(p_eam_wo_relations_tbl IS NOT NULL AND p_eam_wo_relations_tbl.COUNT > 0) THEN
835:
836: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO(
837: p_bo_identifier =>'EAM'
838: , p_api_version_number => 1.0
839: , p_init_msg_list => TRUE
840: , p_eam_wo_relations_tbl => p_eam_wo_relations_tbl

Line 894: EAM_PROCESS_WO_PUB.PROCESS_WO(

890: IF ( l_eam_wo_comp_tbl.COUNT > 0 ) THEN
891: l_eam_wo_comp_rec := l_eam_wo_comp_tbl(l_eam_wo_comp_tbl.FIRST);
892: END IF;
893:
894: EAM_PROCESS_WO_PUB.PROCESS_WO(
895: p_bo_identifier =>'EAM'
896: , p_api_version_number => 1.0
897: , p_init_msg_list => TRUE
898: , p_eam_wo_rec => l_eam_wo_rec