APPS.IGS_PR_RU_OU_PKG dependencies on IGS_PR_RU_OU_ALL

Line 5: old_references IGS_PR_RU_OU_ALL%RowType;

1: package body IGS_PR_RU_OU_PKG AS
2: /* $Header: IGSQI13B.pls 115.13 2003/02/26 07:00:32 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RU_OU_ALL%RowType;
6: new_references IGS_PR_RU_OU_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_RU_OU_ALL%RowType;

2: /* $Header: IGSQI13B.pls 115.13 2003/02/26 07:00:32 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RU_OU_ALL%RowType;
6: new_references IGS_PR_RU_OU_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 39: FROM IGS_PR_RU_OU_ALL

35: ) AS
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_PR_RU_OU_ALL
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 245: FROM IGS_PR_RU_OU_ALL

241: ) RETURN BOOLEAN AS
242:
243: CURSOR cur_rowid IS
244: SELECT rowid
245: FROM IGS_PR_RU_OU_ALL
246: WHERE progression_rule_cat = x_progression_rule_cat
247: AND pra_sequence_number = x_pra_sequence_number
248: AND sequence_number = x_sequence_number;
249:

Line 272: FROM IGS_PR_RU_OU_ALL

268: ) AS
269:
270: CURSOR cur_rowid IS
271: SELECT rowid
272: FROM IGS_PR_RU_OU_ALL
273: WHERE restricted_attendance_type = x_attendance_type ;
274:
275: lv_rowid cur_rowid%RowType;
276:

Line 299: FROM IGS_PR_RU_OU_ALL

295: ) AS
296:
297: CURSOR cur_rowid IS
298: SELECT rowid
299: FROM IGS_PR_RU_OU_ALL
300: WHERE progression_outcome_type = x_progression_outcome_type ;
301:
302: lv_rowid cur_rowid%RowType;
303:

Line 327: FROM IGS_PR_RU_OU_ALL

323: ) AS
324:
325: CURSOR cur_rowid IS
326: SELECT rowid
327: FROM IGS_PR_RU_OU_ALL
328: WHERE progression_rule_cat = x_progression_rule_cat
329: AND pra_sequence_number = x_sequence_number ;
330:
331: lv_rowid cur_rowid%RowType;

Line 355: FROM IGS_PR_RU_OU_ALL

351: ) AS
352:
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM IGS_PR_RU_OU_ALL
356: WHERE prg_rule_repeat_fail_type = x_s_prg_rule_repeat_fail_type ;
357:
358: lv_rowid cur_rowid%RowType;
359:

Line 536: cursor C is select ROWID from IGS_PR_RU_OU_ALL

532: X_ORG_ID IN NUMBER,
533: -- anilk, bug#2784198
534: X_LOGICAL_DELETE_DT in DATE
535: ) AS
536: cursor C is select ROWID from IGS_PR_RU_OU_ALL
537: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
538: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
539: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
540: X_LAST_UPDATE_DATE DATE;

Line 590: insert into IGS_PR_RU_OU_ALL (

586: x_org_id => igs_ge_gen_003.get_org_id,
587: -- anilk, bug#2784198
588: x_logical_delete_dt => x_logical_delete_dt
589: ) ;
590: insert into IGS_PR_RU_OU_ALL (
591: PROGRESSION_RULE_CAT,
592: PRA_SEQUENCE_NUMBER,
593: SEQUENCE_NUMBER,
594: NUMBER_OF_FAILURES,

Line 693: from IGS_PR_RU_OU_ALL

689: RESTRICTED_ATTENDANCE_TYPE,
690: COMMENTS,
691: -- anilk, bug#2784198
692: LOGICAL_DELETE_DT
693: from IGS_PR_RU_OU_ALL
694: where ROWID = X_ROWID for update nowait;
695: tlinfo c1%rowtype;
696:
697: begin

Line 830: update IGS_PR_RU_OU_ALL set

826: -- anilk, bug#2784198
827: x_logical_delete_dt => x_logical_delete_dt
828: ) ;
829:
830: update IGS_PR_RU_OU_ALL set
831: NUMBER_OF_FAILURES = NEW_REFERENCES.NUMBER_OF_FAILURES,
832: PROGRESSION_OUTCOME_TYPE = NEW_REFERENCES.PROGRESSION_OUTCOME_TYPE,
833: APPLY_AUTOMATICALLY_IND = NEW_REFERENCES.APPLY_AUTOMATICALLY_IND,
834: PRG_RULE_REPEAT_FAIL_TYPE = NEW_REFERENCES.PRG_RULE_REPEAT_FAIL_TYPE,

Line 884: cursor c1 is select rowid from IGS_PR_RU_OU_ALL

880: X_ORG_ID IN NUMBER,
881: -- anilk, bug#2784198
882: X_LOGICAL_DELETE_DT in DATE
883: ) AS
884: cursor c1 is select rowid from IGS_PR_RU_OU_ALL
885: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
886: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
887: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
888: ;

Line 952: FROM IGS_PR_RU_OU_ALL

948: X_rank IN NUMBER)
949: RETURN BOOLEAN AS
950: CURSOR cur_rowid IS
951: SELECT rowid
952: FROM IGS_PR_RU_OU_ALL
953: WHERE progression_rule_cat = x_progression_rule_cat
954: AND pra_sequence_number = x_pra_sequence_number
955: AND prg_rule_repeat_fail_type = X_prg_rule_repeat_fail_type
956: AND number_of_failures = X_number_of_failures