APPS.IGS_PS_AWARD_PKG dependencies on IGS_PS_AWARD

Line 1: package body IGS_PS_AWARD_PKG AS

1: package body IGS_PS_AWARD_PKG AS
2: /* $Header: IGSPI06B.pls 115.8 2003/06/16 11:50:07 jbegum ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_AWARD%RowType;

Line 5: old_references IGS_PS_AWARD%RowType;

1: package body IGS_PS_AWARD_PKG AS
2: /* $Header: IGSPI06B.pls 115.8 2003/06/16 11:50:07 jbegum ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_AWARD%RowType;
6: new_references IGS_PS_AWARD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_AWARD%RowType;

2: /* $Header: IGSPI06B.pls 115.8 2003/06/16 11:50:07 jbegum ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_AWARD%RowType;
6: new_references IGS_PS_AWARD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_PS_AWARD

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_PS_AWARD
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 66: -- BEFORE INSERT OR UPDATE ON IGS_PS_AWARD

62: END Set_Column_Values;
63:
64: -- Trigger description :-
65: -- "OSS_TST".TRG_CAW_BR_IUD
66: -- BEFORE INSERT OR UPDATE ON IGS_PS_AWARD
67: -- REFERENCING
68: -- NEW AS NEW
69: -- OLD AS OLD
70: -- FOR EACH ROW

Line 77: v_course_cd IGS_PS_AWARD.course_cd%TYPE;

73: p_inserting IN BOOLEAN DEFAULT FALSE,
74: p_updating IN BOOLEAN DEFAULT FALSE
75: ) AS
76: v_message_name varchar2(30);
77: v_course_cd IGS_PS_AWARD.course_cd%TYPE;
78: v_version_number IGS_PS_AWARD.version_number%TYPE;
79: BEGIN
80:
81: -- Set variables.

Line 78: v_version_number IGS_PS_AWARD.version_number%TYPE;

74: p_updating IN BOOLEAN DEFAULT FALSE
75: ) AS
76: v_message_name varchar2(30);
77: v_course_cd IGS_PS_AWARD.course_cd%TYPE;
78: v_version_number IGS_PS_AWARD.version_number%TYPE;
79: BEGIN
80:
81: -- Set variables.
82: v_course_cd := new_references.course_cd;

Line 205: FROM IGS_PS_AWARD

201: RETURN BOOLEAN AS
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM IGS_PS_AWARD
206: WHERE course_cd = x_course_cd
207: AND version_number = x_version_number
208: AND award_cd = x_award_cd;
209:

Line 234: FROM IGS_PS_AWARD

230: ) AS
231:
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM IGS_PS_AWARD
235: WHERE course_cd = x_course_cd
236: AND version_number = x_version_number ;
237:
238: lv_rowid cur_rowid%RowType;

Line 337: cursor C is select ROWID from IGS_PS_AWARD

333: X_MODE in VARCHAR2 default 'R',
334: X_DEFAULT_IND in VARCHAR2 default 'Y',
335: x_closed_ind IN VARCHAR2
336: ) AS
337: cursor C is select ROWID from IGS_PS_AWARD
338: where COURSE_CD = X_COURSE_CD
339: and AWARD_CD = X_AWARD_CD
340: and VERSION_NUMBER = X_VERSION_NUMBER;
341: X_LAST_UPDATE_DATE DATE;

Line 379: insert into IGS_PS_AWARD (

375: x_default_ind => X_DEFAULT_IND,
376: x_closed_ind => X_CLOSED_IND
377: );
378:
379: insert into IGS_PS_AWARD (
380: COURSE_CD,
381: VERSION_NUMBER,
382: AWARD_CD,
383: CREATION_DATE,

Line 429: from IGS_PS_AWARD

425: ) AS
426: cursor c1 is select
427: DEFAULT_IND,
428: CLOSED_IND
429: from IGS_PS_AWARD
430: where ROWID = X_ROWID
431: for update nowait;
432: tlinfo c1%rowtype;
433:

Line 506: UPDATE IGS_PS_AWARD SET

502: x_default_ind => X_DEFAULT_IND,
503: x_closed_ind => X_CLOSED_IND
504: );
505:
506: UPDATE IGS_PS_AWARD SET
507: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
508: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
509: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
510: DEFAULT_IND = NEW_REFERENCES.DEFAULT_IND,

Line 534: cursor c1 is select rowid from IGS_PS_AWARD

530: X_MODE in VARCHAR2 default 'R',
531: X_DEFAULT_IND in VARCHAR2 default 'Y',
532: x_closed_ind IN VARCHAR2
533: ) AS
534: cursor c1 is select rowid from IGS_PS_AWARD
535: where COURSE_CD = X_COURSE_CD
536: and AWARD_CD = X_AWARD_CD
537: and VERSION_NUMBER = X_VERSION_NUMBER
538: ;

Line 565: end IGS_PS_AWARD_PKG;

561: X_DEFAULT_IND,
562: X_CLOSED_IND);
563: end ADD_ROW;
564:
565: end IGS_PS_AWARD_PKG;