PACKAGE: APPS.AHL_UTIL_PC_PKG

Source

1 PACKAGE AHL_UTIL_PC_PKG AS
2 /* $Header: AHLUPCXS.pls 120.0 2005/05/26 10:59:48 appldev noship $ */
3 
4 	G_PKG_NAME   CONSTANT  VARCHAR2(30) := 'AHL_PC_UTIL_PKG';
5 
6 	-----------------------
7 	-- Declare Functions --
8 	-----------------------
9 	--  Start of Comments  --
10 	--
11 	--  Procedure name    	: Get_fmp_pc_node
12 	--  Type        	:
13 	--  Function    	: Returns boolean based on availabilty of data.
14 	--  Pre-reqs    	:
15 	--
16 	--  Standard IN  Parameters :
17 	--      p_pc_node_id                   IN      NUMBER       Default  NULL
18 	--      p_inventory_id                 IN      VARCHAR2     Default  NULL
19 	--
20 	--  Standard Return value :
21 	--      BOOLEAN
22 	--
23 	--  Version :
24 	--  	Initial Version   1.0
25 	--
26 	--  End of Comments  --
27 
28         FUNCTION get_fmp_pc_node
29         (
30                 p_pc_node_id		IN	NUMBER	:= NULL,
31                 p_inventory_id      	IN	NUMBER 	:= NULL
32         )
33         RETURN BOOLEAN;
34 
35 	-----------------------
36 	-- Declare Functions --
37 	-----------------------
38 	--  Start of Comments  --
39 	--
40 	--  Procedure name    	: get_uc_node
41 	--  Type        	:
42 	--  Function    	: Returns boolean based on availabilty of data.
43 	--  Pre-reqs    	:
44 	--
45 	--  Standard IN  Parameters :
46 	--      p_pc_node_id                   IN      NUMBER       Default  NULL
47 	--      p_Item_Instance_ID             IN      VARCHAR2     Default  NULL
48 	--
49 	--  Standard Return value :
50 	--	BOOLEAN
51 	--
52 	--  Version :
53 	--  	Initial Version   1.0
54 	--
55 	--  End of Comments  --
56 
57 
58         FUNCTION get_uc_node
59         (
60                 p_pc_node_id		IN	NUMBER 	:= NULL,
61                 p_Item_Instance_ID  	IN	NUMBER 	:= NULL
62         )
63         RETURN BOOLEAN;
64 
65         -----------------------
66 	-- Declare Functions --
67 	-----------------------
68 	--  Start of Comments  --
69 	--
70 	--  Procedure name    	: is_pc_complete
71 	--  Type        	:
72 	--  Function    	: Returns 0/-1 based on availabilty of data.
73 	--  Pre-reqs    	:
74 	--
75 	--  Standard IN  Parameters :
76 	--      p_pc_header_id               IN      NUMBER       Default  NULL
77 	--
78 	--  Standard Return value :
79 	--  	NUMBER		: Returns 0 if no need for check completion, -1 otherwise
80 	--
81 	--  Version :
82 	--  	Initial Version   1.0
83 	--
84 	--  End of Comments  --
85 
86 	FUNCTION is_pc_complete
87 	(
88 		p_pc_header_id 		IN 	NUMBER 	:= NULL
89 	)
90 	RETURN NUMBER;
91 
92         PRAGMA RESTRICT_REFERENCES(get_fmp_pc_node,WNPS,RNPS,WNDS);
93 
94 END AHL_UTIL_PC_PKG;