PACKAGE: APPS.SHP_GEN_UNIQUE_PKG

Source

1 PACKAGE SHP_GEN_UNIQUE_PKG AUTHID CURRENT_USER as
2 /* $Header: SHPFXUQS.pls 115.0 99/07/16 08:17:28 porting ship $ */
3 --
4 -- Package
5 --   SHP_GEN_UNIQUE_PKG
6 -- Purpose
7 --   Server side generic uniqueness checking functionality
8 -- History
9 --   27-APR-95	JGOREE	Created
10 --
11 
12   --
13   -- PUBLIC VARIABLES
14   --
15 
16   --
17   -- PUBLIC FUNCTIONS
18   --
19 
20   --
21   -- Name
22   --   Gen_Check_Unique
23   -- Purpose
24   --   Checks for duplicates in database
25   -- Arguments
26   --   query_text               query to execute to test for uniqueness
27   --   prod_name		product name to send message for
28   --   msg_name			message to print if duplicate found
29   --
30   -- Notes
31   --   uses DBMS_SQL package
32 
33   PROCEDURE Gen_Check_Unique(query_text VARCHAR2,
34 			 prod_name VARCHAR2,
35 			 msg_name VARCHAR2);
36 
37   PROCEDURE Get_Active_Date(query_text 		IN	VARCHAR2,
38    			    date_fetched 	OUT	DATE);
39 
40 END SHP_GEN_UNIQUE_PKG;