1 PACKAGE WIP_UPDATE_SETUP_RESOURCES AUTHID CURRENT_USER AS
2 /* $Header: wpusetrs.pls 115.5 2002/11/29 15:03:36 simishra ship $ */
3
4
5 TYPE Number_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6
7 PROCEDURE UPDATE_SETUP_RESOURCES_PUB(p_wip_entity_id IN NUMBER,
8 p_organization_id IN NUMBER,
9 p_list_weid IN Number_Tbl_Type,
10 x_status OUT NOCOPY VARCHAR2,
11 x_msg_count OUT NOCOPY NUMBER,
12 x_msg_data OUT NOCOPY VARCHAR2);
13
14
15 PROCEDURE UPDATE_SETUP_RESOURCES_PUB(p_wip_entity_id IN NUMBER,
16 p_organization_id IN NUMBER,
17 x_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2);
20
21 PROCEDURE DELETE_SETUP_RESOURCES_PUB(p_wip_entity_id IN NUMBER,
22 p_organization_id IN NUMBER);
23
24 -- ADD_SCHEDULED_JOBS: adds the table of wip_entity_ids to a private global
25 -- table. This global table represents all the jobs
26 -- that were scheduled in CBS scheduling run
27 PROCEDURE ADD_SCHEDULED_JOBS(p_list_weid IN Number_Tbl_Type);
28
29 -- DELETE_SCHEDULED_JOBS_TBL: deletes the records in the private global table
30 PROCEDURE DELETE_SCHEDULED_JOBS_TBL;
31
32
33
34 END WIP_UPDATE_SETUP_RESOURCES;