PACKAGE: APPS.IGS_PS_OFR_UNIT_SET_PKG

Source

1 package IGS_PS_OFR_UNIT_SET_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSPI26S.pls 115.3 2002/11/29 02:13:38 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_COURSE_CD in VARCHAR2,
6   X_CRV_VERSION_NUMBER in NUMBER,
7   X_CAL_TYPE in VARCHAR2,
8   X_UNIT_SET_CD in VARCHAR2,
9   X_US_VERSION_NUMBER in NUMBER,
10   X_OVERRIDE_TITLE in VARCHAR2,
11   X_ONLY_AS_SUB_IND in VARCHAR2,
12   X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2,
13   X_MODE in VARCHAR2 default 'R'
14   );
15 procedure LOCK_ROW (
16   X_ROWID IN VARCHAR2,
17   X_COURSE_CD in VARCHAR2,
18   X_CRV_VERSION_NUMBER in NUMBER,
19   X_CAL_TYPE in VARCHAR2,
20   X_UNIT_SET_CD in VARCHAR2,
21   X_US_VERSION_NUMBER in NUMBER,
22   X_OVERRIDE_TITLE in VARCHAR2,
23   X_ONLY_AS_SUB_IND in VARCHAR2,
24   X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2
25 );
26 procedure UPDATE_ROW (
27   X_ROWID IN VARCHAR2,
28   X_COURSE_CD in VARCHAR2,
29   X_CRV_VERSION_NUMBER in NUMBER,
30   X_CAL_TYPE in VARCHAR2,
31   X_UNIT_SET_CD in VARCHAR2,
32   X_US_VERSION_NUMBER in NUMBER,
33   X_OVERRIDE_TITLE in VARCHAR2,
34   X_ONLY_AS_SUB_IND in VARCHAR2,
35   X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2,
36   X_MODE in VARCHAR2 default 'R'
37   );
38 procedure ADD_ROW (
39   X_ROWID in out NOCOPY VARCHAR2,
40   X_COURSE_CD in VARCHAR2,
41   X_CRV_VERSION_NUMBER in NUMBER,
42   X_CAL_TYPE in VARCHAR2,
43   X_UNIT_SET_CD in VARCHAR2,
44   X_US_VERSION_NUMBER in NUMBER,
45   X_OVERRIDE_TITLE in VARCHAR2,
46   X_ONLY_AS_SUB_IND in VARCHAR2,
47   X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2,
48   X_MODE in VARCHAR2 default 'R'
49   );
50 procedure DELETE_ROW (
51   X_ROWID IN VARCHAR2
52 );
53 
54   FUNCTION Get_PK_For_Validation (
55     x_course_cd IN VARCHAR2,
56     x_crv_version_number IN NUMBER,
57     x_cal_type IN VARCHAR2,
58     x_unit_set_cd IN VARCHAR2,
59     x_us_version_number IN NUMBER
60     )
61   RETURN BOOLEAN;
62 
63   PROCEDURE GET_FK_IGS_PS_OFR (
64     x_course_cd IN VARCHAR2,
65     x_version_number IN NUMBER,
66     x_cal_type IN VARCHAR2
67     );
68 
69   PROCEDURE GET_FK_IGS_EN_UNIT_SET (
70     x_unit_set_cd IN VARCHAR2,
71     x_version_number IN NUMBER
72     );
73 
74   PROCEDURE CHECK_CONSTRAINTS(
75 	column_name IN VARCHAR2 DEFAULT NULL,
76 	column_value IN VARCHAR2 DEFAULT NULL
77   );
78 
79   PROCEDURE Before_DML (
80     p_action IN VARCHAR2,
81     x_rowid IN VARCHAR2 DEFAULT NULL,
82     x_course_cd IN VARCHAR2 DEFAULT NULL,
83     x_crv_version_number IN NUMBER DEFAULT NULL,
84     x_cal_type IN VARCHAR2 DEFAULT NULL,
85     x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
86     x_us_version_number IN NUMBER DEFAULT NULL,
87     x_override_title IN VARCHAR2 DEFAULT NULL,
88     x_only_as_sub_ind IN VARCHAR2 DEFAULT NULL,
89     x_show_on_official_ntfctn_ind IN VARCHAR2 DEFAULT NULL,
90     x_creation_date IN DATE DEFAULT NULL,
91     x_created_by IN NUMBER DEFAULT NULL,
92     x_last_update_date IN DATE DEFAULT NULL,
93     x_last_updated_by IN NUMBER DEFAULT NULL,
94     x_last_update_login IN NUMBER DEFAULT NULL
95   ) ;
96 
97 end IGS_PS_OFR_UNIT_SET_PKG;