APPS.IGS_PS_GEN_006 dependencies on IGS_PS_UNIT_VER

Line 10: -- parameters to igs_ps_unit_ver_hist_pkg.insert_row call in

6: --sarakshi 02-Sep-2003 Enh#3052452,removed the reference of the column sup_unit_allowed_ind and sub_unit_allowed_ind
7: -- shtatiko 03-FEB-2003 Bug# 2550411, Modified crsp_ins_ci_uop_uoo procedure and added
8: -- the procedure, log_parameters.
9: -- shtatiko 25-OCT-2002 Added auditable_ind, audit_permission_ind and max_auditors_allowed
10: -- parameters to igs_ps_unit_ver_hist_pkg.insert_row call in
11: -- crsp_ins_uv_hist procedure. This has been done as part of Bug# 2636716.
12: -- jbegum 11 Sep 02 As part of bug fix of bug #2563596
13: -- removed the space present at the end of message string
14: -- during the assignment of message IGS_PS_SUCCESSROLL_UOO_UAI

Line 305: gv_uv_rec igs_ps_unit_ver%ROWTYPE;

301: gv_uoo_rec igs_ps_unit_ofr_opt%ROWTYPE;
302: gv_cal_instance_rec igs_ca_inst%ROWTYPE;
303: gv_start_dt igs_ca_inst.start_dt%TYPE;
304: gv_end_dt igs_ca_inst.end_dt%TYPE;
305: gv_uv_rec igs_ps_unit_ver%ROWTYPE;
306: gv_message VARCHAR2(255);
307: gv_rec_inserted_cnt NUMBER(4);
308: v_uop_identifier VARCHAR2(255);
309: v_message VARCHAR2(255);

Line 346: igs_ps_unit_ver uv

342: uop.waitlist_allowed,
343: uop.max_students_per_waitlist,
344: uop.delete_flag
345: FROM igs_ps_unit_ofr_pat uop,
346: igs_ps_unit_ver uv
347: WHERE uop.cal_type = p_source_cal_type
348: AND uop.ci_sequence_number = p_source_sequence_number
349: AND uv.unit_cd = uop.unit_cd
350: AND uv.version_number = uop.version_number

Line 500: -- selecting IGS_PS_UNIT_OFR_PAT records from IGS_PS_UNIT_OFR_PAT and IGS_PS_UNIT_VER

496: igs_ge_gen_003.genp_ins_log ('USEC-ROLL' ,
497: ' ',
498: lv_out_date );
499:
500: -- selecting IGS_PS_UNIT_OFR_PAT records from IGS_PS_UNIT_OFR_PAT and IGS_PS_UNIT_VER
501: OPEN gc_unit_offering_pattern;
502: LOOP
503: FETCH gc_unit_offering_pattern INTO gv_uop_rec;
504: EXIT WHEN gc_unit_offering_pattern%NOTFOUND;

Line 520: -- Check that IGS_PS_UNIT version in not inactive, otherwise

516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
517: || ' : ' || fnd_date.date_to_displaydate (gv_end_dt) );
518: fnd_file.put_line ( fnd_file.LOG, ' ');
519:
520: -- Check that IGS_PS_UNIT version in not inactive, otherwise
521: -- it can't be updated
522: IF (igs_ps_val_unit.crsp_val_iud_uv_dtl( gv_uop_rec.unit_cd,
523: gv_uop_rec.version_number,
524: gv_message) = TRUE) THEN

Line 1236: IGS_PS_UNIT_VER_HIST_PKG.Insert_Row(

1232:
1233:
1234: l_org_id := igs_ge_gen_003.get_org_id;
1235:
1236: IGS_PS_UNIT_VER_HIST_PKG.Insert_Row(
1237: X_ROWID => x_rowid,
1238: X_UNIT_CD => p_unit_cd,
1239: X_VERSION_NUMBER => p_version_number,
1240: X_HIST_START_DT => p_last_update_on,