PACKAGE: APPS.IGS_PS_UNIT_LVL_HIST_PKG

Source

1 package IGS_PS_UNIT_LVL_HIST_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSPI41S.pls 115.6 2003/11/05 18:08:40 ijeddy ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_UNIT_CD in VARCHAR2,
6   X_VERSION_NUMBER in NUMBER,
7   X_COURSE_TYPE in VARCHAR2 DEFAULT NULL,
8   X_HIST_START_DT in DATE,
9   X_HIST_END_DT in DATE,
10   X_HIST_WHO in NUMBER,
11   X_UNIT_LEVEL in VARCHAR2,
12   X_WAM_WEIGHTING in NUMBER,
13   X_MODE in VARCHAR2 default 'R' ,
14   X_ORG_ID in NUMBER,
15   X_COURSE_CD VARCHAR2,
16   X_COURSE_VERSION_NUMBER NUMBER
17   );
18 procedure LOCK_ROW (
19   X_ROWID in VARCHAR2,
20   X_UNIT_CD in VARCHAR2,
21   X_VERSION_NUMBER in NUMBER,
22   X_COURSE_TYPE in VARCHAR2 DEFAULT NULL,
23   X_HIST_START_DT in DATE,
24   X_HIST_END_DT in DATE,
25   X_HIST_WHO in NUMBER,
26   X_UNIT_LEVEL in VARCHAR2,
27   X_WAM_WEIGHTING in NUMBER,
28   X_COURSE_CD VARCHAR2,
29   X_COURSE_VERSION_NUMBER NUMBER
30 );
31 procedure UPDATE_ROW (
32   X_ROWID in VARCHAR2,
33   X_UNIT_CD in VARCHAR2,
34   X_VERSION_NUMBER in NUMBER,
35   X_COURSE_TYPE in VARCHAR2 DEFAULT NULL,
36   X_HIST_START_DT in DATE,
37   X_HIST_END_DT in DATE,
38   X_HIST_WHO in NUMBER,
39   X_UNIT_LEVEL in VARCHAR2,
40   X_WAM_WEIGHTING in NUMBER,
41   X_MODE in VARCHAR2 default 'R',
42   X_COURSE_CD VARCHAR2,
43   X_COURSE_VERSION_NUMBER NUMBER
44   );
45 procedure ADD_ROW (
46   X_ROWID in out NOCOPY VARCHAR2,
47   X_UNIT_CD in VARCHAR2,
48   X_VERSION_NUMBER in NUMBER,
49   X_COURSE_TYPE in VARCHAR2 DEFAULT NULL,
50   X_HIST_START_DT in DATE,
51   X_HIST_END_DT in DATE,
52   X_HIST_WHO in NUMBER,
53   X_UNIT_LEVEL in VARCHAR2,
54   X_WAM_WEIGHTING in NUMBER,
55   X_MODE in VARCHAR2 default 'R',
56   X_ORG_ID in NUMBER,
57   X_COURSE_CD VARCHAR2,
58   X_COURSE_VERSION_NUMBER NUMBER
59   );
60 
61 procedure DELETE_ROW (
62   X_ROWID in VARCHAR2
63 );
64 
65   FUNCTION Get_PK_For_Validation (
66     x_unit_cd IN VARCHAR2,
67     x_version_number IN NUMBER,
68     x_hist_start_dt IN DATE,
69     x_course_cd             IN VARCHAR2,
70     x_course_version_number IN NUMBER
71     ) RETURN BOOLEAN;
72 
73   PROCEDURE GET_FK_IGS_PS_UNIT_VER (
74     x_unit_cd IN VARCHAR2,
75     x_version_number IN NUMBER
76     );
77 
78   PROCEDURE GET_FK_IGS_PS_VER (
79     x_course_cd IN VARCHAR2,
80     x_course_version_number IN NUMBER);
81 
82   PROCEDURE CHECK_CONSTRAINTS (
83 	Column_Name IN VARCHAR2 DEFAULT NULL,
84 	Column_Value IN VARCHAR2 DEFAULT NULL
85   );
86   PROCEDURE Before_DML (
87     p_action IN VARCHAR2,
88     x_rowid IN VARCHAR2 DEFAULT NULL,
89     x_unit_cd IN VARCHAR2 DEFAULT NULL,
90     x_version_number IN NUMBER DEFAULT NULL,
91     x_course_type IN VARCHAR2 DEFAULT NULL,
92     x_hist_start_dt IN DATE DEFAULT NULL,
93     x_hist_end_dt IN DATE DEFAULT NULL,
94     x_hist_who IN NUMBER DEFAULT NULL,
95     x_unit_level IN VARCHAR2 DEFAULT NULL,
96     x_wam_weighting IN NUMBER DEFAULT NULL,
97     x_creation_date IN DATE DEFAULT NULL,
98     x_created_by IN NUMBER DEFAULT NULL,
99     x_last_update_date IN DATE DEFAULT NULL,
100     x_last_updated_by IN NUMBER DEFAULT NULL,
101     x_last_update_login IN NUMBER DEFAULT NULL,
102     x_org_id IN NUMBER DEFAULT NULL,
103     x_course_cd  IN VARCHAR2 DEFAULT NULL,
104     x_course_version_number IN NUMBER DEFAULT NULL
105   ) ;
106 
107 
108 end IGS_PS_UNIT_LVL_HIST_PKG;