PACKAGE: APPS.IGS_PS_USEC_REF_CD_PKG

Source

1 PACKAGE igs_ps_usec_ref_cd_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI1HS.pls 115.7 2003/05/09 06:39:12 sarakshi ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5       x_UNIT_SECTION_REFERENCE_CD_ID IN OUT NOCOPY NUMBER,
6       x_UNIT_SECTION_REFERENCE_ID IN NUMBER,
7       X_MODE in VARCHAR2 default 'R'  ,
8       x_reference_code_type  IN VARCHAR2 DEFAULT NULL,
9       x_reference_code       IN VARCHAR2 DEFAULT NULL,
10       x_reference_code_desc  IN VARCHAR2 DEFAULT NULL
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15       x_UNIT_SECTION_REFERENCE_CD_ID IN NUMBER,
16       x_UNIT_SECTION_REFERENCE_ID IN NUMBER ,
17       x_reference_code_type  IN VARCHAR2 DEFAULT NULL,
18       x_reference_code       IN VARCHAR2 DEFAULT NULL,
19       x_reference_code_desc  IN VARCHAR2 DEFAULT NULL);
20  procedure UPDATE_ROW (
21       X_ROWID in  VARCHAR2,
22       x_UNIT_SECTION_REFERENCE_CD_ID IN NUMBER,
23       x_UNIT_SECTION_REFERENCE_ID IN NUMBER,
24       X_MODE in VARCHAR2 default 'R'  ,
25       x_reference_code_type  IN VARCHAR2 DEFAULT NULL,
26       x_reference_code       IN VARCHAR2 DEFAULT NULL,
27       x_reference_code_desc  IN VARCHAR2 DEFAULT NULL
28   );
29 
30  procedure ADD_ROW (
31       X_ROWID in out NOCOPY VARCHAR2,
32       x_UNIT_SECTION_REFERENCE_CD_ID IN OUT NOCOPY NUMBER,
33       x_UNIT_SECTION_REFERENCE_ID IN NUMBER,
34       X_MODE in VARCHAR2 default 'R'  ,
35       x_reference_code_type  IN VARCHAR2 DEFAULT NULL,
36       x_reference_code       IN VARCHAR2 DEFAULT NULL,
37       x_reference_code_desc  IN VARCHAR2 DEFAULT NULL
38   ) ;
39 
40 procedure DELETE_ROW (
41   X_ROWID in VARCHAR2
42 ) ;
43   FUNCTION Get_PK_For_Validation (
44     x_unit_section_reference_cd_id IN NUMBER
45     ) RETURN BOOLEAN ;
46 
47   FUNCTION Get_UK_For_Validation (
48     x_unit_section_reference_id IN NUMBER,
49     x_reference_code_type IN VARCHAR2,
50     x_reference_code IN VARCHAR2
51     ) RETURN BOOLEAN;
52 
53   PROCEDURE Get_FK_Igs_Ps_Usec_Ref (
54     x_unit_section_reference_id IN NUMBER
55     );
56 
57   PROCEDURE Get_FK_Igs_Ge_Ref_Cd_Type (
58     x_reference_code_type IN VARCHAR2
59     );
60 
61   PROCEDURE Get_UFK_Igs_Ge_Ref_Cd (
62     x_reference_code_type IN VARCHAR2,
63     x_reference_code  IN VARCHAR2
64     );
65 
66   PROCEDURE Check_Constraints (
67 		 Column_Name IN VARCHAR2  DEFAULT NULL,
68 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
69   PROCEDURE Before_DML (
70     p_action IN VARCHAR2,
71     x_rowid IN VARCHAR2 DEFAULT NULL,
72     x_unit_section_reference_cd_id IN NUMBER DEFAULT NULL,
73     x_unit_section_reference_id IN NUMBER DEFAULT NULL,
74     x_creation_date IN DATE DEFAULT NULL,
75     x_created_by IN NUMBER DEFAULT NULL,
76     x_last_update_date IN DATE DEFAULT NULL,
77     x_last_updated_by IN NUMBER DEFAULT NULL,
78     x_last_update_login IN NUMBER DEFAULT NULL,
79     x_reference_code_type  IN VARCHAR2 DEFAULT NULL,
80     x_reference_code       IN VARCHAR2 DEFAULT NULL,
81     x_reference_code_desc  IN VARCHAR2 DEFAULT NULL
82  );
83 END igs_ps_usec_ref_cd_pkg;