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_GEN_001 dependencies on IGS_PS_OFR_OPT

Line 28: --shtatiko 21-OCT-2002 Added two parameters, program_length and program_length_measurement, to insert_row call of IGS_PS_OFR_OPT_PKG as per bug# 2608227.

24: --sarakshi 23-Feb-2003 Enh#2797116,modified cursor gc_coo_rec in crsp_ins_crs_ver procedure.Also modified
25: -- cursor c_coo_new in crsp_ins_coi_rec procedure.
26: --vvutukur 01-Nov-2002 Enh#2636716.Modifications done in crsp_ins_unit_section.
27: --vvutukur 28-Oct-2002 Enh#2613933.Modifications done in crsp_ins_unit_section.
28: --shtatiko 21-OCT-2002 Added two parameters, program_length and program_length_measurement, to insert_row call of IGS_PS_OFR_OPT_PKG as per bug# 2608227.
29: --amuthu 24-Sep-02 added core_ind column to the cursor c_posu and also
30: -- added it to the insert row call of igs_ps_pat_study_unt_pkg
31: --jbegum 11-Sep-02 1)As part of bug#2563596 modified CURSOR us_req_refcd.
32: -- 2)Also added a for loop which inserts into the igs_ps_usec_ref_cd

Line 76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%ROWTYPE;

72: cst_max_error_range CONSTANT NUMBER := -20999;
73: cst_min_error_range CONSTANT NUMBER := -20000;
74: gv_cv_rec IGS_PS_VER%ROWTYPE;
75: gv_con_rec IGS_PS_OFR_NOTE%ROWTYPE;
76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%ROWTYPE;
77: gv_co_rec IGS_PS_OFR%ROWTYPE;
78: gv_coo_rec IGS_PS_OFR_OPT%ROWTYPE;
79: gv_ceprcd_rec IGS_PS_ENT_PT_REF_CD%ROWTYPE;
80: gv_calulink_rec IGS_PS_ANL_LOAD_U_LN%ROWTYPE;

Line 78: gv_coo_rec IGS_PS_OFR_OPT%ROWTYPE;

74: gv_cv_rec IGS_PS_VER%ROWTYPE;
75: gv_con_rec IGS_PS_OFR_NOTE%ROWTYPE;
76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%ROWTYPE;
77: gv_co_rec IGS_PS_OFR%ROWTYPE;
78: gv_coo_rec IGS_PS_OFR_OPT%ROWTYPE;
79: gv_ceprcd_rec IGS_PS_ENT_PT_REF_CD%ROWTYPE;
80: gv_calulink_rec IGS_PS_ANL_LOAD_U_LN%ROWTYPE;
81: gv_coi_rec IGS_PS_OFR_INST%ROWTYPE;
82: gv_cop_rec IGS_PS_OFR_PAT%ROWTYPE;

Line 85: gv_coo_seq_num IGS_PS_OFR_OPT.coo_id%TYPE;

81: gv_coi_rec IGS_PS_OFR_INST%ROWTYPE;
82: gv_cop_rec IGS_PS_OFR_PAT%ROWTYPE;
83: gv_copn_rec IGS_PS_OFR_PAT_NOTE%ROWTYPE;
84: gv_ref_num IGS_GE_NOTE.reference_number%TYPE;
85: gv_coo_seq_num IGS_PS_OFR_OPT.coo_id%TYPE;
86: gv_cop_seq_num IGS_PS_OFR_PAT.cop_id%TYPE;
87: gv_ca_rec IGS_PS_AWARD%ROWTYPE;
88: gv_cao_rec IGS_PS_AWD_OWN%ROWTYPE;
89: gv_cow_rec IGS_PS_OWN%ROWTYPE;

Line 206: FROM IGS_PS_OFR_OPT

202: WHERE course_cd = p_old_course_cd AND
203: version_number = p_old_version_number;
204: CURSOR gc_coo_rec IS
205: SELECT *
206: FROM IGS_PS_OFR_OPT
207: WHERE course_cd = p_old_course_cd AND
208: version_number = p_old_version_number AND
209: cal_type = gv_co_rec.cal_type
210: AND delete_flag = 'N';

