eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.FUN_REPORT_PVT

Source


1 PACKAGE FUN_REPORT_PVT AUTHID CURRENT_USER AS
2 /*  $Header: FUNVRPTS.pls 120.4 2012/02/15 22:02:10 jmary ship $ */
3 
4 TYPE summaryreport_para_rec_type IS RECORD(
5     batch_type         FND_LOOKUPS.lookup_code%TYPE,
6     initiator_id       FUN_TRX_BATCHES.initiator_id%TYPE,
7     recipient_id       FUN_TRX_HEADERS.recipient_id%TYPE,
8     batch_number_from  FUN_TRX_BATCHES.batch_number%TYPE,
9     batch_number_to    FUN_TRX_BATCHES.batch_number%TYPE,
10     gl_date_from       VARCHAR2(30),
11     gl_date_to         VARCHAR2(30),
12     batch_date_from    VARCHAR2(30),
13     batch_date_to      VARCHAR2(30),
14     batch_status       FUN_TRX_BATCHES.status%TYPE,
15     transaction_status FUN_TRX_HEADERS.status%TYPE,
16     trx_type_id        FUN_TRX_BATCHES.trx_type_id%TYPE,
17     currency_code      FUN_TRX_BATCHES.currency_code%TYPE,
18     invoice_flag       FUN_TRX_HEADERS.invoice_flag%TYPE,
19     ar_invoice_number  FUN_TRX_HEADERS.ar_invoice_number%TYPE
20 );
21 
22 
23 TYPE accountreport_para_rec_type IS RECORD(
24      initiator_from   HZ_PARTIES.PARTY_NAME%TYPE,
25      initiator_to     HZ_PARTIES.PARTY_NAME%TYPE,
26      transact_le      hz_parties.party_name%type,
27      transact_ledger    gl_ledgers.ledger_id%type,
28      recipient_from     hz_parties.party_name%type,
29      recipient_to       hz_parties.party_name%type,
30      trading_le         hz_parties.party_name%type,
31      trading_ledger     gl_ledgers.ledger_id%type,
32      gl_date_from       VARCHAR2(30),
33      gl_date_to         VARCHAR2(30),
34      batch_type         FND_LOOKUPS.lookup_code%TYPE,
35      batch_number_from  FUN_TRX_BATCHES.batch_number%TYPE,
36      batch_number_to    FUN_TRX_BATCHES.batch_number%TYPE,
37      batch_status       FUN_TRX_BATCHES.status%TYPE,
38      transaction_status FUN_TRX_HEADERS.status%TYPE,
39      trx_type_id        FUN_TRX_BATCHES.trx_type_id%TYPE,
40      currency_code      FUN_TRX_BATCHES.currency_code%TYPE,
41      account_type       FND_LOOKUPS.lookup_code%TYPE,
42      rec_account_from   varchar2(100),
43      rec_account_to     varchar2(100),
44      pay_account_from   varchar2(100),
45      pay_account_to     varchar2(100),
46      init_dist_acc_from varchar2(100),
47      init_dist_acc_to   varchar2(100),
48      rec_dist_acc_from  varchar2(100),
49      rec_dist_acc_to    varchar2(100),
50      coa_initiator      gl_ledgers.chart_of_accounts_id%TYPE,
51      coa_recipient      gl_ledgers.chart_of_accounts_id%TYPE,
52      ar_invoice_number  FUN_TRX_HEADERS.ar_invoice_number%TYPE
53 );
54 
55 
56 PROCEDURE build_summary_outquery(
57     x_return_status    OUT NOCOPY VARCHAR2,
58     p_para_rec         IN FUN_REPORT_PVT.summaryreport_para_rec_type,
59     x_outbound_query   OUT NOCOPY VARCHAR2
60 );
61 
62 PROCEDURE build_summary_inquery(
63     x_return_status    OUT NOCOPY VARCHAR2,
64     p_para_rec         IN FUN_REPORT_PVT.summaryreport_para_rec_type,
65     x_inbound_query    OUT NOCOPY VARCHAR2
66 );
67 
68 PROCEDURE build_account_outquery(
69    x_return_status  OUT NOCOPY VARCHAR2,
70    p_para_rec       IN  FUN_REPORT_PVT.accountreport_para_rec_type,
71    x_outbound_query OUT NOCOPY VARCHAR2
72 );
73 PROCEDURE build_account_inquery(
74     x_return_status    OUT NOCOPY VARCHAR2,
75     p_para_rec         IN FUN_REPORT_PVT.accountreport_para_rec_type,
76     x_inbound_query    OUT NOCOPY VARCHAR2
77 );
78 
79 
80 
81 PROCEDURE get_xml(
82     x_return_status OUT NOCOPY VARCHAR2,
83     p_query         IN VARCHAR2,
84     p_rowset_tag    IN VARCHAR2 DEFAULT NULL,
85     p_row_tag       IN VARCHAR2 DEFAULT NULL,
86     x_xml           OUT NOCOPY CLOB
87 );
88 
89 PROCEDURE construct_output(
90     x_return_status OUT NOCOPY VARCHAR2,
91     p_para_rec      IN FUN_REPORT_PVT.summaryreport_para_rec_type,
92     p_outbound_trxs IN CLOB,
93     p_inbound_trxs  IN CLOB
94 );
95 PROCEDURE construct_account_output(
96    x_return_status  OUT NOCOPY VARCHAR2,
97    p_para_rec       IN  FUN_REPORT_PVT.accountreport_para_rec_type,
98    p_trxs   IN CLOB
99 );
100 
101 PROCEDURE save_xml(
102     x_return_status OUT NOCOPY VARCHAR2,
103     p_trxs          IN CLOB,
104     p_offset        IN INTEGER DEFAULT 1
105 );
106 
107 PROCEDURE create_summaryreport(
108     errbuf               OUT NOCOPY VARCHAR2,
109     retcode              OUT NOCOPY NUMBER,
110     p_batch_type         IN VARCHAR2,
111     p_initiator_id       IN NUMBER DEFAULT NULL,
112     p_recipient_id       IN NUMBER DEFAULT NULL,
113     p_batch_number_from  IN VARCHAR2 DEFAULT NULL,
114     p_batch_number_to    IN VARCHAR2 DEFAULT NULL,
115     p_gl_date_from       IN VARCHAR2 DEFAULT NULL,
116     p_gl_date_to         IN VARCHAR2 DEFAULT NULL,
117     p_batch_date_from    IN VARCHAR2 DEFAULT NULL,
118     p_batch_date_to      IN VARCHAR2 DEFAULT NULL,
119     p_batch_status       IN VARCHAR2 DEFAULT NULL,
120     p_transaction_status IN VARCHAR2 DEFAULT NULL,
121     p_trx_type_id        IN NUMBER DEFAULT NULL,
122     p_currency_code      IN VARCHAR2 DEFAULT NULL,
123     p_invoice_flag       IN VARCHAR2 DEFAULT NULL,
124     p_ar_invoice_number  IN VARCHAR2 DEFAULT NULL
125 );
126 
127 
128 PROCEDURE create_accountreport(
129     errbuf               OUT NOCOPY VARCHAR2,
130     retcode              OUT NOCOPY NUMBER,
131     p_initiator_from     IN VARCHAR2 DEFAULT NULL,
132     p_initiator_to       IN VARCHAR2 DEFAULT NULL,
133     p_transact_le        IN VARCHAR2 DEFAULT NULL,
134     p_transact_ledger_id          IN NUMBER   DEFAULT NULL,
135     p_recipient_from     IN VARCHAR2 DEFAULT NULL,
136     p_recipient_to       IN VARCHAR2 DEFAULT NULL,
137     p_trading_le         IN VARCHAR2 DEFAULT NULL,
138     p_trading_ledger_id  IN NUMBER   DEFAULT NULL,
139     p_gl_date_from       IN VARCHAR2 DEFAULT NULL,
140     p_gl_date_to         IN VARCHAR2 DEFAULT NULL,
141     p_batch_type         IN VARCHAR2,
142     p_batch_number_from  IN VARCHAR2 DEFAULT NULL,
143     p_batch_number_to    IN VARCHAR2 DEFAULT NULL,
144     p_batch_status       IN VARCHAR2 DEFAULT NULL,
145     p_transaction_status IN VARCHAR2 DEFAULT NULL,
146     p_trx_type_id        IN NUMBER DEFAULT NULL,
147     p_currency_code      IN VARCHAR2 DEFAULT NULL,
148     p_acc_type           IN VARCHAR2 DEFAULT NULL,
149     p_coa_initiator      IN NUMBER DEFAULT NULL,
150     p_coa_recipient      IN NUMBER DEFAULT NULL,
151     p_ar_invoice_number  IN VARCHAR2 DEFAULT NULL,
152     p_rec_account_from   IN VARCHAR2 DEFAULT NULL,
153     p_rec_account_to     IN VARCHAR2 DEFAULT NULL,
154     p_pay_account_from   IN VARCHAR2 DEFAULT NULL,
155     p_pay_account_to     IN VARCHAR2 DEFAULT NULL,
156     p_init_d_account_from IN VARCHAR2 DEFAULT NULL,
157     p_init_d_account_to  IN VARCHAR2 DEFAULT NULL,
158     p_recip_d_account_from IN VARCHAR2 DEFAULT NULL,
159     p_recip_d_account_to  IN VARCHAR2 DEFAULT NULL
160 );
161 
162 
163 
164 
165 END FUN_REPORT_PVT;
166