PACKAGE: APPS.IGS_PE_DYNAMIC_PERSID_GROUP

Source

1 PACKAGE IGS_PE_DYNAMIC_PERSID_GROUP AS
2 /* $Header: IGSPEDGS.pls 120.1 2006/02/02 06:47:34 skpandey noship $ */
3 
4   FUNCTION IGS_GET_DYNAMIC_SQL(p_GroupID IN              igs_pe_persid_group_all.group_id%TYPE,
5                                 p_Status  OUT NOCOPY      VARCHAR2)
6   RETURN  VARCHAR2;
7 
8   FUNCTION GET_DYNAMIC_SQL(p_GroupID IN              igs_pe_persid_group_all.group_id%TYPE,
9                            p_Status  OUT NOCOPY      VARCHAR2,
10 			   p_group_type OUT NOCOPY   igs_pe_persid_group_v.group_type%TYPE)
11   RETURN  VARCHAR2;
12 
13   FUNCTION GET_DYNAMIC_SQL_FROM_FILE(
14      p_FileName	IN     		IGS_PE_DYN_SQLSEGS.file_name%TYPE,
15      p_Status	OUT NOCOPY 	VARCHAR2) RETURN VARCHAR2;
16 
17   FUNCTION DYN_PIG_MEMBER(p_GroupID  IN   NUMBER,
18                           p_PersonID IN   NUMBER)
19   RETURN NUMBER;
20 
21   FUNCTION IGS_Post_Save_Document(p_WorkBookOwner IN VARCHAR2,
22                        		  p_WorkBookName  IN VARCHAR2,
23                        		  p_WorkSheetName IN VARCHAR2,
24                        		  p_Sequence      IN NUMBER,
25                        		  p_SQLSegment    IN varchar2)
26   RETURN NUMBER;
27 
28 
29 END IGS_PE_DYNAMIC_PERSID_GROUP;