APPS.IGS_PR_S_CRV_PRG_CON_PKG dependencies on IGS_PR_S_CRV_PRG_CON

Line 1: package body IGS_PR_S_CRV_PRG_CON_PKG AS

1: package body IGS_PR_S_CRV_PRG_CON_PKG AS
2: /* $Header: IGSQI22B.pls 115.5 2002/11/29 03:19:40 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_CRV_PRG_CON%RowType;

Line 5: old_references IGS_PR_S_CRV_PRG_CON%RowType;

1: package body IGS_PR_S_CRV_PRG_CON_PKG AS
2: /* $Header: IGSQI22B.pls 115.5 2002/11/29 03:19:40 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_CRV_PRG_CON%RowType;
6: new_references IGS_PR_S_CRV_PRG_CON%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_S_CRV_PRG_CON%RowType;

2: /* $Header: IGSQI22B.pls 115.5 2002/11/29 03:19:40 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_CRV_PRG_CON%RowType;
6: new_references IGS_PR_S_CRV_PRG_CON%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_PR_S_CRV_PRG_CON

33: ) as
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_PR_S_CRV_PRG_CON
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 92: -- ON IGS_PR_S_CRV_PRG_CON

88:
89: -- Trigger description :-
90: -- "OSS_TST".trg_scpc_br_iu
91: -- BEFORE INSERT OR UPDATE
92: -- ON IGS_PR_S_CRV_PRG_CON
93: -- FOR EACH ROW
94:
95: PROCEDURE BeforeRowInsertUpdate1(
96: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 360: IGS_PR_S_CRV_PRG_CAL_PKG.GET_FK_IGS_PR_S_CRV_PRG_CON(

356:
357: PROCEDURE Check_Child_Existance as
358: BEGIN
359:
360: IGS_PR_S_CRV_PRG_CAL_PKG.GET_FK_IGS_PR_S_CRV_PRG_CON(
361: old_references.course_cd,
362: old_references.version_number
363: );
364:

Line 374: FROM IGS_PR_S_CRV_PRG_CON

370: ) RETURN BOOLEAN AS
371:
372: CURSOR cur_rowid IS
373: SELECT rowid
374: FROM IGS_PR_S_CRV_PRG_CON
375: WHERE course_cd = x_course_cd
376: AND version_number = x_version_number
377: FOR UPDATE NOWAIT;
378:

Line 401: FROM IGS_PR_S_CRV_PRG_CON

397: ) as
398:
399: CURSOR cur_rowid IS
400: SELECT rowid
401: FROM IGS_PR_S_CRV_PRG_CON
402: WHERE appeal_cutoff_dt_alias = x_dt_alias
403: OR end_benefit_dt_alias = x_dt_alias
404: OR show_cause_cutoff_dt_alias = x_dt_alias
405: OR apply_end_dt_alias = x_dt_alias

Line 434: FROM IGS_PR_S_CRV_PRG_CON

430: ) as
431:
432: CURSOR cur_rowid IS
433: SELECT rowid
434: FROM IGS_PR_S_CRV_PRG_CON
435: WHERE course_cd = x_course_cd
436: AND version_number = x_version_number ;
437:
438: lv_rowid cur_rowid%RowType;

Line 572: cursor C is select ROWID from IGS_PR_S_CRV_PRG_CON

568: X_CALCULATE_GPA_IND in VARCHAR2,
569: X_OUTCOME_CHECK_TYPE in VARCHAR2,
570: X_MODE in VARCHAR2 default 'R'
571: ) as
572: cursor C is select ROWID from IGS_PR_S_CRV_PRG_CON
573: where COURSE_CD = X_COURSE_CD
574: and VERSION_NUMBER = X_VERSION_NUMBER;
575: X_LAST_UPDATE_DATE DATE;
576: X_LAST_UPDATED_BY NUMBER;

Line 625: insert into IGS_PR_S_CRV_PRG_CON (

621: x_last_updated_by => X_LAST_UPDATED_BY,
622: x_last_update_login => X_LAST_UPDATE_LOGIN
623: );
624:
625: insert into IGS_PR_S_CRV_PRG_CON (
626: COURSE_CD,
627: VERSION_NUMBER,
628: APPLY_START_DT_ALIAS,
629: APPLY_END_DT_ALIAS,

Line 719: from IGS_PR_S_CRV_PRG_CON

715: COUNT_EXC_IN_TIME_IND,
716: CALCULATE_WAM_IND,
717: CALCULATE_GPA_IND,
718: OUTCOME_CHECK_TYPE
719: from IGS_PR_S_CRV_PRG_CON
720: where ROWID = X_ROWID
721: for update nowait;
722: tlinfo c1%rowtype;
723:

Line 839: update IGS_PR_S_CRV_PRG_CON set

835: x_last_updated_by => X_LAST_UPDATED_BY,
836: x_last_update_login => X_LAST_UPDATE_LOGIN
837: );
838:
839: update IGS_PR_S_CRV_PRG_CON set
840: APPLY_START_DT_ALIAS = NEW_REFERENCES.APPLY_START_DT_ALIAS,
841: APPLY_END_DT_ALIAS = NEW_REFERENCES.APPLY_END_DT_ALIAS,
842: END_BENEFIT_DT_ALIAS = NEW_REFERENCES.END_BENEFIT_DT_ALIAS,
843: END_PENALTY_DT_ALIAS = NEW_REFERENCES.END_PENALTY_DT_ALIAS,

Line 887: cursor c1 is select rowid from IGS_PR_S_CRV_PRG_CON

883: X_CALCULATE_GPA_IND in VARCHAR2,
884: X_OUTCOME_CHECK_TYPE in VARCHAR2,
885: X_MODE in VARCHAR2 default 'R'
886: ) as
887: cursor c1 is select rowid from IGS_PR_S_CRV_PRG_CON
888: where COURSE_CD = X_COURSE_CD
889: and VERSION_NUMBER = X_VERSION_NUMBER
890: ;
891: begin

Line 952: delete from IGS_PR_S_CRV_PRG_CON

948: x_rowid=>X_ROWID
949: );
950:
951:
952: delete from IGS_PR_S_CRV_PRG_CON
953: where ROWID = X_ROWID;
954: if (sql%notfound) then
955: raise no_data_found;
956: end if;

Line 1218: end IGS_PR_S_CRV_PRG_CON_PKG;

1214:
1215:
1216: END Check_Constraints;
1217:
1218: end IGS_PR_S_CRV_PRG_CON_PKG;