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_AS_ITEM_ASSESSOR_PKG dependencies on IGS_AS_ITEM_ASSESSOR

Line 1: package body IGS_AS_ITEM_ASSESSOR_PKG AS

1: package body IGS_AS_ITEM_ASSESSOR_PKG AS
2: /* $Header: IGSDI02B.pls 120.0 2005/07/05 12:14:17 appldev noship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374. Repointed genp_val_prsn_id
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ITEM_ASSESSOR%RowType;

Line 5: old_references IGS_AS_ITEM_ASSESSOR%RowType;

1: package body IGS_AS_ITEM_ASSESSOR_PKG AS
2: /* $Header: IGSDI02B.pls 120.0 2005/07/05 12:14:17 appldev noship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374. Repointed genp_val_prsn_id
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ITEM_ASSESSOR%RowType;
6: new_references IGS_AS_ITEM_ASSESSOR%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AS_ITEM_ASSESSOR%RowType;

2: /* $Header: IGSDI02B.pls 120.0 2005/07/05 12:14:17 appldev noship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374. Repointed genp_val_prsn_id
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ITEM_ASSESSOR%RowType;
6: new_references IGS_AS_ITEM_ASSESSOR%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_person_id IN NUMBER DEFAULT NULL,

Line 28: FROM IGS_AS_ITEM_ASSESSOR

24: x_last_update_login IN NUMBER DEFAULT NULL
25: ) AS
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_AS_ITEM_ASSESSOR
29: WHERE rowid = x_rowid;
30: BEGIN
31: l_rowid := x_rowid;
32: -- Code for setting the Old and New Reference Values.

Line 70: -- ON IGS_AS_ITEM_ASSESSOR

66: END Set_Column_Values;
67: -- Trigger description :-
68: -- "OSS_TST".trg_aia_br_iu
69: -- BEFORE INSERT OR UPDATE
70: -- ON IGS_AS_ITEM_ASSESSOR
71: -- FOR EACH ROW
72: PROCEDURE BeforeRowInsertUpdate1(
73: p_inserting IN BOOLEAN DEFAULT FALSE,
74: p_updating IN BOOLEAN DEFAULT FALSE,

Line 129: -- ON IGS_AS_ITEM_ASSESSOR

125: END BeforeRowInsertUpdate1;
126: -- Trigger description :-
127: -- "OSS_TST".trg_aia_ar_iu
128: -- AFTER INSERT OR UPDATE
129: -- ON IGS_AS_ITEM_ASSESSOR
130: -- FOR EACH ROW
131: PROCEDURE AfterRowInsertUpdate2(
132: p_inserting IN BOOLEAN DEFAULT FALSE,
133: p_updating IN BOOLEAN DEFAULT FALSE,

Line 170: -- ON IGS_AS_ITEM_ASSESSOR

166: END AfterRowInsertUpdate2;
167: -- Trigger description :-
168: -- "OSS_TST".trg_aia_as_iu
169: -- AFTER INSERT OR UPDATE
170: -- ON IGS_AS_ITEM_ASSESSOR
171:
172: PROCEDURE Check_Parent_Existance AS
173: BEGIN
174: IF (((old_references.ass_id = new_references.ass_id)) OR

Line 242: FROM IGS_AS_ITEM_ASSESSOR

238: x_sequence_number IN NUMBER
239: ) RETURN BOOLEAN AS
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM IGS_AS_ITEM_ASSESSOR
243: WHERE ass_id = x_ass_id
244: AND person_id = x_person_id
245: AND sequence_number = x_sequence_number
246: FOR UPDATE NOWAIT;

Line 265: FROM IGS_AS_ITEM_ASSESSOR

261: x_ass_id IN NUMBER
262: ) AS
263: CURSOR cur_rowid IS
264: SELECT rowid
265: FROM IGS_AS_ITEM_ASSESSOR
266: WHERE ass_id = x_ass_id ;
267: lv_rowid cur_rowid%RowType;
268: BEGIN
269: Open cur_rowid;

Line 286: FROM IGS_AS_ITEM_ASSESSOR

282: x_ass_assessor_type IN VARCHAR2
283: ) AS
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM IGS_AS_ITEM_ASSESSOR
287: WHERE ass_assessor_type = x_ass_assessor_type ;
288: lv_rowid cur_rowid%RowType;
289: BEGIN
290: Open cur_rowid;

Line 307: FROM IGS_AS_ITEM_ASSESSOR

303: x_location_cd IN VARCHAR2
304: ) AS
305: CURSOR cur_rowid IS
306: SELECT rowid
307: FROM IGS_AS_ITEM_ASSESSOR
308: WHERE location_cd = x_location_cd ;
309: lv_rowid cur_rowid%RowType;
310: BEGIN
311: Open cur_rowid;

Line 328: FROM IGS_AS_ITEM_ASSESSOR

324: x_person_id IN NUMBER
325: ) AS
326: CURSOR cur_rowid IS
327: SELECT rowid
328: FROM IGS_AS_ITEM_ASSESSOR
329: WHERE person_id = x_person_id ;
330: lv_rowid cur_rowid%RowType;
331: BEGIN
332: Open cur_rowid;

Line 350: FROM IGS_AS_ITEM_ASSESSOR

346: x_unit_mode IN VARCHAR2
347: ) AS
348: CURSOR cur_rowid IS
349: SELECT rowid
350: FROM IGS_AS_ITEM_ASSESSOR
351: WHERE unit_mode = x_unit_mode ;
352: lv_rowid cur_rowid%RowType;
353: BEGIN
354: Open cur_rowid;

Line 466: cursor C is select ROWID from IGS_AS_ITEM_ASSESSOR

462: X_UNIT_CLASS in VARCHAR2,
463: X_COMMENTS in VARCHAR2,
464: X_MODE in VARCHAR2 default 'R'
465: ) AS
466: cursor C is select ROWID from IGS_AS_ITEM_ASSESSOR
467: where ASS_ID = X_ASS_ID
468: and PERSON_ID = X_PERSON_ID
469: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
470: X_LAST_UPDATE_DATE DATE;

Line 512: insert into IGS_AS_ITEM_ASSESSOR (

508: x_last_update_date=>X_LAST_UPDATE_DATE,
509: x_last_updated_by=>X_LAST_UPDATED_BY,
510: x_last_update_login=>X_LAST_UPDATE_LOGIN
511: );
512: insert into IGS_AS_ITEM_ASSESSOR (
513: ASS_ID,
514: PERSON_ID,
515: SEQUENCE_NUMBER,
516: ASS_ASSESSOR_TYPE,

Line 578: from IGS_AS_ITEM_ASSESSOR

574: LOCATION_CD,
575: UNIT_MODE,
576: UNIT_CLASS,
577: COMMENTS
578: from IGS_AS_ITEM_ASSESSOR
579: where ROWID = X_ROWID for update nowait;
580: tlinfo c1%rowtype;
581: begin
582: open c1;

Line 673: update IGS_AS_ITEM_ASSESSOR set

669: x_last_update_date=>X_LAST_UPDATE_DATE,
670: x_last_updated_by=>X_LAST_UPDATED_BY,
671: x_last_update_login=>X_LAST_UPDATE_LOGIN
672: );
673: update IGS_AS_ITEM_ASSESSOR set
674: ASS_ASSESSOR_TYPE = NEW_REFERENCES.ASS_ASSESSOR_TYPE,
675: PRIMARY_ASSESSOR_IND = NEW_REFERENCES.PRIMARY_ASSESSOR_IND,
676: ITEM_LIMIT = NEW_REFERENCES.ITEM_LIMIT,
677: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,

Line 707: cursor c1 is select rowid from IGS_AS_ITEM_ASSESSOR

703: X_UNIT_CLASS in VARCHAR2,
704: X_COMMENTS in VARCHAR2,
705: X_MODE in VARCHAR2 default 'R'
706: ) AS
707: cursor c1 is select rowid from IGS_AS_ITEM_ASSESSOR
708: where ASS_ID = X_ASS_ID
709: and PERSON_ID = X_PERSON_ID
710: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
711: ;

Line 754: delete from IGS_AS_ITEM_ASSESSOR

750: Before_DML(
751: p_action => 'DELETE',
752: x_rowid => X_ROWID
753: );
754: delete from IGS_AS_ITEM_ASSESSOR
755: where ROWID = X_ROWID;
756: After_DML(
757: p_action => 'DELETE',
758: x_rowid => X_ROWID

Line 868: end IGS_AS_ITEM_ASSESSOR_PKG;

864: END IF;
865:
866:
867: END Check_Constraints;
868: end IGS_AS_ITEM_ASSESSOR_PKG;