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.WIP_JOB_DETAILS dependencies on WIP_CONSTANTS

Line 18: and process_phase = WIP_CONSTANTS.ML_VALIDATION

14: organization_id
15: from wip_job_dtls_interface
16: where group_id = p_group_id
17: and parent_header_id = p_parent_header_id
18: and process_phase = WIP_CONSTANTS.ML_VALIDATION
19: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
20:
21: Cursor wdj_cur IS
22: select distinct wip_entity_id,

Line 19: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;

15: from wip_job_dtls_interface
16: where group_id = p_group_id
17: and parent_header_id = p_parent_header_id
18: and process_phase = WIP_CONSTANTS.ML_VALIDATION
19: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
20:
21: Cursor wdj_cur IS
22: select distinct wip_entity_id,
23: organization_id

Line 26: and process_phase = WIP_CONSTANTS.ML_VALIDATION

22: select distinct wip_entity_id,
23: organization_id
24: from wip_job_dtls_interface
25: where group_id = p_group_id
26: and process_phase = WIP_CONSTANTS.ML_VALIDATION
27: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
28:
29: Cursor Oper_Cur (p_wip_entity_id number, p_organization_id number) IS
30: select distinct wip_entity_id,

Line 27: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;

23: organization_id
24: from wip_job_dtls_interface
25: where group_id = p_group_id
26: and process_phase = WIP_CONSTANTS.ML_VALIDATION
27: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
28:
29: Cursor Oper_Cur (p_wip_entity_id number, p_organization_id number) IS
30: select distinct wip_entity_id,
31: organization_id,

Line 41: and process_phase = WIP_CONSTANTS.ML_VALIDATION

37: OR p_std_alone = 1)
38: and wip_entity_id = p_wip_entity_id
39: and organization_id = p_organization_id
40: and load_type = WIP_JOB_DETAILS.WIP_OPERATION
41: and process_phase = WIP_CONSTANTS.ML_VALIDATION
42: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
43:
44: Cursor Res_Cur (p_wip_entity_id number, p_organization_id number) IS
45: select distinct wip_entity_id,

Line 42: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;

38: and wip_entity_id = p_wip_entity_id
39: and organization_id = p_organization_id
40: and load_type = WIP_JOB_DETAILS.WIP_OPERATION
41: and process_phase = WIP_CONSTANTS.ML_VALIDATION
42: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
43:
44: Cursor Res_Cur (p_wip_entity_id number, p_organization_id number) IS
45: select distinct wip_entity_id,
46: organization_id,

Line 56: and process_phase = WIP_CONSTANTS.ML_VALIDATION

52: OR p_std_alone = 1)
53: and wip_entity_id = p_wip_entity_id
54: and organization_id = p_organization_id
55: and load_type = WIP_JOB_DETAILS.WIP_RESOURCE
56: and process_phase = WIP_CONSTANTS.ML_VALIDATION
57: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
58:
59: Cursor ResInst_Cur (p_wip_entity_id number, p_organization_id number) IS
60: select distinct wip_entity_id,

Line 57: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

53: and wip_entity_id = p_wip_entity_id
54: and organization_id = p_organization_id
55: and load_type = WIP_JOB_DETAILS.WIP_RESOURCE
56: and process_phase = WIP_CONSTANTS.ML_VALIDATION
57: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
58:
59: Cursor ResInst_Cur (p_wip_entity_id number, p_organization_id number) IS
60: select distinct wip_entity_id,
61: organization_id,

Line 71: and process_phase = WIP_CONSTANTS.ML_VALIDATION

67: OR p_std_alone = 1)
68: and wip_entity_id = p_wip_entity_id
69: and organization_id = p_organization_id
70: and load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
71: and process_phase = WIP_CONSTANTS.ML_VALIDATION
72: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
73:
74: Cursor Req_Cur (p_wip_entity_id number, p_organization_id number) IS
75: select distinct wip_entity_id,

Line 72: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

68: and wip_entity_id = p_wip_entity_id
69: and organization_id = p_organization_id
70: and load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
71: and process_phase = WIP_CONSTANTS.ML_VALIDATION
72: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
73:
74: Cursor Req_Cur (p_wip_entity_id number, p_organization_id number) IS
75: select distinct wip_entity_id,
76: organization_id,

