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_TCH_RESP_PKG dependencies on IGS_PS_TCH_RESP

Line 1: package body IGS_PS_TCH_RESP_PKG as

1: package body IGS_PS_TCH_RESP_PKG as
2: /* $Header: IGSPI69B.pls 120.0 2005/06/01 21:45:01 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_TCH_RESP%RowType;
5: new_references IGS_PS_TCH_RESP%RowType;

Line 4: old_references IGS_PS_TCH_RESP%RowType;

1: package body IGS_PS_TCH_RESP_PKG as
2: /* $Header: IGSPI69B.pls 120.0 2005/06/01 21:45:01 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_TCH_RESP%RowType;
5: new_references IGS_PS_TCH_RESP%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_TCH_RESP%RowType;

1: package body IGS_PS_TCH_RESP_PKG as
2: /* $Header: IGSPI69B.pls 120.0 2005/06/01 21:45:01 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_TCH_RESP%RowType;
5: new_references IGS_PS_TCH_RESP%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 24: FROM IGS_PS_TCH_RESP

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

Line 75: IGS_HE_UNT_OU_CC_PKG.get_fk_igs_ps_tch_resp (

71: || (reverse chronological order - newest change first)
72: */
73: BEGIN
74:
75: IGS_HE_UNT_OU_CC_PKG.get_fk_igs_ps_tch_resp (
76: old_references.unit_cd,
77: old_references.version_number,
78: old_references.org_unit_cd
79: );

Line 88: v_unit_cd IGS_PS_TCH_RESP.unit_cd%TYPE;

84: p_inserting IN BOOLEAN,
85: p_updating IN BOOLEAN,
86: p_deleting IN BOOLEAN
87: ) AS
88: v_unit_cd IGS_PS_TCH_RESP.unit_cd%TYPE;
89: v_version_number IGS_PS_TCH_RESP.version_number%TYPE;
90: v_percentage IGS_PS_TCH_RESP.percentage%TYPE;
91: v_message_name VARCHAR2(30);
92: BEGIN

Line 89: v_version_number IGS_PS_TCH_RESP.version_number%TYPE;

85: p_updating IN BOOLEAN,
86: p_deleting IN BOOLEAN
87: ) AS
88: v_unit_cd IGS_PS_TCH_RESP.unit_cd%TYPE;
89: v_version_number IGS_PS_TCH_RESP.version_number%TYPE;
90: v_percentage IGS_PS_TCH_RESP.percentage%TYPE;
91: v_message_name VARCHAR2(30);
92: BEGIN
93: -- Set variables.

Line 90: v_percentage IGS_PS_TCH_RESP.percentage%TYPE;

86: p_deleting IN BOOLEAN
87: ) AS
88: v_unit_cd IGS_PS_TCH_RESP.unit_cd%TYPE;
89: v_version_number IGS_PS_TCH_RESP.version_number%TYPE;
90: v_percentage IGS_PS_TCH_RESP.percentage%TYPE;
91: v_message_name VARCHAR2(30);
92: BEGIN
93: -- Set variables.
94: IF p_deleting THEN

Line 240: FROM IGS_PS_TCH_RESP

236: ) RETURN BOOLEAN AS
237:
238: CURSOR cur_rowid IS
239: SELECT rowid
240: FROM IGS_PS_TCH_RESP
241: WHERE unit_cd = x_unit_cd
242: AND version_number = x_version_number
243: AND org_unit_cd = x_org_unit_cd
244: AND ou_start_dt = x_ou_start_dt

Line 278: FROM IGS_PS_TCH_RESP

274: || (reverse chronological order - newest change first)
275: */
276: CURSOR cur_rowid IS
277: SELECT rowid
278: FROM IGS_PS_TCH_RESP
279: WHERE unit_cd = x_unit_cd
280: AND version_number = x_version_number
281: AND org_unit_cd = x_org_unit_cd
282: FOR UPDATE NOWAIT;

Line 306: FROM IGS_PS_TCH_RESP

302: ) AS
303:
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM IGS_PS_TCH_RESP
307: WHERE org_unit_cd = x_org_unit_cd
308: AND ou_start_dt = x_start_dt ;
309:
310: lv_rowid cur_rowid%RowType;

Line 334: FROM IGS_PS_TCH_RESP

330: ) AS
331:
332: CURSOR cur_rowid IS
333: SELECT rowid
334: FROM IGS_PS_TCH_RESP
335: WHERE unit_cd = x_unit_cd
336: AND version_number = x_version_number ;
337:
338: lv_rowid cur_rowid%RowType;

Line 450: cursor C is select ROWID from IGS_PS_TCH_RESP

446: X_ORG_UNIT_CD in VARCHAR2,
447: X_PERCENTAGE in NUMBER,
448: X_MODE in VARCHAR2
449: ) as
450: cursor C is select ROWID from IGS_PS_TCH_RESP
451: where UNIT_CD = X_UNIT_CD
452: and VERSION_NUMBER = X_VERSION_NUMBER
453: and OU_START_DT = X_OU_START_DT
454: and ORG_UNIT_CD = X_ORG_UNIT_CD;

Line 493: insert into IGS_PS_TCH_RESP (

489: x_last_updated_by => X_LAST_UPDATED_BY,
490: x_last_update_login => X_LAST_UPDATE_LOGIN
491: );
492:
493: insert into IGS_PS_TCH_RESP (
494: UNIT_CD,
495: VERSION_NUMBER,
496: ORG_UNIT_CD,
497: OU_START_DT,

Line 540: from IGS_PS_TCH_RESP

536: X_PERCENTAGE in NUMBER
537: ) as
538: cursor c1 is select
539: PERCENTAGE
540: from IGS_PS_TCH_RESP
541: where ROWID = X_ROWID
542: for update nowait;
543: tlinfo c1%rowtype;
544:

Line 614: update IGS_PS_TCH_RESP set

610: x_last_updated_by => X_LAST_UPDATED_BY,
611: x_last_update_login => X_LAST_UPDATE_LOGIN
612: );
613:
614: update IGS_PS_TCH_RESP set
615: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
616: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
617: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
618: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 639: cursor c1 is select rowid from IGS_PS_TCH_RESP

635: X_ORG_UNIT_CD in VARCHAR2,
636: X_PERCENTAGE in NUMBER,
637: X_MODE in VARCHAR2
638: ) as
639: cursor c1 is select rowid from IGS_PS_TCH_RESP
640: where UNIT_CD = X_UNIT_CD
641: and VERSION_NUMBER = X_VERSION_NUMBER
642: and OU_START_DT = X_OU_START_DT
643: and ORG_UNIT_CD = X_ORG_UNIT_CD

Line 679: delete from IGS_PS_TCH_RESP

675: Before_DML(
676: p_action => 'DELETE',
677: x_rowid => X_ROWID
678: );
679: delete from IGS_PS_TCH_RESP
680: where ROWID = X_ROWID;
681: if (sql%notfound) then
682: raise no_data_found;
683: end if;

Line 690: end IGS_PS_TCH_RESP_PKG;

686: x_rowid => X_ROWID
687: );
688: end DELETE_ROW;
689:
690: end IGS_PS_TCH_RESP_PKG;