PACKAGE: APPS.IGS_AD_UP_HEADER_PKG

Source

1 PACKAGE igs_ad_up_header_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI92S.pls 115.7 2002/11/28 22:19:56 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_MAX_SCORE IN NUMBER,
6        x_UP_HEADER_ID IN OUT NOCOPY NUMBER,
7        x_ADMISSION_TEST_TYPE IN VARCHAR2,
8        x_TEST_SEGMENT_ID IN NUMBER,
9        x_DEFINITION_LEVEL IN VARCHAR2,
10        x_MIN_SCORE IN NUMBER,
11       X_MODE in VARCHAR2 default 'R'
12   );
13 
14  procedure LOCK_ROW (
15       X_ROWID in  VARCHAR2,
16        x_MAX_SCORE IN NUMBER,
17        x_UP_HEADER_ID IN NUMBER,
18        x_ADMISSION_TEST_TYPE IN VARCHAR2,
19        x_TEST_SEGMENT_ID IN NUMBER,
20        x_DEFINITION_LEVEL IN VARCHAR2,
21        x_MIN_SCORE IN NUMBER  );
22  procedure UPDATE_ROW (
23       X_ROWID in  VARCHAR2,
24        x_MAX_SCORE IN NUMBER,
25        x_UP_HEADER_ID IN NUMBER,
26        x_ADMISSION_TEST_TYPE IN VARCHAR2,
27        x_TEST_SEGMENT_ID IN NUMBER,
28        x_DEFINITION_LEVEL IN VARCHAR2,
29        x_MIN_SCORE IN NUMBER,
30       X_MODE in VARCHAR2 default 'R'
31   );
32 
33  procedure ADD_ROW (
34       X_ROWID in out NOCOPY VARCHAR2,
35        x_MAX_SCORE IN NUMBER,
36        x_UP_HEADER_ID IN OUT NOCOPY NUMBER,
37        x_ADMISSION_TEST_TYPE IN VARCHAR2,
38        x_TEST_SEGMENT_ID IN NUMBER,
39        x_DEFINITION_LEVEL IN VARCHAR2,
40        x_MIN_SCORE IN NUMBER,
41       X_MODE in VARCHAR2 default 'R'
42   ) ;
43 
44 procedure DELETE_ROW (
45   X_ROWID in VARCHAR2
46 ) ;
47   FUNCTION Get_PK_For_Validation (
48     x_up_header_id IN NUMBER
49     ) RETURN BOOLEAN ;
50 
51 
52   FUNCTION Get_UK_For_Validation (
53     x_admission_test_type IN VARCHAR2,
54         x_test_segment_id IN NUMBER
55     ) RETURN BOOLEAN ;
56 
57   PROCEDURE Check_Uniqueness;
58 
59   PROCEDURE Get_FK_Igs_Ad_Test_Type (
60     x_admission_test_type IN VARCHAR2
61     );
62 
63   PROCEDURE Get_FK_Igs_Ad_Test_Segments (
64     x_test_segment_id IN NUMBER
65     );
66 
67   PROCEDURE Check_Constraints (
68 		 Column_Name IN VARCHAR2  DEFAULT NULL,
69 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
70   PROCEDURE Before_DML (
71     p_action IN VARCHAR2,
72     x_rowid IN VARCHAR2 DEFAULT NULL,
73     x_max_score IN NUMBER DEFAULT NULL,
74     x_up_header_id IN NUMBER DEFAULT NULL,
75     x_admission_test_type IN VARCHAR2 DEFAULT NULL,
76     x_test_segment_id IN NUMBER DEFAULT NULL,
77     x_definition_level IN VARCHAR2 DEFAULT NULL,
78     x_min_score IN NUMBER DEFAULT NULL,
79     x_creation_date IN DATE DEFAULT NULL,
80     x_created_by IN NUMBER DEFAULT NULL,
81     x_last_update_date IN DATE DEFAULT NULL,
82     x_last_updated_by IN NUMBER DEFAULT NULL,
83     x_last_update_login IN NUMBER DEFAULT NULL
84  );
85 END igs_ad_up_header_pkg;