DBA Data[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;