APPS.IGS_PS_AWD_OWN_PKG dependencies on IGS_PS_AWD_OWN

Line 1: package body IGS_PS_AWD_OWN_PKG AS

1: package body IGS_PS_AWD_OWN_PKG AS
2: /* $Header: IGSPI07B.pls 115.9 2003/06/10 08:14:30 smvk ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_PS_AWD_OWN%RowType;

2: /* $Header: IGSPI07B.pls 115.9 2003/06/10 08:14:30 smvk ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_AWD_OWN%RowType;
7: new_references IGS_PS_AWD_OWN%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_AWD_OWN%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_AWD_OWN%RowType;
7: new_references IGS_PS_AWD_OWN%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_PS_AWD_OWN

23: ) AS
24:
25: CURSOR cur_old_ref_values IS
26: SELECT *
27: FROM IGS_PS_AWD_OWN
28: WHERE rowid = x_rowid;
29:
30: BEGIN
31:

Line 69: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_PS_AWD_OWN

65: END Set_Column_Values;
66:
67: -- Trigger description :-
68: -- "OSS_TST".TRG_CAO_BR_IUD
69: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_PS_AWD_OWN
70: -- REFERENCING
71: -- NEW AS NEW
72: -- OLD AS OLD
73: -- FOR EACH ROW

Line 81: v_course_cd IGS_PS_AWD_OWN.course_cd%TYPE;

77: p_updating IN BOOLEAN DEFAULT FALSE,
78: p_deleting IN BOOLEAN DEFAULT FALSE
79: ) AS
80: v_message_name varchar2(30);
81: v_course_cd IGS_PS_AWD_OWN.course_cd%TYPE;
82: v_version_number IGS_PS_AWD_OWN.version_number%TYPE;
83: BEGIN
84:
85: -- Set variables.

Line 82: v_version_number IGS_PS_AWD_OWN.version_number%TYPE;

78: p_deleting IN BOOLEAN DEFAULT FALSE
79: ) AS
80: v_message_name varchar2(30);
81: v_course_cd IGS_PS_AWD_OWN.course_cd%TYPE;
82: v_version_number IGS_PS_AWD_OWN.version_number%TYPE;
83: BEGIN
84:
85: -- Set variables.
86: IF p_deleting THEN

Line 239: FROM IGS_PS_AWD_OWN

235: RETURN BOOLEAN AS
236:
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM IGS_PS_AWD_OWN
240: WHERE course_cd = x_course_cd
241: AND version_number = x_version_number
242: AND award_cd = x_award_cd
243: AND org_unit_cd = x_org_unit_cd

Line 270: FROM IGS_PS_AWD_OWN

266: ) AS
267:
268: CURSOR cur_rowid IS
269: SELECT rowid
270: FROM IGS_PS_AWD_OWN
271: WHERE org_unit_cd = x_org_unit_cd
272: AND ou_start_dt = x_start_dt ;
273:
274: lv_rowid cur_rowid%RowType;

Line 388: cursor C is select ROWID from IGS_PS_AWD_OWN

384: X_VERSION_NUMBER in NUMBER,
385: X_PERCENTAGE in NUMBER,
386: X_MODE in VARCHAR2 default 'R'
387: ) AS
388: cursor C is select ROWID from IGS_PS_AWD_OWN
389: where COURSE_CD = X_COURSE_CD
390: and ORG_UNIT_CD = X_ORG_UNIT_CD
391: and OU_START_DT = X_OU_START_DT
392: and AWARD_CD = X_AWARD_CD

Line 433: insert into IGS_PS_AWD_OWN (

429: x_last_updated_by => X_LAST_UPDATED_BY ,
430: x_last_update_login => X_LAST_UPDATE_LOGIN
431: );
432:
433: insert into IGS_PS_AWD_OWN (
434: COURSE_CD,
435: VERSION_NUMBER,
436: AWARD_CD,
437: ORG_UNIT_CD,

Line 485: from IGS_PS_AWD_OWN

481: X_PERCENTAGE in NUMBER
482: ) AS
483: cursor c1 is select
484: PERCENTAGE
485: from IGS_PS_AWD_OWN
486: where ROWID = X_ROWID
487: for update nowait;
488: tlinfo c1%rowtype;
489:

Line 562: update IGS_PS_AWD_OWN set

558: x_last_updated_by => X_LAST_UPDATED_BY ,
559: x_last_update_login => X_LAST_UPDATE_LOGIN
560: );
561:
562: update IGS_PS_AWD_OWN set
563: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
564: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
565: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
566: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 590: cursor c1 is select rowid from IGS_PS_AWD_OWN

586: X_VERSION_NUMBER in NUMBER,
587: X_PERCENTAGE in NUMBER,
588: X_MODE in VARCHAR2 default 'R'
589: ) AS
590: cursor c1 is select rowid from IGS_PS_AWD_OWN
591: where COURSE_CD = X_COURSE_CD
592: and ORG_UNIT_CD = X_ORG_UNIT_CD
593: and OU_START_DT = X_OU_START_DT
594: and AWARD_CD = X_AWARD_CD

Line 636: delete from IGS_PS_AWD_OWN

632: p_action => 'DELETE',
633: x_rowid => X_ROWID
634: );
635:
636: delete from IGS_PS_AWD_OWN
637: where ROWID = X_ROWID;
638: if (sql%notfound) then
639: raise no_data_found;
640: end if;

Line 649: end IGS_PS_AWD_OWN_PKG;

645: );
646:
647: end DELETE_ROW;
648:
649: end IGS_PS_AWD_OWN_PKG;