DBA Data[Home] [Help]

PACKAGE: APPS.JL_JLARPCFF_XMLP_PKG

Source


1 PACKAGE JL_JLARPCFF_XMLP_PKG AS
2 /* $Header: JLARPCFFS.pls 120.1 2007/12/25 16:33:21 dwkrishn noship $ */
3   P_BOOK_TYPE_CODE VARCHAR2(40);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_START_DATE DATE;
8 
9   P_END_DATE DATE;
10 
11   P_TAX_TYPE VARCHAR2(25);
12 
13   P_TRANSACTION_LETTER_FROM VARCHAR2(30);
14 
15   P_TRANSACTION_LETTER_TO VARCHAR2(30);
16 
17   P_LEGAL_ENTITY_ID NUMBER;
18 
19   P_LEGAL_ENTITY_NAME VARCHAR2(240);
20 
21   P_REPORTING_ENTITY_ID NUMBER;
22 
23   P_REPORTING_LEVEL VARCHAR2(32767);
24 
25   P_RETCODE VARCHAR2(32767);
26 
27   P_SET_OF_BOOKS_ID NUMBER;
28 
29   P_ERRBUF VARCHAR2(2000);
30 
31   C_ORGANISATION_NAME VARCHAR2(30);
32 
33   C_BASE_MIN_ACCT_UNIT NUMBER;
34 
35   C_BASE_CURRENCY_CODE VARCHAR2(15);
36 
37   C_BASE_PRECISION NUMBER := 2;
38 
39   C_BASE_DESCRIPTION VARCHAR2(240);
40 
41   PROCEDURE GET_BASE_CURR_DATA;
42 
43   FUNCTION AFTERREPORT RETURN BOOLEAN;
44 
45   PROCEDURE RAISE_ORA_ERR(ERRNO IN VARCHAR2);
46 
47   PROCEDURE RAISE_ERR(ERRNO IN VARCHAR2
48                      ,MSGNAME IN VARCHAR2);
49 
50   FUNCTION CF_ACC_DATEFORMULA(INVOICE_ID IN NUMBER
51                              ,TAX_RATE_ID IN NUMBER) RETURN DATE;
52 
53   FUNCTION CF_CITI_RECFORMULA(CF_ACC_DATE IN DATE
54                              ,CF_TAX_AMOUNT IN NUMBER
55                              ,DOCUMENT_TYPE IN VARCHAR2
56                              ,DOCUMENT_NUM IN VARCHAR2
57                              ,DOCUMENT_DATE IN DATE
58                              ,CUIT_NUMBER IN VARCHAR2
59                              ,SUP_NAME IN VARCHAR2) RETURN CHAR;
60 
61   FUNCTION CF_TAX_AMOUNTFORMULA(TAX_AMOUNT IN NUMBER) RETURN NUMBER;
62 
63   FUNCTION CF_SPACEFORMULA RETURN VARCHAR2;
64 
65   FUNCTION POPULATE_TRL RETURN BOOLEAN;
66 
67   FUNCTION BEFOREREPORT RETURN BOOLEAN;
68 
69   FUNCTION C_ORGANISATION_NAME_P RETURN VARCHAR2;
70 
71   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
72 
73   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
74 
75   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
76 
77   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
78 
79 END JL_JLARPCFF_XMLP_PKG;
80 
81