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 44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

40: ************************************************/
41: PROCEDURE CREATE_UPDATE_WO
42: (
43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

Line 45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

41: PROCEDURE CREATE_UPDATE_WO
42: (
43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

Line 46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

42: (
43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

Line 47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

Line 48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

Line 49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

Line 50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

Line 51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

Line 52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

Line 53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

Line 54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,

Line 55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,
59: p_failure_id IN NUMBER := null,

Line 56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,
59: p_failure_id IN NUMBER := null,
60: p_failure_date IN DATE := null,

Line 57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,
59: p_failure_id IN NUMBER := null,
60: p_failure_date IN DATE := null,
61: p_failure_entry_id IN NUMBER := null,

Line 81: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

77: ************************************************/
78: PROCEDURE CREATE_UPDATE_WO
79: (
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
82: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

Line 82: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

78: PROCEDURE CREATE_UPDATE_WO
79: (
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
82: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

Line 83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

79: (
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
82: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

Line 84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
82: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

Line 85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

81: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
82: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

Line 86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

82: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

Line 87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

83: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

Line 88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

84: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

Line 89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

85: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
93: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

Line 90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

86: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
93: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
94: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

Line 91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

87: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
93: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
94: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
95: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit

Line 92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

88: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
93: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
94: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
95: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
96: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit

Line 93: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

89: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
93: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
94: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
95: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
96: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
97: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance

Line 94: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

90: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
91: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
92: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
93: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
94: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
95: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
96: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
97: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance
98: p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance

Line 122: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,

118:
119: PROCEDURE CREATE_UPDATE_WO
120: (
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
123: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

Line 123: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,

119: PROCEDURE CREATE_UPDATE_WO
120: (
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
123: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

Line 124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,

120: (
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
123: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

Line 125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
123: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

Line 126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

122: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
123: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

Line 127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

123: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

Line 128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,

124: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

Line 129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,

125: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

Line 130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,

126: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
134: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

Line 131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,

127: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
134: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
135: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

Line 132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,

128: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
134: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
135: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
136: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit

Line 133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,

129: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
134: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
135: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
136: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit
137: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type, -- new param for safety permit

Line 134: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,

130: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
134: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
135: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
136: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit
137: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type, -- new param for safety permit
138: p_prev_activity_id IN NUMBER,

Line 135: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,

131: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
132: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
133: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
134: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
135: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
136: p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type, -- new param for safety permit
137: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type, -- new param for safety permit
138: p_prev_activity_id IN NUMBER,
139: p_failure_id IN NUMBER := null,