APPS.IGS_AD_PERD_AD_CAT_PKG dependencies on IGS_AD_PERD_AD_CAT

Line 1: package body IGS_AD_PERD_AD_CAT_PKG as

1: package body IGS_AD_PERD_AD_CAT_PKG as
2: /* $Header: IGSAI29B.pls 115.11 2003/10/30 13:19:40 rghosh ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_PERD_AD_CAT%RowType;

Line 5: old_references IGS_AD_PERD_AD_CAT%RowType;

1: package body IGS_AD_PERD_AD_CAT_PKG as
2: /* $Header: IGSAI29B.pls 115.11 2003/10/30 13:19:40 rghosh ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_PERD_AD_CAT%RowType;
6: new_references IGS_AD_PERD_AD_CAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_PERD_AD_CAT%RowType;

2: /* $Header: IGSAI29B.pls 115.11 2003/10/30 13:19:40 rghosh ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_PERD_AD_CAT%RowType;
6: new_references IGS_AD_PERD_AD_CAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_AD_PERD_AD_CAT

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_AD_PERD_AD_CAT
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 179: IGS_AD_PRD_AD_PRC_CA_PKG.GET_FK_IGS_AD_PERD_AD_CAT (

175:
176: PROCEDURE Check_Child_Existance AS
177: BEGIN
178:
179: IGS_AD_PRD_AD_PRC_CA_PKG.GET_FK_IGS_AD_PERD_AD_CAT (
180: old_references.adm_cal_type,
181: old_references.adm_ci_sequence_number,
182: old_references.admission_cat
183: );

Line 185: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_AD_PERD_AD_CAT (

181: old_references.adm_ci_sequence_number,
182: old_references.admission_cat
183: );
184:
185: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_AD_PERD_AD_CAT (
186: old_references.adm_cal_type,
187: old_references.adm_ci_sequence_number,
188: old_references.admission_cat
189: );

Line 202: FROM IGS_AD_PERD_AD_CAT

198: RETURN BOOLEAN
199: AS
200: CURSOR cur_rowid IS
201: SELECT rowid
202: FROM IGS_AD_PERD_AD_CAT
203: WHERE adm_cal_type = x_adm_cal_type
204: AND adm_ci_sequence_number = x_adm_ci_sequence_number
205: AND admission_cat = x_admission_cat;
206:

Line 228: FROM IGS_AD_PERD_AD_CAT

224: ) AS
225:
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM IGS_AD_PERD_AD_CAT
229: WHERE admission_cat = x_admission_cat ;
230:
231: lv_rowid cur_rowid%RowType;
232:

Line 257: FROM IGS_AD_PERD_AD_CAT

253: ) AS
254:
255: CURSOR cur_rowid IS
256: SELECT rowid
257: FROM IGS_AD_PERD_AD_CAT
258: WHERE adm_cal_type = x_cal_type
259: AND adm_ci_sequence_number = x_sequence_number
260: AND TRUNC(ci_start_dt) = TRUNC(x_start_dt)
261: AND TRUNC(ci_end_dt) = TRUNC(x_end_dt) ;

Line 357: cursor C is select ROWID from IGS_AD_PERD_AD_CAT

353: X_CI_START_DT in DATE,
354: X_CI_END_DT in DATE,
355: X_MODE in VARCHAR2 default 'R'
356: ) AS
357: cursor C is select ROWID from IGS_AD_PERD_AD_CAT
358: where ADM_CAL_TYPE = X_ADM_CAL_TYPE
359: and ADM_CI_SEQUENCE_NUMBER = X_ADM_CI_SEQUENCE_NUMBER
360: and ADMISSION_CAT = X_ADMISSION_CAT;
361: X_LAST_UPDATE_DATE DATE;

Line 413: insert into IGS_AD_PERD_AD_CAT (

409: x_last_updated_by => X_LAST_UPDATED_BY,
410: x_last_update_login => X_LAST_UPDATE_LOGIN
411: );
412:
413: insert into IGS_AD_PERD_AD_CAT (
414: ADM_CAL_TYPE,
415: ADM_CI_SEQUENCE_NUMBER,
416: ADMISSION_CAT,
417: CI_START_DT,

Line 465: from IGS_AD_PERD_AD_CAT

461: ) AS
462: cursor c1 is select
463: CI_START_DT,
464: CI_END_DT
465: from IGS_AD_PERD_AD_CAT
466: where ROWID = X_ROWID for update nowait;
467: tlinfo c1%rowtype;
468:
469: begin

Line 555: update IGS_AD_PERD_AD_CAT set

551: else
552: X_PROGRAM_UPDATE_DATE := SYSDATE;
553: end if;
554: end if;
555: update IGS_AD_PERD_AD_CAT set
556: CI_START_DT = NEW_REFERENCES.CI_START_DT,
557: CI_END_DT = NEW_REFERENCES.CI_END_DT,
558: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
559: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 581: cursor c1 is select rowid from IGS_AD_PERD_AD_CAT

577: X_CI_START_DT in DATE,
578: X_CI_END_DT in DATE,
579: X_MODE in VARCHAR2 default 'R'
580: ) AS
581: cursor c1 is select rowid from IGS_AD_PERD_AD_CAT
582: where ADM_CAL_TYPE = X_ADM_CAL_TYPE
583: and ADM_CI_SEQUENCE_NUMBER = X_ADM_CI_SEQUENCE_NUMBER
584: and ADMISSION_CAT = X_ADMISSION_CAT
585: ;

Line 621: delete from IGS_AD_PERD_AD_CAT

617: Before_DML(
618: p_action =>'DELETE',
619: x_rowid => X_ROWID
620: );
621: delete from IGS_AD_PERD_AD_CAT
622: where ROWID = X_ROWID;
623: if (sql%notfound) then
624: raise no_data_found;
625: end if;

Line 628: end IGS_AD_PERD_AD_CAT_PKG;

624: raise no_data_found;
625: end if;
626: end DELETE_ROW;
627:
628: end IGS_AD_PERD_AD_CAT_PKG;