APPS.IGS_PR_SDT_PR_RU_CK_PKG dependencies on IGS_PR_SDT_PR_RU_CK_ALL

Line 4: old_references IGS_PR_SDT_PR_RU_CK_ALL%RowType;

1: package body IGS_PR_SDT_PR_RU_CK_PKG AS
2: /* $Header: IGSQI17B.pls 115.7 2002/11/29 03:18:19 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_SDT_PR_RU_CK_ALL%RowType;
5: new_references IGS_PR_SDT_PR_RU_CK_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PR_SDT_PR_RU_CK_ALL%RowType;

1: package body IGS_PR_SDT_PR_RU_CK_PKG AS
2: /* $Header: IGSQI17B.pls 115.7 2002/11/29 03:18:19 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_SDT_PR_RU_CK_ALL%RowType;
5: new_references IGS_PR_SDT_PR_RU_CK_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_PR_SDT_PR_RU_CK_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_PR_SDT_PR_RU_CK_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 150: FROM IGS_PR_SDT_PR_RU_CK_ALL

146: ) RETURN BOOLEAN AS
147:
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM IGS_PR_SDT_PR_RU_CK_ALL
151: WHERE person_id = x_person_id
152: AND course_cd = x_course_cd
153: AND prg_cal_type = x_prg_cal_type
154: AND prg_ci_sequence_number = x_prg_ci_sequence_number

Line 183: FROM IGS_PR_SDT_PR_RU_CK_ALL

179: ) AS
180:
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM IGS_PR_SDT_PR_RU_CK_ALL
184: WHERE progression_rule_cat = x_progression_rule_cat
185: AND pra_sequence_number = x_sequence_number ;
186:
187: lv_rowid cur_rowid%RowType;

Line 215: FROM IGS_PR_SDT_PR_RU_CK_ALL

211: ) AS
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_PR_SDT_PR_RU_CK_ALL
216: WHERE person_id = x_person_id
217: AND course_cd = x_course_cd
218: AND prg_cal_type = x_prg_cal_type
219: AND prg_ci_sequence_number = x_prg_ci_sequence_number

Line 346: cursor C is select ROWID from IGS_PR_SDT_PR_RU_CK_ALL

342: X_RULE_MESSAGE_TEXT in VARCHAR2,
343: X_MODE in VARCHAR2 default 'R',
344: X_ORG_ID in NUMBER
345: ) AS
346: cursor C is select ROWID from IGS_PR_SDT_PR_RU_CK_ALL
347: where PERSON_ID = X_PERSON_ID
348: and COURSE_CD = X_COURSE_CD
349: and PRG_CAL_TYPE = X_PRG_CAL_TYPE
350: and PRG_CI_SEQUENCE_NUMBER = X_PRG_CI_SEQUENCE_NUMBER

Line 395: insert into IGS_PR_SDT_PR_RU_CK_ALL (

391: x_last_updated_by => x_last_updated_by ,
392: x_last_update_login => x_last_update_login,
393: x_org_id => igs_ge_gen_003.get_org_id
394: );
395: insert into IGS_PR_SDT_PR_RU_CK_ALL (
396: PERSON_ID,
397: COURSE_CD,
398: PRG_CAL_TYPE,
399: PRG_CI_SEQUENCE_NUMBER,

Line 460: from IGS_PR_SDT_PR_RU_CK_ALL

456: PRA_SEQUENCE_NUMBER ,
457: RULE_CHECK_DT ,
458: PASSED_IND ,
459: RULE_MESSAGE_TEXT
460: from IGS_PR_SDT_PR_RU_CK_ALL
461: where ROWID = X_ROWID for update nowait;
462: tlinfo c1%rowtype;
463:
464: begin

Line 554: update IGS_PR_SDT_PR_RU_CK_ALL set

550: x_last_updated_by => x_last_updated_by ,
551: x_last_update_login => x_last_update_login
552: );
553:
554: update IGS_PR_SDT_PR_RU_CK_ALL set
555: PASSED_IND = NEW_REFERENCES.PASSED_IND,
556: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
557: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
558: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 579: cursor c1 is select rowid from IGS_PR_SDT_PR_RU_CK_ALL

575: X_RULE_MESSAGE_TEXT in VARCHAR2,
576: X_MODE in VARCHAR2 default 'R',
577: X_ORG_ID in NUMBER
578: ) AS
579: cursor c1 is select rowid from IGS_PR_SDT_PR_RU_CK_ALL
580: where PERSON_ID = X_PERSON_ID
581: and COURSE_CD = X_COURSE_CD
582: and PRG_CAL_TYPE = X_PRG_CAL_TYPE
583: and PRG_CI_SEQUENCE_NUMBER = X_PRG_CI_SEQUENCE_NUMBER

Line 632: delete from IGS_PR_SDT_PR_RU_CK_ALL

628: Before_DML (
629: p_action => 'DELETE',
630: x_rowid => X_ROWID
631: ) ;
632: delete from IGS_PR_SDT_PR_RU_CK_ALL
633: where ROWID = X_ROWID;
634: if (sql%notfound) then
635: raise no_data_found;
636: end if;