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_EN_UNIT_SET_PKG dependencies on IGS_EN_UNIT_SET_ALL

Line 5: old_references IGS_EN_UNIT_SET_ALL%RowType;

1: package body IGS_EN_UNIT_SET_PKG as
2: /* $Header: IGSEI01B.pls 120.1 2006/02/16 04:04:49 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_UNIT_SET_ALL%RowType;
6: new_references IGS_EN_UNIT_SET_ALL%RowType;
7:
8: PROCEDURE beforerowdelete AS
9: ------------------------------------------------------------------

Line 6: new_references IGS_EN_UNIT_SET_ALL%RowType;

2: /* $Header: IGSEI01B.pls 120.1 2006/02/16 04:04:49 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_UNIT_SET_ALL%RowType;
6: new_references IGS_EN_UNIT_SET_ALL%RowType;
7:
8: PROCEDURE beforerowdelete AS
9: ------------------------------------------------------------------
10: --Created by : smvk, Oracle India

Line 21: CURSOR cur_delete (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,

17: --
18: --Change History:
19: --Who When What
20: -------------------------------------------------------------------
21: CURSOR cur_delete (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
22: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
23: IS
24: SELECT 'x'
25: FROM igs_en_unit_set_all usv,

Line 22: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)

18: --Change History:
19: --Who When What
20: -------------------------------------------------------------------
21: CURSOR cur_delete (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
22: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
23: IS
24: SELECT 'x'
25: FROM igs_en_unit_set_all usv,
26: igs_en_unit_set_stat uss

Line 25: FROM igs_en_unit_set_all usv,

21: CURSOR cur_delete (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
22: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
23: IS
24: SELECT 'x'
25: FROM igs_en_unit_set_all usv,
26: igs_en_unit_set_stat uss
27: WHERE usv.unit_set_status = uss.unit_set_status
28: AND uss.s_unit_set_status = 'PLANNED'
29: AND usv.unit_set_cd = cp_c_unit_set_cd

Line 68: CURSOR cur_check_update (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,

64: WHERE unit_set_status = cp_c_unit_set_status;
65:
66: l_c_sys_status igs_en_unit_set_stat.s_unit_set_status%TYPE;
67:
68: CURSOR cur_check_update (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
69: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
70: IS
71: SELECT 'x'
72: FROM igs_en_unit_set_all usv,

Line 69: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)

65:
66: l_c_sys_status igs_en_unit_set_stat.s_unit_set_status%TYPE;
67:
68: CURSOR cur_check_update (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
69: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
70: IS
71: SELECT 'x'
72: FROM igs_en_unit_set_all usv,
73: igs_en_unit_set_stat uss

Line 72: FROM igs_en_unit_set_all usv,

68: CURSOR cur_check_update (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
69: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
70: IS
71: SELECT 'x'
72: FROM igs_en_unit_set_all usv,
73: igs_en_unit_set_stat uss
74: WHERE usv.unit_set_status=uss.unit_set_status
75: AND uss.s_unit_set_status <> 'PLANNED'
76: AND usv.unit_set_cd = cp_c_unit_set_cd

Line 155: FROM IGS_EN_UNIT_SET_ALL

151: ) as
152:
153: CURSOR cur_old_ref_values IS
154: SELECT *
155: FROM IGS_EN_UNIT_SET_ALL
156: WHERE rowid = x_rowid;
157:
158: BEGIN
159:

Line 229: -- ON IGS_EN_UNIT_SET_ALL

225:
226: -- Trigger description :-
227: -- "OSS_TST".trg_us_br_iu
228: -- BEFORE INSERT OR UPDATE
229: -- ON IGS_EN_UNIT_SET_ALL
230: -- FOR EACH ROW
231:
232: PROCEDURE BeforeRowInsertUpdate1(
233: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 340: -- ON IGS_EN_UNIT_SET_ALL

336:
337: -- Trigger description :-
338: -- "OSS_TST".trg_us_ar_iu
339: -- AFTER INSERT OR UPDATE
340: -- ON IGS_EN_UNIT_SET_ALL
341: -- FOR EACH ROW
342:
343: PROCEDURE AfterRowInsertUpdate2(
344: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 366: -- ON IGS_EN_UNIT_SET_ALL

362:
363: -- Trigger description :-
364: -- "OSS_TST".trg_us_ar_u_hist
365: -- AFTER UPDATE
366: -- ON IGS_EN_UNIT_SET_ALL
367: -- FOR EACH ROW
368:
369: PROCEDURE AfterRowUpdate3(
370: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 377: -- Create IGS_EN_UNIT_SET_ALL history record.

373: ) as
374: v_message_name varchar2(30);
375: BEGIN
376: IF p_updating THEN
377: -- Create IGS_EN_UNIT_SET_ALL history record.
378: IGS_PS_GEN_006.CRSP_INS_US_HIST (
379: new_references.unit_set_cd,
380: new_references.version_number,
381: new_references.unit_set_status,

Line 571: Added call to igs_fi_fee_as_rate_pkg.get_fk_igs_en_unit_set_all

567: PROCEDURE Check_Child_Existance as
568:
569: /* Who When What
570: pathipat 17-Sep-2003 Enh 3108052 - Add Unit Sets to Rate Table
571: Added call to igs_fi_fee_as_rate_pkg.get_fk_igs_en_unit_set_all
572: and igs_fi_fee_as_items_pkg.get_fk_igs_en_unit_set_all
573: sbaliga 9-May-2002 Added 2 more calls to check for child existence
574: as part of #2330002
575: myoganat 06-Jun-2003 Added IGS_EN_UNIT_SET_MAP_PKG.get_fk_igs_en_unit_set

Line 572: and igs_fi_fee_as_items_pkg.get_fk_igs_en_unit_set_all

568:
569: /* Who When What
570: pathipat 17-Sep-2003 Enh 3108052 - Add Unit Sets to Rate Table
571: Added call to igs_fi_fee_as_rate_pkg.get_fk_igs_en_unit_set_all
572: and igs_fi_fee_as_items_pkg.get_fk_igs_en_unit_set_all
573: sbaliga 9-May-2002 Added 2 more calls to check for child existence
574: as part of #2330002
575: myoganat 06-Jun-2003 Added IGS_EN_UNIT_SET_MAP_PKG.get_fk_igs_en_unit_set
576: as part of #2829265

Line 655: IGS_PS_RSV_ORGUN_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(

651: IGS_EN_UNIT_SET_RULE_PKG.GET_FK_IGS_EN_UNIT_SET (
652: old_references.unit_set_cd,
653: old_references.version_number
654: );
655: IGS_PS_RSV_ORGUN_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
656: old_references.unit_set_cd,
657: old_references.version_number);
658: IGS_PS_RSV_UOP_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
659: old_references.unit_set_cd,

Line 658: IGS_PS_RSV_UOP_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(

654: );
655: IGS_PS_RSV_ORGUN_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
656: old_references.unit_set_cd,
657: old_references.version_number);
658: IGS_PS_RSV_UOP_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
659: old_references.unit_set_cd,
660: old_references.version_number);
661: IGS_PS_RSV_USEC_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
662: old_references.unit_set_cd,

Line 661: IGS_PS_RSV_USEC_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(

657: old_references.version_number);
658: IGS_PS_RSV_UOP_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
659: old_references.unit_set_cd,
660: old_references.version_number);
661: IGS_PS_RSV_USEC_PRF_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
662: old_references.unit_set_cd,
663: old_references.version_number);
664:
665: IGS_AS_GPC_UNIT_SETS_PKG.GET_FK_IGS_EN_UNIT_SET(

Line 670: IGS_HE_POOUS_OU_ALL_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(

666: old_references.unit_set_cd,
667: old_references.version_number);
668:
669: --This call was added by sbaliga as part of #2330002
670: IGS_HE_POOUS_OU_ALL_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
671: old_references.unit_set_cd,
672: old_references.version_number
673: );
674:

Line 677: IGS_HE_POOUS_ALL_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(

673: );
674:
675:
676: -- Added the following check chaild existance for the HESA requirment, pmarada
677: IGS_HE_POOUS_ALL_PKG.GET_FK_IGS_EN_UNIT_SET_ALL(
678: old_references.unit_set_cd,
679: old_references.version_number);
680:
681: -- Enh bug#2833852

Line 693: igs_fi_fee_as_rate_pkg.get_fk_igs_en_unit_set_all(

689: old_references.unit_set_cd,
690: old_references.version_number
691: );
692:
693: igs_fi_fee_as_rate_pkg.get_fk_igs_en_unit_set_all(
694: old_references.unit_set_cd,
695: old_references.version_number
696: );
697:

Line 698: igs_fi_fee_as_items_pkg.get_fk_igs_en_unit_set_all(

694: old_references.unit_set_cd,
695: old_references.version_number
696: );
697:
698: igs_fi_fee_as_items_pkg.get_fk_igs_en_unit_set_all(
699: old_references.unit_set_cd,
700: old_references.version_number
701: );
702:

Line 717: FROM igs_en_unit_set_all usv,

713: -- For other system statuses we are not allowing the user to delete the record.
714:
715: CURSOR cur_get_status IS
716: SELECT uss.s_unit_set_status
717: FROM igs_en_unit_set_all usv,
718: igs_en_unit_set_stat uss
719: WHERE usv.unit_set_status = uss.unit_set_status
720: AND usv.unit_set_cd = x_unit_set_cd
721: AND usv.version_number = x_version_number;

Line 727: FROM IGS_EN_UNIT_SET_ALL

723: l_c_unit_set_status igs_en_unit_set_stat.s_unit_set_status%TYPE;
724:
725: CURSOR cur_rowid IS
726: SELECT rowid
727: FROM IGS_EN_UNIT_SET_ALL
728: WHERE unit_set_cd = x_unit_set_cd
729: AND version_number = x_version_number
730: FOR UPDATE NOWAIT;
731:

Line 767: FROM IGS_EN_UNIT_SET_ALL

763: ) as
764:
765: CURSOR cur_rowid IS
766: SELECT rowid
767: FROM IGS_EN_UNIT_SET_ALL
768: WHERE responsible_org_unit_cd = x_org_unit_cd
769: AND responsible_ou_start_dt = x_start_dt ;
770:
771: lv_rowid cur_rowid%RowType;

Line 794: FROM IGS_EN_UNIT_SET_ALL

790: ) as
791:
792: CURSOR cur_rowid IS
793: SELECT rowid
794: FROM IGS_EN_UNIT_SET_ALL
795: WHERE UNIT_SET_CAT = x_unit_set_cat ;
796:
797: lv_rowid cur_rowid%RowType;
798:

Line 820: FROM IGS_EN_UNIT_SET_ALL

816: ) as
817:
818: CURSOR cur_rowid IS
819: SELECT rowid
820: FROM IGS_EN_UNIT_SET_ALL
821: WHERE UNIT_SET_STATUS = x_unit_set_status ;
822:
823: lv_rowid cur_rowid%RowType;
824:

Line 1049: cursor C is select ROWID from IGS_EN_UNIT_SET_ALL

1045: X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
1046: X_MODE in VARCHAR2 default 'R',
1047: x_org_id IN NUMBER
1048: ) AS
1049: cursor C is select ROWID from IGS_EN_UNIT_SET_ALL
1050: where UNIT_SET_CD = X_UNIT_SET_CD
1051: and VERSION_NUMBER = X_VERSION_NUMBER;
1052: X_LAST_UPDATE_DATE DATE;
1053: X_LAST_UPDATED_BY NUMBER;

Line 1122: insert into IGS_EN_UNIT_SET_ALL (

1118: x_last_update_login => x_last_update_login ,
1119: x_org_id => igs_ge_gen_003.get_org_id
1120: );
1121:
1122: insert into IGS_EN_UNIT_SET_ALL (
1123: UNIT_SET_CD,
1124: VERSION_NUMBER,
1125: UNIT_SET_STATUS,
1126: UNIT_SET_CAT,

Line 1299: from IGS_EN_UNIT_SET_ALL

1295: ATTRIBUTE17,
1296: ATTRIBUTE18,
1297: ATTRIBUTE19,
1298: ATTRIBUTE20
1299: from IGS_EN_UNIT_SET_ALL
1300: where ROWID = X_ROWID
1301: for update nowait;
1302: tlinfo c1%rowtype;
1303:

Line 1500: update IGS_EN_UNIT_SET_ALL set

1496: x_last_updated_by => x_last_updated_by ,
1497: x_last_update_login => x_last_update_login
1498: );
1499:
1500: update IGS_EN_UNIT_SET_ALL set
1501: UNIT_SET_STATUS = NEW_REFERENCES.UNIT_SET_STATUS,
1502: UNIT_SET_CAT = NEW_REFERENCES.UNIT_SET_CAT,
1503: START_DT = NEW_REFERENCES.START_DT,
1504: REVIEW_DT = NEW_REFERENCES.REVIEW_DT,

Line 1593: cursor c1 is select rowid from IGS_EN_UNIT_SET_ALL

1589: X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
1590: X_MODE in VARCHAR2 default 'R',
1591: x_org_id IN NUMBER
1592: ) as
1593: cursor c1 is select rowid from IGS_EN_UNIT_SET_ALL
1594: where UNIT_SET_CD = X_UNIT_SET_CD
1595: and VERSION_NUMBER = X_VERSION_NUMBER;
1596:
1597: begin

Line 1694: delete from IGS_EN_UNIT_SET_ALL

1690: Before_DML(
1691: p_action => 'DELETE',
1692: x_rowid => X_ROWID
1693: );
1694: delete from IGS_EN_UNIT_SET_ALL
1695: where ROWID = X_ROWID;
1696: if (sql%notfound) then
1697: raise no_data_found;
1698: end if;