PACKAGE: APPS.IGS_PS_USEC_AS_PKG

Source

1 PACKAGE igs_ps_usec_as_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI1FS.pls 115.6 2002/11/29 02:06:11 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_SECTION_ASSESSMENT_ID IN OUT NOCOPY NUMBER,
6        x_UOO_ID IN NUMBER,
7        x_FINAL_EXAM_DATE IN DATE,
8        x_EXAM_START_TIME IN DATE,
9        x_EXAM_END_TIME IN DATE,
10        x_LOCATION_CD IN VARCHAR2,
11        x_BUILDING_CODE IN NUMBER,
12        x_ROOM_CODE IN NUMBER,
13       X_MODE in VARCHAR2 default 'R'
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_UNIT_SECTION_ASSESSMENT_ID IN NUMBER,
19        x_UOO_ID IN NUMBER,
20        x_FINAL_EXAM_DATE IN DATE,
21        x_EXAM_START_TIME IN DATE,
22        x_EXAM_END_TIME IN DATE,
23        x_LOCATION_CD IN VARCHAR2,
24        x_BUILDING_CODE IN NUMBER,
25        x_ROOM_CODE IN NUMBER  );
26  procedure UPDATE_ROW (
27       X_ROWID in  VARCHAR2,
28        x_UNIT_SECTION_ASSESSMENT_ID IN NUMBER,
29        x_UOO_ID IN NUMBER,
30        x_FINAL_EXAM_DATE IN DATE,
31        x_EXAM_START_TIME IN DATE,
32        x_EXAM_END_TIME IN DATE,
33        x_LOCATION_CD IN VARCHAR2,
34        x_BUILDING_CODE IN NUMBER,
35        x_ROOM_CODE IN NUMBER,
36       X_MODE in VARCHAR2 default 'R'
37   );
38 
39  procedure ADD_ROW (
40       X_ROWID in out NOCOPY VARCHAR2,
41        x_UNIT_SECTION_ASSESSMENT_ID IN OUT NOCOPY NUMBER,
42        x_UOO_ID IN NUMBER,
43        x_FINAL_EXAM_DATE IN DATE,
44        x_EXAM_START_TIME IN DATE,
45        x_EXAM_END_TIME IN DATE,
46        x_LOCATION_CD IN VARCHAR2,
47        x_BUILDING_CODE IN NUMBER,
48        x_ROOM_CODE IN NUMBER,
49       X_MODE in VARCHAR2 default 'R'
50   ) ;
51 
52 procedure DELETE_ROW (
53   X_ROWID in VARCHAR2
54 ) ;
55   FUNCTION Get_PK_For_Validation (
56     x_unit_section_assessment_id IN NUMBER
57     ) RETURN BOOLEAN ;
58 
59   FUNCTION Get_UK_For_Validation (
60     x_building_code IN NUMBER,
61     x_final_exam_date IN DATE,
62     x_location_cd IN VARCHAR2,
63     x_room_code IN NUMBER,
64     x_uoo_id IN NUMBER
65     ) RETURN BOOLEAN;
66 
67   PROCEDURE Get_UFK_Igs_Ps_Unit_Ofr_Opt (
68     x_uoo_id IN NUMBER
69     );
70 
71   PROCEDURE Check_Constraints (
72 		 Column_Name IN VARCHAR2  DEFAULT NULL,
73 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
74   PROCEDURE Before_DML (
75     p_action IN VARCHAR2,
76     x_rowid IN VARCHAR2 DEFAULT NULL,
77     x_unit_section_assessment_id IN NUMBER DEFAULT NULL,
78     x_uoo_id IN NUMBER DEFAULT NULL,
79     x_final_exam_date IN DATE DEFAULT NULL,
80     x_exam_start_time IN DATE DEFAULT NULL,
81     x_exam_end_time IN DATE DEFAULT NULL,
82     x_location_cd IN VARCHAR2 DEFAULT NULL,
83     x_building_code IN NUMBER DEFAULT NULL,
84     x_room_code IN NUMBER DEFAULT NULL,
85     x_creation_date IN DATE DEFAULT NULL,
86     x_created_by IN NUMBER DEFAULT NULL,
87     x_last_update_date IN DATE DEFAULT NULL,
88     x_last_updated_by IN NUMBER DEFAULT NULL,
89     x_last_update_login IN NUMBER DEFAULT NULL
90  );
91 END igs_ps_usec_as_pkg;