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_USEC_REF_CD

Line 32: -- 2)Also added a for loop which inserts into the igs_ps_usec_ref_cd

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
33: -- all reference code records from old unit section to new unit section.
34: -- 3)Added an IF condition that checks if the function igs_ru_gen_002.rulp_ins_parser
35: -- returns a TRUE or FALSE.
36: -- 4)Modified the values being passed to the parameters in call to igs_ru_gen_002.rulp_ins_parser

Line 2254: FROM igs_ps_usec_ref_cd

2250:
2251: --15
2252: CURSOR usec_refcd( p_usec_ref_id NUMBER ) IS
2253: SELECT *
2254: FROM igs_ps_usec_ref_cd
2255: WHERE unit_section_reference_id = p_usec_ref_id;
2256:
2257: --Modified CURSOR us_req_refcd as part of bug#2563596.In the where condition the column unit_section_req_ref_cd_id
2258: --was replaced with column unit_section_reference_id.This was causing no unit section requirements reference codes

Line 3472: --Unit section TBH automatically inserts in igs_ps_usec_ref and igs_ps_usec_ref_cd, so removed those inserts

3468: WHERE uoo_id = p_uoo_id;
3469: l_usec_ref usec_reference%ROWTYPE;
3470: BEGIN
3471: --added by sarakshi, bug#2332807
3472: --Unit section TBH automatically inserts in igs_ps_usec_ref and igs_ps_usec_ref_cd, so removed those inserts
3473: --only igs_ps_us_req_ref_cd insertion is required
3474:
3475: OPEN usec_reference(p_new_uoo_id);
3476: FETCH usec_reference INTO l_usec_ref;

Line 3480: --The Unit section TBH automatically inserts in igs_ps_usec_ref ,but inserts into igs_ps_usec_ref_cd only

3476: FETCH usec_reference INTO l_usec_ref;
3477: CLOSE usec_reference;
3478:
3479: --Added the following For loop as part of bug#2563596
3480: --The Unit section TBH automatically inserts in igs_ps_usec_ref ,but inserts into igs_ps_usec_ref_cd only
3481: --if the reference codes are of mandatory ref code types.Hence an explicit insert into igs_ps_usec_ref_cd
3482: --table has been added here for rolling over all unit section reference code records of old unit section
3483: --into the new unit section
3484:

Line 3481: --if the reference codes are of mandatory ref code types.Hence an explicit insert into igs_ps_usec_ref_cd

3477: CLOSE usec_reference;
3478:
3479: --Added the following For loop as part of bug#2563596
3480: --The Unit section TBH automatically inserts in igs_ps_usec_ref ,but inserts into igs_ps_usec_ref_cd only
3481: --if the reference codes are of mandatory ref code types.Hence an explicit insert into igs_ps_usec_ref_cd
3482: --table has been added here for rolling over all unit section reference code records of old unit section
3483: --into the new unit section
3484:
3485: -- Rollover of unit section reference code records

Line 3488: CURSOR cur_usec_refcd_new (cp_unit_section_reference_id igs_ps_usec_ref_cd.unit_section_reference_id%TYPE,

3484:
3485: -- Rollover of unit section reference code records
3486: FOR usec_refcd_rec IN usec_refcd (usec_ref_rec.unit_section_reference_id ) LOOP
3487: DECLARE
3488: CURSOR cur_usec_refcd_new (cp_unit_section_reference_id igs_ps_usec_ref_cd.unit_section_reference_id%TYPE,
3489: cp_reference_code_type igs_ps_usec_ref_cd.reference_code_type%TYPE,
3490: cp_reference_code igs_ps_usec_ref_cd.reference_code%TYPE) IS
3491: SELECT 'X'
3492: FROM igs_ps_usec_ref_cd

Line 3489: cp_reference_code_type igs_ps_usec_ref_cd.reference_code_type%TYPE,

3485: -- Rollover of unit section reference code records
3486: FOR usec_refcd_rec IN usec_refcd (usec_ref_rec.unit_section_reference_id ) LOOP
3487: DECLARE
3488: CURSOR cur_usec_refcd_new (cp_unit_section_reference_id igs_ps_usec_ref_cd.unit_section_reference_id%TYPE,
3489: cp_reference_code_type igs_ps_usec_ref_cd.reference_code_type%TYPE,
3490: cp_reference_code igs_ps_usec_ref_cd.reference_code%TYPE) IS
3491: SELECT 'X'
3492: FROM igs_ps_usec_ref_cd
3493: WHERE unit_section_reference_id = cp_unit_section_reference_id

Line 3490: cp_reference_code igs_ps_usec_ref_cd.reference_code%TYPE) IS

3486: FOR usec_refcd_rec IN usec_refcd (usec_ref_rec.unit_section_reference_id ) LOOP
3487: DECLARE
3488: CURSOR cur_usec_refcd_new (cp_unit_section_reference_id igs_ps_usec_ref_cd.unit_section_reference_id%TYPE,
3489: cp_reference_code_type igs_ps_usec_ref_cd.reference_code_type%TYPE,
3490: cp_reference_code igs_ps_usec_ref_cd.reference_code%TYPE) IS
3491: SELECT 'X'
3492: FROM igs_ps_usec_ref_cd
3493: WHERE unit_section_reference_id = cp_unit_section_reference_id
3494: AND reference_code_type = cp_reference_code_type

Line 3492: FROM igs_ps_usec_ref_cd

3488: CURSOR cur_usec_refcd_new (cp_unit_section_reference_id igs_ps_usec_ref_cd.unit_section_reference_id%TYPE,
3489: cp_reference_code_type igs_ps_usec_ref_cd.reference_code_type%TYPE,
3490: cp_reference_code igs_ps_usec_ref_cd.reference_code%TYPE) IS
3491: SELECT 'X'
3492: FROM igs_ps_usec_ref_cd
3493: WHERE unit_section_reference_id = cp_unit_section_reference_id
3494: AND reference_code_type = cp_reference_code_type
3495: AND reference_code = cp_reference_code
3496: AND ROWNUM = 1;

Line 3506: igs_ps_usec_ref_cd_pkg.insert_row (

3502:
3503: OPEN cur_usec_refcd_new(l_usec_ref.unit_section_reference_id, usec_refcd_rec.reference_code_type, usec_refcd_rec.reference_code);
3504: FETCH cur_usec_refcd_new INTO l_cur_usec_refcd_new;
3505: IF cur_usec_refcd_new%NOTFOUND THEN
3506: igs_ps_usec_ref_cd_pkg.insert_row (
3507: x_rowid => lv_rowid,
3508: x_unit_section_reference_cd_id => l_unit_section_reference_cd_id,
3509: x_unit_section_reference_id => l_usec_ref.unit_section_reference_id,
3510: x_mode => 'R',