PACKAGE: APPS.IGS_PS_UNIT_OFR_MODE_PKG

Source

1 PACKAGE igs_ps_unit_ofr_mode_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI0TS.pls 115.6 2002/11/29 01:59:55 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_CD IN VARCHAR2,
6        x_VERSION_NUMBER IN NUMBER,
7        x_OFFERING_MODE IN VARCHAR2,
8       X_MODE in VARCHAR2 default 'R'
9   );
10 
11  procedure LOCK_ROW (
12       X_ROWID in  VARCHAR2,
13        x_UNIT_CD IN VARCHAR2,
14        x_VERSION_NUMBER IN NUMBER,
15        x_OFFERING_MODE IN VARCHAR2  );
16 
17 procedure DELETE_ROW (
18   X_ROWID in VARCHAR2
19 ) ;
20   FUNCTION Get_PK_For_Validation (
21     x_version_number IN NUMBER,
22     x_offering_mode IN VARCHAR2,
23     x_unit_cd IN VARCHAR2
24     ) RETURN BOOLEAN ;
25 
26   PROCEDURE Get_FK_Igs_Ps_Unit_Ver (
27     x_unit_cd IN VARCHAR2,
28     x_version_number IN NUMBER
29     );
30 
31   PROCEDURE Check_Constraints (
32 		 Column_Name IN VARCHAR2  DEFAULT NULL,
33 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
34   PROCEDURE Before_DML (
35     p_action IN VARCHAR2,
36     x_rowid IN VARCHAR2 DEFAULT NULL,
37     x_unit_cd IN VARCHAR2 DEFAULT NULL,
38     x_version_number IN NUMBER DEFAULT NULL,
39     x_offering_mode IN VARCHAR2 DEFAULT NULL,
40     x_creation_date IN DATE DEFAULT NULL,
41     x_created_by IN NUMBER DEFAULT NULL,
42     x_last_update_date IN DATE DEFAULT NULL,
43     x_last_updated_by IN NUMBER DEFAULT NULL,
44     x_last_update_login IN NUMBER DEFAULT NULL
45  );
46 END igs_ps_unit_ofr_mode_pkg;