APPS.IGS_DA_XML_PKG dependencies on IGS_PS_UNIT_VER

Line 17: rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table

13: Change History
14:
15: Who When What
16: shogan May 8 2003 l_event_key - in Submit_Event Procedure
17: rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table
18: in function get_unit_repeatable . PSP integration build #3052433
19: smanglm 12-sep-2003 bug 3093223 - added pre_submit_event to write error report and lauch a workflow
20: shogan 20-feb-2004 Bug #3438386/3472644 - update added loop to procedure Submit_Event
21: - update added table updates with error_code.

Line 828: igs_en_su_attempt sua, igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo, IGS_PS_PRG_UNIT_REL pur,

824: --
825: CURSOR repeatable_cur is
826: SELECT uv.repeatable_ind
827: FROM hz_parties p, igs_en_stdnt_ps_att spa, igs_ps_ver crv, igs_ca_teach_to_load_v ttl,
828: igs_en_su_attempt sua, igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo, IGS_PS_PRG_UNIT_REL pur,
829: igs_as_su_atmptout_h_all atm
830: WHERE p.party_id = sua.person_id
831: AND sua.person_id = p_person_id
832: AND sua.unit_cd = p_unit_cd

Line 860: repeatable_ind igs_ps_unit_ver.repeatable_ind%TYPE

856:
857: l_repeatable_rec repeatable_cur%ROWTYPE;
858:
859: TYPE r_repeatable_rec IS RECORD (
860: repeatable_ind igs_ps_unit_ver.repeatable_ind%TYPE
861: );
862: TYPE t_repeat_table IS TABLE OF r_repeatable_rec INDEX BY BINARY_INTEGER;
863: repeat_table t_repeat_table;
864: