PACKAGE: APPS.IGS_AD_ROOM_PKG

Source

1 PACKAGE igs_ad_room_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAIB5S.pls 115.8 2003/10/30 13:17:33 akadam ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5 			X_ORG_ID in NUMBER,
6        x_ROOM_ID IN OUT NOCOPY NUMBER,
7        x_BUILDING_ID IN NUMBER,
8        x_ROOM_CD IN VARCHAR2,
9        x_DESCRIPTION IN VARCHAR2,
10        x_PRIMARY_USE_CD IN VARCHAR2,
11        x_CAPACITY IN NUMBER,
12        x_CLOSED_IND IN VARCHAR2,
13       X_MODE in VARCHAR2 default 'R'
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_ROOM_ID IN NUMBER,
19        x_BUILDING_ID IN NUMBER,
20        x_ROOM_CD IN VARCHAR2,
21        x_DESCRIPTION IN VARCHAR2,
22        x_PRIMARY_USE_CD IN VARCHAR2,
23        x_CAPACITY IN NUMBER,
24        x_CLOSED_IND IN VARCHAR2  );
25  procedure UPDATE_ROW (
26       X_ROWID in  VARCHAR2,
27        x_ROOM_ID IN NUMBER,
28        x_BUILDING_ID IN NUMBER,
29        x_ROOM_CD IN VARCHAR2,
30        x_DESCRIPTION IN VARCHAR2,
31        x_PRIMARY_USE_CD IN VARCHAR2,
32        x_CAPACITY IN NUMBER,
33        x_CLOSED_IND IN VARCHAR2,
34       X_MODE in VARCHAR2 default 'R'
35   );
36 
37  procedure ADD_ROW (
38       X_ROWID in out NOCOPY VARCHAR2,
39 			X_ORG_ID in NUMBER,
40        x_ROOM_ID IN OUT NOCOPY NUMBER,
41        x_BUILDING_ID IN NUMBER,
42        x_ROOM_CD IN VARCHAR2,
43        x_DESCRIPTION IN VARCHAR2,
44        x_PRIMARY_USE_CD IN VARCHAR2,
45        x_CAPACITY IN NUMBER,
46        x_CLOSED_IND IN VARCHAR2,
47       X_MODE in VARCHAR2 default 'R'
48   ) ;
49 
50 procedure DELETE_ROW (
51   X_ROWID in VARCHAR2
52 ) ;
53   FUNCTION Get_PK_For_Validation (
54     x_room_id IN NUMBER ,
55     x_closed_ind IN VARCHAR2 DEFAULT NULL
56     ) RETURN BOOLEAN ;
57 
58   FUNCTION Get_UK_For_Validation (
59     x_building_id IN NUMBER,
60     x_room_cd IN VARCHAR2 ,
61     x_closed_ind IN VARCHAR2 DEFAULT NULL
62     ) RETURN BOOLEAN;
63 
64   PROCEDURE Get_FK_Igs_Ad_Building (
65     x_building_id IN NUMBER
66     );
67 
68   PROCEDURE Check_Constraints (
69 		 Column_Name IN VARCHAR2  DEFAULT NULL,
70 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
71   PROCEDURE Before_DML (
72     p_action IN VARCHAR2,
73     x_rowid IN VARCHAR2 DEFAULT NULL,
74 		X_ORG_ID IN NUMBER DEFAULT NULL,
75     x_room_id IN NUMBER DEFAULT NULL,
76     x_building_id IN NUMBER DEFAULT NULL,
77     x_room_cd IN VARCHAR2 DEFAULT NULL,
78     x_description IN VARCHAR2 DEFAULT NULL,
79     x_primary_use_cd IN VARCHAR2 DEFAULT NULL,
80     x_capacity IN NUMBER DEFAULT NULL,
81     x_closed_ind IN VARCHAR2 DEFAULT NULL,
82     x_creation_date IN DATE DEFAULT NULL,
83     x_created_by IN NUMBER DEFAULT NULL,
84     x_last_update_date IN DATE DEFAULT NULL,
85     x_last_updated_by IN NUMBER DEFAULT NULL,
86     x_last_update_login IN NUMBER DEFAULT NULL
87  );
88 END igs_ad_room_pkg;