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_CA_INST_PKG dependencies on IGS_CA_INST_ALL

Line 5: old_references IGS_CA_INST_ALL%ROWTYPE;

1: PACKAGE BODY IGS_CA_INST_PKG AS
2: /* $Header: IGSCI12B.pls 120.0 2005/06/01 22:19:16 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_CA_INST_ALL%ROWTYPE;
6: new_references IGS_CA_INST_ALL%ROWTYPE;
7:
8: -- Forward declaring the procedure beforerowdelete, beforerowupdate
9: PROCEDURE beforerowdelete;

Line 6: new_references IGS_CA_INST_ALL%ROWTYPE;

2: /* $Header: IGSCI12B.pls 120.0 2005/06/01 22:19:16 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_CA_INST_ALL%ROWTYPE;
6: new_references IGS_CA_INST_ALL%ROWTYPE;
7:
8: -- Forward declaring the procedure beforerowdelete, beforerowupdate
9: PROCEDURE beforerowdelete;
10: PROCEDURE beforerowupdate;

Line 40: FROM IGS_CA_INST_ALL

36: ) AS
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGS_CA_INST_ALL
41: WHERE ROWID = x_rowid;
42:
43: BEGIN
44:

Line 541: igs_ps_unit_ver_pkg.get_fk_igs_ca_inst_all(

537: igs_ps_usec_x_grp_pkg.get_fk_igs_ca_inst (
538: old_references.cal_type,
539: old_references.sequence_number
540: );
541: igs_ps_unit_ver_pkg.get_fk_igs_ca_inst_all(
542: old_references.cal_type,
543: old_references.sequence_number
544: );
545: igs_ps_unit_ver_pkg.get_fk_igs_ca_inst_all1(

Line 545: igs_ps_unit_ver_pkg.get_fk_igs_ca_inst_all1(

541: igs_ps_unit_ver_pkg.get_fk_igs_ca_inst_all(
542: old_references.cal_type,
543: old_references.sequence_number
544: );
545: igs_ps_unit_ver_pkg.get_fk_igs_ca_inst_all1(
546: old_references.cal_type,
547: old_references.sequence_number
548: );
549: igs_en_elgb_ovr_pkg.get_fk_igs_ca_inst(

Line 732: igs_ca_inst_all ci

728: CURSOR cur_get_status
729: IS
730: SELECT s.s_cal_status
731: FROM igs_ca_stat s,
732: igs_ca_inst_all ci
733: WHERE ci.cal_status = s.cal_status
734: AND ci.cal_type = x_cal_type
735: AND ci.sequence_number = x_sequence_number;
736: l_s_cal_status igs_ca_stat.s_cal_status%TYPE;

Line 740: FROM igs_ca_inst_all

736: l_s_cal_status igs_ca_stat.s_cal_status%TYPE;
737:
738: CURSOR cur_rowid_planned IS
739: SELECT ROWID
740: FROM igs_ca_inst_all
741: WHERE cal_type = x_cal_type
742: AND sequence_number = x_sequence_number
743: FOR UPDATE NOWAIT;
744:

Line 747: FROM igs_ca_inst_all

743: FOR UPDATE NOWAIT;
744:
745: CURSOR cur_rowid_act_inact IS
746: SELECT ROWID
747: FROM igs_ca_inst_all
748: WHERE cal_type = x_cal_type
749: AND sequence_number = x_sequence_number;
750:
751: lv_rowid cur_rowid_planned%ROWTYPE;

Line 796: FROM IGS_CA_INST_ALL

792: )RETURN BOOLEAN AS
793:
794: CURSOR cur_rowid IS
795: SELECT ROWID
796: FROM IGS_CA_INST_ALL
797: WHERE cal_type = x_cal_type
798: AND sequence_number = x_sequence_number
799: AND start_dt = x_start_dt
800: AND end_dt = x_end_dt

Line 827: FROM IGS_CA_INST_ALL

823: )RETURN BOOLEAN AS
824:
825: CURSOR cur_rowid IS
826: SELECT ROWID
827: FROM IGS_CA_INST_ALL
828: WHERE cal_type = x_cal_type
829: AND start_dt = x_start_dt
830: AND end_dt = x_end_dt
831: AND ((l_rowid IS NULL) OR (ROWID <> l_rowid));

Line 855: FROM IGS_CA_INST_ALL

851: ) AS
852:
853: CURSOR cur_rowid IS
854: SELECT ROWID
855: FROM IGS_CA_INST_ALL
856: WHERE cal_type = x_cal_type ;
857:
858: lv_rowid cur_rowid%ROWTYPE;
859:

Line 881: FROM IGS_CA_INST_ALL

877: ) AS
878:
879: CURSOR cur_rowid IS
880: SELECT ROWID
881: FROM IGS_CA_INST_ALL
882: WHERE cal_status = x_cal_status ;
883:
884: lv_rowid cur_rowid%ROWTYPE;
885:

Line 908: FROM IGS_CA_INST_ALL

904: ) AS
905:
906: CURSOR cur_rowid IS
907: SELECT ROWID
908: FROM IGS_CA_INST_ALL
909: WHERE cal_type = x_cal_type
910: AND prior_ci_sequence_number = x_sequence_number ;
911:
912: lv_rowid cur_rowid%ROWTYPE;

Line 1071: CURSOR C IS SELECT ROWID FROM IGS_CA_INST_ALL

1067: X_PLANNING_FLAG IN VARCHAR2,
1068: X_SCHEDULE_FLAG IN VARCHAR2,
1069: X_ADMIN_FLAG IN VARCHAR2
1070: ) AS
1071: CURSOR C IS SELECT ROWID FROM IGS_CA_INST_ALL
1072: WHERE CAL_TYPE = X_CAL_TYPE
1073: AND SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
1074: X_LAST_UPDATE_DATE DATE;
1075: X_LAST_UPDATED_BY NUMBER;

Line 1122: INSERT INTO IGS_CA_INST_ALL (

1118: X_SCHEDULE_FLAG => X_SCHEDULE_FLAG,
1119: X_ADMIN_FLAG => X_ADMIN_FLAG
1120:
1121: );
1122: INSERT INTO IGS_CA_INST_ALL (
1123: CAL_TYPE,
1124: SEQUENCE_NUMBER,
1125: START_DT,
1126: END_DT,

Line 1212: FROM IGS_CA_INST_ALL

1208: TERM_INSTRUCTION_TIME,
1209: PLANNING_FLAG,
1210: SCHEDULE_FLAG,
1211: ADMIN_FLAG
1212: FROM IGS_CA_INST_ALL
1213: WHERE ROWID=X_ROWID
1214: FOR UPDATE NOWAIT;
1215: tlinfo c1%ROWTYPE;
1216:

Line 1362: UPDATE IGS_CA_INST_ALL SET

1358: l_msg :=LTRIM(RTRIM(x_description));
1359:
1360: END IF;
1361:
1362: UPDATE IGS_CA_INST_ALL SET
1363: START_DT = NEW_REFERENCES.START_DT,
1364: END_DT = NEW_REFERENCES.END_DT,
1365: CAL_STATUS = NEW_REFERENCES.CAL_STATUS,
1366: ALTERNATE_CODE = NEW_REFERENCES.ALTERNATE_CODE,

Line 1410: CURSOR c1 IS SELECT ROWID FROM IGS_CA_INST_ALL

1406: X_PLANNING_FLAG IN VARCHAR2,
1407: X_SCHEDULE_FLAG IN VARCHAR2,
1408: X_ADMIN_FLAG IN VARCHAR2
1409: ) AS
1410: CURSOR c1 IS SELECT ROWID FROM IGS_CA_INST_ALL
1411: WHERE CAL_TYPE = X_CAL_TYPE
1412: AND SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
1413: ;
1414: BEGIN

Line 1471: DELETE FROM IGS_CA_INST_ALL

1467: Before_DML(
1468: p_action =>'DELETE',
1469: x_rowid =>X_ROWID
1470: );
1471: DELETE FROM IGS_CA_INST_ALL
1472: WHERE ROWID=X_ROWID;
1473: IF (SQL%NOTFOUND) THEN
1474: RAISE NO_DATA_FOUND;
1475: END IF;