APPS.WSMPUTIL dependencies on WIP_DJ_CLOSE_TEMP

Line 4001: -- the table WIP_DJ_CLOSE_TEMP and validate these records.

3997: --
3998: -- This new procedure will be used by WIP to determine if the lot based jobs
3999: -- can be closed or not. The API will accept 2 parameters: group_id and orgn_id
4000: -- Using these parameters, the API would identify all the lot based jobs in
4001: -- the table WIP_DJ_CLOSE_TEMP and validate these records.
4002: -- All jobs that fail in validation process would be printed and the value of
4003: -- column STATUS_TYPE in wip_dj_close_temp would be updated to 99.
4004: -- In the end, the status of these jobs in wip_discrete_jobs will be updated to 15 (Failed Close)
4005: -- and records in wip_dj_close_temp with status 99 will be deleted.

Line 4003: -- column STATUS_TYPE in wip_dj_close_temp would be updated to 99.

3999: -- can be closed or not. The API will accept 2 parameters: group_id and orgn_id
4000: -- Using these parameters, the API would identify all the lot based jobs in
4001: -- the table WIP_DJ_CLOSE_TEMP and validate these records.
4002: -- All jobs that fail in validation process would be printed and the value of
4003: -- column STATUS_TYPE in wip_dj_close_temp would be updated to 99.
4004: -- In the end, the status of these jobs in wip_discrete_jobs will be updated to 15 (Failed Close)
4005: -- and records in wip_dj_close_temp with status 99 will be deleted.
4006: --
4007: -- x_err_code will be set to 0 if there are any unprocessed/uncosted txn.

Line 4005: -- and records in wip_dj_close_temp with status 99 will be deleted.

4001: -- the table WIP_DJ_CLOSE_TEMP and validate these records.
4002: -- All jobs that fail in validation process would be printed and the value of
4003: -- column STATUS_TYPE in wip_dj_close_temp would be updated to 99.
4004: -- In the end, the status of these jobs in wip_discrete_jobs will be updated to 15 (Failed Close)
4005: -- and records in wip_dj_close_temp with status 99 will be deleted.
4006: --
4007: -- x_err_code will be set to 0 if there are any unprocessed/uncosted txn.
4008: -- Otherwise, x_err_code will have a value of 1.
4009: --

Line 4036: update wip_dj_close_temp wt

4032:
4033: -- bugfix 3080643. added check for WLT interface in WSJI and WRJI, and Move Txn interface in WLMTI
4034: -- replace previous union query with check exists
4035:
4036: update wip_dj_close_temp wt
4037: set status_type = 99
4038: where wt.group_id = p_group_id
4039: and wt.organization_id = p_organization_id
4040: and wt.status_type <> 99

Line 4113: from wip_dj_close_temp wt, wip_entities we

4109: update wip_discrete_jobs
4110: set status_type = 15 -- Failed Close.
4111: where wip_entity_id in
4112: (select wt.wip_entity_id
4113: from wip_dj_close_temp wt, wip_entities we
4114: where wt.group_id = p_group_id
4115: and wt.organization_id = p_organization_id
4116: and wt.status_type = 99
4117: and wt.wip_entity_id = we.wip_entity_id

Line 4125: from wip_dj_close_temp tm, wip_entities we

4121: fnd_file.put_line(fnd_file.log, 'Following jobs failed the close process because of unprocessed/uncosted WIP lot transactions or Move transactions:');
4122:
4123: -- Print the entities which FAILED CLOSE
4124: for rec in (select tm.wip_entity_id, we.wip_entity_name
4125: from wip_dj_close_temp tm, wip_entities we
4126: where tm.wip_entity_id = we.wip_entity_id
4127: and tm.organization_id = we.organization_id
4128: and tm.group_id = p_group_id
4129: and tm.organization_id = p_organization_id

Line 4139: delete from wip_dj_close_temp

4135:
4136: end if;
4137:
4138: -- Clean up the temp table.
4139: delete from wip_dj_close_temp
4140: where group_id = p_group_id
4141: and organization_id = p_organization_id
4142: and status_type = 99;
4143: