APPS.IGS_AD_APPL_PGMAPPRV_PKG dependencies on IGS_AD_APPL_PGMAPPRV

Line 1: PACKAGE BODY igs_ad_appl_pgmapprv_pkg AS

1: PACKAGE BODY igs_ad_appl_pgmapprv_pkg AS
2: /* $Header: IGSAIA5B.pls 120.5 2005/10/03 08:23:00 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_pgmapprv%RowType;
5: new_references igs_ad_appl_pgmapprv%RowType;

Line 4: old_references igs_ad_appl_pgmapprv%RowType;

1: PACKAGE BODY igs_ad_appl_pgmapprv_pkg AS
2: /* $Header: IGSAIA5B.pls 120.5 2005/10/03 08:23:00 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_pgmapprv%RowType;
5: new_references igs_ad_appl_pgmapprv%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_appl_pgmapprv%RowType;

1: PACKAGE BODY igs_ad_appl_pgmapprv_pkg AS
2: /* $Header: IGSAIA5B.pls 120.5 2005/10/03 08:23:00 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_pgmapprv%RowType;
5: new_references igs_ad_appl_pgmapprv%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 41: FROM IGS_AD_APPL_PGMAPPRV

37: ***************************************************************/
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM IGS_AD_APPL_PGMAPPRV
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 228: FROM igs_ad_appl_pgmapprv

224: ***************************************************************/
225:
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_ad_appl_pgmapprv
229: WHERE appl_pgmapprv_id = x_appl_pgmapprv_id
230: FOR UPDATE NOWAIT;
231:
232: lv_rowid cur_rowid%RowType;

Line 268: FROM igs_ad_appl_pgmapprv

264: ***************************************************************/
265:
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM igs_ad_appl_pgmapprv
269: WHERE pgm_approver_id = x_pgm_approver_id
270: AND sequence_number = x_sequence_number
271: AND admission_appl_number = x_admission_appl_number
272: AND nominated_course_cd = x_nominated_course_cd

Line 310: FROM igs_ad_appl_pgmapprv

306: ***************************************************************/
307:
308: CURSOR cur_rowid IS
309: SELECT rowid
310: FROM igs_ad_appl_pgmapprv
311: WHERE person_id = x_person_id
312: AND admission_appl_number = x_admission_appl_number
313: AND nominated_course_cd = x_nominated_course_cd
314: AND sequence_number = x_sequence_number ;

Line 350: FROM igs_ad_appl_pgmapprv

346: ***************************************************************/
347:
348: CURSOR cur_rowid IS
349: SELECT rowid
350: FROM igs_ad_appl_pgmapprv
351: WHERE pgm_approver_id = x_person_id ;
352:
353: lv_rowid cur_rowid%RowType;
354:

Line 533: cursor C is select ROWID from IGS_AD_APPL_PGMAPPRV

529: present only in specification
530: (reverse chronological order - newest change first)
531: ***************************************************************/
532:
533: cursor C is select ROWID from IGS_AD_APPL_PGMAPPRV
534: where APPL_PGMAPPRV_ID= X_APPL_PGMAPPRV_ID
535: ;
536: X_LAST_UPDATE_DATE DATE ;
537: X_LAST_UPDATED_BY NUMBER ;

Line 601: insert into IGS_AD_APPL_PGMAPPRV (

597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.set_ctx('R');
599: END IF;
600:
601: insert into IGS_AD_APPL_PGMAPPRV (
602: APPL_PGMAPPRV_ID
603: ,PERSON_ID
604: ,ADMISSION_APPL_NUMBER
605: ,NOMINATED_COURSE_CD

Line 623: IGS_AD_APPL_PGMAPPRV_S.NEXTVAL

619: ,PROGRAM_ID
620: ,PROGRAM_APPLICATION_ID
621: ,PROGRAM_UPDATE_DATE
622: ) values (
623: IGS_AD_APPL_PGMAPPRV_S.NEXTVAL
624: ,NEW_REFERENCES.PERSON_ID
625: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
626: ,NEW_REFERENCES.NOMINATED_COURSE_CD
627: ,NEW_REFERENCES.SEQUENCE_NUMBER

Line 722: from IGS_AD_APPL_PGMAPPRV

718: , ASSIGN_DATE
719: , PROGRAM_APPROVAL_DATE
720: , PROGRAM_APPROVAL_STATUS
721: , APPROVAL_NOTES
722: from IGS_AD_APPL_PGMAPPRV
723: where ROWID = X_ROWID
724: for update nowait;
725: tlinfo c1%rowtype;
726: begin

Line 857: update IGS_AD_APPL_PGMAPPRV set

853:
854: IF (x_mode = 'S') THEN
855: igs_sc_gen_001.set_ctx('R');
856: END IF;
857: update IGS_AD_APPL_PGMAPPRV set
858: PERSON_ID = NEW_REFERENCES.PERSON_ID,
859: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
860: NOMINATED_COURSE_CD = NEW_REFERENCES.NOMINATED_COURSE_CD,
861: SEQUENCE_NUMBER = NEW_REFERENCES.SEQUENCE_NUMBER,

Line 936: cursor c1 is select ROWID from IGS_AD_APPL_PGMAPPRV

932: present only in specification
933: (reverse chronological order - newest change first)
934: ***************************************************************/
935:
936: cursor c1 is select ROWID from IGS_AD_APPL_PGMAPPRV
937: where APPL_PGMAPPRV_ID= X_APPL_PGMAPPRV_ID
938: ;
939:
940: l_mode VARCHAR2(1);

Line 1002: delete from IGS_AD_APPL_PGMAPPRV

998: );
999: IF (x_mode = 'S') THEN
1000: igs_sc_gen_001.set_ctx('R');
1001: END IF;
1002: delete from IGS_AD_APPL_PGMAPPRV
1003: where ROWID = X_ROWID;
1004: if (sql%notfound) then
1005: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1006: igs_ge_msg_stack.add;

Line 1034: END igs_ad_appl_pgmapprv_pkg;

1030: ELSE
1031: RAISE;
1032: END IF;
1033: end DELETE_ROW;
1034: END igs_ad_appl_pgmapprv_pkg;