DBA Data[Home] [Help]

PACKAGE: APPS.IGIRCBAP

Source


1 PACKAGE IGIRCBAP AUTHID CURRENT_USER AS
2 -- $Header: igircaps.pls 115.6 2002/11/18 14:25:11 panaraya ship $
3 
4     TYPE PostingParametersType IS RECORD
5     (
6         PostingControlId          NUMBER(15),
7         FuncCurr                  VARCHAR2(15),
8         ChkBalance                VARCHAR2(1),
9         GlDateFrom                DATE,
10         GlDateTo                  DATE,
11         SetOfBooksId              NUMBER(15),
12         CashSetOfBooksId          NUMBER(15),
13         UnallocatedRevCcid        NUMBER(15),
14         GlPostedDate              DATE,
15         UnpostedPostingControlId  ar_posting_control.posting_control_id%TYPE := -3,
16     ReqId             NUMBER(15),      -- Concurrent Request ID
17         CreatedBy                 NUMBER(15),
18         UserSource                VARCHAR2(25),    -- user_name_struct->source
19         UserTrade                 VARCHAR2(25),    -- user_name_struct->misc
20         UserMisc                  VARCHAR2(25),    -- user_name_struct->trade
21         UserCcurr                 VARCHAR2(25),
22         NxtCashReceiptHistoryId     ar_cash_receipt_history.cash_receipt_history_id%TYPE        := 999999999999999,
23         NxtReceivableApplicationId  ar_receivable_applications.receivable_application_id%TYPE   := 999999999999999,
24         NxtMiscCashDistributionId   ar_misc_cash_distributions.misc_cash_distribution_id%TYPE   := 999999999999999,
25         NxtAdjustmentId             ar_adjustments.adjustment_id%TYPE                           := 999999999999999,
26         NxtCustTrxLineGlDistId      ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE      := 999999999999999,
27         SummaryFlag               VARCHAR2(1),
28 -- NLS strings from host app
29         NlsPreReceipt             VARCHAR2(240),   -- AR_NLS_GLTP_PRE_RECEIPT
30         NlsPostReceipt            VARCHAR2(240),   -- AR_NLS_GLTP_POST_RECEIPT
31         NlsPreMiscDist            VARCHAR2(240),   -- AR_NLS_GLTP_PRE_MISC_DIST
32         NlsPostMiscDist           VARCHAR2(240),   -- AR_NLS_GLTP_POST_MISC_DIST
33         NlsPreTradeApp            VARCHAR2(240),   -- AR_NLS_GLTP_PRE_TRADEAPP
34         NlsPostTradeApp           VARCHAR2(240),   -- AR_NLS_GLTP_POST_TRADEAPP
35         NlsPreReceiptGl            VARCHAR2(240),   -- AR_NLS_GLTP_PRE_RECEIPTGL
36         NlsPostReceiptGl           VARCHAR2(240),   -- AR_NLS_GLTP_POST_RECEIPTGL
37         NlsAppOnacc               VARCHAR2(240),   -- AR_NLS_APP_ONACC
38         NlsAppUnapp               VARCHAR2(240),   -- AR_NLS_APP_UNAPP
39         NlsAppUnid                VARCHAR2(240),   -- AR_NLS_APP_UNID
40         NlsAppApplied             VARCHAR2(240)    -- AR_NLS_APP_APPLIED
41     );
42 --
43    PROCEDURE Post
44                 ( p_PostingControlId    IN  NUMBER
45         , p_GlDateFrom      IN  DATE
46         , p_GlDateTo        IN  DATE
47         , p_GlPostedDate    IN  DATE
48         , p_CreatedBy       IN  NUMBER
49         , p_SummaryFlag     IN  VARCHAR2
50         , p_SetOfBooksId    OUT NOCOPY NUMBER
51         , p_CashSetOfBooksId    OUT NOCOPY NUMBER
52         , p_user_je_source_name OUT NOCOPY Varchar2
53         , p_ra_id       OUT NOCOPY NUMBER
54         , p_crh_id      OUT NOCOPY NUMBER
55         , p_mcd_id      OUT NOCOPY NUMBER
56         , p_balanceflag     OUT NOCOPY VARCHAR2
57         );
58 --
59     PROCEDURE SubmitJournalImport
60         ( p_posting_control_id           IN   NUMBER
61         , p_start_date                   IN   DATE
62         , p_post_thru_date               IN   DATE
63         );
64 END;