1 PACKAGE FUN_INITIATOR_WF_PKG AUTHID CURRENT_USER AS
2 /* $Header: funwints.pls 120.3 2004/11/10 06:04:59 panaraya noship $ */
3
4 -- The record type for AR transfer
5
6 TYPE AR_interface_line IS RECORD(
7 AMOUNT NUMBER,
8 BATCH_SOURCE_NAME Varchar2(50), -- <bug 3450031>
9 CONVERSION_TYPE Varchar2(30),
10 CURRENCY_CODE Varchar2(15),
11 CUSTOMER_TRX_TYPE_ID Number, --CUSTOMER_TRX_TYPE_ID
12 DESCRIPTION Varchar2(240),
13 GL_DATE Date,
14 INTERFACE_LINE_ATTRIBUTE1 Varchar2(30),
15 INTERFACE_LINE_ATTRIBUTE2 Varchar2(30),
16 INTERFACE_LINE_ATTRIBUTE3 Varchar2(30),
17 INTERFACE_LINE_CONTEXT Varchar2(30), -- <bug 3450031>
18 LINE_TYPE Varchar2(20) ,
19 MEMO_LINE_ID Number,
20 ORG_ID Number,
21 ORIG_SYSTEM_BILL_ADDRESS_ID Number,
22 ORIG_SYSTEM_BILL_CUSTOMER_ID Number,
23 SET_OF_BOOKS_ID Number,
24 TRX_DATE Date,
25 UOM_NAME Varchar2(25)
26 );
27
28 TYPE AR_interface_Dist_line IS RECORD(
29 ACCOUNT_CLASS RA_CUST_TRX_LINE_GL_DIST_ALL.account_class%TYPE,
30 -- <bug 3450031>
31 AMOUNT NUMBER,
32 percent RA_CUST_TRX_LINE_GL_DIST_ALL.percent%TYPE, -- <bug 3450031>
33 CODE_COMBINATION_ID Number,
34 INTERFACE_LINE_ATTRIBUTE1 Varchar2(30),
35 INTERFACE_LINE_ATTRIBUTE2 Varchar2(30),
36 INTERFACE_LINE_ATTRIBUTE3 Varchar2(30),
37 INTERFACE_LINE_CONTEXT Varchar2(30), -- <bug 3450031>
38 ORG_ID Number
39 );
40
41
42
43 -- Set workflow item attributes for the process
44
45 PROCEDURE SET_ATTRIBUTES (itemtype IN VARCHAR2,
46 itemkey IN VARCHAR2,
47 actid IN NUMBER,
48 funcmode IN VARCHAR2,
49 resultout OUT NOCOPY VARCHAR2);
50
51
52 -- Update transaction Status
53
54 PROCEDURE UPDATE_STATUS (itemtype IN VARCHAR2,
55 itemkey IN VARCHAR2,
56 actid IN NUMBER,
57 funcmode IN VARCHAR2,
58 resultout OUT NOCOPY VARCHAR2);
59
60
61 -- Transfer the transaction to AR interface tables
62
63 PROCEDURE TRANSFER_AR (itemtype IN VARCHAR2,
64 itemkey IN VARCHAR2,
65 actid IN NUMBER,
66 funcmode IN VARCHAR2,
67 resultout OUT NOCOPY VARCHAR2);
68
69
70 -- Check AR setup
71
72 PROCEDURE CHECK_AR_SETUP (itemtype IN VARCHAR2,
73 itemkey IN VARCHAR2,
74 actid IN NUMBER,
75 funcmode IN VARCHAR2,
76 resultout OUT NOCOPY VARCHAR2);
77
78 -- The function that subscribles to AR autoinvoice event:
79 -- oracle.apps.ar.batch.AutoInvoice.run
80
81 FUNCTION GET_INVOICE (p_subscription_guid IN RAW,
82 p_event IN OUT NOCOPY WF_EVENT_T)
83 return Varchar2;
84
85
86 -- This function generate the event key (random)
87
88 FUNCTION GENERATE_KEY (p_batch_id in Number,
89 p_trx_id in NUMBER)
90 return Varchar2;
91
92
93 ---------------------------------------------------------------------------
94 --Start of Comments
95 --Function:
96 -- After transactions are interfaced to AR and invoices have been created,
97 -- FUN_TRX_HEADERS.ar_invoice_number will be updated with the corresonding
98 -- AR_CUSTOMER_TRX_ALL.trx_number
99 --End of Comments
100 ---------------------------------------------------------------------------
101
102 PROCEDURE update_trx_headers(p_request_id IN NUMBER);
103
104
105 ---------------------------------------------------------------------------
106 --Start of Comments
107 --Function:
108 -- After transactions are interfaced to AR and invoices have been created,
109 -- it will get AR invoice number based on autoinvice conc. program
110 -- request_id, and then FUN_TRX_HEADERS.ar_invoice_number will be updated
111 -- with the corresonding AR invoice number
112 --End of Comments
113 ---------------------------------------------------------------------------
114
115 PROCEDURE post_ar_invoice(
116 itemtype IN varchar2,
117 itemkey IN varchar2,
118 actid IN number,
119 funcmode IN varchar2,
120 resultout IN OUT NOCOPY varchar2);
121
122 END FUN_INITIATOR_WF_PKG;
123