1 PACKAGE WIP_MASS_LOAD_PROCESSOR AUTHID CURRENT_USER AS
2 /* $Header: wipmlprs.pls 115.9 2002/12/03 10:12:23 rmahidha ship $ */
3
4
5 /* This procedure is a wrapper for the RELEASE stored procedure. It is
6 called from the WIP Mass Load Exploder. It returns 1 if the
7 job is released successfully, 0 otherwise.
8 */
9 PROCEDURE ML_Release(P_Wip_Entity_Id IN NUMBER,
10 P_Organization_Id IN NUMBER,
11 P_Class_Code IN VARCHAR2,
12 P_New_Status_Type IN NUMBER,
13 P_Success_Flag OUT NOCOPY NUMBER,
14 P_Error_Msg OUT NOCOPY VARCHAR2,
15 P_Release_Date IN Date DEFAULT NULL); /* 2424987 */
16
17 /* This procedure is a wrapper for both the release and unrelease
18 procedures. P_Success_Flag = 0 if the action fails, 1 if it
19 succeeds.
20
21 The routine assumes that either P_New or P_Old is 1 (Unreleased)
22 but not both.
23 */
24 PROCEDURE ML_Status_Change(P_Wip_Entity_Id IN NUMBER,
25 P_Organization_Id IN NUMBER,
26 P_Class_Code IN VARCHAR2,
27 P_New_Status_Type IN NUMBER,
28 P_Old_Status_Type IN NUMBER,
29 P_Success_Flag OUT NOCOPY NUMBER,
30 P_Error_Msg OUT NOCOPY VARCHAR2,
31 P_Release_Date in Date DEFAULT NULL); /* 2424987 */
32
33 /* DELETE_COMPLETED_RECORDS (GROUP_ID)
34
35 This procedure deletes records from the WIP_JOB_SCHEDULE_INTERFACE table
36 that were successfully loaded by the Mass Load Process.
37
38 It only acts on records in the interface table that have
39 WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID = Group_Id
40 */
41 PROCEDURE Delete_Completed_Records(P_Group_Id IN NUMBER);
42
43 /* This procedure sets the Process Status to Error for all records in a
44 P_Group_Id whenever a SQL error is found.
45 */
46
47 PROCEDURE Raise_Sql_Error(P_Group_Id IN NUMBER);
48
49 END WIP_MASS_LOAD_PROCESSOR;