eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_RU_APPL_PKG dependencies on IGS_PR_RU_APPL_ALL

Line 5: old_references IGS_PR_RU_APPL_ALL%RowType;

1: package body IGS_PR_RU_APPL_PKG AS
2: /* $Header: IGSQI10B.pls 115.15 2003/06/05 13:02:48 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RU_APPL_ALL%RowType;
6: new_references IGS_PR_RU_APPL_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_RU_APPL_ALL%RowType;

2: /* $Header: IGSQI10B.pls 115.15 2003/06/05 13:02:48 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RU_APPL_ALL%RowType;
6: new_references IGS_PR_RU_APPL_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 46: FROM IGS_PR_RU_APPL_ALL

42: ) AS
43:
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM IGS_PR_RU_APPL_ALL
47: WHERE rowid = x_rowid;
48:
49: BEGIN
50:

Line 447: FROM IGS_PR_RU_APPL_ALL

443: ) RETURN BOOLEAN AS
444:
445: CURSOR cur_rowid IS
446: SELECT rowid
447: FROM IGS_PR_RU_APPL_ALL
448: WHERE progression_rule_cat = x_progression_rule_cat
449: AND sequence_number = x_sequence_number
450: FOR UPDATE NOWAIT;
451:

Line 473: FROM IGS_PR_RU_APPL_ALL

469: ) AS
470:
471: CURSOR cur_rowid IS
472: SELECT rowid,logical_delete_dt
473: FROM IGS_PR_RU_APPL_ALL
474: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id;
475:
476: lv_rowid cur_rowid%RowType;
477:

Line 499: FROM IGS_PR_RU_APPL_ALL

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

Line 526: FROM IGS_PR_RU_APPL_ALL

522: ) AS
523:
524: CURSOR cur_rowid IS
525: SELECT rowid,logical_delete_dt
526: FROM IGS_PR_RU_APPL_ALL
527: WHERE crv_course_cd = x_course_cd
528: AND crv_version_number = x_version_number ;
529:
530: lv_rowid cur_rowid%RowType;

Line 555: FROM IGS_PR_RU_APPL_ALL

551: ) AS
552:
553: CURSOR cur_rowid IS
554: SELECT rowid,logical_delete_dt
555: FROM IGS_PR_RU_APPL_ALL
556: WHERE ou_org_unit_cd = x_org_unit_cd
557: AND ou_start_dt = x_start_dt ;
558:
559: lv_rowid cur_rowid%RowType;

Line 582: FROM IGS_PR_RU_APPL_ALL

578: ) AS
579:
580: CURSOR cur_rowid IS
581: SELECT rowid,logical_delete_dt
582: FROM IGS_PR_RU_APPL_ALL
583: WHERE progression_rule_cat = x_progression_rule_cat ;
584:
585: lv_rowid cur_rowid%RowType;
586:

Line 611: FROM IGS_PR_RU_APPL_ALL

607: ) AS
608:
609: CURSOR cur_rowid IS
610: SELECT rowid,logical_delete_dt
611: FROM IGS_PR_RU_APPL_ALL
612: WHERE pro_progression_rule_cat = x_progression_rule_cat
613: AND pro_pra_sequence_number = x_pra_sequence_number
614: AND pro_sequence_number = x_sequence_number ;
615:

Line 641: FROM IGS_PR_RU_APPL_ALL

637: ) AS
638:
639: CURSOR cur_rowid IS
640: SELECT rowid,logical_delete_dt
641: FROM IGS_PR_RU_APPL_ALL
642: WHERE progression_rule_cat = x_progression_rule_cat
643: AND progression_rule_cd = x_progression_rule_cd ;
644:
645: lv_rowid cur_rowid%RowType;

Line 670: FROM IGS_PR_RU_APPL_ALL

666: ) AS
667:
668: CURSOR cur_rowid IS
669: SELECT rowid,logical_delete_dt
670: FROM IGS_PR_RU_APPL_ALL
671: WHERE sca_person_id = x_person_id
672: AND sca_course_cd = x_course_cd ;
673:
674: lv_rowid cur_rowid%RowType;

Line 700: FROM IGS_PR_RU_APPL_ALL

696: ) AS
697:
698: CURSOR cur_rowid IS
699: SELECT rowid,logical_delete_dt
700: FROM IGS_PR_RU_APPL_ALL
701: WHERE spo_person_id = x_person_id
702: AND spo_course_cd = x_course_cd
703: AND spo_sequence_number = x_sequence_number ;
704:

Line 943: cursor C is select ROWID from IGS_PR_RU_APPL_ALL

939: X_MIN_CP IN NUMBER DEFAULT NULL,
940: X_MAX_CP IN NUMBER DEFAULT NULL,
941: X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
942: ) AS
943: cursor C is select ROWID from IGS_PR_RU_APPL_ALL
944: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
945: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
946: X_LAST_UPDATE_DATE DATE;
947: X_LAST_UPDATED_BY NUMBER;

Line 1005: insert into IGS_PR_RU_APPL_ALL (

1001: x_max_cp => x_max_cp,
1002: x_igs_pr_class_std_id => x_igs_pr_class_std_id
1003: );
1004:
1005: insert into IGS_PR_RU_APPL_ALL (
1006: PROGRESSION_RULE_CAT,
1007: SEQUENCE_NUMBER,
1008: S_RELATION_TYPE,
1009: PROGRESSION_RULE_CD,

Line 1132: from IGS_PR_RU_APPL_ALL

1128: MESSAGE,
1129: MIN_CP,
1130: MAX_CP,
1131: IGS_PR_CLASS_STD_ID
1132: from IGS_PR_RU_APPL_ALL
1133: where ROWID = X_ROWID for update nowait;
1134: tlinfo c1%rowtype;
1135:
1136: begin

Line 1312: update IGS_PR_RU_APPL_ALL set

1308: x_max_cp => x_max_cp,
1309: x_igs_pr_class_std_id => x_igs_pr_class_std_id
1310: );
1311:
1312: update IGS_PR_RU_APPL_ALL set
1313: S_RELATION_TYPE = NEW_REFERENCES.S_RELATION_TYPE,
1314: PROGRESSION_RULE_CD = NEW_REFERENCES.PROGRESSION_RULE_CD,
1315: REFERENCE_CD = NEW_REFERENCES.REFERENCE_CD,
1316: RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,

Line 1376: cursor c1 is select rowid from IGS_PR_RU_APPL_ALL

1372: X_MIN_CP IN NUMBER DEFAULT NULL,
1373: X_MAX_CP IN NUMBER DEFAULT NULL,
1374: X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
1375: ) AS
1376: cursor c1 is select rowid from IGS_PR_RU_APPL_ALL
1377: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
1378: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER ;
1379: begin
1380: open c1;

Line 1455: delete from IGS_PR_RU_APPL_ALL

1451: Before_DML (
1452: p_action => 'DELETE',
1453: x_rowid => X_ROWID
1454: );
1455: delete from IGS_PR_RU_APPL_ALL
1456: where ROWID = X_ROWID;
1457: if (sql%notfound) then
1458: raise no_data_found;
1459: end if;