1 PACKAGE JA_JAINAPCR_XMLP_PKG AS
2 /* $Header: JAINAPCRS.pls 120.1 2007/12/25 16:11:27 dwkrishn noship $ */
3 P_FROM_DATE DATE;
4 P_FROM_DATE_V VARCHAR2(11);
5 P_TO_DATE DATE;
6 P_TO_DATE_V VARCHAR2(11);
7 P_VENDOR_ID NUMBER;
8 P_VENDOR_NO VARCHAR2(40);
9 P_VENDOR_TYPE_LOOKUP_CODE VARCHAR2(25);
10 P_CHART_OF_ACCTS_ID NUMBER;
11 P_ORG_ID NUMBER;
12 P_VENDOR_SITE_ID NUMBER;
13 P_CONC_REQUEST_ID NUMBER;
14 P_VENDOR_SITE_CODE2 VARCHAR2(15);
15 P_ORG_ID1 NUMBER;
16 P_SEGMENT2 NUMBER;
17 FUNCTION CF_PO_NOFORMULA(P_PO_DISTRIBUTION_ID IN NUMBER) RETURN VARCHAR2;
18 FUNCTION CF_ORGNFORMULA(P_PO_DISTRIBUTION_ID IN NUMBER) RETURN VARCHAR2;
19 FUNCTION CF_LOCNFORMULA(P_PO_DISTRIBUTION_ID IN NUMBER) RETURN VARCHAR2;
20 FUNCTION CF_DR_REFORMULA(ORG_ID IN NUMBER
21 ,INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2
22 ,ACCT_DR IN NUMBER
23 ,EXCHANGE_RATE_TYPE IN VARCHAR2
24 ,INVOICE_CURRENCY_CODE IN VARCHAR2
25 ,EXCHANGE_DATE IN DATE
26 ,EXCHANGE_RATE IN NUMBER
27 ,DR_VAL IN NUMBER) RETURN NUMBER;
28 FUNCTION CF_CR_REFORMULA(ORG_ID IN NUMBER
29 ,INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2
30 ,ACCT_CR IN NUMBER
31 ,EXCHANGE_RATE_TYPE IN VARCHAR2
32 ,INVOICE_CURRENCY_CODE IN VARCHAR2
33 ,EXCHANGE_DATE IN DATE
34 ,EXCHANGE_RATE IN NUMBER
35 ,CR_VAL IN NUMBER) RETURN NUMBER;
36 FUNCTION CF_BATCHFORMULA(P_BATCH_ID IN NUMBER) RETURN VARCHAR2;
37 FUNCTION CF_ADDRFORMULA(P_INVOICE_NUM IN VARCHAR2) RETURN VARCHAR2;
38 FUNCTION CF_ACCOUNTFORMULA(CCID IN NUMBER) RETURN VARCHAR2;
39 FUNCTION DEBIT_BALANCE(CAL_DATE IN DATE) RETURN NUMBER;
40 FUNCTION CREDIT_BALANCE(CAL_DATE IN DATE) RETURN NUMBER;
41 FUNCTION CF_V_NAMEFORMULA RETURN VARCHAR2;
42 FUNCTION CF_P_SOBFORMULA RETURN VARCHAR2;
43 FUNCTION CF_TOTAL_CRFORMULA(VENDOR_SITE_CODE2 IN VARCHAR2
44 ,SEGMENT2 IN VARCHAR2
45 ,ORG_ID1 IN NUMBER) RETURN NUMBER;
46 FUNCTION CF_TOTAL_DRFORMULA(VENDOR_SITE_CODE2 IN VARCHAR2
47 ,SEGMENT2 IN VARCHAR2
48 ,ORG_ID1 IN NUMBER) RETURN NUMBER;
49 FUNCTION CF_CLOSING_BAL_CRFORMULA0070(VENDOR_SITE_CODE2 IN VARCHAR2
50 ,SEGMENT2 IN VARCHAR2
51 ,ORG_ID1 IN NUMBER) RETURN NUMBER;
52 FUNCTION CF_CLOSING_BAL_DRFORMULA0072(VENDOR_SITE_CODE2 IN VARCHAR2
53 ,SEGMENT2 IN VARCHAR2
54 ,ORG_ID1 IN NUMBER) RETURN NUMBER;
55 FUNCTION CF_TOTAL_CR1FORMULA(CF_TOTAL_CR IN NUMBER
56 ,CF_TOTAL_DR IN NUMBER) RETURN NUMBER;
57 FUNCTION CF_TOTAL_DR1FORMULA(CF_TOTAL_DR IN NUMBER
58 ,CF_TOTAL_CR IN NUMBER) RETURN NUMBER;
59 FUNCTION CF_CLOSING_BAL_CR1FORMULA0076(CF_CLOSING_BAL_CR IN NUMBER
60 ,CF_CLOSING_BAL_DR IN NUMBER) RETURN NUMBER;
61 FUNCTION CF_CLOSING_BAL_DR1FORMULA0078(CF_CLOSING_BAL_DR IN NUMBER
62 ,CF_CLOSING_BAL_CR IN NUMBER) RETURN NUMBER;
63 FUNCTION CF_1FORMULA(CF_TOTAL_CR1 IN NUMBER
64 ,CS_2 IN NUMBER
65 ,CS_1 IN NUMBER
66 ,CF_TOTAL_DR1 IN NUMBER) RETURN NUMBER;
67 FUNCTION CF_2FORMULA(CS_3 IN NUMBER
68 ,CS_4 IN NUMBER) RETURN NUMBER;
69 FUNCTION BEFOREREPORT RETURN BOOLEAN;
70 FUNCTION AFTERREPORT RETURN BOOLEAN;
71 END JA_JAINAPCR_XMLP_PKG;
72
73