1 PACKAGE IGS_ST_GEN_004 AS
2 /* $Header: IGSST04S.pls 120.0 2005/06/01 22:27:15 appldev noship $ */
3 /*------------------------------------------------------------------------------+
4 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA |
5 | All rights reserved. |
6 +==============================================================================+
7 | |
8 | DESCRIPTION |
9 | PL/SQL body for package: IGS_ST_GEN_004 |
10 | |
11 | NOTES |
12 | |
13 | |
14 | HISTORY |
15 | Who When What |
16 | knaraset 15-May-2003 Modified function Stap_Get_Un_Comp_Sts to add
17 | parameter uoo_id,as part of MUS build bug 2829262
18 |
19 | ctyagi 12-Apr-2005 Obsolete Procedure Stas_Ins_Ess for bug 4293239
20 +------------------------------------------------------------------------------*/
21 Function Stap_Get_Supp_Fos(
22 p_course_cd IN VARCHAR2 ,
23 p_version_number IN NUMBER )
24 RETURN VARCHAR2;
25
26 Function Stap_Get_Tot_Exmpt(
27 p_person_id IN NUMBER ,
28 p_course_cd IN VARCHAR2 ,
29 p_version_number IN NUMBER )
30 RETURN NUMBER;
31
32 Function Stap_Get_Un_Comp_Sts(
33 p_person_id IN NUMBER ,
34 p_course_cd IN VARCHAR2 ,
35 p_unit_cd IN VARCHAR2 ,
36 p_sua_cal_type IN VARCHAR2 ,
37 p_sua_ci_sequence_number IN NUMBER,
38 p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE)
39 RETURN NUMBER;
40
41 Function Stap_Ins_Govt_Snpsht(
42 p_submission_yr IN NUMBER ,
43 p_submission_number IN NUMBER ,
44 p_ess_snapshot_dt_time IN DATE ,
45 p_use_most_recent_ess_ind IN VARCHAR2 DEFAULT 'N',
46 p_message_nAmE OUT NOCOPY VARCHAR2,
47 p_log_creation_dt OUT NOCOPY DATE )
48 RETURN BOOLEAN;
49
50 Procedure Stap_Ins_Gsch(
51 p_submission_yr IN NUMBER ,
52 p_submission_number IN NUMBER );
53
54
55 Procedure Stas_Ins_Govt_Snpsht(
56 p_submission_yr IN NUMBER ,
57 p_submission_number IN NUMBER ,
58 p_ess_snapshot_dt_time IN DATE ,
59 p_use_most_recent_ess_ind IN VARCHAR2 DEFAULT 'N',
60 p_log_creation_dt OUT NOCOPY DATE );
61
62 END IGS_ST_GEN_004;