[Home] [Help]
PACKAGE: APPS.AR_UNACCOUNTED_TRX_SWEEP
Source
1 PACKAGE AR_UNACCOUNTED_TRX_SWEEP AUTHID CURRENT_USER AS
2 /* $Header: ARUNACCTS.pls 120.1.12020000.3 2013/01/17 09:30:54 kkikkise noship $ */
3
4 /*------------------------------------------------------------------------------------------------------------------------*/
5 -- CONSTANTS
6 /*------------------------------------------------------------------------------------------------------------------------*/
7 G_SRC_TYP_UNACCT_TRX constant varchar2 (30) := 'UNACCT_TRX';
8 G_SRC_TYP_UNACCT_RCT constant varchar2 (30) := 'UNACCT_RCT';
9 G_SRC_TYP_UNACCT_ADJ constant varchar2 (30) := 'UNACCT_ADJ';
10 G_SRC_TYP_UNACCT_BR constant varchar2 (30) := 'UNACCT_BR';
11 G_SRC_TYP_OTHER_EXCPS constant varchar2 (30) := 'OTHER_EXCEPTIONS';
12
13 G_AR_APPLICATION_ID constant number := 222;
14
15 /*------------------------------------------------------------------------------------------------------------------------*/
16 -- GLOBAL DECLARATION
17 /*------------------------------------------------------------------------------------------------------------------------*/
18
19 g_ledger_id ar_system_parameters_all.set_of_books_id%type;
20 g_org_id ar_system_parameters_all.org_id%type;
21 g_period_name gl_periods.period_name%type;
22 g_period_start_date gl_period_statuses.start_date%type;
23 g_period_end_date gl_period_statuses.end_date%type;
24 g_sweep_period_name gl_periods.period_name%type;
25 g_sweep_to_date gl_periods.start_date%type;
26 g_sweep_now varchar2 (1);
27 g_reporting_level number;
28 g_reporting_entity_id number (15);
29
30 g_ledger_name gl_sets_of_books.name%type;
31 g_cash_basis_flag gl_sets_of_books.sla_ledger_cash_basis_flag%type;
32
33 g_fetch_limit number := 1000; -- per Perf Team, this is std limit size.
34
35 g_orphan_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE := NULL;
36
37
38 P_REPORTING_LEVEL number;
39 P_REPORTING_ENTITY_ID number (15);
40 P_LEDGER_ID number (15);
41 P_PERIOD_NAME varchar2(15);
42 P_SWEEP_TO_PERIOD varchar2(15);
43 P_SWEEP_NOW varchar2(1);
44 P_DEBUG varchar2(1);
45
46
47 /*------------------------------------------------------------------------------------------------------------------------*/
48 -- GLOBAL FUNCTIONS/PROCEDURES
49 /*------------------------------------------------------------------------------------------------------------------------*/
50
51 --
52 -- process_period
53 -- the main procedure to process period closing activity.
54 -- overall flow is as below:
55 -- 1. populate global variables to hold parameter values
56 -- 2. populate the global temp table
57 -- 3. based on p_sweep_now either SWEEP or provide report output
58 --
59
60 PROCEDURE process_period(
61 p_reporting_level IN NUMBER,
62 p_reporting_entity_id IN NUMBER,
63 p_period_name IN VARCHAR2,
64 p_sweep_period_name IN VARCHAR2,
65 p_sweep_now IN VARCHAR2,
66 p_process_flag out nocopy varchar2,
67 p_process_message out nocopy varchar2
68 );
69
70
71 --
72 -- before report trigger for XMLP reports. XMLP concurrent program will invoke
73 -- this method before executing the report queries in that particular data template
74 --
75 FUNCTION before_report_artrxswp RETURN BOOLEAN;
76 FUNCTION get_acct_start_date RETURN varchar2;
77 FUNCTION get_acct_end_date RETURN varchar2;
78 FUNCTION get_ledger_name RETURN varchar2;
79
80
81 END AR_UNACCOUNTED_TRX_SWEEP;
82