APPS.EAM_MRI_UTILS dependencies on WIP_CONSTANTS

Line 17: ' and mri.process_phase = '|| WIP_CONSTANTS.ML_VALIDATION ||

13: x_statement varchar2(2000) :=
14: ' select interface_id
15: from eam_meter_readings_interface mri' ||
16: ' where mri.group_id = :x_group_id'||
17: ' and mri.process_phase = '|| WIP_CONSTANTS.ML_VALIDATION ||
18: ' and mri.process_status in ('|| WIP_CONSTANTS.RUNNING||
19: ','||WIP_CONSTANTS.PENDING||
20: ','||WIP_CONSTANTS.WARNING ||') and '||
21: replace(p_where_clause, ' ',' ');

Line 18: ' and mri.process_status in ('|| WIP_CONSTANTS.RUNNING||

14: ' select interface_id
15: from eam_meter_readings_interface mri' ||
16: ' where mri.group_id = :x_group_id'||
17: ' and mri.process_phase = '|| WIP_CONSTANTS.ML_VALIDATION ||
18: ' and mri.process_status in ('|| WIP_CONSTANTS.RUNNING||
19: ','||WIP_CONSTANTS.PENDING||
20: ','||WIP_CONSTANTS.WARNING ||') and '||
21: replace(p_where_clause, ' ',' ');
22:

Line 19: ','||WIP_CONSTANTS.PENDING||

15: from eam_meter_readings_interface mri' ||
16: ' where mri.group_id = :x_group_id'||
17: ' and mri.process_phase = '|| WIP_CONSTANTS.ML_VALIDATION ||
18: ' and mri.process_status in ('|| WIP_CONSTANTS.RUNNING||
19: ','||WIP_CONSTANTS.PENDING||
20: ','||WIP_CONSTANTS.WARNING ||') and '||
21: replace(p_where_clause, ' ',' ');
22:
23: x_cursor_id integer;

Line 20: ','||WIP_CONSTANTS.WARNING ||') and '||

16: ' where mri.group_id = :x_group_id'||
17: ' and mri.process_phase = '|| WIP_CONSTANTS.ML_VALIDATION ||
18: ' and mri.process_status in ('|| WIP_CONSTANTS.RUNNING||
19: ','||WIP_CONSTANTS.PENDING||
20: ','||WIP_CONSTANTS.WARNING ||') and '||
21: replace(p_where_clause, ' ',' ');
22:
23: x_cursor_id integer;
24: n_rows_fetched integer;

Line 85: AND PROCESS_PHASE = ' || WIP_CONSTANTS.ML_VALIDATION || '

81: x_statement :=
82: ' UPDATE eam_meter_readings_interface mri'||
83: ' SET PROCESS_STATUS = ' ||P_New_Process_Status|| '
84: WHERE GROUP_ID = ' || P_Group_Id || '
85: AND PROCESS_PHASE = ' || WIP_CONSTANTS.ML_VALIDATION || '
86: AND PROCESS_STATUS IN ('|| WIP_CONSTANTS.RUNNING||
87: ','||WIP_CONSTANTS.PENDING||
88: ','||WIP_CONSTANTS.WARNING ||')'||
89: ' AND ' || replace(p_where_clause, ' ',' ');

Line 86: AND PROCESS_STATUS IN ('|| WIP_CONSTANTS.RUNNING||

82: ' UPDATE eam_meter_readings_interface mri'||
83: ' SET PROCESS_STATUS = ' ||P_New_Process_Status|| '
84: WHERE GROUP_ID = ' || P_Group_Id || '
85: AND PROCESS_PHASE = ' || WIP_CONSTANTS.ML_VALIDATION || '
86: AND PROCESS_STATUS IN ('|| WIP_CONSTANTS.RUNNING||
87: ','||WIP_CONSTANTS.PENDING||
88: ','||WIP_CONSTANTS.WARNING ||')'||
89: ' AND ' || replace(p_where_clause, ' ',' ');
90: */

Line 87: ','||WIP_CONSTANTS.PENDING||

83: ' SET PROCESS_STATUS = ' ||P_New_Process_Status|| '
84: WHERE GROUP_ID = ' || P_Group_Id || '
85: AND PROCESS_PHASE = ' || WIP_CONSTANTS.ML_VALIDATION || '
86: AND PROCESS_STATUS IN ('|| WIP_CONSTANTS.RUNNING||
87: ','||WIP_CONSTANTS.PENDING||
88: ','||WIP_CONSTANTS.WARNING ||')'||
89: ' AND ' || replace(p_where_clause, ' ',' ');
90: */
91:

Line 88: ','||WIP_CONSTANTS.WARNING ||')'||

84: WHERE GROUP_ID = ' || P_Group_Id || '
85: AND PROCESS_PHASE = ' || WIP_CONSTANTS.ML_VALIDATION || '
86: AND PROCESS_STATUS IN ('|| WIP_CONSTANTS.RUNNING||
87: ','||WIP_CONSTANTS.PENDING||
88: ','||WIP_CONSTANTS.WARNING ||')'||
89: ' AND ' || replace(p_where_clause, ' ',' ');
90: */
91:
92: x_statement :=

Line 96: AND PROCESS_PHASE = WIP_CONSTANTS.ML_VALIDATION

92: x_statement :=
93: ' UPDATE eam_meter_readings_interface mri'||
94: ' SET PROCESS_STATUS = :process_status
95: WHERE GROUP_ID = :group_id
96: AND PROCESS_PHASE = WIP_CONSTANTS.ML_VALIDATION
97: AND PROCESS_STATUS IN (WIP_CONSTANTS.RUNNING,
98: WIP_CONSTANTS.PENDING,
99: WIP_CONSTANTS.WARNING)
100: AND ' || replace(p_where_clause, ' ',' ');

Line 97: AND PROCESS_STATUS IN (WIP_CONSTANTS.RUNNING,

93: ' UPDATE eam_meter_readings_interface mri'||
94: ' SET PROCESS_STATUS = :process_status
95: WHERE GROUP_ID = :group_id
96: AND PROCESS_PHASE = WIP_CONSTANTS.ML_VALIDATION
97: AND PROCESS_STATUS IN (WIP_CONSTANTS.RUNNING,
98: WIP_CONSTANTS.PENDING,
99: WIP_CONSTANTS.WARNING)
100: AND ' || replace(p_where_clause, ' ',' ');
101:

Line 98: WIP_CONSTANTS.PENDING,

94: ' SET PROCESS_STATUS = :process_status
95: WHERE GROUP_ID = :group_id
96: AND PROCESS_PHASE = WIP_CONSTANTS.ML_VALIDATION
97: AND PROCESS_STATUS IN (WIP_CONSTANTS.RUNNING,
98: WIP_CONSTANTS.PENDING,
99: WIP_CONSTANTS.WARNING)
100: AND ' || replace(p_where_clause, ' ',' ');
101:
102:

Line 99: WIP_CONSTANTS.WARNING)

95: WHERE GROUP_ID = :group_id
96: AND PROCESS_PHASE = WIP_CONSTANTS.ML_VALIDATION
97: AND PROCESS_STATUS IN (WIP_CONSTANTS.RUNNING,
98: WIP_CONSTANTS.PENDING,
99: WIP_CONSTANTS.WARNING)
100: AND ' || replace(p_where_clause, ' ',' ');
101:
102:
103: begin