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_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 2357: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

2353: l_conc_flag BOOLEAN;
2354: l_request_id NUMBER;
2355: l_message_name VARCHAR2(30);
2356:
2357: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2358: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2359: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;

Line 2358: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

2354: l_request_id NUMBER;
2355: l_message_name VARCHAR2(30);
2356:
2357: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2358: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2359: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;

Line 2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

2359: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;
2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2364: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;
2365: l_c_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE;
2366: l_n_subtitle_id igs_ps_unit_subtitle.subtitle_id%TYPE;
2367: l_b_uop_deleted BOOLEAN;

Line 2364: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;

2360: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;
2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2364: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;
2365: l_c_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE;
2366: l_n_subtitle_id igs_ps_unit_subtitle.subtitle_id%TYPE;
2367: l_b_uop_deleted BOOLEAN;
2368:

Line 2365: l_c_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE;

2361: l_c_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;
2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2364: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;
2365: l_c_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE;
2366: l_n_subtitle_id igs_ps_unit_subtitle.subtitle_id%TYPE;
2367: l_b_uop_deleted BOOLEAN;
2368:
2369:

Line 2938: l_c_sup_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

2934: Who When What
2935: sarakshi 11-Sep-2003 Enh#3052452,dervied teh value of sup_uoo_id.
2936: sarakshi 22-Aug-2003 Bug#304509, defaulting the value of Not Multiple Unit Section Flag
2937: ********************************************************************************************* */
2938: l_c_sup_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2939: l_n_sup_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2940: l_d_sup_start_dt igs_ca_inst_all.start_dt%TYPE;
2941: l_d_sup_end_dt igs_ca_inst_all.end_dt%TYPE;
2942: l_c_message VARCHAR2(30);

Line 2939: l_n_sup_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

2935: sarakshi 11-Sep-2003 Enh#3052452,dervied teh value of sup_uoo_id.
2936: sarakshi 22-Aug-2003 Bug#304509, defaulting the value of Not Multiple Unit Section Flag
2937: ********************************************************************************************* */
2938: l_c_sup_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2939: l_n_sup_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2940: l_d_sup_start_dt igs_ca_inst_all.start_dt%TYPE;
2941: l_d_sup_end_dt igs_ca_inst_all.end_dt%TYPE;
2942: l_c_message VARCHAR2(30);
2943:

Line 3237: CURSOR c_usec_check(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

3233: vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Added new column not_multiple_section_flag while insertion.
3234: ********************************************************************************************* */
3235: AS
3236:
3237: CURSOR c_usec_check(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3238: SELECT 'X'
3239: FROM igs_ps_unit_ofr_opt_all
3240: WHERE uoo_id=cp_uoo_id
3241: AND relation_type='SUPERIOR';

Line 3239: FROM igs_ps_unit_ofr_opt_all

3235: AS
3236:
3237: CURSOR c_usec_check(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3238: SELECT 'X'
3239: FROM igs_ps_unit_ofr_opt_all
3240: WHERE uoo_id=cp_uoo_id
3241: AND relation_type='SUPERIOR';
3242: l_c_var VARCHAR2(1);
3243:

Line 3276: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS

3272: l_cur_int_usec cur_int_usec%ROWTYPE;
3273:
3274:
3275: FUNCTION check_insert_update ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type) RETURN VARCHAR2 IS
3276: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
3277: SELECT 'X'
3278: FROM igs_ps_unit_ofr_opt_all
3279: WHERE unit_cd = p_usec_rec.unit_cd
3280: AND version_number = p_usec_rec.version_number

Line 3278: FROM igs_ps_unit_ofr_opt_all

3274:
3275: FUNCTION check_insert_update ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type) RETURN VARCHAR2 IS
3276: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
3277: SELECT 'X'
3278: FROM igs_ps_unit_ofr_opt_all
3279: WHERE unit_cd = p_usec_rec.unit_cd
3280: AND version_number = p_usec_rec.version_number
3281: AND ci_sequence_number =cp_seq_num
3282: AND unit_class = p_usec_rec.unit_class

Line 3302: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS

3298: END check_insert_update;
3299:
3300: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
3301:
3302: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
3303: SELECT *
3304: FROM igs_ps_unit_ofr_opt_all
3305: WHERE unit_cd = p_usec_rec.unit_cd
3306: AND version_number = p_usec_rec.version_number

Line 3304: FROM igs_ps_unit_ofr_opt_all

3300: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
3301:
3302: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
3303: SELECT *
3304: FROM igs_ps_unit_ofr_opt_all
3305: WHERE unit_cd = p_usec_rec.unit_cd
3306: AND version_number = p_usec_rec.version_number
3307: AND ci_sequence_number =cp_seq_num
3308: AND unit_class = p_usec_rec.unit_class

Line 3779: UPDATE igs_ps_unit_ofr_opt_all SET relation_type = 'SUPERIOR'

3775: IF l_n_sup_uoo_id IS NOT NULL THEN
3776: OPEN c_usec_check(l_n_sup_uoo_id);
3777: FETCH c_usec_check INTO l_c_var;
3778: IF c_usec_check%NOTFOUND THEN
3779: UPDATE igs_ps_unit_ofr_opt_all SET relation_type = 'SUPERIOR'
3780: WHERE uoo_id = l_n_sup_uoo_id;
3781: END IF;
3782: CLOSE c_usec_check;
3783: l_c_relation_type := 'SUBORDINATE';

Line 3797: FROM igs_ps_unit_ofr_opt_all

3793: cp_location_cd IN VARCHAR2,
3794: cp_unit_class IN VARCHAR2
3795: ) IS
3796: SELECT relation_type,sup_uoo_id
3797: FROM igs_ps_unit_ofr_opt_all
3798: WHERE unit_cd = cp_unit_cd
3799: AND version_number = cp_version_number
3800: AND ci_sequence_number =cp_seq_num
3801: AND unit_class = cp_unit_class

