APPS.WIP_JOB_DETAILS dependencies on WIP_JOB_DTLS_INTERFACE

Line 15: from wip_job_dtls_interface

11:
12: Cursor Job_Cur IS
13: select distinct wip_entity_id,
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) ;

Line 24: from wip_job_dtls_interface

20:
21: Cursor wdj_cur IS
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:

Line 33: from wip_job_dtls_interface

29: Cursor Oper_Cur (p_wip_entity_id number, p_organization_id number) IS
30: select distinct wip_entity_id,
31: organization_id,
32: load_type, substitution_type
33: from wip_job_dtls_interface
34: where group_id = p_group_id
35: and ((p_std_alone = 0
36: and parent_header_id = p_parent_header_id)
37: OR p_std_alone = 1)

Line 48: from wip_job_dtls_interface

44: Cursor Res_Cur (p_wip_entity_id number, p_organization_id number) IS
45: select distinct wip_entity_id,
46: organization_id,
47: load_type, substitution_type
48: from wip_job_dtls_interface
49: where group_id = p_group_id
50: and ((p_std_alone = 0
51: and parent_header_id = p_parent_header_id)
52: OR p_std_alone = 1)

Line 63: from wip_job_dtls_interface

59: Cursor ResInst_Cur (p_wip_entity_id number, p_organization_id number) IS
60: select distinct wip_entity_id,
61: organization_id,
62: load_type, substitution_type
63: from wip_job_dtls_interface
64: where group_id = p_group_id
65: and ((p_std_alone = 0
66: and parent_header_id = p_parent_header_id)
67: OR p_std_alone = 1)

Line 78: from wip_job_dtls_interface

74: Cursor Req_Cur (p_wip_entity_id number, p_organization_id number) IS
75: select distinct wip_entity_id,
76: organization_id,
77: load_type, substitution_type
78: from wip_job_dtls_interface
79: where group_id = p_group_id
80: and ((p_std_alone = 0
81: and parent_header_id = p_parent_header_id)
82: OR p_std_alone = 1 )

Line 93: from wip_job_dtls_interface

89: Cursor Res_Usage_Cur (p_wip_entity_id number, p_organization_id number) IS
90: select distinct wip_entity_id,
91: organization_id,
92: load_type, substitution_type
93: from wip_job_dtls_interface
94: where group_id = p_group_id
95: and ((p_std_alone = 0
96: and parent_header_id = p_parent_header_id)
97: OR p_std_alone = 1)

Line 109: from wip_job_dtls_interface

105: Cursor SubRes_Cur (p_wip_entity_id number, p_organization_id number) IS
106: select distinct wip_entity_id,
107: organization_id,
108: load_type, substitution_type
109: from wip_job_dtls_interface
110: where group_id = p_group_id
111: and ((p_std_alone = 0
112: and parent_header_id = p_parent_header_id)
113: OR p_std_alone = 1)

Line 124: from wip_job_dtls_interface

120: Cursor Op_Link_Cur (p_wip_entity_id number, p_organization_id number) IS
121: select distinct wip_entity_id,
122: organization_id,
123: load_type, substitution_type
124: from wip_job_dtls_interface
125: where group_id = p_group_id
126: and ((p_std_alone = 0
127: and parent_header_id = p_parent_header_id)
128: OR p_std_alone = 1)

Line 139: from wip_job_dtls_interface

135: Cursor Serials_Cur (p_wip_entity_id number, p_organization_id number) IS
136: select distinct wip_entity_id,
137: organization_id,
138: load_type, substitution_type
139: from wip_job_dtls_interface
140: where group_id = p_group_id
141: and ((p_std_alone = 0
142: and parent_header_id = p_parent_header_id)
143: OR p_std_alone = 1)

Line 1044: from WIP_JOB_DTLS_INTERFACE

1040:
1041:
1042: SELECT count(*)
1043: INTO x_count
1044: from WIP_JOB_DTLS_INTERFACE
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

Line 1064: UPDATE wip_job_dtls_interface

1060:
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

Line 1076: DELETE from wip_job_dtls_interface

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
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

Line 1117: from wip_job_dtls_interface wjdi

1113: x_statement varchar(500);
1114:
1115: cursor c_invalid_rows is
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

Line 1145: update wip_job_dtls_interface wjdi

1141: p_text => substr(fnd_message.get,1,500),
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

Line 1167: Update wip_job_dtls_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
1170: where group_id = p_group_id
1171: and parent_header_id = p_parent_header_id