1 PACKAGE igi_exp_utils AS
2 -- $Header: igiexpqs.pls 120.4.12000000.2 2007/09/21 07:10:50 dvjoshi ship $
3 --
4
5 --
6 -- Procedure
7 -- Generate_Number
8 -- Purpose
9 -- Generates DU/TU Order/Legal Numbers
10 -- History
11 -- 27-NOV-2001 L Silveira Initial Version
12 --
13 PROCEDURE Generate_Number(pi_number_type IN VARCHAR2,
14 pi_number_class IN VARCHAR2,
15 pi_du_tu_type_id IN NUMBER,
16 pi_fiscal_year IN NUMBER,
17 po_du_tu_number OUT NOCOPY VARCHAR2,
18 po_error_message OUT NOCOPY VARCHAR2
19 );
20
21 --
22 -- Procedure
23 -- Get Fiscal Year
24 -- Purpose
25 -- Gets the fiscal year corresponding to the passed date
26 -- History
27 -- 03-DEC-2001 L Silveira Initial Version
28 --
29 PROCEDURE Get_Fiscal_Year(pi_gl_date IN DATE,
30 po_fiscal_year OUT NOCOPY NUMBER,
31 po_error_message OUT NOCOPY VARCHAR2
32 );
33
34
35 --
36 -- Procedure
37 -- ValidateGLDate
38 -- Purpose
39 -- Validates whether a date passed existed in the current open period
40 -- If not, checks if the date exists within the last open period
41 -- If not assign date to sysdate
42 -- If p_app_id = 200, checks if encumbrance is on, if so, checks if
43 -- the period year is greater than then encumbrance year. If so,
44 -- set the p_update_gl_date falg to 'N'.
45 -- History
46 -- 11-DEC-2001 A Smales Initial Version
47 --
48 PROCEDURE ValidateGLDate(p_app_id IN VARCHAR2,
49 p_gl_date IN OUT NOCOPY DATE,
50 p_update_gl_date OUT NOCOPY VARCHAR2,
51 p_du_id IN VARCHAR2
52 );
53
54
55 --
56 -- Procedure
57 -- CompleteDU
58 -- Purpose
59 -- Completes the DU passed from EXP Workflow
60 -- History
61 -- 11-DEC-2001 A Smales Initial Version
62 --
63 PROCEDURE Complete_Du (p_du_id IN NUMBER,
64 p_app_id IN NUMBER,
65 p_gl_date IN OUT NOCOPY DATE,
66 p_error_message IN OUT NOCOPY VARCHAR2,
67 p_trx_id OUT NOCOPY NUMBER
68 );
69
70
71
72 END igi_exp_utils;