DBA Data[Home] [Help]

PACKAGE: APPS.MRP_LAUNCH_PLAN_PK

Source


1 PACKAGE mrp_launch_plan_pk AUTHID CURRENT_USER AS
2 /* $Header: MRPPLAPS.pls 115.4 2002/11/26 18:55:08 jhegde ship $ */
3 	PROCEDURE 	mrp_launch_plan (
4 						errbuf  OUT NOCOPY VARCHAR2,
5 						retcode OUT NOCOPY NUMBER,
6 						arg_org_id IN NUMBER,
7 						arg_compile_desig IN VARCHAR2,
8 						arg_launch_snapshot IN NUMBER,
9 						arg_launch_planner IN NUMBER,
10 						arg_anchor_date IN VARCHAR2,
11 						arg_plan_horizon IN VARCHAR2 default NULL);
12 
13 	FUNCTION get_crp_status (
14 						app_id IN NUMBER,
15 						dep_app_id IN NUMBER)
16 						RETURN VARCHAR2;
17      PRAGMA RESTRICT_REFERENCES (get_crp_status, WNDS, WNPS);
18 
19 
20 
21 	/*-----------------+
22 	| Define constants |
23 	+-----------------*/
24 
25 	SYS_YES         CONSTANT INTEGER := 1;
26 	SYS_NO          CONSTANT INTEGER := 2;
27 	VERSION                 CONSTANT CHAR(80) :=
28 			'$Header: MRPPLAPS.pls 115.4 2002/11/26 18:55:08 jhegde ship $';
29 
30 END mrp_launch_plan_pk;