APPS.WIP_JDI_UTILS dependencies on WIP_JOB_DETAILS

Line 19: IF (WIP_JOB_DETAILS.STD_ALONE = 1) THEN

15: -- Do autonomous commit;
16:
17: begin
18:
19: IF (WIP_JOB_DETAILS.STD_ALONE = 1) THEN
20: Update WIP_JOB_DTLS_INTERFACE
21: SET interface_id = WIP_INTERFACE_S.NEXTVAL,
22: process_status = WIP_CONSTANTS.RUNNING
23: WHERE group_id = p_group_id

Line 116: if WIP_JOB_DETAILS.std_alone = 1 THEN

112:
113: -- If it stand alone, insert the interface_id of details
114: -- else insert the interface_id of job header.
115:
116: if WIP_JOB_DETAILS.std_alone = 1 THEN
117:
118: WIP_INTERFACE_ERR_Utils.add_error(x_jdi_interface_id,
119: x_error_msg,
120: x_error_type);

Line 122: elsif WIP_JOB_DETAILS.std_alone = 0 then

118: WIP_INTERFACE_ERR_Utils.add_error(x_jdi_interface_id,
119: x_error_msg,
120: x_error_type);
121:
122: elsif WIP_JOB_DETAILS.std_alone = 0 then
123:
124: WIP_INTERFACE_ERR_Utils.add_error(WIP_JSI_Utils.current_interface_id,
125: x_error_msg,
126: x_error_type);

Line 163: IF WIP_JOB_DETAILS.std_alone = 1 THEN

159: x_count number;
160:
161: BEGIN
162:
163: IF WIP_JOB_DETAILS.std_alone = 1 THEN
164:
165: select count(*) into x_count
166: from wip_job_dtls_interface
167: where wip_entity_id = p_wip_entity_id

Line 202: IF WIP_JOB_DETAILS.std_alone = 1 THEN

198: p_organization_id number := null) IS
199:
200: BEGIN
201: begin
202: IF WIP_JOB_DETAILS.std_alone = 1 THEN
203:
204: Update WIP_JOB_DTLS_INTERFACE
205: SET process_status = WIP_CONSTANTS.ERROR
206: WHERE wip_entity_id = p_wip_entity_id

Line 209: ELSIF WIP_JOB_DETAILS.std_alone = 0 THEN

205: SET process_status = WIP_CONSTANTS.ERROR
206: WHERE wip_entity_id = p_wip_entity_id
207: AND organization_id = p_organization_id;
208:
209: ELSIF WIP_JOB_DETAILS.std_alone = 0 THEN
210:
211: Update WIP_JOB_DTLS_INTERFACE
212: SET process_status = WIP_CONSTANTS.ERROR
213: WHERE group_id = p_group_id