1 PACKAGE FUN_PERIOD_STATUS_PKG AUTHID CURRENT_USER AS
2 /* $Header: funprdstss.pls 120.10 2012/04/17 08:15:32 srampure ship $ */
3
4 /***********************************************
5 * Procedure Close_Period :
6 * This Procedure Closes specified Intercompany Period or *
7 * all the periods. It checks whether there are any Open Intercompany Transactions.*
8 * If Yes, then user can sweep the transactions to next open period before closing *
9 * the Period. *
10 ***************************************************/
11 PROCEDURE Close_Period
12 (
13 p_api_version IN NUMBER,
14 p_init_msg_list IN VARCHAR2 default null,
15 p_commit IN VARCHAR2 default null,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_message_count OUT NOCOPY NUMBER,
18 x_message_data OUT NOCOPY VARCHAR2,
19 p_period_name IN VARCHAR2,
20 p_trx_type_id IN NUMBER,
21 p_sweep IN VARCHAR2,
22 p_sweep_GL_date IN DATE,
23 x_request_id OUT NOCOPY NUMBER
24 );
25
26
27 /***********************************************
28 * Procedure Get_Period_Status :
29 * This API Checks whether Application Module (AP, AR, GL) can close their *
30 * periods. It checks whether Intercompany Period is closed and if yes then whether *
31 * any Open Transactions exists for the given Period. *
32 * *
33 ***************************************************/
34 PROCEDURE Get_Period_Status
35 (
36 p_api_version IN NUMBER,
37 p_application_id IN NUMBER,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_message_count OUT NOCOPY NUMBER,
40 x_message_data OUT NOCOPY VARCHAR2,
41 p_period_set_name IN VARCHAR2,
42 p_period_type IN VARCHAR2,
43 p_period_name IN VARCHAR2,
44 p_ledger_id IN NUMBER,
45 p_org_id IN NUMBER,
46 x_close OUT NOCOPY VARCHAR2
47 );
48
49 /**********************************************
50 * Procedure sweep_partial_batches
51 * Bug : 6892783
52 * This API Sweeps Partially complete Batches to given period
53 *
54 ************************************************/
55
56 PROCEDURE sweep_partial_batches
57 (
58 p_errbuff OUT NOCOPY VARCHAR2,
59 p_period_name IN VARCHAR2,
60 p_trx_type_id IN NUMBER,
61 p_sweep_GL_date IN DATE
62 );
63
64 /***********************************************
65 * Procedure Sweep_Transactions :
66 * This API sweeps transactions from the given period to specified next *
67 * open period. *
68 * *
69 ***************************************************/
70
71
72 PROCEDURE sweep_transactions
73 (
74 p_errbuff OUT NOCOPY VARCHAR2,
75 p_retcode OUT NOCOPY NUMBER,
76 p_api_version IN VARCHAR2,
77 p_period_name IN VARCHAR2,
78 p_trx_type_id IN NUMBER,
79 p_sweep_GL_date IN DATE,
80 p_debug IN VARCHAR2 default null,
81 p_close IN VARCHAR2 default null
82 );
83
84 /***********************************************
85 * Procedure Sync_calendars :
86 * This API sychronises the GL Calendar withthat of the Intercompany *
87 * Calendar . *
88 * *
89 ***************************************************/
90 procedure sync_calendars ;
91
92 /***********************************************
93 * Function get_fun_prd_status :
94 * This API accepts date and trx type and returns status in Intercompany *
95 * *
96 ***************************************************/
97 FUNCTION get_fun_prd_status(p_date Date, p_trx_type_id number)
98 RETURN VARCHAR2;
99
100
101 END FUN_PERIOD_STATUS_PKG;