APPS.IGS_AD_PRCS_CAT_LTR_PKG dependencies on IGS_AD_PRCS_CAT_LTR

Line 1: package body IGS_AD_PRCS_CAT_LTR_PKG AS

1: package body IGS_AD_PRCS_CAT_LTR_PKG AS
2: /* $Header: IGSAI36B.pls 115.6 2003/10/30 13:20:05 rghosh ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRCS_CAT_LTR%RowType;
5: new_references IGS_AD_PRCS_CAT_LTR%RowType;

Line 4: old_references IGS_AD_PRCS_CAT_LTR%RowType;

1: package body IGS_AD_PRCS_CAT_LTR_PKG AS
2: /* $Header: IGSAI36B.pls 115.6 2003/10/30 13:20:05 rghosh ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRCS_CAT_LTR%RowType;
5: new_references IGS_AD_PRCS_CAT_LTR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_PRCS_CAT_LTR%RowType;

1: package body IGS_AD_PRCS_CAT_LTR_PKG AS
2: /* $Header: IGSAI36B.pls 115.6 2003/10/30 13:20:05 rghosh ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRCS_CAT_LTR%RowType;
5: new_references IGS_AD_PRCS_CAT_LTR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_AD_PRCS_CAT_LTR

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_AD_PRCS_CAT_LTR
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 187: FROM IGS_AD_PRCS_CAT_LTR

183: AS
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM IGS_AD_PRCS_CAT_LTR
188: WHERE admission_cat = x_admission_cat
189: AND s_admission_process_type = x_s_admission_process_type
190: AND correspondence_type = x_correspondence_type
191: FOR UPDATE NOWAIT;

Line 216: FROM IGS_AD_PRCS_CAT_LTR

212: ) AS
213:
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM IGS_AD_PRCS_CAT_LTR
217: WHERE admission_cat = x_admission_cat
218: AND s_admission_process_type = x_s_admission_process_type ;
219:
220: lv_rowid cur_rowid%RowType;

Line 244: FROM IGS_AD_PRCS_CAT_LTR

240: ) AS
241:
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM IGS_AD_PRCS_CAT_LTR
245: WHERE correspondence_type = x_correspondence_type
246: AND letter_reference_number = x_letter_reference_number ;
247:
248: lv_rowid cur_rowid%RowType;

Line 347: cursor C is select ROWID from IGS_AD_PRCS_CAT_LTR

343: X_CORRESPONDENCE_TYPE in VARCHAR2,
344: X_LETTER_REFERENCE_NUMBER in NUMBER,
345: X_MODE in VARCHAR2 default 'R'
346: ) AS
347: cursor C is select ROWID from IGS_AD_PRCS_CAT_LTR
348: where ADMISSION_CAT = X_ADMISSION_CAT
349: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE
350: and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE;
351: X_LAST_UPDATE_DATE DATE;

Line 386: insert into IGS_AD_PRCS_CAT_LTR (

382: x_last_update_date => X_LAST_UPDATE_DATE,
383: x_last_updated_by => X_LAST_UPDATED_BY,
384: x_last_update_login => X_LAST_UPDATE_LOGIN
385: );
386: insert into IGS_AD_PRCS_CAT_LTR (
387: ADMISSION_CAT,
388: S_ADMISSION_PROCESS_TYPE,
389: CORRESPONDENCE_TYPE,
390: LETTER_REFERENCE_NUMBER,

Line 430: from IGS_AD_PRCS_CAT_LTR

426: X_LETTER_REFERENCE_NUMBER in NUMBER
427: ) AS
428: cursor c1 is select
429: LETTER_REFERENCE_NUMBER
430: from IGS_AD_PRCS_CAT_LTR
431: where ROWID = X_ROWID for update nowait;
432: tlinfo c1%rowtype;
433:
434: begin

Line 499: update IGS_AD_PRCS_CAT_LTR set

495: x_last_update_date => X_LAST_UPDATE_DATE,
496: x_last_updated_by => X_LAST_UPDATED_BY,
497: x_last_update_login => X_LAST_UPDATE_LOGIN
498: );
499: update IGS_AD_PRCS_CAT_LTR set
500: LETTER_REFERENCE_NUMBER = NEW_REFERENCES.LETTER_REFERENCE_NUMBER,
501: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
502: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
503: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 523: cursor c1 is select rowid from IGS_AD_PRCS_CAT_LTR

519: X_CORRESPONDENCE_TYPE in VARCHAR2,
520: X_LETTER_REFERENCE_NUMBER in NUMBER,
521: X_MODE in VARCHAR2 default 'R'
522: ) AS
523: cursor c1 is select rowid from IGS_AD_PRCS_CAT_LTR
524: where ADMISSION_CAT = X_ADMISSION_CAT
525: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE
526: and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE
527: ;

Line 561: delete from IGS_AD_PRCS_CAT_LTR

557: Before_DML(
558: p_action =>'DELETE',
559: x_rowid => X_ROWID
560: );
561: delete from IGS_AD_PRCS_CAT_LTR
562: where ROWID = X_ROWID;
563: if (sql%notfound) then
564: raise no_data_found;
565: end if;

Line 572: end IGS_AD_PRCS_CAT_LTR_PKG;

568: x_rowid => X_ROWID
569: );
570: end DELETE_ROW;
571:
572: end IGS_AD_PRCS_CAT_LTR_PKG;