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_op_tbl EAM_PROCESS_WO_PUB.eam_op_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_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_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_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_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_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 128: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_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_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_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_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_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_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

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

Line 132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

128: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

129: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

Line 134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

130: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

131: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

Line 136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

132: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
140:

Line 137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

133: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
140:
141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

134: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
140:
141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

135: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
136: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
140:
141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

137: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
140:
141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

138: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
140:
141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

139: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
140:
141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

140:
141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

141: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

142: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

143: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

144: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

145: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

146: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

147: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

148: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

149: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

150: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

151: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
159: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

152: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
159: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
160: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

Line 157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

153: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
159: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
160: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
161:

Line 158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

154: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
159: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
160: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
161:
162:

Line 159: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;

155: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
159: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
160: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
161:
162:
163: l_output_dir VARCHAR2(512);

Line 160: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

156: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
157: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
158: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
159: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
160: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
161:
162:
163: l_output_dir VARCHAR2(512);
164:

Line 1206: 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

1202: --Set the auto_charge type to Manual/POReceipt for newly created workorders
1203: l_eam_res_tbl := p_eam_res_tbl;
1204: IF(l_eam_res_tbl IS NOT NULL AND l_eam_res_tbl.COUNT>0) THEN
1205: FOR i IN l_eam_res_tbl.FIRST .. l_eam_res_tbl.LAST LOOP
1206: 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
1207: OPEN resources(l_eam_res_tbl(i).resource_id,l_eam_res_tbl(i).organization_id);
1208: FETCH resources INTO l_resources;
1209: IF(resources%FOUND) THEN
1210: IF(l_resources.autocharge_type=1 OR l_resources.autocharge_type=2) THEN

