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 4111: from wip_dj_close_temp wt, wip_entities we

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

Line 4127: from wip_dj_close_temp tm, wip_entities we

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

Line 4142: delete from wip_dj_close_temp

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