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_PRG_CONF_PKG

Source


1 package IGS_PR_S_PRG_CONF_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSQI26S.pls 115.3 2002/11/29 03:20:58 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_S_CONTROL_NUM in out NOCOPY NUMBER,
6   X_EFFECTIVE_END_DT_ALIAS in VARCHAR2,
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_ENCUMB_END_DT_ALIAS in VARCHAR2,
22   X_OUTCOME_CHECK_TYPE in VARCHAR2,
23   X_MODE in VARCHAR2 default 'R'
24   );
25 procedure LOCK_ROW (
26   X_ROWID in VARCHAR2,
27   X_S_CONTROL_NUM in NUMBER,
28   X_EFFECTIVE_END_DT_ALIAS in VARCHAR2,
29   X_APPLY_START_DT_ALIAS in VARCHAR2,
30   X_APPLY_END_DT_ALIAS in VARCHAR2,
31   X_END_BENEFIT_DT_ALIAS in VARCHAR2,
32   X_END_PENALTY_DT_ALIAS in VARCHAR2,
33   X_SHOW_CAUSE_CUTOFF_DT_ALIAS in VARCHAR2,
34   X_APPEAL_CUTOFF_DT_ALIAS in VARCHAR2,
35   X_SHOW_CAUSE_IND in VARCHAR2,
36   X_APPLY_BEFORE_SHOW_IND in VARCHAR2,
37   X_APPEAL_IND in VARCHAR2,
38   X_APPLY_BEFORE_APPEAL_IND in VARCHAR2,
39   X_COUNT_SUS_IN_TIME_IND in VARCHAR2,
40   X_COUNT_EXC_IN_TIME_IND in VARCHAR2,
41   X_CALCULATE_WAM_IND in VARCHAR2,
42   X_CALCULATE_GPA_IND in VARCHAR2,
43   X_ENCUMB_END_DT_ALIAS in VARCHAR2,
44   X_OUTCOME_CHECK_TYPE in VARCHAR2
45 );
46 procedure UPDATE_ROW (
47   X_ROWID in VARCHAR2,
48   X_S_CONTROL_NUM in NUMBER,
49   X_EFFECTIVE_END_DT_ALIAS in VARCHAR2,
50   X_APPLY_START_DT_ALIAS in VARCHAR2,
51   X_APPLY_END_DT_ALIAS in VARCHAR2,
52   X_END_BENEFIT_DT_ALIAS in VARCHAR2,
53   X_END_PENALTY_DT_ALIAS in VARCHAR2,
54   X_SHOW_CAUSE_CUTOFF_DT_ALIAS in VARCHAR2,
55   X_APPEAL_CUTOFF_DT_ALIAS in VARCHAR2,
56   X_SHOW_CAUSE_IND in VARCHAR2,
57   X_APPLY_BEFORE_SHOW_IND in VARCHAR2,
58   X_APPEAL_IND in VARCHAR2,
59   X_APPLY_BEFORE_APPEAL_IND in VARCHAR2,
60   X_COUNT_SUS_IN_TIME_IND in VARCHAR2,
61   X_COUNT_EXC_IN_TIME_IND in VARCHAR2,
62   X_CALCULATE_WAM_IND in VARCHAR2,
63   X_CALCULATE_GPA_IND in VARCHAR2,
64   X_ENCUMB_END_DT_ALIAS in VARCHAR2,
65   X_OUTCOME_CHECK_TYPE in VARCHAR2,
66 
67   X_MODE in VARCHAR2 default 'R'
68   );
69 procedure ADD_ROW (
70   X_ROWID in out NOCOPY VARCHAR2,
71   X_S_CONTROL_NUM in out NOCOPY NUMBER,
72   X_EFFECTIVE_END_DT_ALIAS in VARCHAR2,
73   X_APPLY_START_DT_ALIAS in VARCHAR2,
74   X_APPLY_END_DT_ALIAS in VARCHAR2,
75   X_END_BENEFIT_DT_ALIAS in VARCHAR2,
76   X_END_PENALTY_DT_ALIAS in VARCHAR2,
77   X_SHOW_CAUSE_CUTOFF_DT_ALIAS in VARCHAR2,
78   X_APPEAL_CUTOFF_DT_ALIAS in VARCHAR2,
79   X_SHOW_CAUSE_IND in VARCHAR2,
80   X_APPLY_BEFORE_SHOW_IND in VARCHAR2,
81   X_APPEAL_IND in VARCHAR2,
82   X_APPLY_BEFORE_APPEAL_IND in VARCHAR2,
83   X_COUNT_SUS_IN_TIME_IND in VARCHAR2,
84   X_COUNT_EXC_IN_TIME_IND in VARCHAR2,
85   X_CALCULATE_WAM_IND in VARCHAR2,
86   X_CALCULATE_GPA_IND in VARCHAR2,
87   X_ENCUMB_END_DT_ALIAS in VARCHAR2,
88   X_OUTCOME_CHECK_TYPE in VARCHAR2,
89   X_MODE in VARCHAR2 default 'R'
90   );
91 procedure DELETE_ROW (
92   X_ROWID in VARCHAR2
93 );
94 
95   FUNCTION Get_PK_For_Validation (
96     x_s_control_num IN NUMBER
97     )
98   RETURN BOOLEAN;
99 
100   PROCEDURE GET_FK_IGS_CA_DA (
101     x_dt_alias IN varchar2
102     );
103 
104 PROCEDURE  Check_Constraints (
105     Column_Name IN VARCHAR2 DEFAULT NULL,
106     Column_Value IN VARCHAR2 DEFAULT NULL
107 );
108 
109   PROCEDURE Before_DML (
110     p_action IN VARCHAR2,
111     x_rowid IN VARCHAR2 DEFAULT NULL,
112     x_s_control_num IN NUMBER DEFAULT NULL,
113     x_effective_end_dt_alias IN VARCHAR2 DEFAULT NULL,
114     x_apply_start_dt_alias IN VARCHAR2 DEFAULT NULL,
115     x_apply_end_dt_alias IN VARCHAR2 DEFAULT NULL,
116     x_end_benefit_dt_alias IN VARCHAR2 DEFAULT NULL,
117     x_end_penalty_dt_alias IN VARCHAR2 DEFAULT NULL,
118     x_show_cause_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
119     x_appeal_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
120     x_show_cause_ind IN VARCHAR2 DEFAULT NULL,
121     x_apply_before_show_ind IN VARCHAR2 DEFAULT NULL,
122     x_appeal_ind IN VARCHAR2 DEFAULT NULL,
123     x_apply_before_appeal_ind IN VARCHAR2 DEFAULT NULL,
124     x_count_sus_in_time_ind IN VARCHAR2 DEFAULT NULL,
125     x_count_exc_in_time_ind IN VARCHAR2 DEFAULT NULL,
126     x_calculate_wam_ind IN VARCHAR2 DEFAULT NULL,
127     x_calculate_gpa_ind IN VARCHAR2 DEFAULT NULL,
128     X_ENCUMB_END_DT_ALIAS 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_PRG_CONF_PKG;