1 PACKAGE IGR_PER_INFO_001 AS
2 /* $Header: IGSRTP1S.pls 120.0 2005/06/01 19:02:27 appldev noship $ */
3 /******************************************************************
4 Created By: Benjamin Gu
5 Date Created By: 19-Feb-2002
6 Purpose: Some pl/sql functions used in person summary pages
7 Known limitations,enhancements,remarks:
8 Change History
9 Who When What
10 jchin 14-Feb-05 Modified package for IGR pseudo product
11 ******************************************************************/
12 FUNCTION GET_APPL_PROG_UNIT_SETS(x_person_id IN NUMBER,
13 x_adm_appl_number IN NUMBER,
14 x_course_cd IN VARCHAR2,
15 x_seq_number IN NUMBER
16 ) RETURN VARCHAR2;
17
18 FUNCTION GET_INQ_PROG_UNIT_SETS(x_prog_pref_id IN NUMBER) RETURN VARCHAR2;
19
20 FUNCTION GET_TEST_SCORES(x_test_result_id IN NUMBER) RETURN VARCHAR2;
21 END IGR_PER_INFO_001;