APPS.IGS_PS_AWD_PKG dependencies on IGS_PS_AWD

Line 1: PACKAGE BODY IGS_PS_AWD_PKG AS

1: PACKAGE BODY IGS_PS_AWD_PKG AS
2: /* $Header: IGSPI01B.pls 115.9 2003/02/25 08:10:44 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_AWD%ROWTYPE;

Line 5: old_references IGS_PS_AWD%ROWTYPE;

1: PACKAGE BODY IGS_PS_AWD_PKG AS
2: /* $Header: IGSPI01B.pls 115.9 2003/02/25 08:10:44 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_AWD%ROWTYPE;
6: new_references IGS_PS_AWD%ROWTYPE;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_AWD%ROWTYPE;

2: /* $Header: IGSPI01B.pls 115.9 2003/02/25 08:10:44 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_AWD%ROWTYPE;
6: new_references IGS_PS_AWD%ROWTYPE;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_PS_AWD

24: ) AS
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_PS_AWD
29: WHERE ROWID = x_rowid;
30:
31: BEGIN
32:

Line 78: -- Validate the IGS_PS_AWD is not closed

74: p_deleting IN BOOLEAN DEFAULT FALSE
75: ) AS
76: v_message_name VARCHAR2(30);
77: BEGIN
78: -- Validate the IGS_PS_AWD is not closed
79: IF p_inserting OR p_updating THEN
80: IF NVL(new_references.testamur_type, 'NULL') <> NVL(old_references.testamur_type, 'NULL') THEN
81: IF new_references.testamur_type IS NOT NULL THEN
82: IF IGS_PS_VAL_AW.crsp_val_tt_closed(

Line 92: -- Validate update to IGS_PS_AWD system IGS_PS_AWD type

88: END IF;
89: END IF;
90: END IF;
91: END IF;
92: -- Validate update to IGS_PS_AWD system IGS_PS_AWD type
93: IF p_updating THEN
94: IF IGS_PS_VAL_AW.crsp_val_aw_upd(
95: new_references.award_cd,
96: new_references.s_award_type,

Line 258: FROM IGS_PS_AWD

254: RETURN BOOLEAN AS
255:
256: CURSOR cur_rowid IS
257: SELECT ROWID
258: FROM IGS_PS_AWD
259: WHERE award_cd = x_award_cd;
260:
261: lv_rowid cur_rowid%ROWTYPE;
262:

Line 283: FROM IGS_PS_AWD

279: ) AS
280:
281: CURSOR cur_rowid IS
282: SELECT ROWID
283: FROM IGS_PS_AWD
284: WHERE testamur_type = x_testamur_type ;
285:
286: lv_rowid cur_rowid%ROWTYPE;
287:

Line 312: FROM IGS_PS_AWD

308: ) AS
309:
310: CURSOR cur_rowid IS
311: SELECT ROWID
312: FROM IGS_PS_AWD
313: WHERE grading_schema_cd = x_grading_schema_cd
314: AND
315: gs_version_number = x_gs_version_number;
316:

Line 423: CURSOR C IS SELECT ROWID FROM IGS_PS_AWD

419: X_MODE IN VARCHAR2 DEFAULT 'R' ,
420: X_GRADING_SCHEMA_CD IN VARCHAR2 ,
421: X_GS_VERSION_NUMBER IN NUMBER
422: ) AS
423: CURSOR C IS SELECT ROWID FROM IGS_PS_AWD
424: WHERE AWARD_CD = X_AWARD_CD;
425: X_LAST_UPDATE_DATE DATE;
426: X_LAST_UPDATED_BY NUMBER;
427: X_LAST_UPDATE_LOGIN NUMBER;

Line 466: INSERT INTO IGS_PS_AWD (

462: x_grading_schema_cd => X_GRADING_SCHEMA_CD,
463: x_gs_version_number => X_GS_VERSION_NUMBER
464: );
465:
466: INSERT INTO IGS_PS_AWD (
467: AWARD_CD,
468: AWARD_TITLE,
469: S_AWARD_TYPE,
470: TESTAMUR_TYPE,

Line 530: FROM IGS_PS_AWD

526: CLOSED_IND,
527: NOTES,
528: GRADING_SCHEMA_CD,
529: GS_VERSION_NUMBER
530: FROM IGS_PS_AWD
531: WHERE ROWID = X_ROWID
532: FOR UPDATE NOWAIT;
533: tlinfo c1%ROWTYPE;
534:

Line 639: UPDATE IGS_PS_AWD SET

635: x_grading_schema_cd => X_GRADING_SCHEMA_CD ,
636: x_gs_version_number => X_GS_VERSION_NUMBER
637: );
638:
639: UPDATE IGS_PS_AWD SET
640: AWARD_TITLE = NEW_REFERENCES.AWARD_TITLE,
641: S_AWARD_TYPE = NEW_REFERENCES.S_AWARD_TYPE,
642: TESTAMUR_TYPE = NEW_REFERENCES.TESTAMUR_TYPE,
643: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 675: CURSOR c1 IS SELECT ROWID FROM IGS_PS_AWD

671: X_MODE IN VARCHAR2 DEFAULT 'R',
672: X_GRADING_SCHEMA_CD IN VARCHAR2 ,
673: X_GS_VERSION_NUMBER IN NUMBER
674: ) AS
675: CURSOR c1 IS SELECT ROWID FROM IGS_PS_AWD
676: WHERE AWARD_CD = X_AWARD_CD
677: ;
678: BEGIN
679: OPEN c1;

Line 713: END IGS_PS_AWD_PKG;

709: );
710: END ADD_ROW;
711:
712:
713: END IGS_PS_AWD_PKG;