[Home] [Help]
PACKAGE: APPS.IGIRCBJP
Source
1 PACKAGE IGIRCBJP AS
2 -- $Header: igircjps.pls 120.3.12000000.2 2007/10/26 13:11:41 sguduru ship $
3 --
4 TYPE ReportParametersType IS RECORD
5 (
6 CallingMode VARCHAR2(15) DEFAULT 'ARC',
7 ReqId NUMBER(15),
8 FuncCurr VARCHAR2(15),
9 ChkBalance VARCHAR2(1),
10 StartPeriod VARCHAR2(40),
11 EndPeriod VARCHAR2(40),
12 GlDateFrom DATE,
13 GlDateTo DATE,
14 SetOfBooksId NUMBER(15),
15 CashSetOfBooksId NUMBER(15),
16 UnallocatedRevCcid NUMBER(15),
17 CreatedBy NUMBER(15),
18 NxtCashReceiptHistoryId ar_cash_receipt_history.cash_receipt_history_id%TYPE := 999999999999999,
19 NxtReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE := 999999999999999,
20 NxtMiscCashDistributionId ar_misc_cash_distributions.misc_cash_distribution_id%TYPE := 999999999999999,
21 NxtAdjustmentId ar_adjustments.adjustment_id%TYPE
22 := 999999999999999,
23 NxtCustTrxLineGlDistId ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE := 999999999999999,
24 Currency VARCHAR2(15),
25 CMApp VARCHAR2(1),
26 Adj VARCHAR2(1),
27 Trade VARCHAR2(1),
28 Misc VARCHAR2(1),
29 CCurr VARCHAR2(1),
30 PostedStatus VARCHAR2(30),
31 PostedDateFrom DATE,
32 PostedDateTo DATE
33 , DetailByAccount VARCHAR2(1)
34 , DetailByCategory VARCHAR2(1)
35 , SummaryByAccount VARCHAR2(1)
36 , SummaryByCategory VARCHAR2(1)
37 , ChartOfAccountsID NUMBER(15)
38 , CompanySegmentFrom VARCHAR2(30)
39 , CompanySegmentTo VARCHAR2(30)
40 , AccountSegmentFrom VARCHAR2(30)
41 , AccountSegmentTo VARCHAR2(30)
42 );
43 --
44 PROCEDURE Report( p_Report IN ReportParametersType );
45 PROCEDURE Report
46 ( errbuf OUT NOCOPY VARCHAR2
47 , retcode OUT NOCOPY NUMBER
48 , p_DetailByAccount VARCHAR2
49 , p_DetailByCategory VARCHAR2
50 , p_SummaryByAccount VARCHAR2
51 , p_SummaryByCategory VARCHAR2
52 , p_SetOfBooksId NUMBER
53 , p_ChartOfAccountsId NUMBER
54 , p_PostedStatus VARCHAR2
55 , p_GlDateFrom VARCHAR2
56 , p_GlDateTo VARCHAR2
57 , p_PostedDateFrom VARCHAR2
58 , p_PostedDateTo VARCHAR2
59 , p_Currency VARCHAR2
60 , p_CMApp VARCHAR2
61 , p_Adj VARCHAR2
62 , p_Trade VARCHAR2
63 , p_Misc VARCHAR2
64 , p_CCurr VARCHAR2
65 , p_CompanySegmentFrom VARCHAR2
66 , p_CompanySegmentTo VARCHAR2
67 , p_AccountSegmentFrom VARCHAR2
68 , p_AccountSegmentTo VARCHAR2
69 , p_DebugFlag VARCHAR2
70 );
71 --
72 END;