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_USEC_OCCURS_PKG dependencies on IGS_PS_USEC_OCCURS_ALL

Line 4: old_references igs_ps_usec_occurs_ALL%RowType;

1: PACKAGE BODY igs_ps_usec_occurs_pkg AS
2: /* $Header: IGSPI0WB.pls 120.2 2005/09/22 00:58:08 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_occurs_ALL%RowType;
5: new_references igs_ps_usec_occurs_ALL%RowType;
6:
7: PROCEDURE BeforeRowInsertUpdatedelete1( x_rowid IN VARCHAR2) IS
8: /*************************************************************

Line 5: new_references igs_ps_usec_occurs_ALL%RowType;

1: PACKAGE BODY igs_ps_usec_occurs_pkg AS
2: /* $Header: IGSPI0WB.pls 120.2 2005/09/22 00:58:08 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_occurs_ALL%RowType;
5: new_references igs_ps_usec_occurs_ALL%RowType;
6:
7: PROCEDURE BeforeRowInsertUpdatedelete1( x_rowid IN VARCHAR2) IS
8: /*************************************************************
9: Created By : pradhakr

Line 16: vvutukur 05-Nov-2002 Enh#2613933.Modified the cursor cur_ref_cd to add join with igs_ps_usec_occurs_all.

12: Know limitations, enhancements or remarks
13: Change History
14: Who When What
15: (reverse chronological order - newest change first)
16: vvutukur 05-Nov-2002 Enh#2613933.Modified the cursor cur_ref_cd to add join with igs_ps_usec_occurs_all.
17: ***************************************************************/
18: CURSOR cur_ref_cd IS
19: SELECT reference_code_type
20: FROM igs_ps_usec_ocur_ref_v A,

Line 21: igs_ps_usec_occurs_all B

17: ***************************************************************/
18: CURSOR cur_ref_cd IS
19: SELECT reference_code_type
20: FROM igs_ps_usec_ocur_ref_v A,
21: igs_ps_usec_occurs_all B
22: WHERE A.unit_section_occurrence_id = B.unit_section_occurrence_id
23: AND B.rowid = x_rowid;
24:
25: l_ref_cd igs_ps_usec_ocur_ref_v.reference_code_type%TYPE;

Line 184: FROM IGS_PS_USEC_OCCURS_ALL

180: ***************************************************************/
181:
182: CURSOR cur_old_ref_values IS
183: SELECT *
184: FROM IGS_PS_USEC_OCCURS_ALL
185: WHERE rowid = x_rowid;
186:
187: BEGIN
188:

Line 558: FROM igs_ps_usec_occurs_ALL

554: ***************************************************************/
555:
556: CURSOR cur_rowid IS
557: SELECT rowid
558: FROM igs_ps_usec_occurs_ALL
559: WHERE unit_section_occurrence_id = x_unit_section_occurrence_id
560: FOR UPDATE NOWAIT;
561:
562: lv_rowid cur_rowid%RowType;

Line 595: FROM igs_ps_usec_occurs_all

591: ***************************************************************/
592:
593: CURSOR cur_rowid IS
594: SELECT rowid
595: FROM igs_ps_usec_occurs_all
596: WHERE uoo_id = x_uoo_id
597: AND occurrence_identifier = x_occurrence_identifier
598: AND ((l_rowid is null) or (rowid <> l_rowid));
599: lv_rowid cur_rowid%ROWTYPE;

Line 632: FROM igs_ps_usec_occurs_ALL

628: ***************************************************************/
629:
630: CURSOR cur_rowid IS
631: SELECT rowid
632: FROM igs_ps_usec_occurs_ALL
633: WHERE building_code = x_building_id ;
634:
635: lv_rowid cur_rowid%RowType;
636:

Line 670: FROM igs_ps_usec_occurs_ALL

666: ***************************************************************/
667:
668: CURSOR cur_rowid IS
669: SELECT rowid
670: FROM igs_ps_usec_occurs_ALL
671: WHERE room_code = x_room_id ;
672:
673: lv_rowid cur_rowid%RowType;
674:

Line 708: FROM igs_ps_usec_occurs_ALL

704: ***************************************************************/
705:
706: CURSOR cur_rowid IS
707: SELECT rowid
708: FROM igs_ps_usec_occurs_ALL
709: WHERE uoo_id = x_uoo_id ;
710:
711: lv_rowid cur_rowid%RowType;
712:

Line 1030: cursor C is select ROWID from IGS_PS_USEC_OCCURS_ALL

1026: Sreenivas.Bonam 28-Aug-2000 Added x_ERROR_TEXT argument
1027: (reverse chronological order - newest change first)
1028: ***************************************************************/
1029:
1030: cursor C is select ROWID from IGS_PS_USEC_OCCURS_ALL
1031: where UNIT_SECTION_OCCURRENCE_ID= X_UNIT_SECTION_OCCURRENCE_ID
1032: ;
1033: X_LAST_UPDATE_DATE DATE ;
1034: X_LAST_UPDATED_BY NUMBER ;

Line 1139: insert into IGS_PS_USEC_OCCURS_ALL (

1135: x_occurrence_identifier => x_occurrence_identifier,
1136: x_abort_flag => x_abort_flag
1137:
1138: );
1139: insert into IGS_PS_USEC_OCCURS_ALL (
1140: UNIT_SECTION_OCCURRENCE_ID
1141: ,UOO_ID
1142: ,MONDAY
1143: ,TUESDAY

Line 1404: from IGS_PS_USEC_OCCURS_ALL

1400: no_set_day_ind,
1401: cancel_flag,
1402: occurrence_identifier,
1403: abort_flag
1404: from IGS_PS_USEC_OCCURS_ALL
1405: where ROWID = X_ROWID
1406: for update nowait;
1407: tlinfo c1%rowtype;
1408: begin

Line 1754: update IGS_PS_USEC_OCCURS_ALL set

1750: X_PROGRAM_UPDATE_DATE := SYSDATE;
1751: END IF;
1752: END IF;
1753:
1754: update IGS_PS_USEC_OCCURS_ALL set
1755: UOO_ID = NEW_REFERENCES.UOO_ID,
1756: MONDAY = NEW_REFERENCES.MONDAY,
1757: TUESDAY = NEW_REFERENCES.TUESDAY,
1758: WEDNESDAY = NEW_REFERENCES.WEDNESDAY,

Line 1896: cursor c1 is select ROWID from IGS_PS_USEC_OCCURS_ALL

1892: Sreenivas.Bonam 28-Aug-2000 Added x_error_text argument
1893: (reverse chronological order - newest change first)
1894: ***************************************************************/
1895:
1896: cursor c1 is select ROWID from IGS_PS_USEC_OCCURS_ALL
1897: where UNIT_SECTION_OCCURRENCE_ID= X_UNIT_SECTION_OCCURRENCE_ID
1898: ;
1899: begin
1900: open c1;

Line 2043: delete from IGS_PS_USEC_OCCURS_ALL

2039: x_rowid => X_ROWID
2040: );
2041:
2042: BeforeRowInsertUpdatedelete1(X_ROWID);
2043: delete from IGS_PS_USEC_OCCURS_ALL
2044: where ROWID = X_ROWID;
2045: if (sql%notfound) then
2046: raise no_data_found;
2047: end if;