1 PACKAGE WIP_CLOSE_UTILITIES AUTHID CURRENT_USER AS
2 /* $Header: wipcluts.pls 115.6 2002/12/12 16:56:46 rmahidha ship $ */
3
4 /* UNCLOSE_JOB
5 DESCRIPTION:
6 This function updates all tables when a job is unclosed.
7 - Changes WIP_ENTITIES.Entity_Type from 3 to 1
8 - Inserts WIP_PERIOD_BALANCES records from Date_Released onward if
9 the job was released
10 RETURNS:
11 1 upon success
12 0 if the unclose fails due to the fact that the period in which
13 the job was closed in is now closed.
14 Note: This DOES NOT clear Date_Closed or change the status of the job
15 */
16
17 FUNCTION UNCLOSE_JOB
18 (P_wip_entity_id NUMBER,
19 P_organization_id NUMBER,
20 P_class_code VARCHAR2) RETURN NUMBER;
21
22 /* CHECK_PENDING_CLOSE takes the wip_entity_id, organization_id, and
23 request_id of a discrete job that is status pending close.
24 It looks at the request id, which should be a close process for the job.
25 If the process has terminated abnormally, this function deletes the row
26 for the job from wip_dj_close_temp and returns the status_type that was
27 stored in WIP_DJ_CLOSE_TEMP. The calling procedure should set the status
28 type in WIP_DISCRETE_JOBS back to that status.
29
30 If the request is running normally, CHECK_PENDING_CLOSE returns 0
31 */
32
33 FUNCTION Check_Pending_Close
34 (P_wip_entity_id NUMBER,
35 P_organization_id NUMBER,
36 P_request_id NUMBER) RETURN NUMBER;
37
38 END WIP_CLOSE_UTILITIES;