Line 237: FROM IGS_PS_OFR_OPT_NOTE coon

233: -- Only interested in notes that are not OLE type as
234: -- currently unable to copy long raw field within PL/SQL
235: CURSOR gc_coon_rec IS
236: SELECT *
237: FROM IGS_PS_OFR_OPT_NOTE coon
238: WHERE coon.course_cd = p_old_course_cd AND
239: coon.version_number = p_old_version_number AND
240: coon.cal_type = gv_coo_rec.cal_type AND
241: coon.location_cd = gv_coo_rec.location_cd AND

Line 282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL

278: CURSOR gc_ref_num IS
279: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL
280: FROM DUAL;
281: CURSOR gc_coo_seq_num IS
282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL
283: FROM DUAL;
284:
285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records
286: PROCEDURE crsp_ins_coon_rec (

Line 285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records

281: CURSOR gc_coo_seq_num IS
282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL
283: FROM DUAL;
284:
285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records
286: PROCEDURE crsp_ins_coon_rec (
287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
289:

Line 313: -- inserting IGS_PS_OFR_OPT_NOTE records

309: X_MODE =>'R');
310: End Loop;
311:
312:
313: -- inserting IGS_PS_OFR_OPT_NOTE records
314: x_rowid := NULL;
315: IGS_PS_OFR_OPT_NOTE_PKG.INSERT_ROW(
316: X_ROWID => X_ROWID,
317: X_COURSE_CD => p_new_course_cd,

Line 315: IGS_PS_OFR_OPT_NOTE_PKG.INSERT_ROW(

311:
312:
313: -- inserting IGS_PS_OFR_OPT_NOTE records
314: x_rowid := NULL;
315: IGS_PS_OFR_OPT_NOTE_PKG.INSERT_ROW(
316: X_ROWID => X_ROWID,
317: X_COURSE_CD => p_new_course_cd,
318: X_VERSION_NUMBER => p_new_version_number,
319: X_CAL_TYPE => gv_coon_rec.cal_type,

Line 687: -- procedure for inserting new IGS_PS_OFR_OPT records

683: ELSE
684: App_Exception.Raise_Exception;
685: END IF;
686: END crspl_ins_cooac_rec;
687: -- procedure for inserting new IGS_PS_OFR_OPT records
688: --modified by shtatiko on 21-OCT-2002 to incorporate the addition of two new columns to IGS_PS_OFR_OPT viz. program_length, program_length_measurement.
689: --this has been done as per bug# 2608227.
690: PROCEDURE crsp_ins_coo_rec(
691: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

Line 688: --modified by shtatiko on 21-OCT-2002 to incorporate the addition of two new columns to IGS_PS_OFR_OPT viz. program_length, program_length_measurement.

684: App_Exception.Raise_Exception;
685: END IF;
686: END crspl_ins_cooac_rec;
687: -- procedure for inserting new IGS_PS_OFR_OPT records
688: --modified by shtatiko on 21-OCT-2002 to incorporate the addition of two new columns to IGS_PS_OFR_OPT viz. program_length, program_length_measurement.
689: --this has been done as per bug# 2608227.
690: PROCEDURE crsp_ins_coo_rec(
691: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
692: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

Line 718: -- select the next IGS_PS_OFR_OPT reference_number

714: cous.unit_set_cd = coous.unit_set_cd AND
715: cous.us_version_number = coous.us_version_number);
716: l_org_id NUMBER(15);
717: BEGIN
718: -- select the next IGS_PS_OFR_OPT reference_number
719: -- from the system
720: OPEN gc_coo_seq_num;
721: FETCH gc_coo_seq_num INTO gv_coo_seq_num;
722: CLOSE gc_coo_seq_num;

Line 725: IGS_PS_OFR_OPT_PKG.INSERT_ROW(

721: FETCH gc_coo_seq_num INTO gv_coo_seq_num;
722: CLOSE gc_coo_seq_num;
723: x_rowid := NULL;
724: l_org_id := IGS_GE_GEN_003.GET_ORG_ID;
725: IGS_PS_OFR_OPT_PKG.INSERT_ROW(
726: X_ROWID => x_rowid,
727: X_COURSE_CD => p_new_course_cd,
728: X_VERSION_NUMBER => p_new_version_number,
729: X_CAL_TYPE => gv_coo_rec.cal_type,

Line 765: -- calling procedure to insert IGS_PS_OFR_OPT_NOTE records

761: X_ORG_ID => l_org_id ,
762: x_program_length => gv_coo_rec.program_length, --added as per bug# 2608227
763: x_program_length_measurement => gv_coo_rec.program_length_measurement --added as per bug# 2608227
764: );
765: -- calling procedure to insert IGS_PS_OFR_OPT_NOTE records
766: -- associated with each IGS_PS_OFR_OPT record
767: OPEN gc_coon_rec;
768: LOOP
769: FETCH gc_coon_rec INTO gv_coon_rec;

Line 766: -- associated with each IGS_PS_OFR_OPT record

762: x_program_length => gv_coo_rec.program_length, --added as per bug# 2608227
763: x_program_length_measurement => gv_coo_rec.program_length_measurement --added as per bug# 2608227
764: );
765: -- calling procedure to insert IGS_PS_OFR_OPT_NOTE records
766: -- associated with each IGS_PS_OFR_OPT record
767: OPEN gc_coon_rec;
768: LOOP
769: FETCH gc_coon_rec INTO gv_coon_rec;
770: IF gc_coon_rec%FOUND THEN

Line 840: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,

836: IS
837: BEGIN
838: DECLARE
839: CURSOR c_coo_new (
840: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
841: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
842: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
843: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE) IS
844: SELECT 'x'

Line 841: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,

837: BEGIN
838: DECLARE
839: CURSOR c_coo_new (
840: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
841: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
842: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
843: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE) IS
844: SELECT 'x'
845: FROM IGS_PS_OFR_OPT coo

Line 842: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,

838: DECLARE
839: CURSOR c_coo_new (
840: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
841: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
842: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
843: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE) IS
844: SELECT 'x'
845: FROM IGS_PS_OFR_OPT coo
846: WHERE coo.course_cd = p_new_course_cd AND

Line 843: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE) IS

839: CURSOR c_coo_new (
840: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
841: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
842: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
843: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE) IS
844: SELECT 'x'
845: FROM IGS_PS_OFR_OPT coo
846: WHERE coo.course_cd = p_new_course_cd AND
847: coo.version_number = p_new_version_number AND

Line 845: FROM IGS_PS_OFR_OPT coo

841: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
842: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
843: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE) IS
844: SELECT 'x'
845: FROM IGS_PS_OFR_OPT coo
846: WHERE coo.course_cd = p_new_course_cd AND
847: coo.version_number = p_new_version_number AND
848: coo.cal_type = cp_cal_type AND
849: coo.location_cd = cp_location_cd AND

Line 1242: -- calling procedure to insert IGS_PS_OFR_OPT records

1238: -- calling procedure to insert IGS_PS_OFR_UNIT_SET records
1239: -- and its child tables IGS_PS_OF_OPT_UNT_ST and
1240: -- IGS_PS_OF_UNT_SET_RL
1241: crspl_ins_cous_rec;
1242: -- calling procedure to insert IGS_PS_OFR_OPT records
1243: -- associated with each IGS_PS_OFR record
1244: OPEN gc_coo_rec;
1245: LOOP
1246: FETCH gc_coo_rec INTO gv_coo_rec;

Line 1883: -- IGS_PS_OFR_UNIT_SET and IGS_PS_OFR_OPT populated first.

1879: -- If the insertion of a IGS_PS_COURSE IGS_GE_NOTE fails, the associated IGS_GE_NOTE is removed.
1880: -- IGS_GE_NOTE: If any tables to be added, be careful to ensure relational integrity
1881: -- is preserved. Please check that all foreign keys are catered for.
1882: -- (For example, IGS_PS_OF_OPT_UNT_ST relies on
1883: -- IGS_PS_OFR_UNIT_SET and IGS_PS_OFR_OPT populated first.
1884: -- Only then can the records be created for the new version provided
1885: -- the parent records exist.)
1886: -- This checks if the specified new IGS_PS_COURSE version exists
1887: