1 PACKAGE IGS_EN_DASHBOARD AS
2 /* $Header: IGSENB2S.pls 120.1 2005/11/18 04:20:57 appldev noship $ */
3
4 /*---------------------------------------------------------------------------------------
5 Created by : Somasekar.N , Oracle Student Systems Oracle IDC
6
7 --Change History:
8 --Who When What
9 --jnalam 18-Nov-2--5 Added new function Schedule_Units_Exists Bug# 4742735
10 ----------------------------------------------------------------------------------------*/
11
12 TYPE LINK_TEXT_TYPE IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
13 TYPE CAL_TYPE IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
14 TYPE SEQ_NUM_TYPE IS TABLE OF NUMBER(6) INDEX BY BINARY_INTEGER;
15 TYPE PRG_CAR_TYPE IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
16 TYPE PLAN_SCHED_TYPE IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
17
18 PROCEDURE student_api ( p_n_person_id IN NUMBER,
19 p_c_person_type IN VARCHAR2,
20 p_text_tbl OUT NOCOPY LINK_TEXT_TYPE,
21 p_cal_tbl OUT NOCOPY CAL_TYPE,
22 p_seq_tbl OUT NOCOPY SEQ_NUM_TYPE,
23 p_car_tbl OUT NOCOPY PRG_CAR_TYPE,
24 p_typ_tbl OUT NOCOPY PLAN_SCHED_TYPE,
25 p_sch_allow OUT NOCOPY VARCHAR2);
26
27 FUNCTION Schedule_Units_Exists ( cp_n_person_id IN NUMBER,
28 cp_c_program_cd IN VARCHAR2,
29 cp_c_cal_type IN VARCHAR2,
30 cp_n_seq_num IN NUMBER ) RETURN BOOLEAN;
31
32 END IGS_EN_DASHBOARD;