PACKAGE: APPS.IGS_PS_COO_AD_UNIT_S_PKG

Source

1 package  IGS_PS_COO_AD_UNIT_S_PKG AS
2   /* $Header: IGSPI02S.pls 120.1 2006/05/29 07:35:37 sarakshi noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_COURSE_CD in VARCHAR2,
7   X_CRV_VERSION_NUMBER in NUMBER,
8   X_CAL_TYPE in VARCHAR2,
9   X_LOCATION_CD in VARCHAR2,
10   X_ATTENDANCE_MODE in VARCHAR2,
11   X_ATTENDANCE_TYPE in VARCHAR2,
12   X_ADMISSION_CAT in VARCHAR2,
13   X_UNIT_SET_CD in VARCHAR2,
14   X_US_VERSION_NUMBER in NUMBER,
15   X_MODE in VARCHAR2 default 'R'
16   );
17 procedure LOCK_ROW (
18   X_ROWID IN VARCHAR2,
19   X_COURSE_CD in VARCHAR2,
20   X_CRV_VERSION_NUMBER in NUMBER,
21   X_CAL_TYPE in VARCHAR2,
22   X_LOCATION_CD in VARCHAR2,
23   X_ATTENDANCE_MODE in VARCHAR2,
24   X_ATTENDANCE_TYPE in VARCHAR2,
25   X_ADMISSION_CAT in VARCHAR2,
26   X_UNIT_SET_CD in VARCHAR2,
27   X_US_VERSION_NUMBER in NUMBER
28 );
29 procedure DELETE_ROW (
30     X_ROWID IN VARCHAR2
31 );
32 
33   FUNCTION Get_PK_For_Validation (
34     x_course_cd IN VARCHAR2,
35     x_crv_version_number IN NUMBER,
36     x_cal_type IN VARCHAR2,
37     x_location_cd IN VARCHAR2,
38     x_attendance_mode IN VARCHAR2,
39     x_attendance_type IN VARCHAR2,
40     x_admission_cat IN VARCHAR2,
41     x_unit_set_cd IN VARCHAR2,
42     x_us_version_number IN NUMBER)
43   RETURN BOOLEAN;
44 
45   PROCEDURE GET_FK_IGS_PS_OF_OPT_AD_CAT (
46     x_course_cd IN VARCHAR2,
47     x_version_number IN NUMBER,
48     x_cal_type IN VARCHAR2,
49     x_location_cd IN VARCHAR2,
50     x_attendance_mode IN VARCHAR2,
51     x_attendance_type IN VARCHAR2,
52     x_admission_cat IN VARCHAR2
53     );
54 
55   PROCEDURE GET_FK_IGS_EN_UNIT_SET (
56     x_unit_set_cd IN VARCHAR2,
57     x_version_number IN NUMBER
58     );
59 
60   PROCEDURE GET_FK_IGS_PS_OFR_UNIT_SET (
61     x_course_cd IN VARCHAR2,
62     x_version_number IN NUMBER,
63     x_cal_type IN VARCHAR2,
64     x_unit_set_cd IN VARCHAR2,
65     x_us_version_number IN NUMBER
66     );
67 
68   PROCEDURE Check_Constraints (
69     Column_Name	IN VARCHAR2	DEFAULT NULL,
70     Column_Value 	IN VARCHAR2	DEFAULT NULL
71   );
72 
73   PROCEDURE Before_DML (
74     p_action IN VARCHAR2,
75     x_rowid IN VARCHAR2 DEFAULT NULL,
76     x_course_cd IN VARCHAR2 DEFAULT NULL,
77     x_crv_version_number IN NUMBER DEFAULT NULL,
78     x_cal_type IN VARCHAR2 DEFAULT NULL,
79     x_location_cd IN VARCHAR2 DEFAULT NULL,
80     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
81     x_attendance_type IN VARCHAR2 DEFAULT NULL,
82     x_admission_cat IN VARCHAR2 DEFAULT NULL,
83     x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
84     x_us_version_number 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 
92 end IGS_PS_COO_AD_UNIT_S_PKG;