PACKAGE: APPS.IGS_PS_OFR_INST_PKG

Source

1 package IGS_PS_OFR_INST_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSPI20S.pls 115.3 2002/11/29 02:11:56 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_COURSE_CD in VARCHAR2,
7   X_VERSION_NUMBER in NUMBER,
8   X_CAL_TYPE in VARCHAR2,
9   X_CI_SEQUENCE_NUMBER in NUMBER,
10   X_CI_START_DT in DATE,
11   X_CI_END_DT in DATE,
12   X_MIN_ENTRY_ASS_SCORE in NUMBER,
13   X_GUARANTEED_ENTRY_ASS_SCR in NUMBER,
14   X_MODE in VARCHAR2 default 'R'
15   );
16 procedure LOCK_ROW (
17   X_ROWID IN VARCHAR2,
18   X_COURSE_CD in VARCHAR2,
19   X_VERSION_NUMBER in NUMBER,
20   X_CAL_TYPE in VARCHAR2,
21   X_CI_SEQUENCE_NUMBER in NUMBER,
22   X_CI_START_DT in DATE,
23   X_CI_END_DT in DATE,
24   X_MIN_ENTRY_ASS_SCORE in NUMBER,
25   X_GUARANTEED_ENTRY_ASS_SCR in NUMBER
26 );
27 procedure UPDATE_ROW (
28   X_ROWID IN VARCHAR2,
29   X_COURSE_CD in VARCHAR2,
30   X_VERSION_NUMBER in NUMBER,
31   X_CAL_TYPE in VARCHAR2,
32   X_CI_SEQUENCE_NUMBER in NUMBER,
33   X_CI_START_DT in DATE,
34   X_CI_END_DT in DATE,
35   X_MIN_ENTRY_ASS_SCORE in NUMBER,
36   X_GUARANTEED_ENTRY_ASS_SCR in NUMBER,
37   X_MODE in VARCHAR2 default 'R'
38   );
39 procedure ADD_ROW (
40   X_ROWID in out NOCOPY VARCHAR2,
41   X_COURSE_CD in VARCHAR2,
42   X_VERSION_NUMBER in NUMBER,
43   X_CAL_TYPE in VARCHAR2,
44   X_CI_SEQUENCE_NUMBER in NUMBER,
45   X_CI_START_DT in DATE,
46   X_CI_END_DT in DATE,
47   X_MIN_ENTRY_ASS_SCORE in NUMBER,
48   X_GUARANTEED_ENTRY_ASS_SCR in NUMBER,
49   X_MODE in VARCHAR2 default 'R'
50   );
51 procedure DELETE_ROW (
52   X_ROWID IN VARCHAR2
53 );
54 
55   FUNCTION Get_PK_For_Validation (
56     x_course_cd IN VARCHAR2,
57     x_version_number IN NUMBER,
58     x_cal_type IN VARCHAR2,
59     x_ci_sequence_number IN NUMBER
60     )
61   RETURN BOOLEAN;
62 
63   PROCEDURE GET_UFK_IGS_CA_INST (
64     x_cal_type IN VARCHAR2,
65     x_sequence_number IN NUMBER,
66     x_start_dt IN DATE,
67     x_end_dt IN DATE
68     );
69 
70   PROCEDURE GET_FK_IGS_PS_OFR (
71     x_course_cd IN VARCHAR2,
72     x_version_number IN NUMBER,
73     x_cal_type IN VARCHAR2
74     );
75 
76 PROCEDURE Check_Constraints (
77     Column_Name	IN VARCHAR2	DEFAULT NULL,
78     Column_Value 	IN VARCHAR2	DEFAULT NULL
79 );
80 
81 PROCEDURE Before_DML (
82     p_action IN VARCHAR2,
83     x_rowid IN VARCHAR2 DEFAULT NULL,
84     x_course_cd IN VARCHAR2 DEFAULT NULL,
85     x_version_number IN NUMBER DEFAULT NULL,
86     x_cal_type IN VARCHAR2 DEFAULT NULL,
87     x_ci_sequence_number IN NUMBER DEFAULT NULL,
88     x_ci_start_dt IN DATE DEFAULT NULL,
89     x_ci_end_dt IN DATE DEFAULT NULL,
90     x_min_entry_ass_score IN NUMBER DEFAULT NULL,
91     x_guaranteed_entry_ass_scr IN NUMBER DEFAULT NULL,
92     x_creation_date IN DATE DEFAULT NULL,
93     x_created_by IN NUMBER DEFAULT NULL,
94     x_last_update_date IN DATE DEFAULT NULL,
95     x_last_updated_by IN NUMBER DEFAULT NULL,
96     x_last_update_login IN NUMBER DEFAULT NULL
97   ) ;
98 
99 end IGS_PS_OFR_INST_PKG;