APPS.IGS_AD_PRCS_CAT_PKG dependencies on IGS_AD_PRCS_CAT_ALL

Line 4: old_references igs_ad_prcs_cat_all%RowType;

1: PACKAGE BODY igs_ad_prcs_cat_pkg AS
2: /* $Header: IGSAI09B.pls 115.14 2003/10/30 13:10:20 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_prcs_cat_all%RowType;
5: new_references igs_ad_prcs_cat_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_prcs_cat_all%RowType;

1: PACKAGE BODY igs_ad_prcs_cat_pkg AS
2: /* $Header: IGSAI09B.pls 115.14 2003/10/30 13:10:20 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_prcs_cat_all%RowType;
5: new_references igs_ad_prcs_cat_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 35: FROM IGS_AD_PRCS_CAT_ALL

31: ***************************************************************/
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_AD_PRCS_CAT_ALL
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 79: v_admission_cat IGS_AD_PRCS_CAT_ALL.admission_cat%TYPE;

75: p_inserting IN BOOLEAN,
76: p_updating IN BOOLEAN,
77: p_deleting IN BOOLEAN
78: ) AS
79: v_admission_cat IGS_AD_PRCS_CAT_ALL.admission_cat%TYPE;
80: v_message_name varchar2(30);
81: BEGIN
82: -- Set the Admission Category value.
83: IF p_deleting THEN

Line 269: FROM igs_ad_prcs_cat_all

265: ***************************************************************/
266:
267: CURSOR cur_rowid IS
268: SELECT rowid
269: FROM igs_ad_prcs_cat_all
270: WHERE admission_cat = x_admission_cat AND
271: s_admission_process_type = x_s_admission_process_type AND
272: closed_ind = NVL(x_closed_ind,closed_ind);
273:

Line 306: FROM IGS_AD_PRCS_CAT_ALL

302: ***************************************************************/
303:
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM IGS_AD_PRCS_CAT_ALL
307: WHERE admission_cat = x_admission_cat ;
308:
309: lv_rowid cur_rowid%RowType;
310:

Line 342: FROM IGS_AD_PRCS_CAT_ALL

338: (reverse chronological order - newest change first)
339: ***************************************************************/
340: CURSOR cur_rowid IS
341: SELECT rowid
342: FROM IGS_AD_PRCS_CAT_ALL
343: WHERE s_admission_process_type = x_s_admission_process_type ;
344:
345: lv_rowid cur_rowid%RowType;
346:

Line 496: cursor C is select ROWID from IGS_AD_PRCS_CAT_ALL

492:
493: (reverse chronological order - newest change first)
494: ***************************************************************/
495:
496: cursor C is select ROWID from IGS_AD_PRCS_CAT_ALL
497: where ADMISSION_CAT= X_ADMISSION_CAT
498: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE
499: ;
500: X_LAST_UPDATE_DATE DATE ;

Line 535: insert into IGS_AD_PRCS_CAT_ALL (

531: x_last_update_date=>X_LAST_UPDATE_DATE,
532: x_last_updated_by=>X_LAST_UPDATED_BY,
533: x_last_update_login=>X_LAST_UPDATE_LOGIN,
534: x_closed_ind => x_closed_ind);
535: insert into IGS_AD_PRCS_CAT_ALL (
536: ORG_ID
537: ,ADMISSION_CAT
538: ,S_ADMISSION_PROCESS_TYPE
539: ,OFFER_RESPONSE_OFFSET

Line 590: from IGS_AD_PRCS_CAT_ALL

586:
587: cursor c1 is select
588: OFFER_RESPONSE_OFFSET,
589: CLOSED_IND
590: from IGS_AD_PRCS_CAT_ALL
591: where ROWID = X_ROWID
592: for update nowait;
593: tlinfo c1%rowtype;
594: begin

Line 671: update IGS_AD_PRCS_CAT_ALL set

667: x_last_update_date=>X_LAST_UPDATE_DATE,
668: x_last_updated_by=>X_LAST_UPDATED_BY,
669: x_last_update_login=>X_LAST_UPDATE_LOGIN,
670: x_closed_ind => x_closed_ind);
671: update IGS_AD_PRCS_CAT_ALL set
672: OFFER_RESPONSE_OFFSET = NEW_REFERENCES.OFFER_RESPONSE_OFFSET,
673: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
674: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
675: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 707: cursor c1 is select ROWID from IGS_AD_PRCS_CAT_ALL

703:
704: (reverse chronological order - newest change first)
705: ***************************************************************/
706:
707: cursor c1 is select ROWID from IGS_AD_PRCS_CAT_ALL
708: where ADMISSION_CAT= X_ADMISSION_CAT
709: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE
710: ;
711: begin

Line 754: delete from IGS_AD_PRCS_CAT_ALL

750: Before_DML (
751: p_action => 'DELETE',
752: x_rowid => X_ROWID
753: );
754: delete from IGS_AD_PRCS_CAT_ALL
755: where ROWID = X_ROWID;
756: if (sql%notfound) then
757: raise no_data_found;
758: end if;