DBA Data[Home] [Help]

PACKAGE: APPS.IGS_RU_GROUP_SET_PKG

Source


1 package IGS_RU_GROUP_SET_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSUI06S.pls 115.4 2002/11/29 04:26:25 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_RUD_SEQUENCE_NUMBER in NUMBER,
7   X_RUG_SEQUENCE_NUMBER in NUMBER,
8   X_MODE in VARCHAR2 default 'R'
9   );
10 procedure LOCK_ROW (
11   X_ROWID in VARCHAR2,
12   X_RUD_SEQUENCE_NUMBER in NUMBER,
13   X_RUG_SEQUENCE_NUMBER in NUMBER
14 );
15 procedure DELETE_ROW (
16   X_ROWID in VARCHAR2
17 );
18 
19 FUNCTION Get_PK_For_Validation (
20     x_rug_sequence_number IN NUMBER,
21     x_rud_sequence_number IN NUMBER
22     ) RETURN BOOLEAN ;
23 
24 PROCEDURE GET_FK_IGS_RU_DESCRIPTION (
25     x_sequence_number IN NUMBER
26     );
27 
28 PROCEDURE GET_FK_IGS_RU_GROUP (
29     x_sequence_number IN NUMBER
30     );
31 
32 PROCEDURE   Check_Constraints (
33                  Column_Name     IN   VARCHAR2    DEFAULT NULL ,
34                  Column_Value    IN   VARCHAR2    DEFAULT NULL
35                                 );
36 PROCEDURE Before_DML (
37     p_action IN VARCHAR2,
38     x_rowid IN VARCHAR2 DEFAULT NULL,
39     x_rug_sequence_number IN NUMBER DEFAULT NULL,
40     x_rud_sequence_number IN NUMBER DEFAULT NULL,
41     x_creation_date IN DATE DEFAULT NULL,
42     x_created_by IN NUMBER DEFAULT NULL,
43     x_last_update_date IN DATE DEFAULT NULL,
44     x_last_updated_by IN NUMBER DEFAULT NULL,
45     x_last_update_login IN NUMBER DEFAULT NULL
46   ) ;
47 
48 end IGS_RU_GROUP_SET_PKG;