eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_PR_S_CRV_PRG_CON_PKG

Source


1 package IGS_PR_S_CRV_PRG_CON_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSQI22S.pls 115.3 2002/11/29 03:19:47 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_COURSE_CD in VARCHAR2,
6   X_VERSION_NUMBER in NUMBER,
7   X_APPLY_START_DT_ALIAS in VARCHAR2,
8   X_APPLY_END_DT_ALIAS in VARCHAR2,
9   X_END_BENEFIT_DT_ALIAS in VARCHAR2,
10   X_END_PENALTY_DT_ALIAS in VARCHAR2,
11   X_SHOW_CAUSE_CUTOFF_DT_ALIAS in VARCHAR2,
12   X_APPEAL_CUTOFF_DT_ALIAS in VARCHAR2,
13   X_SHOW_CAUSE_IND in VARCHAR2,
14   X_APPLY_BEFORE_SHOW_IND in VARCHAR2,
15   X_APPEAL_IND in VARCHAR2,
16   X_APPLY_BEFORE_APPEAL_IND in VARCHAR2,
17   X_COUNT_SUS_IN_TIME_IND in VARCHAR2,
18   X_COUNT_EXC_IN_TIME_IND in VARCHAR2,
19   X_CALCULATE_WAM_IND in VARCHAR2,
20   X_CALCULATE_GPA_IND in VARCHAR2,
21   X_OUTCOME_CHECK_TYPE in VARCHAR2,
22   X_MODE in VARCHAR2 default 'R'
23   );
24 procedure LOCK_ROW (
25   X_ROWID in VARCHAR2,
26   X_COURSE_CD in VARCHAR2,
27   X_VERSION_NUMBER in NUMBER,
28   X_APPLY_START_DT_ALIAS in VARCHAR2,
29   X_APPLY_END_DT_ALIAS in VARCHAR2,
30   X_END_BENEFIT_DT_ALIAS in VARCHAR2,
31   X_END_PENALTY_DT_ALIAS in VARCHAR2,
32   X_SHOW_CAUSE_CUTOFF_DT_ALIAS in VARCHAR2,
33   X_APPEAL_CUTOFF_DT_ALIAS in VARCHAR2,
34   X_SHOW_CAUSE_IND in VARCHAR2,
35   X_APPLY_BEFORE_SHOW_IND in VARCHAR2,
36   X_APPEAL_IND in VARCHAR2,
37   X_APPLY_BEFORE_APPEAL_IND in VARCHAR2,
38   X_COUNT_SUS_IN_TIME_IND in VARCHAR2,
39   X_COUNT_EXC_IN_TIME_IND in VARCHAR2,
40   X_CALCULATE_WAM_IND in VARCHAR2,
41   X_CALCULATE_GPA_IND in VARCHAR2,
42   X_OUTCOME_CHECK_TYPE in VARCHAR2
43 );
44 procedure UPDATE_ROW (
45   X_ROWID in VARCHAR2,
46   X_COURSE_CD in VARCHAR2,
47   X_VERSION_NUMBER in NUMBER,
48   X_APPLY_START_DT_ALIAS in VARCHAR2,
49   X_APPLY_END_DT_ALIAS in VARCHAR2,
50   X_END_BENEFIT_DT_ALIAS in VARCHAR2,
51   X_END_PENALTY_DT_ALIAS in VARCHAR2,
52   X_SHOW_CAUSE_CUTOFF_DT_ALIAS in VARCHAR2,
53   X_APPEAL_CUTOFF_DT_ALIAS in VARCHAR2,
54   X_SHOW_CAUSE_IND in VARCHAR2,
55   X_APPLY_BEFORE_SHOW_IND in VARCHAR2,
56   X_APPEAL_IND in VARCHAR2,
57   X_APPLY_BEFORE_APPEAL_IND in VARCHAR2,
58   X_COUNT_SUS_IN_TIME_IND in VARCHAR2,
59   X_COUNT_EXC_IN_TIME_IND in VARCHAR2,
60   X_CALCULATE_WAM_IND in VARCHAR2,
61   X_CALCULATE_GPA_IND in VARCHAR2,
62   X_OUTCOME_CHECK_TYPE in VARCHAR2,
63   X_MODE in VARCHAR2 default 'R'
64   );
65 procedure ADD_ROW (
66   X_ROWID in out NOCOPY VARCHAR2,
67   X_COURSE_CD in VARCHAR2,
68   X_VERSION_NUMBER in NUMBER,
69   X_APPLY_START_DT_ALIAS in VARCHAR2,
70   X_APPLY_END_DT_ALIAS in VARCHAR2,
71   X_END_BENEFIT_DT_ALIAS in VARCHAR2,
72   X_END_PENALTY_DT_ALIAS in VARCHAR2,
73   X_SHOW_CAUSE_CUTOFF_DT_ALIAS in VARCHAR2,
74   X_APPEAL_CUTOFF_DT_ALIAS in VARCHAR2,
75   X_SHOW_CAUSE_IND in VARCHAR2,
76   X_APPLY_BEFORE_SHOW_IND in VARCHAR2,
77   X_APPEAL_IND in VARCHAR2,
78   X_APPLY_BEFORE_APPEAL_IND in VARCHAR2,
79   X_COUNT_SUS_IN_TIME_IND in VARCHAR2,
80   X_COUNT_EXC_IN_TIME_IND in VARCHAR2,
81   X_CALCULATE_WAM_IND in VARCHAR2,
82   X_CALCULATE_GPA_IND in VARCHAR2,
83   X_OUTCOME_CHECK_TYPE in VARCHAR2,
84   X_MODE in VARCHAR2 default 'R'
85   );
86 procedure DELETE_ROW (
87   X_ROWID in VARCHAR2
88 );
89 
90   FUNCTION Get_PK_For_Validation (
91     x_course_cd IN VARCHAR2,
92     x_version_number IN NUMBER
93     )
94   RETURN BOOLEAN;
95 
96   PROCEDURE GET_FK_IGS_CA_DA (
97     x_dt_alias IN varchar2
98     );
99 
100   PROCEDURE GET_FK_IGS_PS_VER (
101     x_course_cd IN VARCHAR2,
102     x_version_number IN NUMBER
103     );
104 
105 PROCEDURE  Check_Constraints (
106     Column_Name IN VARCHAR2 DEFAULT NULL,
107     Column_Value IN VARCHAR2 DEFAULT NULL
108 );
109 
110   PROCEDURE Before_DML (
111     p_action IN VARCHAR2,
112     x_rowid IN VARCHAR2 DEFAULT NULL,
113     x_course_cd IN VARCHAR2 DEFAULT NULL,
114     x_version_number IN NUMBER DEFAULT NULL,
115     x_apply_start_dt_alias IN VARCHAR2 DEFAULT NULL,
116     x_apply_end_dt_alias IN VARCHAR2 DEFAULT NULL,
117     x_end_benefit_dt_alias IN VARCHAR2 DEFAULT NULL,
118     x_end_penalty_dt_alias IN VARCHAR2 DEFAULT NULL,
119     x_show_cause_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
120     x_appeal_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
121     x_show_cause_ind IN VARCHAR2 DEFAULT NULL,
122     x_apply_before_show_ind IN VARCHAR2 DEFAULT NULL,
123     x_appeal_ind IN VARCHAR2 DEFAULT NULL,
124     x_apply_before_appeal_ind IN VARCHAR2 DEFAULT NULL,
125     x_count_sus_in_time_ind IN VARCHAR2 DEFAULT NULL,
126     x_count_exc_in_time_ind IN VARCHAR2 DEFAULT NULL,
127     x_calculate_wam_ind IN VARCHAR2 DEFAULT NULL,
128     x_calculate_gpa_ind IN VARCHAR2 DEFAULT NULL,
129     x_outcome_check_type IN VARCHAR2 DEFAULT NULL,
130     x_creation_date IN DATE DEFAULT NULL,
131     x_created_by IN NUMBER DEFAULT NULL,
132     x_last_update_date IN DATE DEFAULT NULL,
133     x_last_updated_by IN NUMBER DEFAULT NULL,
134     x_last_update_login IN NUMBER DEFAULT NULL
135   );
136 
137 end IGS_PR_S_CRV_PRG_CON_PKG;