APPS.IGS_PR_STDNT_PR_OU_PKG dependencies on IGS_PR_STDNT_PR_OU_ALL

Line 6: old_references IGS_PR_STDNT_PR_OU_ALL%RowType;

2: /* $Header: IGSQI15B.pls 120.0 2005/07/05 12:07:10 appldev noship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PR_STDNT_PR_OU_ALL%RowType;
7: new_references IGS_PR_STDNT_PR_OU_ALL%RowType;
8:
9: /* Forward Declaration of apply_appr_outcome*/
10: PROCEDURE apply_appr_outcome;

Line 7: new_references IGS_PR_STDNT_PR_OU_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PR_STDNT_PR_OU_ALL%RowType;
7: new_references IGS_PR_STDNT_PR_OU_ALL%RowType;
8:
9: /* Forward Declaration of apply_appr_outcome*/
10: PROCEDURE apply_appr_outcome;
11:

Line 58: FROM IGS_PR_STDNT_PR_OU_ALL

54: ) AS
55:
56: CURSOR cur_old_ref_values IS
57: SELECT *
58: FROM IGS_PR_STDNT_PR_OU_ALL
59: WHERE ROWID = x_rowid;
60:
61: BEGIN
62:

Line 297: FROM igs_pr_stdnt_pr_ou_all

293: ) RETURN BOOLEAN AS
294:
295: CURSOR cur_rowid IS
296: SELECT ROWID
297: FROM igs_pr_stdnt_pr_ou_all
298: WHERE person_id = x_person_id
299: AND course_cd = x_course_cd
300: AND sequence_number = x_sequence_number
301: FOR UPDATE NOWAIT;

Line 325: FROM igs_pr_stdnt_pr_ou_all

321: ) AS
322:
323: CURSOR cur_rowid IS
324: SELECT ROWID
325: FROM igs_pr_stdnt_pr_ou_all
326: WHERE restricted_attendance_type = x_attendance_type ;
327:
328: lv_rowid cur_rowid%RowType;
329:

Line 353: FROM igs_pr_stdnt_pr_ou_all

349: ) AS
350:
351: CURSOR cur_rowid IS
352: SELECT ROWID
353: FROM igs_pr_stdnt_pr_ou_all
354: WHERE decision_org_unit_cd = x_org_unit_cd
355: AND decision_ou_start_dt = x_start_dt ;
356:
357: lv_rowid cur_rowid%RowType;

Line 380: FROM igs_pr_stdnt_pr_ou_all

376: ) AS
377:
378: CURSOR cur_rowid IS
379: SELECT ROWID
380: FROM igs_pr_stdnt_pr_ou_all
381: WHERE progression_outcome_type = x_progression_outcome_type ;
382:
383: lv_rowid cur_rowid%RowType;
384:

Line 408: FROM igs_pr_stdnt_pr_ou_all

404: ) AS
405:
406: CURSOR cur_rowid IS
407: SELECT ROWID
408: FROM igs_pr_stdnt_pr_ou_all
409: WHERE progression_rule_cat = x_progression_rule_cat
410: AND pro_pra_sequence_number = x_pra_sequence_number
411: AND pro_sequence_number = x_sequence_number ;
412:

Line 442: FROM igs_pr_stdnt_pr_ou_all

438: ) AS
439:
440: CURSOR cur_rowid IS
441: SELECT ROWID
442: FROM igs_pr_stdnt_pr_ou_all
443: WHERE person_id = x_person_id
444: AND course_cd = x_course_cd
445: AND prg_cal_type = x_prg_cal_type
446: AND prg_ci_sequence_number = x_prg_ci_sequence_number

Line 715: FROM igs_pr_stdnt_pr_ou_all

711: X_ORG_ID IN NUMBER
712: ) AS
713: CURSOR C IS
714: SELECT ROWID
715: FROM igs_pr_stdnt_pr_ou_all
716: WHERE person_id = x_person_id
717: AND course_cd = x_course_cd
718: AND sequence_number = x_sequence_number;
719: X_LAST_UPDATE_DATE DATE;

Line 789: INSERT INTO igs_pr_stdnt_pr_ou_all (

785:
786: IF (x_mode = 'S') THEN
787: igs_sc_gen_001.set_ctx('R');
788: END IF;
789: INSERT INTO igs_pr_stdnt_pr_ou_all (
790: person_id,
791: course_cd,
792: sequence_number,
793: prg_cal_type,

Line 965: FROM igs_pr_stdnt_pr_ou_all

961: show_cause_comments,
962: appeal_comments,
963: expiry_dt,
964: pro_pra_sequence_number
965: FROM igs_pr_stdnt_pr_ou_all
966: WHERE ROWID = x_rowid FOR UPDATE NOWAIT;
967: tlinfo c1%ROWTYPE;
968:
969: BEGIN

Line 1188: UPDATE igs_pr_stdnt_pr_ou_all SET

1184:
1185: IF (x_mode = 'S') THEN
1186: igs_sc_gen_001.set_ctx('R');
1187: END IF;
1188: UPDATE igs_pr_stdnt_pr_ou_all SET
1189: prg_cal_type = new_references.prg_cal_type,
1190: prg_ci_sequence_number = new_references.prg_ci_sequence_number,
1191: rule_check_dt = new_references.rule_check_dt,
1192: progression_rule_cat = new_references.progression_rule_cat,

Line 1290: FROM igs_pr_stdnt_pr_ou_all

1286: X_ORG_ID IN NUMBER
1287: ) AS
1288: CURSOR c1 IS
1289: SELECT ROWID
1290: FROM igs_pr_stdnt_pr_ou_all
1291: WHERE person_id = x_person_id
1292: AND course_cd = x_course_cd
1293: AND sequence_number = x_sequence_number;
1294: BEGIN

Line 1391: DELETE FROM igs_pr_stdnt_pr_ou_all

1387:
1388: IF (x_mode = 'S') THEN
1389: igs_sc_gen_001.set_ctx('R');
1390: END IF;
1391: DELETE FROM igs_pr_stdnt_pr_ou_all
1392: WHERE ROWID = x_rowid;
1393: IF (SQL%NOTFOUND) THEN
1394: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1395: igs_ge_msg_stack.add;