Line 3808: FROM igs_ps_unit_ofr_opt_all

3804: l_cur_usec cur_usec%ROWTYPE;
3805:
3806: CURSOR c_count_sup(cp_uoo_id NUMBER) IS
3807: SELECT COUNT(*)
3808: FROM igs_ps_unit_ofr_opt_all
3809: WHERE sup_uoo_id= cp_uoo_id;
3810: l_c_count NUMBER;
3811: BEGIN
3812:

Line 3822: UPDATE igs_ps_unit_ofr_opt_all SET relation_type = 'SUPERIOR'

3818: IF l_n_sup_uoo_id IS NOT NULL THEN
3819: OPEN c_usec_check(l_n_sup_uoo_id);
3820: FETCH c_usec_check INTO l_c_var;
3821: IF c_usec_check%NOTFOUND THEN
3822: UPDATE igs_ps_unit_ofr_opt_all SET relation_type = 'SUPERIOR'
3823: WHERE uoo_id = l_n_sup_uoo_id;
3824: END IF;
3825: CLOSE c_usec_check;
3826: l_c_relation_type := 'SUBORDINATE';

Line 3835: UPDATE igs_ps_unit_ofr_opt_all SET relation_type = 'NONE'

3831: OPEN c_count_sup(l_cur_usec.sup_uoo_id);
3832: FETCH c_count_sup INTO l_c_count;
3833: IF c_count_sup%FOUND THEN
3834: IF l_c_count < 2 THEN
3835: UPDATE igs_ps_unit_ofr_opt_all SET relation_type = 'NONE'
3836: WHERE uoo_id = l_cur_usec.sup_uoo_id;
3837: END IF;
3838: END IF;
3839: CLOSE c_count_sup;

Line 3857: INSERT INTO igs_ps_unit_ofr_opt_all

3853: IF FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'AUTO' THEN
3854: p_usec_rec.call_number := igs_ps_unit_ofr_opt_pkg.get_call_number( l_c_cal_type, l_n_seq_num);
3855: END IF;
3856:
3857: INSERT INTO igs_ps_unit_ofr_opt_all
3858: (unit_cd,
3859: version_number,
3860: cal_type,
3861: ci_sequence_number,

Line 3976: UPDATE igs_ps_unit_ofr_opt_all SET

3972:
3973: END IF;
3974:
3975: ELSE --update
3976: UPDATE igs_ps_unit_ofr_opt_all SET
3977: ivrs_available_ind = p_usec_rec.ivrs_available_ind,
3978: call_number=p_usec_rec.call_number,
3979: unit_section_status=p_usec_rec.unit_section_status,
3980: unit_section_start_date=p_usec_rec.unit_section_start_date,

Line 5671: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

5667: Change History (in reverse chronological order)
5668: Who When What
5669: ********************************************************************************************** */
5670: l_insert_update VARCHAR2(1);
5671: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5672: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
5673:
5674: /* Private Procedures for create_usec_grd_sch */
5675: PROCEDURE trim_values ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS

Line 5752: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

5748: END check_insert_update;
5749:
5750: -- Carry out derivations and validate them
5751: PROCEDURE validate_derivations ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5752: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5753: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5754: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5755: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5756: l_c_message VARCHAR2(30);

Line 5753: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

5749:
5750: -- Carry out derivations and validate them
5751: PROCEDURE validate_derivations ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5752: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5753: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5754: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5755: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5756: l_c_message VARCHAR2(30);
5757: BEGIN

Line 6056: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

6052: For PSP Scheduling Enhancements TD:
6053: Modified the local procedure's validate_derivation,validate_db_cons.
6054: ********************************************************************************************** */
6055:
6056: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
6057: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

Line 6057: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

6053: Modified the local procedure's validate_derivation,validate_db_cons.
6054: ********************************************************************************************** */
6055:
6056: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
6057: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;

Line 6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

6056: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
6057: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6063:
6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;

Line 7341: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- Holds Unit Offering Options Identifier

7337:
7338:
7339: l_c_cal_type igs_ca_inst_all.cal_type%TYPE; -- Holds Calendar Type
7340: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE; -- Holds Calendar Instance Sequence Number
7341: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- Holds Unit Offering Options Identifier
7342: l_n_usec_ref_id igs_ps_usec_ref.unit_section_reference_id%TYPE; -- Holds Unit Section Reference Identifier
7343: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE; -- Holds the Unit Section Occurrence Identifier
7344:
7345: --

Line 7449: CURSOR c_usec_ref_id (cp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

7445:
7446: -- Derivation of values required to create Unit Section Referrence.
7447: PROCEDURE validate_usec_derivations( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7448:
7449: CURSOR c_usec_ref_id (cp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7450: SELECT A.unit_section_reference_id
7451: FROM igs_ps_usec_ref A
7452: WHERE A.uoo_id = cp_uoo_id;
7453:

Line 8294: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

8290: ***********************************************************************************************/
8291:
8292: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
8293: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
8294: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8295: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
8297:
8298: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

Line 8507: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b

8503:
8504: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
8505: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8506: SELECT a.unit_cd, a.version_number
8507: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
8508: WHERE a.uoo_id = b.uoo_id
8509: AND b.unit_section_occurrence_id = cp_n_uso_id;
8510:
8511: rec_unit_ver c_unit_ver%ROWTYPE;