1 PACKAGE WIP_SCHEDULING AUTHID CURRENT_USER AS
2 /* $Header: wipsilds.pls 115.7 2002/11/29 18:53:18 simishra ship $ */
3
4 /*
5 This procedure inserts records into WIP_SCHEDULING_INTERFACE
6 for the job identified by the P_WIP_ENTITY_ID parameter.
7
8 It inserts a record for each operation if P_SCHEDULING_LEVEL = 1
9 It inserts a record for each resource if P_SCHEDULING_LEVEL = 2
10
11 Each of these records is inserted with a unique INTERFACE_ID
12 using the sequence WIP_INTERFACE_S. Each record will be
13 assigned GROUP_ID = P_GROUP_ID.
14
15 */
16
17 PROCEDURE LOAD_INTERFACE (
18 P_WIP_ENTITY_ID NUMBER,
19 P_ORGANIZATION_ID NUMBER,
20 P_JOB_INTERFACE_GROUP_ID NUMBER,
21 P_GROUP_ID NUMBER,
22 P_SCHEDULING_LEVEL NUMBER);
23
24 /* This procedure validates and loads information into WIP tables
25 based on information in the WIP_SCHEDULING_INTERFACE_TABLE.
26 */
27 PROCEDURE LOAD_WIP(P_GROUP_ID NUMBER);
28
29
30 /*
31 This procedure is used as a concurrent program to invoke
32 LOAD_WIP.
33 It checks if data are available in WIP_SCHEDULING_INTERFACE with
34 the specified group_id and if the data have
35 process_phase = 2 (validation) and process_status = 1 (pending).
36 If no data are available in the table, it returns a warning (retcode = 1).
37 If errors occur in LOAD_WIP, it returns an error (retcode = 2)
38 */
39
40 PROCEDURE LOAD_WIP_CONCURRENT( errbuf out NOCOPY varchar2,
41 retcode out NOCOPY number,
42 p_group_id number);
43
44
45
46
47 /* This procedure errors out records in the WIP_SCHEDULING_INTERFACE table
48 that do not correspond to existing jobs in the system that are status
49 Unreleased
50 Released
51 Complete
52 Hold
53 */
54
55 PROCEDURE VALIDATE_JOBS(P_GROUP_ID NUMBER);
56 PROCEDURE VALIDATE_SCHEDULING_LEVEL(P_GROUP_ID NUMBER);
57 PROCEDURE VALIDATE_DATES(P_GROUP_ID NUMBER);
58 PROCEDURE VALIDATE_USAGE_RATE(P_GROUP_ID NUMBER);
59 PROCEDURE VALIDATE_OPS_RES_MATCH(P_GROUP_ID NUMBER);
60 PROCEDURE ERROR_ALL_IF_ANY(P_GROUP_ID NUMBER);
61
62 PROCEDURE UPDATE_REQ_DATES(P_WIP_ENTITY_ID NUMBER,
63 P_ORGANIZATION_ID NUMBER);
64
65 PROCEDURE UPDATE_JOB_DATES(P_WIP_ENTITY_ID NUMBER,
66 P_ORGANIZATION_ID NUMBER);
67
68 END WIP_SCHEDULING;