PACKAGE: APPS.JA_JAINCTRB_XMLP_PKG

Source

1 PACKAGE JA_JAINCTRB_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINCTRBS.pls 120.1 2007/12/25 16:16:20 dwkrishn noship $ */
3   P_AS_OF_DATE DATE;
4 
5   P_VENDOR_ID NUMBER;
6 
7   P_VENDOR_NO VARCHAR2(40);
8 
9   CP_AS_OF_DATE VARCHAR2(20);
10 
11   P_VENDOR_TYPE_LOOKUP_CODE VARCHAR2(40);
12 
13   P_ACCTS_ID NUMBER;
14 
15   P_CHARTS_OF_ACCTS_ID NUMBER;
16 
17   P_ORG_ID NUMBER;
18 
19   P_CONC_REQUEST_ID NUMBER;
20 
21   LP_SELECTED_VENDOR_ID VARCHAR2(1000);
22 
23   LP_SELECTED_VENDOR_NO VARCHAR2(1000);
24 
25   FUNCTION CF_VENDOR_TYPEFORMULA(VENDOR_ID IN NUMBER) RETURN VARCHAR2;
26 
27   FUNCTION CF_VENDOR_NAMEFORMULA(VENDOR_ID IN NUMBER) RETURN VARCHAR2;
28 
29   FUNCTION CF_VENDOR_CODEFORMULA(VENDOR_ID IN NUMBER) RETURN VARCHAR2;
30 
31   FUNCTION CF_ADDRFORMULA(ORG_ID IN NUMBER) RETURN VARCHAR2;
32 
33   FUNCTION CF_ENTERED_AMOUNTFORMULA(ACCTS IN NUMBER
34                                    ,VENDOR_ID IN NUMBER
35                                    ,ORG_ID IN NUMBER
36                                    ,INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
37 
38   FUNCTION CF_RE_AMTFORMULA(ACCTS IN NUMBER
39                            ,ORG_ID IN NUMBER
40                            ,VENDOR_ID IN NUMBER
41                            ,INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
42 
43   FUNCTION CF_ACCTSFORMULA(ACCTS IN NUMBER) RETURN VARCHAR2;
44 
45   FUNCTION CF_ADDR1FORMULA(ORG_ID IN NUMBER) RETURN VARCHAR2;
46 
47   FUNCTION CF_SOB_NAMEFORMULA RETURN VARCHAR2;
48 
49   FUNCTION CF_P_VENDOR_NAMEFORMULA RETURN VARCHAR2;
50 
51   FUNCTION CF_P_ACCTSFORMULA RETURN VARCHAR2;
52 
53   FUNCTION BEFOREREPORT RETURN BOOLEAN;
54 
55   FUNCTION F_SELECTED_VENDOR RETURN VARCHAR2;
56 
57   FUNCTION F_SELECTED_VENDOR_NO RETURN VARCHAR2;
58 
59   FUNCTION AFTERPFORM RETURN BOOLEAN;
60 
61   FUNCTION AFTERREPORT RETURN BOOLEAN;
62 
63   LV_NEGOT_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'NEGOTIABLE';
64 
65   LV_CLEAR_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'CLEARED';
66 
67   LV_VOIDED_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'VOIDED';
68 
69   LV_REC_UNACC_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'RECONCILED UNACCOUNTED';
70 
71   LV_REC_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'RECONCILED';
72 
73   LV_CLEAR_UNACC_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'CLEARED BUT UNACCOUNTED';
74 
75   LV_ISSUED_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'ISSUED';
76 
77   LV_OVERFLOW_LOOKUP CONSTANT AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE DEFAULT 'OVERFLOW';
78 
79   LV_PREPAYMENT_LOOKUP CONSTANT AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE DEFAULT 'PREPAYMENT';
80 
81   LV_CREDIT_LOOKUP CONSTANT AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE DEFAULT 'CREDIT';
82 
83   LV_DEBIT_LOOKUP CONSTANT AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE DEFAULT 'DEBIT';
84 
85   LV_PREPAY_LINE_TYPE CONSTANT AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE DEFAULT 'PREPAY';
86 
87 END JA_JAINCTRB_XMLP_PKG;
88 
89