eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_OWN_PKG dependencies on IGS_PS_OWN

Line 1: package body IGS_PS_OWN_PKG AS

1: package body IGS_PS_OWN_PKG AS
2: /* $Header: IGSPI27B.pls 120.0 2005/06/01 22:10:53 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_OWN%RowType;
5: new_references IGS_PS_OWN%RowType;

Line 4: old_references IGS_PS_OWN%RowType;

1: package body IGS_PS_OWN_PKG AS
2: /* $Header: IGSPI27B.pls 120.0 2005/06/01 22:10:53 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_OWN%RowType;
5: new_references IGS_PS_OWN%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_OWN%RowType;

1: package body IGS_PS_OWN_PKG AS
2: /* $Header: IGSPI27B.pls 120.0 2005/06/01 22:10:53 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_OWN%RowType;
5: new_references IGS_PS_OWN%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PS_OWN

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

Line 76: IGS_HE_PROG_OU_CC_PKG.get_fk_igs_ps_own (

72: || (reverse chronological order - newest change first)
73: */
74: BEGIN
75:
76: IGS_HE_PROG_OU_CC_PKG.get_fk_igs_ps_own (
77: old_references.course_cd,
78: old_references.version_number,
79: old_references.org_unit_cd
80: );

Line 88: -- ON IGS_PS_OWN

84:
85: -- Trigger description :-
86: -- "OSS_TST".trg_cow_br_iud
87: -- BEFORE INSERT OR DELETE OR UPDATE
88: -- ON IGS_PS_OWN
89: -- FOR EACH ROW
90:
91: PROCEDURE BeforeRowInsertUpdateDelete1(
92: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 97: v_course_cd IGS_PS_OWN.course_cd%TYPE;

93: p_updating IN BOOLEAN DEFAULT FALSE,
94: p_deleting IN BOOLEAN DEFAULT FALSE
95: ) AS
96: v_message_name VARCHAR2(30);
97: v_course_cd IGS_PS_OWN.course_cd%TYPE;
98: v_version_number IGS_PS_OWN.version_number%TYPE;
99: v_percentage IGS_PS_OWN.percentage%TYPE;
100: BEGIN
101: -- Set variables.

Line 98: v_version_number IGS_PS_OWN.version_number%TYPE;

94: p_deleting IN BOOLEAN DEFAULT FALSE
95: ) AS
96: v_message_name VARCHAR2(30);
97: v_course_cd IGS_PS_OWN.course_cd%TYPE;
98: v_version_number IGS_PS_OWN.version_number%TYPE;
99: v_percentage IGS_PS_OWN.percentage%TYPE;
100: BEGIN
101: -- Set variables.
102: IF p_deleting THEN

Line 99: v_percentage IGS_PS_OWN.percentage%TYPE;

95: ) AS
96: v_message_name VARCHAR2(30);
97: v_course_cd IGS_PS_OWN.course_cd%TYPE;
98: v_version_number IGS_PS_OWN.version_number%TYPE;
99: v_percentage IGS_PS_OWN.percentage%TYPE;
100: BEGIN
101: -- Set variables.
102: IF p_deleting THEN
103: v_course_cd := old_references.course_cd;

Line 250: FROM IGS_PS_OWN

246: ) RETURN BOOLEAN AS
247:
248: CURSOR cur_rowid IS
249: SELECT rowid
250: FROM IGS_PS_OWN
251: WHERE course_cd = x_course_cd
252: AND version_number = x_version_number
253: AND org_unit_cd = x_org_unit_cd
254: AND ou_start_dt = x_ou_start_dt

Line 288: FROM IGS_PS_OWN

284: || (reverse chronological order - newest change first)
285: */
286: CURSOR cur_rowid IS
287: SELECT rowid
288: FROM IGS_PS_OWN
289: WHERE course_cd = x_course_cd
290: AND version_number = x_version_number
291: AND org_unit_cd = x_org_unit_cd
292: FOR UPDATE NOWAIT;

Line 317: FROM IGS_PS_OWN

313:
314:
315: CURSOR cur_rowid IS
316: SELECT rowid
317: FROM IGS_PS_OWN
318: WHERE course_cd = x_course_cd
319: AND version_number = x_version_number ;
320:
321: lv_rowid cur_rowid%RowType;

Line 345: FROM IGS_PS_OWN

341: ) AS
342:
343: CURSOR cur_rowid IS
344: SELECT rowid
345: FROM IGS_PS_OWN
346: WHERE org_unit_cd = x_org_unit_cd
347: AND ou_start_dt = x_start_dt ;
348:
349: lv_rowid cur_rowid%RowType;

Line 460: cursor C is select ROWID from IGS_PS_OWN

456: X_VERSION_NUMBER in NUMBER,
457: X_PERCENTAGE in NUMBER,
458: X_MODE in VARCHAR2 default 'R'
459: ) AS
460: cursor C is select ROWID from IGS_PS_OWN
461: where COURSE_CD = X_COURSE_CD
462: and OU_START_DT = X_OU_START_DT
463: and ORG_UNIT_CD = X_ORG_UNIT_CD
464: and VERSION_NUMBER = X_VERSION_NUMBER;

Line 501: insert into IGS_PS_OWN (

497: x_last_update_date => X_LAST_UPDATE_DATE ,
498: x_last_updated_by => X_LAST_UPDATED_BY ,
499: x_last_update_login => X_LAST_UPDATE_LOGIN
500: );
501: insert into IGS_PS_OWN (
502: COURSE_CD,
503: VERSION_NUMBER,
504: ORG_UNIT_CD,
505: OU_START_DT,

Line 548: from IGS_PS_OWN

544: X_PERCENTAGE in NUMBER
545: ) AS
546: cursor c1 is select
547: PERCENTAGE
548: from IGS_PS_OWN
549: where ROWID = X_ROWID
550: for update nowait;
551: tlinfo c1%rowtype;
552:

Line 621: update IGS_PS_OWN set

617: x_last_update_date => X_LAST_UPDATE_DATE ,
618: x_last_updated_by => X_LAST_UPDATED_BY ,
619: x_last_update_login => X_LAST_UPDATE_LOGIN
620: );
621: update IGS_PS_OWN set
622: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
623: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
624: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
625: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 646: cursor c1 is select rowid from IGS_PS_OWN

642: X_VERSION_NUMBER in NUMBER,
643: X_PERCENTAGE in NUMBER,
644: X_MODE in VARCHAR2 default 'R'
645: ) AS
646: cursor c1 is select rowid from IGS_PS_OWN
647: where COURSE_CD = X_COURSE_CD
648: and OU_START_DT = X_OU_START_DT
649: and ORG_UNIT_CD = X_ORG_UNIT_CD
650: and VERSION_NUMBER = X_VERSION_NUMBER

Line 686: delete from IGS_PS_OWN

682: Before_DML (
683: p_action => 'DELETE',
684: x_rowid => X_ROWID
685: );
686: delete from IGS_PS_OWN
687: where ROWID = X_ROWID;
688: if (sql%notfound) then
689: raise no_data_found;
690: end if;

Line 697: end IGS_PS_OWN_PKG;

693: x_rowid => X_ROWID
694: );
695: end DELETE_ROW;
696:
697: end IGS_PS_OWN_PKG;