PACKAGE: APPS.IGS_AD_BUILDING_PKG

Source

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