PACKAGE: APPS.JL_JLCOPWHR_XMLP_PKG

Source

1 PACKAGE JL_JLCOPWHR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLCOPWHRS.pls 120.1 2007/12/25 16:52:14 dwkrishn noship $ */
3   P_SEGMENT_LOW VARCHAR2(240);
4   P_VENDOR_NUMBER  VARCHAR2(240);
5 X BOOLEAN;
6 Y BOOLEAN;
7 a BOOLEAN;
8   P_SEGMENT_HIGH VARCHAR2(240);
9   P_TAX_NAME  VARCHAR2(240);
10    P_VENDOR_ID  NUMBER;
11   P_WITHHOLDING_TYPE_FROM VARCHAR2(30);
12   P_WITHHOLDING_TYPE_TO VARCHAR2(30);
13   P_TAX_PAYER_ID_FROM VARCHAR2(40);
14   P_TAX_PAYER_ID_TO VARCHAR2(40);
15   P_1 VARCHAR2(150);
16   P_CONC_REQUEST_ID NUMBER;
17   P_END_OF_REPORT VARCHAR2(21);
18   P_NO_DATA_FOUND VARCHAR2(100);
19   P_COA_ID NUMBER;
20   P_SOB_ID NUMBER;
21   P_ACCOUNTING_DATE_FROM DATE;
22   P_ACCOUNTING_DATE_TO DATE;
23   P_PERIOD_FROM VARCHAR2(32767);
24   P_PERIOD_TO VARCHAR2(32767);
25   P_FLEXDATA VARCHAR2(600);
26   P_MIN_PRECISION NUMBER := 0;
27   P_SELECTED_TAXPAYERID VARCHAR2(1000);
28   C_LOCATION_ID NUMBER;
29   C_BASE_CURRENCY_CODE VARCHAR2(16);
30   C_BASE_MIN_ACCT_UNIT NUMBER;
31   C_BASE_PRECISION NUMBER;
32   C_CHART_OF_ACCOUNTS_ID NUMBER;
33   C_COMPANY_NAME_HEADER VARCHAR2(50);
34   C_BASE_DESCRIPTION NUMBER;
35   C_REPORT_RUN_TIME VARCHAR2(8);
36   C_REPORT_START_DATE DATE;
37   CP_1 VARCHAR2(150);
38   C_WHERE_FLEX VARCHAR2(4000) := 'CC.SEGMENT1 BETWEEN ''00'' AND ''11''';
39   C_ALL_SEGS VARCHAR2(1000) := 'SEGMENT1';
40   FUNCTION BEFOREREPORT RETURN BOOLEAN;
41   FUNCTION CALCULATE_VAT_AMOUNT(P_TAX_NAME IN VARCHAR2
42                                ,P_VENDOR_ID IN NUMBER
43                                ,P_VENDOR_NUMBER IN VARCHAR2,
44 			       document_number in varchar2) RETURN NUMBER;
45   FUNCTION CF_VAT_AMOUNTFORMULA(CERTIFICATE_TYPE IN VARCHAR2
46                                ,TAX_NAME IN VARCHAR2
47                                ,VENDOR_ID IN NUMBER
48                                ,VENDOR_NUMBER IN VARCHAR2
49                                ,DOCUMENT_NUMBER IN VARCHAR2) RETURN NUMBER;
50   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
51   FUNCTION BEFOREPFORM RETURN BOOLEAN;
52   FUNCTION CF_1FORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
53   FUNCTION CP_1FORMULA(CF_1 IN VARCHAR2) RETURN VARCHAR2;
54   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
55   FUNCTION AFTERREPORT RETURN BOOLEAN;
56   FUNCTION F_NO_DATA_FOUNDFORMATTRIGGER(CS_NO_DATA_FOUND IN NUMBER) RETURN BOOLEAN;
57   FUNCTION P_PERIOD_FROMVALIDTRIGGER RETURN BOOLEAN;
58   FUNCTION P_PERIOD_TOVALIDTRIGGER RETURN BOOLEAN;
59   FUNCTION F_SELECTED_TAXPAYERID RETURN VARCHAR2;
60   FUNCTION AFTERPFORM RETURN BOOLEAN;
61   FUNCTION C_LOCATION_ID_P RETURN NUMBER;
62   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
63   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
64   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
65   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
66   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
67   FUNCTION C_BASE_DESCRIPTION_P RETURN NUMBER;
68   FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
69   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
70   FUNCTION CP_1_P RETURN VARCHAR2;
71   FUNCTION C_WHERE_FLEX_P RETURN VARCHAR2;
72   FUNCTION C_ALL_SEGS_P RETURN VARCHAR2;
73 END JL_JLCOPWHR_XMLP_PKG;
74 
75 
76