PACKAGE: APPS.IGS_PS_ANL_LOAD_PKG

Source

1 package IGS_PS_ANL_LOAD_PKG AUTHID CURRENT_USER AS
2   /* $Header: IGSPI04S.pls 115.3 2002/11/29 01:53:22 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_VERSION_NUMBER in NUMBER,
7   X_COURSE_CD in VARCHAR2,
8   X_YR_NUM in NUMBER,
9   X_EFFECTIVE_START_DT in DATE,
10   X_EFFECTIVE_END_DT in DATE,
11   X_ANNUAL_LOAD_VAL in NUMBER,
12   X_MODE in VARCHAR2 default 'R'
13   );
14 procedure LOCK_ROW (
15   X_ROWID IN VARCHAR2,
16   X_VERSION_NUMBER in NUMBER,
17   X_COURSE_CD in VARCHAR2,
18   X_YR_NUM in NUMBER,
19   X_EFFECTIVE_START_DT in DATE,
20   X_EFFECTIVE_END_DT in DATE,
21   X_ANNUAL_LOAD_VAL in NUMBER
22 );
23 procedure UPDATE_ROW (
24   X_ROWID IN VARCHAR2,
25   X_VERSION_NUMBER in NUMBER,
26   X_COURSE_CD in VARCHAR2,
27   X_YR_NUM in NUMBER,
28   X_EFFECTIVE_START_DT in DATE,
29   X_EFFECTIVE_END_DT in DATE,
30   X_ANNUAL_LOAD_VAL in NUMBER,
31   X_MODE in VARCHAR2 default 'R'
32   );
33 procedure ADD_ROW (
34   X_ROWID in out NOCOPY VARCHAR2,
35   X_VERSION_NUMBER in NUMBER,
36   X_COURSE_CD in VARCHAR2,
37   X_YR_NUM in NUMBER,
38   X_EFFECTIVE_START_DT in DATE,
39   X_EFFECTIVE_END_DT in DATE,
40   X_ANNUAL_LOAD_VAL in NUMBER,
41   X_MODE in VARCHAR2 default 'R'
42   );
43 procedure DELETE_ROW (
44   X_ROWID in VARCHAR2
45 );
46 
47   FUNCTION Get_PK_For_Validation (
48     x_course_cd IN VARCHAR2,
49     x_version_number IN NUMBER,
50     x_yr_num IN NUMBER,
51     x_effective_start_dt IN DATE )
52   RETURN BOOLEAN;
53 
54   PROCEDURE GET_FK_IGS_PS_VER (
55     x_course_cd IN VARCHAR2,
56     x_version_number IN NUMBER
57     );
58 
59 PROCEDURE Check_Constraints (
60     Column_Name	IN VARCHAR2	DEFAULT NULL,
61     Column_Value 	IN VARCHAR2	DEFAULT NULL
62 );
63 
64 PROCEDURE Before_DML (
65     p_action IN VARCHAR2,
66     x_rowid IN VARCHAR2 DEFAULT NULL,
67     x_course_cd IN VARCHAR2 DEFAULT NULL,
68     x_version_number IN NUMBER DEFAULT NULL,
69     x_yr_num IN NUMBER DEFAULT NULL,
70     x_effective_start_dt IN DATE DEFAULT NULL,
71     x_effective_end_dt IN DATE DEFAULT NULL,
72     x_annual_load_val IN NUMBER DEFAULT NULL,
73     x_creation_date IN DATE DEFAULT NULL,
74     x_created_by IN NUMBER DEFAULT NULL,
75     x_last_update_date IN DATE DEFAULT NULL,
76     x_last_updated_by IN NUMBER DEFAULT NULL,
77     x_last_update_login IN NUMBER DEFAULT NULL
78   ) ;
79 
80 end IGS_PS_ANL_LOAD_PKG;