[Home] [Help]
PACKAGE: APPS.GL_SRS_INCREMENTOR_API
Source
1 PACKAGE GL_SRS_INCREMENTOR_API AUTHID CURRENT_USER AS
2 /* $Header: gluschps.pls 120.7 2005/05/05 01:43:38 kvora ship $ */
3
4 -- Public Variables
5 error_buffer VARCHAR2(500);
6
7
8 ------------------------------------------------------
9 -- Functions processing increment : made public for debugging
10 ------------------------------------------------------
11
12 -- Purpose: Increment Journal date by business days offset method
13 -- then find corresponding period.
14 -- This method is used for ADB ledgeres.
15 FUNCTION increment_bus_date(
16 x_ledger_id NUMBER,
17 x_last_anchor_date DATE,
18 x_last_para_date DATE,
19 x_new_anchor_date DATE,
20 x_new_para_date IN OUT NOCOPY DATE,
21 x_new_para_period IN OUT NOCOPY VARCHAR2)
22 RETURN NUMBER;
23
24
25 -- Purpose: Increment Period using journals days offset method
26 -- This method is used for Non-ADB and ADB consolidation
27 -- ledgers.
28 FUNCTION inc_period_by_days_offset(
29 x_ledger_id NUMBER,
30 x_start_date_last_run DATE,
31 x_period_last_run VARCHAR2,
32 x_start_date_this_run DATE,
33 x_period_this_run IN OUT NOCOPY VARCHAR2)
34 RETURN NUMBER;
35
36
37 ------------------------------------------------------
38 -- Function that handles specific ledger
39 ------------------------------------------------------
40 -- Purpose: Handles Period Increment for Standard (Non-ADB) ledger
41 PROCEDURE increment_period(
42 x_ledger_id NUMBER,
43 x_period_para VARCHAR2);
44
45
46 -- Purpose: Handles GL Date and Period Increment for Standard ADB ledger
47 PROCEDURE increment_adb(
48 x_ledger_id NUMBER,
49 x_period_para VARCHAR2,
50 x_je_date_para VARCHAR2,
51 x_calc_date_para VARCHAR2,
52 x_date_format VARCHAR2);
53
54
55 ------------------------------------------------------
56 -- Function to be called by SRS
57 ------------------------------------------------------
58 -- PROCEDURE increment_period;
59
60 PROCEDURE increment_parameters;
61
62 PROCEDURE increment_date(
63 x_date_para VARCHAR2,
64 x_period_flag VARCHAR2,
65 x_period_para VARCHAR2,
66 x_ledger_id NUMBER);
67
68
69 -- Purpose: Get a random ledger from a batch or an allocation set
70 -- that contains no ADB or consolidation ledgers
71
72 FUNCTION get_random_ledger(
73 x_batch_type VARCHAR2,
74 x_ledger_id NUMBER,
75 x_batch_id NUMBER) RETURN NUMBER;
76
77
78 END gl_srs_incrementor_api;