Line 86: and process_phase = WIP_CONSTANTS.ML_VALIDATION

82: OR p_std_alone = 1 )
83: and wip_entity_id = p_wip_entity_id
84: and organization_id = p_organization_id
85: and load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
86: and process_phase = WIP_CONSTANTS.ML_VALIDATION
87: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
88:
89: Cursor Res_Usage_Cur (p_wip_entity_id number, p_organization_id number) IS
90: select distinct wip_entity_id,

Line 87: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);

83: and wip_entity_id = p_wip_entity_id
84: and organization_id = p_organization_id
85: and load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
86: and process_phase = WIP_CONSTANTS.ML_VALIDATION
87: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
88:
89: Cursor Res_Usage_Cur (p_wip_entity_id number, p_organization_id number) IS
90: select distinct wip_entity_id,
91: organization_id,

Line 102: and process_phase = WIP_CONSTANTS.ML_VALIDATION

98: and wip_entity_id = p_wip_entity_id
99: and organization_id = p_organization_id
100: and load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
101: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
102: and process_phase = WIP_CONSTANTS.ML_VALIDATION
103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
104:
105: Cursor SubRes_Cur (p_wip_entity_id number, p_organization_id number) IS
106: select distinct wip_entity_id,

Line 103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);

99: and organization_id = p_organization_id
100: and load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
101: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
102: and process_phase = WIP_CONSTANTS.ML_VALIDATION
103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
104:
105: Cursor SubRes_Cur (p_wip_entity_id number, p_organization_id number) IS
106: select distinct wip_entity_id,
107: organization_id,

Line 117: and process_phase = WIP_CONSTANTS.ML_VALIDATION

113: OR p_std_alone = 1)
114: and wip_entity_id = p_wip_entity_id
115: and organization_id = p_organization_id
116: and load_type = WIP_JOB_DETAILS.WIP_SUB_RES
117: and process_phase = WIP_CONSTANTS.ML_VALIDATION
118: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
119:
120: Cursor Op_Link_Cur (p_wip_entity_id number, p_organization_id number) IS
121: select distinct wip_entity_id,

Line 118: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

114: and wip_entity_id = p_wip_entity_id
115: and organization_id = p_organization_id
116: and load_type = WIP_JOB_DETAILS.WIP_SUB_RES
117: and process_phase = WIP_CONSTANTS.ML_VALIDATION
118: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
119:
120: Cursor Op_Link_Cur (p_wip_entity_id number, p_organization_id number) IS
121: select distinct wip_entity_id,
122: organization_id,

Line 132: and process_phase = WIP_CONSTANTS.ML_VALIDATION

128: OR p_std_alone = 1)
129: and wip_entity_id = p_wip_entity_id
130: and organization_id = p_organization_id
131: and load_type = WIP_JOB_DETAILS.WIP_OP_LINK
132: and process_phase = WIP_CONSTANTS.ML_VALIDATION
133: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
134:
135: Cursor Serials_Cur (p_wip_entity_id number, p_organization_id number) IS
136: select distinct wip_entity_id,

Line 133: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

129: and wip_entity_id = p_wip_entity_id
130: and organization_id = p_organization_id
131: and load_type = WIP_JOB_DETAILS.WIP_OP_LINK
132: and process_phase = WIP_CONSTANTS.ML_VALIDATION
133: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
134:
135: Cursor Serials_Cur (p_wip_entity_id number, p_organization_id number) IS
136: select distinct wip_entity_id,
137: organization_id,

Line 147: and process_phase = WIP_CONSTANTS.ML_VALIDATION

143: OR p_std_alone = 1)
144: and wip_entity_id = p_wip_entity_id
145: and organization_id = p_organization_id
146: and load_type = WIP_JOB_DETAILS.WIP_SERIAL
147: and process_phase = WIP_CONSTANTS.ML_VALIDATION
148: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
149:
150: x_count number;
151:

Line 148: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);

