APPS.IGS_CA_DT_OF_MTH_PKG dependencies on IGS_CA_DT_OF_MTH

Line 1: package body IGS_CA_DT_OF_MTH_PKG AS

1: package body IGS_CA_DT_OF_MTH_PKG AS
2: /* $Header: IGSCI11B.pls 115.4 2002/11/28 23:02:13 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DT_OF_MTH%RowType;
5: new_references IGS_CA_DT_OF_MTH%RowType;

Line 4: old_references IGS_CA_DT_OF_MTH%RowType;

1: package body IGS_CA_DT_OF_MTH_PKG AS
2: /* $Header: IGSCI11B.pls 115.4 2002/11/28 23:02:13 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DT_OF_MTH%RowType;
5: new_references IGS_CA_DT_OF_MTH%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_CA_DT_OF_MTH%RowType;

1: package body IGS_CA_DT_OF_MTH_PKG AS
2: /* $Header: IGSCI11B.pls 115.4 2002/11/28 23:02:13 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DT_OF_MTH%RowType;
5: new_references IGS_CA_DT_OF_MTH%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 21: FROM IGS_CA_DT_OF_MTH

17: ) AS
18:
19: CURSOR cur_old_ref_values IS
20: SELECT *
21: FROM IGS_CA_DT_OF_MTH
22: WHERE rowid = x_rowid;
23:
24: BEGIN
25:

Line 85: FROM IGS_CA_DT_OF_MTH

81: ) RETURN BOOLEAN AS
82:
83: CURSOR cur_rowid IS
84: SELECT rowid
85: FROM IGS_CA_DT_OF_MTH
86: WHERE dt_of_month = x_dt_of_month
87: AND current_user = x_current_user
88: FOR UPDATE NOWAIT;
89:

Line 175: cursor C is select ROWID from IGS_CA_DT_OF_MTH

171: X_DT_OF_MONTH in DATE,
172: X_CURRENT_USER in VARCHAR2,
173: X_MODE in VARCHAR2 default 'R'
174: ) AS
175: cursor C is select ROWID from IGS_CA_DT_OF_MTH
176: where DT_OF_MONTH = X_DT_OF_MONTH
177: and CURRENT_USER = X_CURRENT_USER;
178: X_LAST_UPDATE_DATE DATE;
179: X_LAST_UPDATED_BY NUMBER;

Line 211: insert into IGS_CA_DT_OF_MTH (

207: x_last_update_date =>X_LAST_UPDATE_DATE,
208: x_last_updated_by =>X_LAST_UPDATED_BY,
209: x_last_update_login =>X_LAST_UPDATE_LOGIN
210: );
211: insert into IGS_CA_DT_OF_MTH (
212: DT_OF_MONTH,
213: CURRENT_USER,
214: CREATION_DATE,
215: CREATED_BY,

Line 244: from IGS_CA_DT_OF_MTH

240: X_DT_OF_MONTH in DATE,
241: X_CURRENT_USER in VARCHAR2
242: ) AS
243: cursor c1 is select ROWID
244: from IGS_CA_DT_OF_MTH
245: where ROWID=X_ROWID
246: for update nowait;
247: tlinfo c1%rowtype;
248: begin

Line 270: delete from IGS_CA_DT_OF_MTH

266: Before_DML (
267: p_action =>'DELETE',
268: x_rowid =>X_ROWID
269: );
270: delete from IGS_CA_DT_OF_MTH
271: where ROWID=X_ROWID;
272: if (sql%notfound) then
273: raise no_data_found;
274: end if;

Line 277: end IGS_CA_DT_OF_MTH_PKG;

273: raise no_data_found;
274: end if;
275: end DELETE_ROW;
276:
277: end IGS_CA_DT_OF_MTH_PKG;