[Home] [Help]
PACKAGE: APPS.GCS_AD_TRIALBALANCE_PKG
Source
1 PACKAGE GCS_AD_TRIALBALANCE_PKG AS
2 /* $Header: gcsadtbs.pls 120.2 2006/05/29 06:47:28 vkosuri noship $ */
3 --
4 -- Package
5 -- gcs_ad_trialbalance_pkg
6 -- Purpose
7 -- Package procedures for the AD Trial Balance Program
8 -- History
9 -- 25-OCT-03 Ying Liu Created
10 --
11 --
12 -- Procedure
13 -- Import
14 -- Purpose
15 -- Import trial balances data to GCS_AD_TRIAL_BALANCES table
16 -- Arguments
17 -- p_xns_id ad_transaction_id
18 --
19 -- Bug fix : 5169619 -- data type of p_xns_id(_char) changed to VARCHAR2
20 PROCEDURE import (
21 x_errbuf OUT NOCOPY VARCHAR2,
22 x_retcode OUT NOCOPY VARCHAR2,
23 p_xns_id_char IN VARCHAR2,
24 p_entry_name IN VARCHAR2,
25 p_description IN VARCHAR2,
26 p_consideration_amount IN NUMBER,
27 p_currency_code IN VARCHAR2,
28 p_hierarchy_id IN NUMBER,
29 p_consolidation_entity_id IN NUMBER
30 );
31 --
32 -- Procedure
33 -- Import
34 -- Purpose
35 -- Import AD manual adjustments data
36 -- Arguments
37 -- p_xns_id ad_transaction_id
38 --
39 -- Bug fix : 5169619 -- data type of p_xns_id(_char) changed to VARCHAR2
40 PROCEDURE Import_Entry (
41 x_errbuf OUT NOCOPY VARCHAR2,
42 x_retcode OUT NOCOPY VARCHAR2,
43 p_xns_id_char IN VARCHAR2,
44 p_entry_name IN VARCHAR2,
45 p_description IN VARCHAR2,
46 p_consideration_amount IN NUMBER,
47 p_currency_code IN VARCHAR2,
48 p_hierarchy_id IN NUMBER,
49 p_consolidation_entity_id IN NUMBER,
50 p_operating_entity_id IN NUMBER
51 );
52
53
54 --
55 -- Procedure
56 -- upload_header
57 -- Purpose
58 -- Upload Web ADI AD Trial Balances header data
59 -- Arguments
60 -- p_xns_id ad_transaction_id
61 --
62 -- Bug fix : 5169619 -- data type of p_xns_id(_char) changed to VARCHAR2
63 PROCEDURE upload_header (
64 p_consolidation_entity_id IN NUMBER,
65 p_hierarchy_id IN NUMBER,
66 p_transaction_date IN VARCHAR2,
67 p_currency_code IN VARCHAR2,
68 p_xns_id_char IN VARCHAR2,
69 p_category_code IN VARCHAR2,
70 p_template_type IN VARCHAR2,
71 p_entry_name IN VARCHAR2,
72 p_operating_entity_id IN NUMBER,
73 p_consideration_amount IN NUMBER,
74 p_description IN VARCHAR2 );
75
76 --
77 -- Procedure
78 -- undo_elim_adj
79 -- Purpose
80 -- An API to undo an elimination adjustment
81 -- Arguments
82 -- Notes
83 --
84 PROCEDURE undo_elim_adj (
85 p_xns_id IN NUMBER,
86 x_errbuf OUT NOCOPY VARCHAR2,
87 x_retcode OUT NOCOPY VARCHAR2
88 );
89
90 END gcs_ad_trialbalance_pkg;