144: and wip_entity_id = p_wip_entity_id
145: and organization_id = p_organization_id
146: and load_type = WIP_JOB_DETAILS.WIP_SERIAL
147: and process_phase = WIP_CONSTANTS.ML_VALIDATION
148: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
149:
150: x_count number;
151:
152: cur_job job_cur%ROWTYPE ;

Line 515: if (l_logLevel <= wip_constants.trace_logging) then

511: wip_logger.log('Error in WIP_RES_INST_VALIDATIONS.Delete_Resource_Instance,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
512: wip_logger.log(SQLERRM,l_dummy2);
513: raise;
514: end;
515: if (l_logLevel <= wip_constants.trace_logging) then
516: IF x_err_code IS NOT NULL THEN
517: wip_logger.log(x_err_code, l_dummy2);
518: wip_logger.log(x_err_msg, l_dummy2);
519: end if;

Line 530: if (l_logLevel <= wip_constants.trace_logging) then

526: l_cur.organization_id,
527: l_cur.substitution_type,
528: x_err_code,
529: x_err_msg);
530: if (l_logLevel <= wip_constants.trace_logging) then
531: IF x_err_code IS NOT NULL THEN
532: wip_logger.log(x_err_code, l_dummy2);
533: wip_logger.log(x_err_msg, l_dummy2);
534: end if;

Line 545: if (l_logLevel <= wip_constants.trace_logging) then

541: l_cur.organization_id,
542: l_cur.substitution_type,
543: x_err_code,
544: x_err_msg);
545: if (l_logLevel <= wip_constants.trace_logging) then
546: IF x_err_code IS NOT NULL THEN
547: wip_logger.log(x_err_code, l_dummy2);
548: wip_logger.log(x_err_msg, l_dummy2);
549: end if;

Line 1011: if (l_logLevel <= wip_constants.trace_logging) then

1007: x_err_code,
1008: x_err_msg,
1009: x_return_status);
1010:
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||

Line 1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||

1010:
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;

Line 1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||

1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);

Line 1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||

1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop

Line 1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);

1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||

Line 1022: ' St Dt '||to_date(wor_rec.start_date,WIP_CONSTANTS.DATETIME_FMT) ||

1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||
1022: ' St Dt '||to_date(wor_rec.start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1024: end loop;
1025: end if;
1026:

Line 1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);

