1 PACKAGE igs_ge_gen_003 AS
2 /* $Header: IGSGE03S.pls 120.1 2006/01/06 03:59:26 gmaheswa noship $ */
3 --
4 -- Who When What
5 -- knaraset 29-Apr-03 Added parameter p_uoo_id in GENP_INS_TODO_REF, as part of MUS build bug 2829262
6 --
7
8 FUNCTION genp_get_user_person(
9 p_oracle_username IN VARCHAR2 ,
10 p_staff_member_ind OUT NOCOPY VARCHAR2 )
11 RETURN NUMBER ;
12
13 PROCEDURE genp_ins_log(
14 p_s_log_type IN VARCHAR2 ,
15 p_key IN VARCHAR2 ,
16 p_creation_dt OUT NOCOPY DATE ) ;
17
18
19 PROCEDURE genp_ins_log_entry(
20 p_s_log_type IN VARCHAR2 ,
21 p_creation_dt IN DATE ,
22 p_key IN VARCHAR2 ,
23 p_s_message_name IN VARCHAR2,
24 p_text IN VARCHAR2 ) ;
25
26
27 FUNCTION genp_ins_stdnt_todo(
28 p_person_id IN NUMBER ,
29 p_s_student_todo_type IN VARCHAR2 ,
30 p_todo_dt IN DATE ,
31 p_single_entry_ind IN VARCHAR2 DEFAULT 'N')
32 RETURN NUMBER ;
33
34 PROCEDURE genp_set_sle_count(
35 p_s_log_type IN VARCHAR2 ,
36 p_key IN VARCHAR2 ,
37 p_sle_key IN VARCHAR2 ,
38 p_message_name IN VARCHAR2 ,
39 p_count IN NUMBER ,
40 p_creation_dt IN OUT NOCOPY DATE ,
41 p_total_count OUT NOCOPY NUMBER ) ;
42
43 FUNCTION genp_set_time(
44 p_time IN DATE )
45 RETURN DATE ;
46
47 FUNCTION genp_upd_str_lgc_del(
48 p_person_id IN NUMBER ,
49 p_s_student_todo_type IN VARCHAR2 ,
50 p_sequence_number IN NUMBER ,
51 p_reference_number IN NUMBER ,
52 p_message_name OUT NOCOPY VARCHAR2 )
53 RETURN BOOLEAN ;
54
55 PROCEDURE genp_ins_todo_ref(
56 p_person_id IN NUMBER ,
57 p_s_student_todo_type IN VARCHAR2 ,
58 p_sequence_number IN NUMBER ,
59 p_cal_type IN VARCHAR2 ,
60 p_ci_sequence_number IN NUMBER ,
61 p_course_cd IN VARCHAR2 ,
62 p_unit_cd IN VARCHAR2 ,
63 p_other_reference IN VARCHAR2,
64 p_uoo_id IN NUMBER);
65
66
67
68 PROCEDURE set_org_id(p_context IN VARCHAR2 DEFAULT NULL);
69
70 FUNCTION get_org_id RETURN NUMBER;
71
72 /*------------------------------------------------------------------
73 --Created by : knaraset, Oracle IDC
74 --Date created: 14-Nov-2002
75 --
76 --Purpose:Function to get the person ID for the given person number
77 -- returns NULL if no person or more than one person found in the system.
78 --
79 --Known limitations/enhancements and/or remarks:
80 --
81 --Change History:
82 --Who When What
83 --
84 ------------------------------------------------------------------ */
85 FUNCTION get_person_id(
86 p_person_number IN VARCHAR2)
87 RETURN NUMBER;
88
89 /*------------------------------------------------------------------
90 --Created by : knaraset, Oracle IDC
91 --Date created: 14-Nov-2002
92 --
93 --Purpose:Function to get the version number for the given program attempt
94 -- returns NULL if no program attempt found in the system.
95 --
96 --Known limitations/enhancements and/or remarks:
97 --
98 --Change History:
99 --Who When What
100 --
101 ------------------------------------------------------------------ */
102 FUNCTION get_program_version(
103 p_person_id IN NUMBER,
104 p_program_cd IN VARCHAR2)
105 RETURN NUMBER;
106
107 /*------------------------------------------------------------------
108 --Created by : knaraset, Oracle IDC
109 --Date created: 14-Nov-2002
110 --
111 --Purpose:procedure which returns the calendar details of the given caledar alternate code as OUT params.
112 -- returns NULL if no calendar instance found or more than one calendar instance found in the system.
113 --
114 --Known limitations/enhancements and/or remarks:
115 --
116 --Change History:
117 --Who When What
118 --
119 ------------------------------------------------------------------ */
120 PROCEDURE get_calendar_instance(
121 p_alternate_cd IN VARCHAR2,
122 p_s_cal_category IN VARCHAR2 DEFAULT NULL,
123 p_cal_type OUT NOCOPY VARCHAR2,
124 p_ci_sequence_number OUT NOCOPY NUMBER,
125 p_start_dt OUT NOCOPY DATE,
126 p_end_dt OUT NOCOPY DATE,
127 p_return_status OUT NOCOPY VARCHAR2);
128
129 /*------------------------------------------------------------------
130 --Created by : knaraset, Oracle IDC
131 --Date created: 14-Nov-2002
132 --
133 --Purpose: procedure which returns the unit set version number and sequence number of the given unit set attempt.
134 -- returns NULL if no unit set attempt found or more than one unit set attempt found in the system.
135 --
136 --Known limitations/enhancements and/or remarks:
137 --
138 --Change History:
139 --Who When What
140 --
141 ------------------------------------------------------------------ */
142 PROCEDURE get_susa_sequence_num(
143 p_person_id IN NUMBER,
144 p_program_cd IN VARCHAR2,
145 p_unit_set_cd IN VARCHAR2,
146 p_us_version_number OUT NOCOPY NUMBER,
147 p_sequence_number OUT NOCOPY NUMBER);
148
149 FUNCTION disable_oss RETURN VARCHAR2;
150
151 g_oss_disable_exception EXCEPTION;
152
153 END igs_ge_gen_003 ;