[Home] [Help]
PACKAGE: APPS.XTR_JOURNAL_PROCESS_P
Source
1 PACKAGE XTR_JOURNAL_PROCESS_P AUTHID CURRENT_USER as
2 /* $Header: xtrjrnls.pls 120.7 2006/07/14 06:35:44 eaggarwa ship $ */
3 ----------------------------------------------------------------------------------------------------------------
4
5 --
6 -- GLOBAL VARIABLES
7 --
8
9 -- CONTEXT: XTR_JOURNAL_PROCESS_P.Do_Journal_Process
10 -- Run-Time Parameters
11 --
12 G_company_code XTR_PARTY_INFO.party_code%TYPE;
13 --G_cutoff_date XTR_DEAL_DATE_AMOUNTS.amount_date%TYPE;
14 G_batch_id XTR_BATCHES.batch_id%TYPE;
15 G_period_end XTR_DEAL_DATE_AMOUNTS.amount_date%TYPE;
16 G_set_of_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
17 G_suspense_ccid XTR_GL_REFERENCES.code_combination_id%TYPE;
18
19 -- CONTEXT: XTR_JOUNRAL_PROCESS_P.Update_Journals
20
21 G_user VARCHAR2(30);
22
23 FUNCTION GET_CLOSED_PERIOD_PARAM
24 (in_company IN VARCHAR2) RETURN VARCHAR2;
25
26
27 PROCEDURE DO_JOURNAL_PROCESS
28 (errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY NUMBER,
30 p_source_option IN VARCHAR2,
31 p_company_code IN VARCHAR2,
32 p_batch_id_from IN NUMBER,
33 p_batch_id_to IN NUMBER,
34 p_cutoff_date IN DATE);
35
36 FUNCTION GEN_JOURNALS
37 (in_source_option IN VARCHAR2,
38 in_company IN VARCHAR2,
39 in_batch_id IN NUMBER,
40 in_period_end IN DATE,
41 in_upgrade_batch IN VARCHAR2) RETURN NUMBER; -- 1336492. Chg ret type to accomodate warnings.
42
43 PROCEDURE UPDATE_JOURNALS(l_deal_nos IN NUMBER,
44 l_trans_nos IN NUMBER,
45 l_deal_type IN VARCHAR2);
46
47 -- Procedure journals was added for bug 2404342 - Flex Journals.
48
49 PROCEDURE JOURNALS
50 (errbuf OUT NOCOPY VARCHAR2,
51 retcode OUT NOCOPY NUMBER,
52 p_source_option IN VARCHAR2,
53 p_company_code IN VARCHAR2,
54 p_batch_id_from IN NUMBER,
55 p_batch_id_to IN NUMBER,
56 p_cutoff_date IN VARCHAR2,
57 p_dummy_date IN VARCHAR2,
58 p_processing_option IN VARCHAR2,
59 p_dummy_proc_opt IN VARCHAR2,
60 p_closed_periods IN VARCHAR2,
61 p_incl_transferred IN VARCHAR2);
62
63 -- Bug 4504734 Removed procedure get_next_open_start_date
64 -- Added the new override procedure for Bug 4639287
65 PROCEDURE JOURNALS
66 (errbuf OUT NOCOPY VARCHAR2,
67 retcode OUT NOCOPY NUMBER,
68 p_source_option IN VARCHAR2,
69 p_company_code IN VARCHAR2,
70 p_batch_id_from IN NUMBER,
71 p_batch_id_to IN NUMBER,
72 p_cutoff_date IN VARCHAR2,
73 p_dummy_date IN VARCHAR2,
74 p_processing_option IN VARCHAR2,
75 p_dummy_proc_opt IN VARCHAR2,
76 p_closed_periods IN VARCHAR2,
77 p_incl_transferred IN VARCHAR2,
78 p_multiple_acct IN VARCHAR2 ); -- Added this parameter Bug 4639287
79
80 G_gen_journal_retcode NUMBER := 0; --bug 2804548
81 ----------------------------------------------------------------------------------------------------------------
82 end XTR_JOURNAL_PROCESS_P;