APPS.IGS_AD_PRD_PS_OF_OPT_PKG dependencies on IGS_AD_PRD_PS_OF_OPT

Line 1: package body IGS_AD_PRD_PS_OF_OPT_PKG AS

1: package body IGS_AD_PRD_PS_OF_OPT_PKG AS
2: /* $Header: IGSAI31B.pls 115.5 2003/10/30 13:19:48 rghosh ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRD_PS_OF_OPT%RowType;
5: new_references IGS_AD_PRD_PS_OF_OPT%RowType;

Line 4: old_references IGS_AD_PRD_PS_OF_OPT%RowType;

1: package body IGS_AD_PRD_PS_OF_OPT_PKG AS
2: /* $Header: IGSAI31B.pls 115.5 2003/10/30 13:19:48 rghosh ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRD_PS_OF_OPT%RowType;
5: new_references IGS_AD_PRD_PS_OF_OPT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_PRD_PS_OF_OPT%RowType;

1: package body IGS_AD_PRD_PS_OF_OPT_PKG AS
2: /* $Header: IGSAI31B.pls 115.5 2003/10/30 13:19:48 rghosh ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRD_PS_OF_OPT%RowType;
5: new_references IGS_AD_PRD_PS_OF_OPT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_AD_PRD_PS_OF_OPT

27: ) AS
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_AD_PRD_PS_OF_OPT
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 408: FROM IGS_AD_PRD_PS_OF_OPT

404: RETURN BOOLEAN
405: AS
406: CURSOR cur_rowid IS
407: SELECT rowid
408: FROM IGS_AD_PRD_PS_OF_OPT
409: WHERE adm_cal_type = x_adm_cal_type
410: AND adm_ci_sequence_number = x_adm_ci_sequence_number
411: AND admission_cat = x_admission_cat
412: AND s_admission_process_type = x_s_admission_process_type

Line 440: FROM IGS_AD_PRD_PS_OF_OPT

436: ) AS
437:
438: CURSOR cur_rowid IS
439: SELECT rowid
440: FROM IGS_AD_PRD_PS_OF_OPT
441: WHERE attendance_mode = x_attendance_mode ;
442:
443: lv_rowid cur_rowid%RowType;
444:

Line 469: FROM IGS_AD_PRD_PS_OF_OPT

465: ) AS
466:
467: CURSOR cur_rowid IS
468: SELECT rowid
469: FROM IGS_AD_PRD_PS_OF_OPT
470: WHERE adm_cal_type = x_adm_cal_type
471: AND adm_ci_sequence_number = x_adm_ci_sequence_number
472: AND admission_cat = x_admission_cat
473: AND s_admission_process_type = x_s_admission_process_type ;

Line 498: FROM IGS_AD_PRD_PS_OF_OPT

494: ) AS
495:
496: CURSOR cur_rowid IS
497: SELECT rowid
498: FROM IGS_AD_PRD_PS_OF_OPT
499: WHERE attendance_type = x_attendance_type ;
500:
501: lv_rowid cur_rowid%RowType;
502:

Line 526: FROM IGS_AD_PRD_PS_OF_OPT

522: ) AS
523:
524: CURSOR cur_rowid IS
525: SELECT rowid
526: FROM IGS_AD_PRD_PS_OF_OPT
527: WHERE course_cd = x_course_cd
528: AND version_number = x_version_number
529: AND acad_cal_type = x_cal_type ;
530:

Line 554: FROM IGS_AD_PRD_PS_OF_OPT

550: ) AS
551:
552: CURSOR cur_rowid IS
553: SELECT rowid
554: FROM IGS_AD_PRD_PS_OF_OPT
555: WHERE location_cd = x_location_cd ;
556:
557: lv_rowid cur_rowid%RowType;
558:

Line 696: cursor C is select ROWID from IGS_AD_PRD_PS_OF_OPT

692: X_ATTENDANCE_TYPE in VARCHAR2,
693: X_ROLLOVER_INCLUSION_IND in VARCHAR2,
694: X_MODE in VARCHAR2 default 'R'
695: ) AS
696: cursor C is select ROWID from IGS_AD_PRD_PS_OF_OPT
697: where ADM_CAL_TYPE = X_ADM_CAL_TYPE
698: and ADM_CI_SEQUENCE_NUMBER = X_ADM_CI_SEQUENCE_NUMBER
699: and ADMISSION_CAT = X_ADMISSION_CAT
700: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE

Line 764: insert into IGS_AD_PRD_PS_OF_OPT (

760: x_last_updated_by => X_LAST_UPDATED_BY,
761: x_last_update_login => X_LAST_UPDATE_LOGIN
762: );
763:
764: insert into IGS_AD_PRD_PS_OF_OPT (
765: ADM_CAL_TYPE,
766: ADM_CI_SEQUENCE_NUMBER,
767: ADMISSION_CAT,
768: S_ADMISSION_PROCESS_TYPE,

Line 844: from IGS_AD_PRD_PS_OF_OPT

840: LOCATION_CD,
841: ATTENDANCE_MODE,
842: ATTENDANCE_TYPE,
843: ROLLOVER_INCLUSION_IND
844: from IGS_AD_PRD_PS_OF_OPT
845: where ROWID = X_ROWID for update nowait;
846: tlinfo c1%rowtype;
847:
848: begin

Line 956: update IGS_AD_PRD_PS_OF_OPT set

952: else
953: X_PROGRAM_UPDATE_DATE := SYSDATE;
954: end if;
955: end if;
956: update IGS_AD_PRD_PS_OF_OPT set
957: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
958: ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
959: ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
960: ROLLOVER_INCLUSION_IND = NEW_REFERENCES.ROLLOVER_INCLUSION_IND,

Line 997: cursor c1 is select rowid from IGS_AD_PRD_PS_OF_OPT

993: X_ATTENDANCE_TYPE in VARCHAR2,
994: X_ROLLOVER_INCLUSION_IND in VARCHAR2,
995: X_MODE in VARCHAR2 default 'R'
996: ) AS
997: cursor c1 is select rowid from IGS_AD_PRD_PS_OF_OPT
998: where ADM_CAL_TYPE = X_ADM_CAL_TYPE
999: and ADM_CI_SEQUENCE_NUMBER = X_ADM_CI_SEQUENCE_NUMBER
1000: and ADMISSION_CAT = X_ADMISSION_CAT
1001: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE

Line 1055: delete from IGS_AD_PRD_PS_OF_OPT

1051: Before_DML(
1052: p_action =>'DELETE',
1053: x_rowid => X_ROWID
1054: );
1055: delete from IGS_AD_PRD_PS_OF_OPT
1056: where ROWID = X_ROWID;
1057: if (sql%notfound) then
1058: raise no_data_found;
1059: end if;

Line 1066: end IGS_AD_PRD_PS_OF_OPT_PKG;

1062: x_rowid => X_ROWID
1063: );
1064: end DELETE_ROW;
1065:
1066: end IGS_AD_PRD_PS_OF_OPT_PKG;