DBA Data[Home] [Help]

PACKAGE: APPS.GL_ADI_ACCT_TYPE_CONV_PKG

Source


1 PACKAGE GL_ADI_ACCT_TYPE_CONV_PKG AUTHID CURRENT_USER as
2 /* $Header: gluadics.pls 120.5 2005/05/05 01:34:50 kvora ship $ */
3 
4   ---
5   --- PUBLIC FUNCTIONS
6   ---
7 
8   --
9   -- Procedure
10   --   get_accounted_amount
11   -- Purpose
12   --   Get accounted amount after applying account type specific conversion.
13   --   This program assumes that currencies with an EMU fixed rate will not
14   --   be passed as parameters. ADI will call a different API in that case.
15   --   The accounted amount is returned with the correct precision and mau.
16   -- History
17   --   19-APR-2000      K Vora        Created
18   -- Arguments
19   --   p_ledger_id                   Ledger Id
20   --   p_reporting_ledger_id         Preferred Reporting Ledger Id
21   --   p_functional_currency         Functional Currency
22   --   p_journal_currency            Entered Currency
23   --   p_conversion_type             Currency Conversion Type (Optional)
24   --   p_bs_conversion_type          Balance Sheet or User Conversion Type
25   --   p_is_conversion_type          Income Statement Account Conversion Type
26   --   p_conversion_date             Currency Conversion Date
27   --   p_conversion_rate             Currency Conversion Rate (Optional)
28   --   p_source_name                 Journal Source
29   --   p_category_name               Journal Category
30   --   p_max_roll_days               Rollback Days from Profile Option
31   --   p_code_combination_id         Code Combination Id
32   --   p_entered_amount              Entered Amount
33   --   p_accounted_amount            Returns - Accounted Amount
34   --   p_error_msg                   Returns - Error Message, 240 chars max
35   --
36   -- Example
37   --   gl_adi_acct_type_conv_pkg.get_accounted_amount(101, 102, 'USD', 'ITL',
38   --      NULL, '1205', '1204', to_date('31-MAR-1999', 'DD-MON-YYYY'),
39   --      NULL, 'Payables', 'Other', 31, 34567, 100.00, NULL, NULL),
40 
41   PROCEDURE get_accounted_amount(
42     p_ledger_id                  NUMBER,
43     p_reporting_ledger_id        NUMBER,
44     p_functional_currency        VARCHAR2,
45     p_journal_currency           VARCHAR2,
46     p_conversion_type            VARCHAR2,
47     p_bs_conversion_type         VARCHAR2,
48     p_is_conversion_type         VARCHAR2,
49     p_conversion_date            DATE,
50     p_conversion_rate            NUMBER,
51     p_source_name                VARCHAR2,
52     p_category_name              VARCHAR2,
53     p_max_roll_days              NUMBER,
54     p_code_combination_id        NUMBER,
55     p_entered_amount             NUMBER,
56     p_accounted_amount           OUT NOCOPY NUMBER,
57     p_error_msg                  OUT NOCOPY VARCHAR2);
58 
59 END GL_ADI_ACCT_TYPE_CONV_PKG;