1 PACKAGE MRP_Rel_Plan_PUB AUTHID CURRENT_USER AS
2 /* $Header: MRPPRELS.pls 115.11 2002/11/22 21:49:07 schaudha ship $ */
3
4 -- Start of Comments
5 -- API name MRP_Release_Plan_Sc
6 -- Type Public
7 -- Procedure
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE MRP_RELEASE_PLAN_SC
21 ( arg_log_org_id IN NUMBER
22 , arg_org_id IN NUMBER
23 , arg_compile_desig IN VARCHAR2
24 , arg_user_id IN NUMBER
25 , arg_po_group_by IN NUMBER
26 , arg_po_batch_number IN NUMBER
27 , arg_wip_group_id IN NUMBER
28 , arg_loaded_jobs IN OUT NOCOPY NUMBER
29 , arg_loaded_reqs IN OUT NOCOPY NUMBER
30 , arg_loaded_scheds IN OUT NOCOPY NUMBER
31 , arg_resched_jobs IN OUT NOCOPY NUMBER
32 , arg_resched_reqs IN OUT NOCOPY NUMBER
33 , arg_wip_req_id IN OUT NOCOPY NUMBER
34 , arg_req_load_id IN OUT NOCOPY NUMBER
35 , arg_req_resched_id IN OUT NOCOPY NUMBER
36 , arg_mode IN VARCHAR2 DEFAULT NULL
37 , arg_transaction_id IN NUMBER DEFAULT NULL
38 );
39
40 /** Bug#1519701 : Added a new function get_dock_date **/
41
42 FUNCTION GET_DOCK_DATE
43 ( arg_compile_desig IN VARCHAR2
44 , arg_plan_owning_org IN NUMBER /*2448572*/
45 , arg_calendar_exception_set_id IN NUMBER
46 , arg_calendar_code IN VARCHAR2
47 , arg_implement_date IN DATE
48 , arg_vendor_id IN NUMBER
49 , arg_vendor_site_id IN NUMBER
50 , arg_item_id IN NUMBER
51 , arg_lead_time NUMBER
52 ) RETURN DATE;
53
54 END MRP_Rel_Plan_PUB;