PACKAGE: APPS.IGS_RU_SET_PKG

Source

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