PACKAGE: APPS.IGS_OR_ORG_INST_TYPE_PKG

Source

1 PACKAGE igs_or_org_inst_type_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSOI19S.pls 115.8 2002/11/29 01:42:06 nsidana ship $ */
3  procedure INSERT_ROW (
4        X_ROWID in out NOCOPY VARCHAR2,
5        x_INSTITUTION_TYPE IN VARCHAR2,
6        x_DESCRIPTION IN VARCHAR2,
7        x_SYSTEM_INST_TYPE VARCHAR2,
8        x_CLOSE_IND IN VARCHAR2,
9        X_MODE in VARCHAR2 default 'R'  ,
10        X_ORG_ID in NUMBER
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_INSTITUTION_TYPE IN VARCHAR2,
16        x_DESCRIPTION IN VARCHAR2,
17        x_SYSTEM_INST_TYPE VARCHAR2,
18        x_CLOSE_IND IN VARCHAR2 );
19 
20  procedure UPDATE_ROW (
21        X_ROWID in  VARCHAR2,
22        x_INSTITUTION_TYPE IN VARCHAR2,
23        x_DESCRIPTION IN VARCHAR2,
24        x_SYSTEM_INST_TYPE VARCHAR2,
25        x_CLOSE_IND IN VARCHAR2,
26        X_MODE in VARCHAR2 default 'R'
27   );
28 
29  procedure ADD_ROW (
30        X_ROWID in out NOCOPY VARCHAR2,
31        x_INSTITUTION_TYPE IN VARCHAR2,
32        x_DESCRIPTION IN VARCHAR2,
33        x_SYSTEM_INST_TYPE VARCHAR2,
34        x_CLOSE_IND IN VARCHAR2,
35        X_MODE in VARCHAR2 default 'R'  ,
36        X_ORG_ID in NUMBER
37   ) ;
38 
39 procedure DELETE_ROW (
40   X_ROWID in VARCHAR2
41 ) ;
42   FUNCTION Get_PK_For_Validation (
43     x_institution_type IN VARCHAR2
44     ) RETURN BOOLEAN ;
45 
46   PROCEDURE Check_Constraints (
47 		 Column_Name IN VARCHAR2  DEFAULT NULL,
48 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
49   PROCEDURE Before_DML (
50     p_action IN VARCHAR2,
51     x_rowid IN VARCHAR2 DEFAULT NULL,
52     x_institution_type IN VARCHAR2 DEFAULT NULL,
53     x_description IN VARCHAR2 DEFAULT NULL,
54     x_SYSTEM_INST_TYPE VARCHAR2 DEFAULT NULL,
55     x_close_ind IN VARCHAR2 DEFAULT NULL,
56     x_creation_date IN DATE DEFAULT NULL,
57     x_created_by IN NUMBER DEFAULT NULL,
58     x_last_update_date IN DATE DEFAULT NULL,
59     x_last_updated_by IN NUMBER DEFAULT NULL,
60     x_last_update_login IN NUMBER DEFAULT NULL,
61     X_ORG_ID in NUMBER DEFAULT NULL
62  );
63 END igs_or_org_inst_type_pkg;