APPS.IGS_AD_PS_APPL_PKG dependencies on IGS_AD_PS_APPL_ALL

Line 5: old_references IGS_AD_PS_APPL_ALL%RowType;

1: package body IGS_AD_PS_APPL_PKG as
2: /* $Header: IGSAI16B.pls 120.1 2005/07/14 00:57:40 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_PS_APPL_ALL%RowType;
6: new_references IGS_AD_PS_APPL_ALL%RowType;
7:
8:
9: PROCEDURE Set_Column_Values (

Line 6: new_references IGS_AD_PS_APPL_ALL%RowType;

2: /* $Header: IGSAI16B.pls 120.1 2005/07/14 00:57:40 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_PS_APPL_ALL%RowType;
6: new_references IGS_AD_PS_APPL_ALL%RowType;
7:
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 32: FROM IGS_AD_PS_APPL_ALL

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

Line 560: FROM IGS_AD_PS_APPL_ALL

556: RETURN BOOLEAN AS
557:
558: CURSOR cur_rowid IS
559: SELECT rowid
560: FROM IGS_AD_PS_APPL_ALL
561: WHERE person_id = x_person_id
562: AND admission_appl_number = x_admission_appl_number
563: AND nominated_course_cd = x_nominated_course_cd
564: FOR UPDATE NOWAIT;

Line 590: FROM IGS_AD_PS_APPL_ALL

586: ) AS
587:
588: CURSOR cur_rowid IS
589: SELECT rowid
590: FROM IGS_AD_PS_APPL_ALL
591: WHERE person_id = x_person_id
592: AND admission_appl_number = x_admission_appl_number ;
593:
594: lv_rowid cur_rowid%RowType;

Line 617: FROM IGS_AD_PS_APPL_ALL

613: ) AS
614:
615: CURSOR cur_rowid IS
616: SELECT rowid
617: FROM IGS_AD_PS_APPL_ALL
618: WHERE admission_cd = x_admission_cd ;
619:
620: lv_rowid cur_rowid%RowType;
621:

Line 643: FROM IGS_AD_PS_APPL_ALL

639: ) AS
640:
641: CURSOR cur_rowid IS
642: SELECT rowid
643: FROM IGS_AD_PS_APPL_ALL
644: WHERE basis_for_admission_type = x_basis_for_admission_type ;
645:
646: lv_rowid cur_rowid%RowType;
647:

Line 669: FROM IGS_AD_PS_APPL_ALL

665: ) AS
666:
667: CURSOR cur_rowid IS
668: SELECT rowid
669: FROM IGS_AD_PS_APPL_ALL
670: WHERE nominated_course_cd = x_course_cd ;
671:
672: lv_rowid cur_rowid%RowType;
673:

Line 696: FROM IGS_AD_PS_APPL_ALL

692: ) AS
693:
694: CURSOR cur_rowid IS
695: SELECT rowid
696: FROM IGS_AD_PS_APPL_ALL
697: WHERE person_id = x_person_id
698: AND transfer_course_cd = x_course_cd ;
699:
700: lv_rowid cur_rowid%RowType;

Line 912: cursor C is select ROWID from IGS_AD_PS_APPL_ALL

908: X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
909: X_REQ_FOR_ADV_STANDING_IND in VARCHAR2,
910: X_MODE in VARCHAR2
911: ) as
912: cursor C is select ROWID from IGS_AD_PS_APPL_ALL
913: where PERSON_ID = X_PERSON_ID
914: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
915: and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD;
916: X_LAST_UPDATE_DATE DATE;

Line 978: insert into IGS_AD_PS_APPL_ALL (

974:
975: IF (x_mode = 'S') THEN
976: igs_sc_gen_001.set_ctx('R');
977: END IF;
978: insert into IGS_AD_PS_APPL_ALL (
979: ORG_ID,
980: PERSON_ID,
981: ADMISSION_APPL_NUMBER,
982: NOMINATED_COURSE_CD,

Line 1080: from IGS_AD_PS_APPL_ALL

1076: COURSE_RANK_SET,
1077: COURSE_RANK_SCHEDULE,
1078: REQ_FOR_RECONSIDERATION_IND,
1079: REQ_FOR_ADV_STANDING_IND
1080: from IGS_AD_PS_APPL_ALL
1081: where ROWID = X_ROWID
1082: for update nowait;
1083: tlinfo c1%rowtype;
1084:

Line 1201: update IGS_AD_PS_APPL_ALL set

1197: end if;
1198: IF (x_mode = 'S') THEN
1199: igs_sc_gen_001.set_ctx('R');
1200: END IF;
1201: update IGS_AD_PS_APPL_ALL set
1202: TRANSFER_COURSE_CD = NEW_REFERENCES.TRANSFER_COURSE_CD,
1203: BASIS_FOR_ADMISSION_TYPE = NEW_REFERENCES.BASIS_FOR_ADMISSION_TYPE,
1204: ADMISSION_CD = NEW_REFERENCES.ADMISSION_CD,
1205: COURSE_RANK_SET = NEW_REFERENCES.COURSE_RANK_SET,

Line 1271: cursor c1 is select rowid from IGS_AD_PS_APPL_ALL

1267: X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
1268: X_REQ_FOR_ADV_STANDING_IND in VARCHAR2,
1269: X_MODE in VARCHAR2
1270: ) as
1271: cursor c1 is select rowid from IGS_AD_PS_APPL_ALL
1272: where PERSON_ID = X_PERSON_ID
1273: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
1274: and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
1275: ;

Line 1327: delete from IGS_AD_PS_APPL_ALL

1323:
1324: IF (x_mode = 'S') THEN
1325: igs_sc_gen_001.set_ctx('R');
1326: END IF;
1327: delete from IGS_AD_PS_APPL_ALL
1328: where ROWID = X_ROWID;
1329: if (sql%notfound) then
1330: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1331: igs_ge_msg_stack.add;