1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||
1022: ' St Dt '||to_date(wor_rec.start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1024: end loop;
1025: end if;
1026:
1027: WIP_JOB_DTLS_SUBSTITUTIONS.VERIFY_OPERATION

Line 1049: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1045: WHERE group_id = p_group_id
1046: AND parent_header_id = p_parent_header_id
1047: AND wip_entity_id = cur_job.wip_entity_id
1048: AND organization_id = cur_job.organization_id
1049: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1050: AND process_status = WIP_CONSTANTS.ERROR ;
1051:
1052: IF x_count <> 0 THEN
1053: x_err_code := -20239;

Line 1050: AND process_status = WIP_CONSTANTS.ERROR ;

1046: AND parent_header_id = p_parent_header_id
1047: AND wip_entity_id = cur_job.wip_entity_id
1048: AND organization_id = cur_job.organization_id
1049: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1050: AND process_status = WIP_CONSTANTS.ERROR ;
1051:
1052: IF x_count <> 0 THEN
1053: x_err_code := -20239;
1054: x_err_msg := 'VALIDATION ERROR HAPPENED!';

Line 1065: SET process_status = WIP_CONSTANTS.COMPLETED

1061: IF x_err_code IS NULL THEN
1062:
1063: /* set process_status = COMPLETED */
1064: UPDATE wip_job_dtls_interface
1065: SET process_status = WIP_CONSTANTS.COMPLETED
1066: WHERE group_id = p_group_id
1067: AND wip_entity_id = cur_job.wip_entity_id
1068: AND (p_parent_header_id IS NULL OR
1069: (p_parent_header_id IS NOT NULL AND

Line 1072: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1068: AND (p_parent_header_id IS NULL OR
1069: (p_parent_header_id IS NOT NULL AND
1070: parent_header_id = p_parent_header_id))
1071: AND organization_id = cur_job.organization_id
1072: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1073: AND process_status = WIP_CONSTANTS.RUNNING ;
1074:
1075: /* DELETE THE COMPLETED ROWS FROM INTERFACE TABLE */
1076: DELETE from wip_job_dtls_interface

Line 1073: AND process_status = WIP_CONSTANTS.RUNNING ;

1069: (p_parent_header_id IS NOT NULL AND
1070: parent_header_id = p_parent_header_id))
1071: AND organization_id = cur_job.organization_id
1072: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1073: AND process_status = WIP_CONSTANTS.RUNNING ;
1074:
1075: /* DELETE THE COMPLETED ROWS FROM INTERFACE TABLE */
1076: DELETE from wip_job_dtls_interface
1077: WHERE group_id = p_group_id

Line 1081: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1077: WHERE group_id = p_group_id
1078: AND parent_header_id = p_parent_header_id
1079: AND wip_entity_id = cur_job.wip_entity_id
1080: AND organization_id = cur_job.organization_id
1081: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1082: AND process_status = WIP_CONSTANTS.COMPLETED;
1083:
1084: END IF;
1085:

Line 1082: AND process_status = WIP_CONSTANTS.COMPLETED;

1078: AND parent_header_id = p_parent_header_id
1079: AND wip_entity_id = cur_job.wip_entity_id
1080: AND organization_id = cur_job.organization_id
1081: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1082: AND process_status = WIP_CONSTANTS.COMPLETED;
1083:
1084: END IF;
1085:
1086: WIP_JDI_Utils.end_processing_request(cur_job.wip_entity_id,

Line 1120: and wjdi.process_phase = wip_constants.ml_validation

1116: select interface_id
1117: from wip_job_dtls_interface wjdi
1118: where wjdi.group_id = p_group_id
1119: and wjdi.parent_header_id = p_parent_header_id
1120: and wjdi.process_phase = wip_constants.ml_validation
1121: and wjdi.process_status = wip_constants.running
1122: and wjdi.parent_header_id is not null
1123: and ( wjdi.wip_entity_id is not null
1124: or wjdi.organization_id is not null);

Line 1121: and wjdi.process_status = wip_constants.running

1117: from wip_job_dtls_interface wjdi
1118: where wjdi.group_id = p_group_id
1119: and wjdi.parent_header_id = p_parent_header_id
1120: and wjdi.process_phase = wip_constants.ml_validation
1121: and wjdi.process_status = wip_constants.running
1122: and wjdi.parent_header_id is not null
1123: and ( wjdi.wip_entity_id is not null
1124: or wjdi.organization_id is not null);
1125:

Line 1146: set process_status = wip_constants.warning

1142: p_error_type => wip_jdi_utils.msg_error);
1143: end loop;
1144: if(l_error_exists) then
1145: update wip_job_dtls_interface wjdi
1146: set process_status = wip_constants.warning
1147: where group_id = p_group_id
1148: and parent_header_id = p_parent_header_id
1149: and process_phase = wip_constants.ml_validation
1150: and process_status = wip_constants.running

Line 1149: and process_phase = wip_constants.ml_validation

1145: update wip_job_dtls_interface wjdi
1146: set process_status = wip_constants.warning
1147: where group_id = p_group_id
1148: and parent_header_id = p_parent_header_id
1149: and process_phase = wip_constants.ml_validation
1150: and process_status = wip_constants.running
1151: and wjdi.parent_header_id is not null
1152: and ( wjdi.wip_entity_id is not null
1153: or wjdi.organization_id is not null);

Line 1150: and process_status = wip_constants.running

1146: set process_status = wip_constants.warning
1147: where group_id = p_group_id
1148: and parent_header_id = p_parent_header_id
1149: and process_phase = wip_constants.ml_validation
1150: and process_status = wip_constants.running
1151: and wjdi.parent_header_id is not null
1152: and ( wjdi.wip_entity_id is not null
1153: or wjdi.organization_id is not null);
1154:

Line 1165: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);

1161: into l_wip_entity_id, l_organization_id
1162: from wip_job_schedule_interface
1163: where header_id = p_parent_header_id
1164: and group_id = p_group_id
1165: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
1166:
1167: Update wip_job_dtls_interface
1168: Set wip_entity_id = l_wip_entity_id,
1169: organization_id = l_organization_id