[Home] [Help]
PACKAGE: APPS.XLA_FSAH_INT_PVT
Source
1 PACKAGE xla_fsah_int_pvt AUTHID CURRENT_USER AS
2 /* $Header: xlafsipvt.pkh 120.6.12010000.1 2009/08/17 14:35:53 vkasina noship $ */
3 /*================================================================================|
4 | FILENAME |
5 | xlafsipvt.pkb |
6 | |
7 | PACKAGE NAME |
8 | xla_fsah_int_pvt |
9 | |
10 | DESCRIPTION |
11 | This is a XLA private package, which contains all the fucntions and |
12 | procedures which required to update and reprocess the successfull and |
13 | non-succesfull transactions |
14 | and tranfermations to people soft General Ledger. |
15 | |
16 | Also API Return The new group_id for the further Successfull Update |
17 | |
18 | |
19 | Note: |
20 | - the APIs do not execute any COMMIT or ROLLBACK. |
21 | |
22 | |
23 | HISTORY |
24 | ------- |
25 | 23-Jun-08 JAGAN KODURI |
26 | |
27 | |
28 | |
29 | PARAMETER DESCRIPTION |
30 | --------------------- |
31 | GET_GROUP_ID |
32 | -------------- |
33 | Return Only The group_id |
34 | |
35 | SET_GROUP_ID |
36 | ------------ |
37 | p_ledger_id :in parameter |
38 | |
39 | SET_TRANSFER_STATUS |
40 | -------------------- |
41 | p_group_id :in parameter (xla_fsah_int_pvt.group_id) |
42 | p_batch_status :in parameter (F/S) |
43 | p_api_version :in parameter (Default API version 1.0) |
44 | p_return_status :out parameter (Use to Return Process Successfull Status) |
45 | p_msg_data :out parameter (Default API out to Error count) |
46 | p_msg_count :out parameter (return New Group Id for New Process Update) |
47 | |
48 +=================================================================================*/
49 FUNCTION get_group_id (
50 p_ledger_short_name IN VARCHAR2,
51 p_appl_short_name IN VARCHAR2,
52 p_end_date IN DATE,
53 p_accounting_batch_id IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
55 p_api_version IN NUMBER DEFAULT 1.0
56 )
57 RETURN NUMBER;
58
59 PROCEDURE set_group_id (
60 p_ledger_short_name IN VARCHAR2,
61 p_appl_short_name IN VARCHAR2,
62 p_end_date IN DATE,
63 p_accounting_batch_id IN NUMBER,
64 p_group_id IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
66 p_api_version IN NUMBER DEFAULT 1.0,
67 p_commit IN BOOLEAN DEFAULT TRUE
68 );
69
70 PROCEDURE set_transfer_status (
71 p_group_id IN NUMBER,
72 p_batch_status IN VARCHAR2,
73 p_api_version IN NUMBER DEFAULT 1.0,
74 p_return_status OUT NOCOPY VARCHAR2,
75 p_err_msg OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE reverse_journal_entries (
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2,
81 p_application_id IN INTEGER,
82 p_event_id IN INTEGER,
83 p_reversal_method IN VARCHAR2,
84 p_gl_date IN DATE,
85 p_post_to_gl_flag IN VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 x_rev_ae_header_id OUT NOCOPY INTEGER,
90 x_rev_event_id OUT NOCOPY INTEGER,
91 x_rev_entity_id OUT NOCOPY INTEGER,
92 x_new_event_id OUT NOCOPY INTEGER,
93 x_new_entity_id OUT NOCOPY INTEGER
94 );
95
96 PROCEDURE rev_jour_entry (
97 p_ae_header_id IN NUMBER,
98 p_return_status OUT NOCOPY VARCHAR2,
99 p_error_msg OUT NOCOPY VARCHAR2
100 );
101
102 PROCEDURE rev_jour_entry_list (
103 p_list_ae_header_id IN FND_TABLE_OF_NUMBER,
104 p_return_status OUT NOCOPY VARCHAR2,
105 p_error_msg OUT NOCOPY VARCHAR2
106 );
107 END xla_fsah_int_pvt;