PACKAGE: APPS.IGS_AD_RATING_SCALES_PKG

Source

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