PACKAGE: APPS.AR_ADV_BAL_SEL_CURR_PKG

Source

1 PACKAGE AR_ADV_BAL_SEL_CURR_PKG AS
2 -- $Header: ARADVBALPKGS.pls 120.2.12000000.1 2007/10/24 18:52:43 sgudupat noship $
3 --*****************************************************************************
4 -- Copyright (c)  2000    Oracle Solution Services (India)  Product Development
5 -- All rights reserved
6 --*****************************************************************************
7 --
8 --
9 -- PROGRAM NAME
10 --  ARADVBALPKGS.pls
11 --
12 -- DESCRIPTION
13 --   This script creates the package specification of AR_ADV_BAL_SEL_CURR_PKG.
14 --   This package is used by the 'Balance of Advances Received in Selected currency-slovakia' report.
15 --
16 -- USAGE
17 --
18 --   To execute           This can be applied by running this script at SQL*Plus.
19 --
20 --  PROGRAM LIST          DESCRIPTION
21 --
22 --  beforeReportTrigger   It is a public function which is run just after the
23 --                        queries are parsed and before queries are executed.
24 --
25 -- DEPENDENCIES
26 --   None
27 --
28 -- CALLED BY
29 --   DataTemplate Extract in 'Balance of Advances Received in Selected currency-slovakia' report.
30 --
31 -- LAST UPDATE DATE   17-FEB-2007
32 --
33 --
34 -- HISTORY
35 -- =======
36 --
37 -- VERSION DATE               AUTHOR(S)            DESCRIPTION
38 -- ------- ----------- ----------------- ------------------------------------
39 -- Draft1A 17-FEB-2007     Mallikarjun Gupta   Initial version
40 --***************************************************************************
41 
42 -------Parameters in Data Template-------------------
43 
44 P_ACCESS_SET_ID        NUMBER;
45 P_LEDGER_NAME          VARCHAR2(30);
46 P_LEDGER_ID            NUMBER;
47 P_CHART_OF_ACCOUNTS_ID NUMBER;
48 P_COMMITMENT_DATE      VARCHAR2(30);
49 P_AS_OF_DATE           VARCHAR2(30);
50 P_CURRENCY_TYPE        VARCHAR2(30);
51 P_CURRENCY_VALUE       VARCHAR2(30);
52 P_CURRENCY_CODE        VARCHAR2(30);
53 P_ASSGN_ACC_TO         VARCHAR2(30);
54 P_FORMAT               VARCHAR2(30);
55 P_SORT_BY              VARCHAR2(30);
56 P_INCL_TRANS_STMT      VARCHAR2(30);
57 P_CONTROL_SEGMENT      VARCHAR2(30);
58 P_CONTROL_SEGMENT_LOW  VARCHAR2(30);
59 P_CONTROL_SEGMENT_HIGH VARCHAR2(30);
60 P_ACCOUNT_SEGMENT_LOW  VARCHAR2(30);
61 P_ACCOUNT_SEGMENT_HIGH VARCHAR2(30);
62 P_COMMITMENT_LOW       VARCHAR2(30);
63 P_COMMITMENT_HIGH      VARCHAR2(30);
64 P_CUSTOMER_NUMBER_LOW  VARCHAR2(30);
65 P_CUSTOMER_NUMBER_HIGH VARCHAR2(30);
66 
67 ----Global Variables-----
68 
69 gc_ctrl_seg fnd_id_flex_segments.segment_name%TYPE;
70 gc_func_currency  gl_ledgers.currency_code%TYPE;
71 gc_currency_code_where VARCHAR2(300) := ' 1 = 1 ';
72 
73 FUNCTION BEFOREREPORT RETURN BOOLEAN;
74 END AR_ADV_BAL_SEL_CURR_PKG;