APPS.IGS_PS_UNIT_OFR_PAT_PKG dependencies on IGS_PS_UNIT_OFR_PAT_ALL

Line 5: old_references IGS_PS_UNIT_OFR_PAT_ALL%RowType;

1: package body IGS_PS_UNIT_OFR_PAT_PKG as
2: /* $Header: IGSPI87B.pls 120.1 2005/06/29 05:05:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_OFR_PAT_ALL%RowType;
6: new_references IGS_PS_UNIT_OFR_PAT_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_OFR_PAT_ALL%RowType;

2: /* $Header: IGSPI87B.pls 120.1 2005/06/29 05:05:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_OFR_PAT_ALL%RowType;
6: new_references IGS_PS_UNIT_OFR_PAT_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_PS_UNIT_OFR_PAT_ALL

27: ) AS
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_PS_UNIT_OFR_PAT_ALL
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 81: v_unit_cd IGS_PS_UNIT_OFR_PAT_ALL.unit_cd%TYPE;

77: p_inserting IN BOOLEAN DEFAULT FALSE,
78: p_updating IN BOOLEAN DEFAULT FALSE,
79: p_deleting IN BOOLEAN DEFAULT FALSE
80: ) AS
81: v_unit_cd IGS_PS_UNIT_OFR_PAT_ALL.unit_cd%TYPE;
82: v_version_number IGS_PS_UNIT_OFR_PAT_ALL.version_number%TYPE;
83: v_message_name VARCHAR2(30);
84: BEGIN
85: -- Set variables.

Line 82: v_version_number IGS_PS_UNIT_OFR_PAT_ALL.version_number%TYPE;

78: p_updating IN BOOLEAN DEFAULT FALSE,
79: p_deleting IN BOOLEAN DEFAULT FALSE
80: ) AS
81: v_unit_cd IGS_PS_UNIT_OFR_PAT_ALL.unit_cd%TYPE;
82: v_version_number IGS_PS_UNIT_OFR_PAT_ALL.version_number%TYPE;
83: v_message_name VARCHAR2(30);
84: BEGIN
85: -- Set variables.
86: IF p_deleting THEN

Line 330: FROM IGS_PS_UNIT_OFR_PAT_ALL

326: ) RETURN BOOLEAN AS
327:
328: CURSOR cur_rowid IS
329: SELECT rowid
330: FROM IGS_PS_UNIT_OFR_PAT_ALL
331: WHERE unit_cd = x_unit_cd
332: AND version_number = x_version_number
333: AND cal_type = x_cal_type
334: AND ci_sequence_number = x_ci_sequence_number

Line 361: FROM IGS_PS_UNIT_OFR_PAT_ALL

357: ) AS
358:
359: CURSOR cur_rowid IS
360: SELECT rowid
361: FROM IGS_PS_UNIT_OFR_PAT_ALL
362: WHERE cal_type = x_cal_type
363: AND ci_sequence_number = x_sequence_number
364: AND ci_start_dt = x_start_dt
365: AND ci_end_dt = x_end_dt

Line 393: FROM IGS_PS_UNIT_OFR_PAT_ALL

389: ) AS
390:
391: CURSOR cur_rowid IS
392: SELECT rowid
393: FROM IGS_PS_UNIT_OFR_PAT_ALL
394: WHERE unit_cd = x_unit_cd
395: AND version_number = x_version_number
396: AND cal_type = x_cal_type
397: AND delete_flag = 'N';

Line 527: cursor C is select ROWID from IGS_PS_UNIT_OFR_PAT_ALL

523: X_ORG_ID in NUMBER,
524: X_DELETE_FLAG IN VARCHAR2 ,
525: x_abort_flag IN VARCHAR2
526: ) AS
527: cursor C is select ROWID from IGS_PS_UNIT_OFR_PAT_ALL
528: where UNIT_CD = X_UNIT_CD
529: and VERSION_NUMBER = X_VERSION_NUMBER
530: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
531: and CAL_TYPE = X_CAL_TYPE;

Line 599: INSERT INTO IGS_PS_UNIT_OFR_PAT_ALL (

595: OPEN C;
596: FETCH C INTO l_c_rowid;
597: IF C%NOTFOUND THEN
598: CLOSE C;
599: INSERT INTO IGS_PS_UNIT_OFR_PAT_ALL (
600: UNIT_CD,
601: VERSION_NUMBER,
602: CAL_TYPE,
603: CI_SEQUENCE_NUMBER,

Line 644: UPDATE IGS_PS_UNIT_OFR_PAT_ALL SET

640: NEW_REFERENCES.ABORT_FLAG
641: );
642: ELSE
643: CLOSE C;
644: UPDATE IGS_PS_UNIT_OFR_PAT_ALL SET
645: WAITLIST_ALLOWED=NEW_REFERENCES.WAITLIST_ALLOWED,
646: MAX_STUDENTS_PER_WAITLIST=NEW_REFERENCES.MAX_STUDENTS_PER_WAITLIST,
647: CREATION_DATE=X_LAST_UPDATE_DATE,
648: CREATED_BY=X_LAST_UPDATED_BY,

Line 695: from IGS_PS_UNIT_OFR_PAT_ALL

691: WAITLIST_ALLOWED,
692: MAX_STUDENTS_PER_WAITLIST,
693: DELETE_FLAG,
694: abort_flag
695: from IGS_PS_UNIT_OFR_PAT_ALL
696: where ROWID = X_ROWID for update nowait;
697: tlinfo c1%rowtype;
698:
699: begin

Line 809: update IGS_PS_UNIT_OFR_PAT_ALL set

805: IF x_delete_flag = 'Y' THEN
806: Check_Child_Existance;
807: END IF;
808:
809: update IGS_PS_UNIT_OFR_PAT_ALL set
810: CI_START_DT = NEW_REFERENCES.CI_START_DT,
811: CI_END_DT = NEW_REFERENCES.CI_END_DT,
812: WAITLIST_ALLOWED = NEW_REFERENCES.WAITLIST_ALLOWED,
813: MAX_STUDENTS_PER_WAITLIST = NEW_REFERENCES.MAX_STUDENTS_PER_WAITLIST,

Line 849: cursor c1 is select rowid from IGS_PS_UNIT_OFR_PAT_ALL

845: X_ORG_ID in NUMBER,
846: X_DELETE_FLAG IN VARCHAR2 ,
847: x_abort_flag IN VARCHAR2
848: ) AS
849: cursor c1 is select rowid from IGS_PS_UNIT_OFR_PAT_ALL
850: where UNIT_CD = X_UNIT_CD
851: and VERSION_NUMBER = X_VERSION_NUMBER
852: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
853: and CAL_TYPE = X_CAL_TYPE

Line 901: delete from IGS_PS_UNIT_OFR_PAT_ALL

897: Before_DML (
898: p_action => 'DELETE',
899: x_rowid => X_ROWID
900: );
901: delete from IGS_PS_UNIT_OFR_PAT_ALL
902: where ROWID = X_ROWID
903: ;
904: if (sql%notfound) then
905: raise no_data_found;