1 PACKAGE igs_fi_gen_gl AS
2 /* $Header: IGSFI75S.pls 120.1 2006/05/12 02:00:39 abshriva noship $ */
3
4 /*=======================================================================+
5 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
6 | All rights reserved. |
7 +=======================================================================+
8 | |
9 | DESCRIPTION |
10 | PL/SQL spec for package: IGS_FI_GEN_GL |
11 | |
12 | NOTES |
13 |New Package created for generic |
14 | procedures and functions |
15 | as per GL Interfac TD.
16 | Bug 2584986) |
17 | HISTORY |
18 | Who When What |
19 | abshriva 12-MAY-2006 Added new function get_formatted_amount
20 | to return formatted amount |
21 | agairola 26-Nov-2002 Removed the procedures for Journal |
22 | categories derivation |
23 | SYKRISHN 05-NOV/2002 New Package created for generic |
24 | procedures and functions |
25 | as per GL Interface TD.
26 | The below procedures/functions have been added new
27 PROCEDURE finp_get_cur
28 FUNCTION finp_ss_get_cur
29 FUNCTION check_unposted_txns_exist
30 PROCEDURE get_period_status_for_date
31 FUNCTION check_gl_dt_appl_not_valid
32 FUNCTION check_neg_chgadj_exists
33 FUNCTION get_lkp_meaning
34 *=======================================================================*/
35
36
37 PROCEDURE finp_get_cur (
38 p_v_currency_cd OUT NOCOPY VARCHAR2,
39 p_v_curr_desc OUT NOCOPY VARCHAR2,
40 p_v_message_name OUT NOCOPY VARCHAR2);
41
42
43 FUNCTION finp_ss_get_cur RETURN VARCHAR2;
44
45 FUNCTION check_unposted_txns_exist(p_d_start_date IN DATE,
46 p_d_end_date IN DATE,
47 p_v_accounting_mthd IN VARCHAR2) RETURN BOOLEAN;
48
49
50 PROCEDURE get_period_status_for_date(p_d_date IN DATE,
51 p_v_closing_status OUT NOCOPY VARCHAR2,
52 p_v_message_name OUT NOCOPY VARCHAR2);
53
54
55
56 FUNCTION check_gl_dt_appl_not_valid (p_d_gl_date IN DATE,
57 p_n_invoice_id IN NUMBER,
58 p_n_credit_id IN NUMBER) RETURN BOOLEAN;
59
60
61 FUNCTION check_neg_chgadj_exists (p_n_invoice_id IN NUMBER) RETURN BOOLEAN;
62
63
64 FUNCTION get_lkp_meaning (p_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,
65 p_v_lookup_code IN igs_lookup_values.lookup_code%TYPE ) RETURN VARCHAR2;
66
67 /*Public function to return the formatted value of the input
68 amount based on the currency precision
69 **/
70 FUNCTION get_formatted_amount ( p_n_amount IN NUMBER) RETURN NUMBER;
71
72 END igs_fi_gen_gl;