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_AD_CAL_CONF_PKG

Source


1 package IGS_AD_CAL_CONF_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI70S.pls 115.7 2002/11/28 22:13:57 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_S_CONTROL_NUM in out NOCOPY NUMBER,
7   X_INITIALISE_AD_PERD_DT_ALIAS in VARCHAR2,
8   X_AD_APPL_ENCMB_CHK_DT_ALIAS in VARCHAR2,
9   X_AD_APPL_COURSE_STRT_DT_ALIAS in VARCHAR2,
10   X_AD_APPL_SHORT_STRT_DT_ALIAS in VARCHAR2,
11   X_AD_APPL_DUE_DT_ALIAS in VARCHAR2,
12   X_AD_APPL_FINAL_DT_ALIAS in VARCHAR2,
13   X_AD_APPL_CHG_OF_PREF_DT_ALIAS in VARCHAR2,
14   X_AD_APPL_OFFER_RESP_DT_ALIAS in VARCHAR2,
15   X_AD_APPL_E_COMP_PERD_DT_ALIAS in VARCHAR2,
16   X_AD_APPL_M_COMP_PERD_DT_ALIAS in VARCHAR2,
17   X_AD_APPL_S_COMP_PERD_DT_ALIAS in VARCHAR2,
18   X_MODE in VARCHAR2 default 'R' ,
19   X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
20   X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
21   X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
22   );
23 
24 procedure LOCK_ROW (
25   X_ROWID in VARCHAR2,
26   X_S_CONTROL_NUM in NUMBER,
27   X_INITIALISE_AD_PERD_DT_ALIAS in VARCHAR2,
28   X_AD_APPL_ENCMB_CHK_DT_ALIAS in VARCHAR2,
29   X_AD_APPL_COURSE_STRT_DT_ALIAS in VARCHAR2,
30   X_AD_APPL_SHORT_STRT_DT_ALIAS in VARCHAR2,
31   X_AD_APPL_DUE_DT_ALIAS in VARCHAR2,
32   X_AD_APPL_FINAL_DT_ALIAS in VARCHAR2,
33   X_AD_APPL_CHG_OF_PREF_DT_ALIAS in VARCHAR2,
34   X_AD_APPL_OFFER_RESP_DT_ALIAS in VARCHAR2,
35   X_AD_APPL_E_COMP_PERD_DT_ALIAS in VARCHAR2,
36   X_AD_APPL_M_COMP_PERD_DT_ALIAS in VARCHAR2,
37   X_AD_APPL_S_COMP_PERD_DT_ALIAS in VARCHAR2,
38   X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
39   X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
40   X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
41 );
42 
43 procedure UPDATE_ROW (
44   X_ROWID in VARCHAR2,
45   X_S_CONTROL_NUM in NUMBER,
46   X_INITIALISE_AD_PERD_DT_ALIAS in VARCHAR2,
47   X_AD_APPL_ENCMB_CHK_DT_ALIAS in VARCHAR2,
48   X_AD_APPL_COURSE_STRT_DT_ALIAS in VARCHAR2,
49   X_AD_APPL_SHORT_STRT_DT_ALIAS in VARCHAR2,
50   X_AD_APPL_DUE_DT_ALIAS in VARCHAR2,
51   X_AD_APPL_FINAL_DT_ALIAS in VARCHAR2,
52   X_AD_APPL_CHG_OF_PREF_DT_ALIAS in VARCHAR2,
53   X_AD_APPL_OFFER_RESP_DT_ALIAS in VARCHAR2,
54   X_AD_APPL_E_COMP_PERD_DT_ALIAS in VARCHAR2,
55   X_AD_APPL_M_COMP_PERD_DT_ALIAS in VARCHAR2,
56   X_AD_APPL_S_COMP_PERD_DT_ALIAS in VARCHAR2,
57   X_MODE in VARCHAR2 default 'R',
58   X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
59   X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
60   X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
61   );
62 
63 procedure ADD_ROW (
64   X_ROWID in out NOCOPY VARCHAR2,
65   X_S_CONTROL_NUM in out NOCOPY NUMBER,
66   X_INITIALISE_AD_PERD_DT_ALIAS in VARCHAR2,
67   X_AD_APPL_ENCMB_CHK_DT_ALIAS in VARCHAR2,
68   X_AD_APPL_COURSE_STRT_DT_ALIAS in VARCHAR2,
69   X_AD_APPL_SHORT_STRT_DT_ALIAS in VARCHAR2,
70   X_AD_APPL_DUE_DT_ALIAS in VARCHAR2,
71   X_AD_APPL_FINAL_DT_ALIAS in VARCHAR2,
72   X_AD_APPL_CHG_OF_PREF_DT_ALIAS in VARCHAR2,
73   X_AD_APPL_OFFER_RESP_DT_ALIAS in VARCHAR2,
74   X_AD_APPL_E_COMP_PERD_DT_ALIAS in VARCHAR2,
75   X_AD_APPL_M_COMP_PERD_DT_ALIAS in VARCHAR2,
76   X_AD_APPL_S_COMP_PERD_DT_ALIAS in VARCHAR2,
77   X_MODE in VARCHAR2 default 'R',
78   X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
79   X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
80   X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
81   );
82 
83 procedure DELETE_ROW (
84   X_ROWID in VARCHAR2
85   );
86 
87 FUNCTION Get_PK_For_Validation (
88     x_s_control_num IN NUMBER
89 )return BOOLEAN;
90 
91 PROCEDURE Check_Constraints (
92   Column_Name IN VARCHAR2 DEFAULT NULL,
93   Column_Value IN VARCHAR2 DEFAULT NULL
94 );
95 
96 PROCEDURE GET_FK_IGS_CA_DA (
97     x_dt_alias IN VARCHAR2
98     );
99 
100 PROCEDURE GET_FK_IGS_CA_TYPE (
101   x_cal_type IN VARCHAR2
102   );
103 
104 
105 PROCEDURE Before_DML (
106   p_action IN VARCHAR2,
107   x_rowid IN VARCHAR2 DEFAULT NULL,
108   x_s_control_num IN NUMBER DEFAULT NULL,
109   x_initialise_adm_perd_dt_alias IN VARCHAR2 DEFAULT NULL,
110   x_adm_appl_encmb_chk_dt_alias IN VARCHAR2 DEFAULT NULL,
111   x_ad_appl_course_strt_dt_alias IN VARCHAR2 DEFAULT NULL,
112   x_adm_appl_short_strt_dt_alias IN VARCHAR2 DEFAULT NULL,
113   x_adm_appl_due_dt_alias IN VARCHAR2 DEFAULT NULL,
114   x_adm_appl_final_dt_alias IN VARCHAR2 DEFAULT NULL,
115   x_ad_appl_chg_of_pref_dt_alias IN VARCHAR2 DEFAULT NULL,
116   x_adm_appl_offer_resp_dt_alias IN VARCHAR2 DEFAULT NULL,
117   x_ad_appl_e_comp_perd_dt_alias IN VARCHAR2 DEFAULT NULL,
118   x_ad_appl_m_comp_perd_dt_alias IN VARCHAR2 DEFAULT NULL,
119   x_ad_appl_s_comp_perd_dt_alias IN VARCHAR2 DEFAULT NULL,
120   x_creation_date IN DATE DEFAULT NULL,
121   x_created_by IN NUMBER DEFAULT NULL,
122   x_last_update_date IN DATE DEFAULT NULL,
123   x_last_updated_by IN NUMBER DEFAULT NULL,
124   x_last_update_login IN NUMBER DEFAULT NULL,
125   X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
126   X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
127   X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
128 );
129 
130 end IGS_AD_CAL_CONF_PKG;