[Home] [Help]
PACKAGE: APPS.ARP_XLA_EVENTS
Source
1 PACKAGE ARP_XLA_EVENTS AUTHID CURRENT_USER AS
2 /* $Header: ARXLAEVS.pls 120.9.12010000.4 2009/01/28 15:40:58 ankausha ship $ */
3
4 Test_flag VARCHAR2(1) := 'N';
5
6 TYPE xla_events_type IS RECORD (
7 xla_from_doc_id NUMBER , --document id from
8 xla_to_doc_id NUMBER , --document id to
9 xla_req_id NUMBER , --request id batch processing
10 xla_dist_id NUMBER , --distribution id
11 xla_doc_table VARCHAR2(10) , --document table OLTP
12 xla_doc_event VARCHAR2(30) , --document business event OLTP
13 xla_mode VARCHAR2(1) , --upgrade, Oltp, Batch mode
14 xla_call VARCHAR2(1) , --call Create, Denormalize, Both
15 xla_fetch_size NUMBER --bulk fetch size
16 );
17
18 TYPE ev_rec_type IS RECORD (
19 trx_status DBMS_SQL.VARCHAR2_TABLE ,
20 trx_number DBMS_SQL.VARCHAR2_TABLE ,
21 trx_id DBMS_SQL.NUMBER_TABLE ,
22 pstid DBMS_SQL.NUMBER_TABLE ,
23 org_id DBMS_SQL.NUMBER_TABLE ,
24 dist_id DBMS_SQL.NUMBER_TABLE ,
25 dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26 dist_event_id DBMS_SQL.NUMBER_TABLE ,
27 dist_gl_date DBMS_SQL.DATE_TABLE ,
28 override_event DBMS_SQL.VARCHAR2_TABLE ,
29 trx_type DBMS_SQL.VARCHAR2_TABLE ,
30 posttogl DBMS_SQL.VARCHAR2_TABLE ,
31 ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32 ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33 ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34 ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35 ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36 ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37 ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38 ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39 ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40 dist_dml_flag DBMS_SQL.VARCHAR2_TABLE
41 --{HYU Add transaction_date and legal_entity_id
42 ,transaction_date DBMS_SQL.DATE_TABLE
43 ,legal_entity_id DBMS_SQL.NUMBER_TABLE
44 --}
45 );
46
47 /*========================================================================
48 | PUBLIC PROCEDURE Create_Events
49 |
50 | DESCRIPTION
51 | Main routine which forks processing based on input parameters
52 | and creates events for a given Document.
53 |
54 | This procedure does the following calls the create events routine
55 | for :
56 | a) Transactions
57 | b) Bills Receivable
58 | c) Receipts
59 | d) Adjustments
60 | e) Receipt/CM applications
61 |
62 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
63 |
64 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
65 | a) Create_Transaction_event
66 | b) Create_Receipt_Event
67 | c) Create_Adjustment_Event
68 | d) Create_Application_Event
69 |
70 | PARAMETERS p_ev_rec which contains
71 | 1) xla_doc_id IN NUMBER --document id OLTP
72 | 2) xla_req_id IN NUMBER --request id batch processing
73 | 3) xla_dist_id IN NUMBER --distribution id
74 | 3) xla_doc_table IN VARCHAR2 --document table OLTP
75 | 4) xla_doc_event IN VARCHAR2 --document business event OLTP
76 | 5) xla_mode IN VARCHAR2 --Upgrade, Oltp, Batch mode
77 |
78 | KNOWN ISSUES
79 |
80 | NOTES
81 |
82 | MODIFICATION HISTORY
83 | Date Author Description of Changes
84 | 13-JAN-2003 Herve Yu Add delete_event
85 *=======================================================================*/
86 PROCEDURE Create_Events(p_xla_ev_rec IN OUT NOCOPY xla_events_type );
87
88 PROCEDURE Create_Events_Req( p_request_id IN NUMBER,
89 p_doc_table IN VARCHAR2,
90 p_mode IN VARCHAR2,
91 p_call IN VARCHAR2);
92
93 PROCEDURE Create_Events_Doc( p_document_id IN NUMBER,
94 p_doc_table IN VARCHAR2,
95 p_mode IN VARCHAR2,
96 p_call IN VARCHAR2);
97
98 PROCEDURE delete_event( p_document_id IN NUMBER,
99 p_doc_table IN VARCHAR2);
100
101 --6870437
102 PROCEDURE delete_reverse_revrec_event( p_document_id IN NUMBER,
103 p_doc_table IN VARCHAR2);
104
105 PROCEDURE ar_xla_period_close (p_application_id NUMBER DEFAULT 222,
106 p_ledger_id NUMBER,
107 p_period_name VARCHAR2,
108 p_cannot_close_period OUT NOCOPY BOOLEAN ,
109 p_incomplete_events OUT NOCOPY BOOLEAN );
110
111 END ARP_XLA_EVENTS;