PACKAGE: APPS.JA_JAINARDR_XMLP_PKG

Source

1 PACKAGE JA_JAINARDR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINARDRS.pls 120.1 2007/12/25 16:12:29 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4   P_CUSTOMER_ID NUMBER;
5   P_CUSTOMER_TYPE VARCHAR2(30);
6   P_START_DATE DATE;
7   P_END_DATE DATE;
8   P_START_DATE1 VARCHAR2(30);
9   P_END_DATE1 VARCHAR2(30);
10   P_COLUMN_VALUE VARCHAR2(30);
11   P_CHART_OF_ACCOUNTS_ID NUMBER;
12   P_CUSTOMER_ID2 NUMBER;
13   P_CONC_REQUEST_ID NUMBER;
14   OP_TOT_CR NUMBER := 0;
15   CL_TOT_CR NUMBER := 0;
16   TRAN_OPEN_BAL_CR NUMBER;
17   FUNC_OPEN_BAL_DR NUMBER := 0;
18   FUNC_OPEN_BAL_CR NUMBER;
19   CP_EXCISE_INV_NO VARCHAR2(20);
20   TRAN_CR_AMT NUMBER;
21   FUNC_DR_AMT NUMBER;
22   FUNC_CR_AMT NUMBER;
23   TRAN_CLOSING_BAL_CR NUMBER := 0;
24   FUNC_CLOSING_BAL_DR NUMBER := 0;
25   FUNC_CLOSING_BAL_CR NUMBER;
26   ADD1 VARCHAR2(60);
27   ADD2 VARCHAR2(60);
28   ADD3 VARCHAR2(60);
29   COUNTRY VARCHAR2(60);
30   LOC_NAME VARCHAR2(60);
31   FUNCTION BEFOREPFORM RETURN BOOLEAN;
32   FUNCTION OPEN_BAL_TRFORMULA(CUSTOMER_ID IN NUMBER
33                              ,CURR_CODE IN VARCHAR2) RETURN NUMBER;
34   FUNCTION FUNC_OPEN_BALFORMULA RETURN NUMBER;
35   FUNCTION CF_1FORMULA(CUSTOMER_ID2 IN NUMBER
36                       ,CURR_CODE1 IN VARCHAR2) RETURN NUMBER;
37   FUNCTION CF_1FORMULA0031(CUSTOMER_TRX_ID_1 IN NUMBER) RETURN CHAR;
38   FUNCTION ACCOUNT_CODEFORMULA(ACCOUNT_ID IN NUMBER) RETURN CHAR;
39   FUNCTION CF_1FORMULA0034(CUSTOMER_ID IN NUMBER) RETURN CHAR;
40   FUNCTION CF_1FORMULA0037(TYPE IN VARCHAR2
41                           ,AMOUNT IN NUMBER
42                           ,AMOUNT_OTHER_CURRENCY IN NUMBER
43                           ,REMARKS IN VARCHAR2) RETURN NUMBER;
44   FUNCTION CF_1FORMULA0040 RETURN CHAR;
45   FUNCTION DESCRIPTIONFORMULA(ACCOUNT_ID IN NUMBER) RETURN CHAR;
46   FUNCTION CF_1FORMULA0038(FUNC_OP_BAL_TOT_DR IN NUMBER
47                           ,FUNC_OP_BAL_TOT_CR IN NUMBER) RETURN NUMBER;
48   FUNCTION CL_TOT_DRFORMULA(FUNC_CL_BAL_DR IN NUMBER
49                            ,FUNC_CL_BAL_CR IN NUMBER) RETURN NUMBER;
50   FUNCTION CF_1FORMULA0057(CS_1 IN NUMBER
51                           ,CS_2 IN NUMBER) RETURN NUMBER;
52   FUNCTION CF_EXCISE_INVFORMULA(CUSTOMER_TRX_ID_1 IN NUMBER) RETURN NUMBER;
53   FUNCTION BEFOREREPORT RETURN BOOLEAN;
54   FUNCTION AFTERREPORT RETURN BOOLEAN;
55   FUNCTION OP_TOT_CR_P RETURN NUMBER;
56   FUNCTION CL_TOT_CR_P RETURN NUMBER;
57   FUNCTION TRAN_OPEN_BAL_CR_P RETURN NUMBER;
58   FUNCTION FUNC_OPEN_BAL_DR_P RETURN NUMBER;
59   FUNCTION FUNC_OPEN_BAL_CR_P RETURN NUMBER;
60   FUNCTION CP_EXCISE_INV_NO_P RETURN VARCHAR2;
61   FUNCTION TRAN_CR_AMT_P RETURN NUMBER;
62   FUNCTION FUNC_DR_AMT_P RETURN NUMBER;
63   FUNCTION FUNC_CR_AMT_P RETURN NUMBER;
64   FUNCTION TRAN_CLOSING_BAL_CR_P RETURN NUMBER;
65   FUNCTION FUNC_CLOSING_BAL_DR_P RETURN NUMBER;
66   FUNCTION FUNC_CLOSING_BAL_CR_P RETURN NUMBER;
67   FUNCTION ADD1_P RETURN VARCHAR2;
68   FUNCTION ADD2_P RETURN VARCHAR2;
69   FUNCTION ADD3_P RETURN VARCHAR2;
70   FUNCTION COUNTRY_P RETURN VARCHAR2;
71   FUNCTION LOC_NAME_P RETURN VARCHAR2;
72   V_LAST_PAGE VARCHAR2(1) := 'F';
73   LAST_PAGE NUMBER := 0;
74   VALIDATION_FLAG VARCHAR2(1) := 'N';
75   PREV_PAGE NUMBER := 0;
76   LV_INV_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'INV';
77   LV_DM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DM';
78   LV_CM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'CM';
79   LV_DEP_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DEP';
80   LV_REC_ACCOUNT_CLASS CONSTANT RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE DEFAULT 'REC';
81   LV_REV_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'REVERSED';
82   LV_ACT_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'ACTIVITY';
83   LV_LOSS_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_LOSS';
84   LV_GAIN_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_GAIN';
85 END JA_JAINARDR_XMLP_PKG;
86 
87