PACKAGE: APPS.ARP_CASH_BASIS_JE_REPORT

Source

1 PACKAGE arp_cash_basis_je_report AUTHID CURRENT_USER AS
2 /* $Header: ARPLCBJS.pls 120.2 2005/10/30 04:24:20 appldev ship $ */
3 
4 
5     TYPE ReportParametersType IS RECORD
6     (
7         ReqId                     NUMBER(15),
8         ChkBalance                VARCHAR2(1),
9         GlDateFrom                DATE,
10         GlDateTo                  DATE,
11         SetOfBooksId              NUMBER(15),
12         UnallocatedRevCcid        NUMBER(15),
13         CreatedBy                 NUMBER(15),
14         NxtCashReceiptHistoryId     ar_cash_receipt_history.cash_receipt_history_id%TYPE        := 999999999999999,
15         NxtReceivableApplicationId  ar_receivable_applications.receivable_application_id%TYPE   := 999999999999999,
16         NxtMiscCashDistributionId   ar_misc_cash_distributions.misc_cash_distribution_id%TYPE   := 999999999999999,
17         NxtAdjustmentId             ar_adjustments.adjustment_id%TYPE                           := 999999999999999,
18         NxtCustTrxLineGlDistId      ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE      := 999999999999999,
19 	Currency		VARCHAR2(15),
20 	Inv			VARCHAR2(1),
21 	DM			VARCHAR2(1),
22 	CB			VARCHAR2(1),
23 	CM			VARCHAR2(1),
24 	CMApp			VARCHAR2(1),
25 	Adj			VARCHAR2(1),
26 	Trade			VARCHAR2(1),
27 	Misc			VARCHAR2(1),
28         Ccurr                   VARCHAR2(1),
29 	PostedStatus		VARCHAR2(30),
30 	PostedDateFrom		DATE,
31 	PostedDateTo		DATE
32     );
33 --
34     PROCEDURE Report( p_Report IN ReportParametersType );
35     PROCEDURE Report( p_ReqId                   NUMBER,
36                     p_ChkBalance                VARCHAR2,
37                     p_GlDateFrom                DATE,
38                     p_GlDateTo                  DATE,
39                     p_SetOfBooksId              NUMBER,
40 		    p_UnallocatedRevCcid	NUMBER,
41                     p_CreatedBy                 NUMBER,
42                     p_NxtCashReceiptHistoryId     NUMBER,
43                     p_NxtReceivableApplicationId  NUMBER,
44                     p_NxtMiscCashDistributionId   NUMBER,
45                     p_NxtAdjustmentId             NUMBER,
46                     p_NxtCustTrxLineGlDistId      NUMBER,
47 		    p_Currency			VARCHAR2,
48 		    p_Inv			VARCHAR2,
49 		    p_DM			VARCHAR2,
50 		    p_CB			VARCHAR2,
51 		    p_CM			VARCHAR2,
52 		    p_CMApp			VARCHAR2,
53 		    p_Adj			VARCHAR2,
54 		    p_Trade			VARCHAR2,
55 		    p_Misc			VARCHAR2,
56                     p_Ccurr                     VARCHAR2,
57 		    p_PostedStatus		VARCHAR2,
58 		    p_PostedDateFrom		DATE,
59 		    p_PostedDateTo		DATE );
60 --
61 END;