1: PACKAGE IGS_HE_EXTRACT_FIELDS_PKG AS
2: /* $Header: IGSHE9CS.pls 120.5 2006/09/15 01:48:52 jtmathew noship $ */
3:
4: -- Structure to hold Cost Centre details
5: TYPE cc IS TABLE of igs_he_poous_ou_cc.cost_centre%TYPE
6: INDEX BY binary_integer;
7: TYPE subj IS TABLE of igs_he_poous_ou_cc.subject%TYPE
8: INDEX BY binary_integer;
9: TYPE prop IS TABLE of igs_he_poous_ou_cc.proportion%TYPE
3:
4: -- Structure to hold Cost Centre details
5: TYPE cc IS TABLE of igs_he_poous_ou_cc.cost_centre%TYPE
6: INDEX BY binary_integer;
7: TYPE subj IS TABLE of igs_he_poous_ou_cc.subject%TYPE
8: INDEX BY binary_integer;
9: TYPE prop IS TABLE of igs_he_poous_ou_cc.proportion%TYPE
10: INDEX BY binary_integer;
11:
5: TYPE cc IS TABLE of igs_he_poous_ou_cc.cost_centre%TYPE
6: INDEX BY binary_integer;
7: TYPE subj IS TABLE of igs_he_poous_ou_cc.subject%TYPE
8: INDEX BY binary_integer;
9: TYPE prop IS TABLE of igs_he_poous_ou_cc.proportion%TYPE
10: INDEX BY binary_integer;
11:
12: TYPE cc_rec IS RECORD
13: (cost_centre cc,