PACKAGE: APPS.IGS_GE_REF_CD_PKG

Source

1 PACKAGE igs_ge_ref_cd_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSMI16S.pls 115.6 2002/11/29 01:13:17 nsidana ship $ */
3 /*************************************************************
4   Created By : sbeerell
5   Date Created By : 09-MAY-2000
6   Purpose :
7   Know limitations, enhancements or remarks
8   Change History
9   Who             When            What
10 
11   (reverse chronological order - newest change first)
12 ***************************************************************/
13 
14  procedure INSERT_ROW (
15       X_ROWID in out NOCOPY VARCHAR2,
16        x_REFERENCE_CODE_ID IN OUT NOCOPY NUMBER,
17        x_REFERENCE_CD_TYPE IN VARCHAR2,
18        x_REFERENCE_CD IN VARCHAR2,
19        x_DESCRIPTION IN VARCHAR2,
20        x_DEFAULT_FLAG IN VARCHAR2,
21       X_MODE in VARCHAR2 default 'R'
22   );
23 
24  procedure LOCK_ROW (
25       X_ROWID in  VARCHAR2,
26        x_REFERENCE_CODE_ID IN NUMBER,
27        x_REFERENCE_CD_TYPE IN VARCHAR2,
28        x_REFERENCE_CD IN VARCHAR2,
29        x_DESCRIPTION IN VARCHAR2,
30        x_DEFAULT_FLAG IN VARCHAR2  );
31  procedure UPDATE_ROW (
32       X_ROWID in  VARCHAR2,
33        x_REFERENCE_CODE_ID IN NUMBER,
34        x_REFERENCE_CD_TYPE IN VARCHAR2,
35        x_REFERENCE_CD IN VARCHAR2,
36        x_DESCRIPTION IN VARCHAR2,
37        x_DEFAULT_FLAG IN VARCHAR2,
38       X_MODE in VARCHAR2 default 'R'
39   );
40 
41  procedure ADD_ROW (
42       X_ROWID in out NOCOPY VARCHAR2,
43       x_REFERENCE_CODE_ID IN OUT NOCOPY NUMBER,
44        x_REFERENCE_CD_TYPE IN VARCHAR2,
45        x_REFERENCE_CD IN VARCHAR2,
46        x_DESCRIPTION IN VARCHAR2,
47        x_DEFAULT_FLAG IN VARCHAR2,
48       X_MODE in VARCHAR2 default 'R'
49   ) ;
50 
51 procedure DELETE_ROW (
52   X_ROWID in VARCHAR2
53 ) ;
54   FUNCTION Get_PK_For_Validation (
55     x_reference_code_id IN NUMBER
56     ) RETURN BOOLEAN ;
57 
58   FUNCTION Get_UK_For_Validation (
59     x_reference_cd_type IN VARCHAR2,
60     x_reference_cd IN VARCHAR2
61     ) RETURN BOOLEAN;
62 
63   PROCEDURE Get_FK_Igs_Ge_Ref_Cd_Type (
64     x_reference_cd_type IN VARCHAR2
65     );
66 
67   PROCEDURE Check_Constraints (
68 		 Column_Name IN VARCHAR2  DEFAULT NULL,
69 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
70   PROCEDURE Before_DML (
71     p_action IN VARCHAR2,
72     x_rowid IN VARCHAR2 DEFAULT NULL,
73     x_reference_code_id IN NUMBER DEFAULT NULL,
74     x_reference_cd_type IN VARCHAR2 DEFAULT NULL,
75     x_reference_cd IN VARCHAR2 DEFAULT NULL,
76     x_description IN VARCHAR2 DEFAULT NULL,
77     x_default_flag IN VARCHAR2 DEFAULT NULL,
78     x_creation_date IN DATE DEFAULT NULL,
79     x_created_by IN NUMBER DEFAULT NULL,
80     x_last_update_date IN DATE DEFAULT NULL,
81     x_last_updated_by IN NUMBER DEFAULT NULL,
82     x_last_update_login IN NUMBER DEFAULT NULL
83  );
84 END igs_ge_ref_cd_pkg;