Line 1389: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO(

1385: x_wip_entity_id := NULL;
1386:
1387: IF(p_eam_wo_relations_tbl IS NOT NULL AND p_eam_wo_relations_tbl.COUNT > 0) THEN
1388:
1389: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO(
1390: p_bo_identifier =>'EAM'
1391: , p_api_version_number => 1.0
1392: , p_init_msg_list => TRUE
1393: , p_eam_wo_relations_tbl => p_eam_wo_relations_tbl

Line 1447: EAM_PROCESS_WO_PUB.PROCESS_WO(

1443: IF ( l_eam_wo_comp_tbl.COUNT > 0 ) THEN
1444: l_eam_wo_comp_rec := l_eam_wo_comp_tbl(l_eam_wo_comp_tbl.FIRST);
1445: END IF;
1446:
1447: EAM_PROCESS_WO_PUB.PROCESS_WO(
1448: p_bo_identifier =>'EAM'
1449: , p_api_version_number => 1.0
1450: , p_init_msg_list => TRUE
1451: , p_eam_wo_rec => l_eam_wo_rec

Line 1522: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

1518: ************************************************/
1519: PROCEDURE CREATE_UPDATE_WO
1520: (
1521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1522: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

Line 1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

1519: PROCEDURE CREATE_UPDATE_WO
1520: (
1521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1522: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

Line 1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

1520: (
1521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1522: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

Line 1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

1521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1522: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

Line 1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

1522: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

Line 1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

Line 1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

Line 1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

Line 1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

1526: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1534: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

Line 1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

1527: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1534: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1535: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

Line 1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

1528: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1534: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1535: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1536: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit

Line 1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

1529: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1534: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1535: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1536: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit
1537: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type, -- new param for safety permit

Line 1534: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

1530: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1534: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1535: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1536: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit
1537: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type, -- new param for safety permit
1538: p_prev_activity_id IN NUMBER,

Line 1535: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

1531: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1532: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1533: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1534: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1535: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1536: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit
1537: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type, -- new param for safety permit
1538: p_prev_activity_id IN NUMBER,
1539: p_failure_id IN NUMBER := null,

Line 1721: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

1717: ************************************************/
1718: PROCEDURE CREATE_UPDATE_WO
1719: (
1720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1721: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

Line 1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

1718: PROCEDURE CREATE_UPDATE_WO
1719: (
1720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1721: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

Line 1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

1719: (
1720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1721: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

Line 1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

1720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1721: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

Line 1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

1721: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

Line 1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

Line 1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

Line 1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

Line 1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

1725: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

Line 1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

1726: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

Line 1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

1727: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit

Line 1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

1728: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit

Line 1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

1729: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
1737: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance

Line 1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

1730: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
1737: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance
1738: p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance

Line 1754: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

1750: x_msg_count OUT NOCOPY NUMBER
1751: ) IS
1752:
1753:
1754: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1755: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1756: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 1755: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1751: ) IS
1752:
1753:
1754: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1755: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1756: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

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

1752:
1753:
1754: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1755: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1756: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1753:
1754: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1755: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1756: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1754: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1755: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1756: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

1755: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1756: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1756: l_import_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type; --MSP Project
1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1757: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

Line 1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

1758: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

1759: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

Line 1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

1760: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

1761: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

Line 1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1762: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
1770:

Line 1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

1763: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
1770:
1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1764: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
1770:
1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;

1765: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1766: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
1770:
1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line 1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

1767: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
1770:
1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;

1768: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
1770:
1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

1769: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
1770:
1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;

1770:
1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

1771: l_eam_wo_relations_tbl_out EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;

1772: l_eam_wo_rec_out EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

1773: l_eam_wo_tbl_out EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

1774: l_eam_op_tbl_out EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

1775: l_eam_op_network_tbl_out EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

1776: l_eam_res_tbl_out EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

1777: l_eam_res_usage_tbl_out EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

1778: l_eam_res_inst_tbl_out EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

1779: l_eam_sub_res_tbl_out EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

1780: l_eam_mat_req_tbl_out EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

1781: l_eam_direct_items_tbl_out EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1789: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

1782: l_eam_wo_comp_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1789: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1790: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

Line 1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

1783: l_eam_wo_quality_tbl_out EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1789: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1790: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1791:

Line 1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

1784: l_eam_meter_reading_tbl_out EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1789: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1790: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1791:
1792:

Line 1789: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;

1785: l_eam_counter_prop_tbl_out EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1789: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1790: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1791:
1792:
1793: l_output_dir VARCHAR2(512);

Line 1790: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;

1786: l_eam_wo_comp_rebuild_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1787: l_eam_wo_comp_mr_read_tbl_out EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1788: l_eam_op_comp_tbl_out EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1789: l_eam_request_tbl_out EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1790: l_eam_wo_comp_rec_out EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1791:
1792:
1793: l_output_dir VARCHAR2(512);
1794:

Line 2838: 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

2834: --Set the auto_charge type to Manual/POReceipt for newly created workorders
2835: l_eam_res_tbl := p_eam_res_tbl;
2836: IF(l_eam_res_tbl IS NOT NULL AND l_eam_res_tbl.COUNT>0) THEN
2837: FOR i IN l_eam_res_tbl.FIRST .. l_eam_res_tbl.LAST LOOP
2838: 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
2839: OPEN resources(l_eam_res_tbl(i).resource_id,l_eam_res_tbl(i).organization_id);
2840: FETCH resources INTO l_resources;
2841: IF(resources%FOUND) THEN
2842: IF(l_resources.autocharge_type=1 OR l_resources.autocharge_type=2) THEN

Line 3021: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO(

3017: x_wip_entity_id := NULL;
3018:
3019: IF(p_eam_wo_relations_tbl IS NOT NULL AND p_eam_wo_relations_tbl.COUNT > 0) THEN
3020:
3021: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO(
3022: p_bo_identifier =>'EAM'
3023: , p_api_version_number => 1.0
3024: , p_init_msg_list => TRUE
3025: , p_eam_wo_relations_tbl => p_eam_wo_relations_tbl

Line 3079: EAM_PROCESS_WO_PUB.PROCESS_WO(

3075: IF ( l_eam_wo_comp_tbl.COUNT > 0 ) THEN
3076: l_eam_wo_comp_rec := l_eam_wo_comp_tbl(l_eam_wo_comp_tbl.FIRST);
3077: END IF;
3078:
3079: EAM_PROCESS_WO_PUB.PROCESS_WO(
3080: p_bo_identifier =>'EAM'
3081: , p_api_version_number => 1.0
3082: , p_init_msg_list => TRUE
3083: , p_eam_wo_rec => l_eam_wo_rec