PACKAGE: APPS.INV_INVPOPSR_XMLP_PKG

Source

1 PACKAGE INV_INVPOPSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVPOPSRS.pls 120.5 2011/02/11 14:38:00 abhissri ship $ */
3   P_PRINT_DESC VARCHAR2(1);
4 
5   P_ITEM_LO VARCHAR2(240);
6 
7   P_ITEM_HIGH VARCHAR2(240);
8 
9   P_VENDOR_LO VARCHAR2(240);
10 
11   P_VENDOR_HIGH VARCHAR2(240);
12 
13   P_SHIPMENT_DATE_LO VARCHAR2(40);
14 
15   P_SHIPMENT_DATE_HIGH VARCHAR2(40);
16 
17   P_PACKSLIP_LO NUMBER;
18 
19   P_PACKSLIP_HIGH NUMBER;
20 
21   L_NEW_PACKSLIP_NUM NUMBER;
22 
23   P_CONC_REQUEST_ID NUMBER;
24 
25   P_PRINT_SHIPPER_DETAILS VARCHAR2(1);
26 
27   P_NOTE VARCHAR2(240);
28 
29   P_CARRIER VARCHAR2(40);
30 
31   P_ORG_ID NUMBER;
32 
33   P_SHIP_DATE_LO DATE;
34 
35   P_SHIP_DATE_HIGH DATE;
36 
37   OLD_VENDOR number;
38 
39   C_MESSAGE_NO_DATA VARCHAR2(80);
40 
41   FUNCTION AFTERREPORT RETURN BOOLEAN;
42 
43   FUNCTION C_ITEM_WHERE RETURN VARCHAR2;
44 
45   FUNCTION C_PACKSLIP_WHERE RETURN VARCHAR2;
46 
47   FUNCTION BEFOREREPORT RETURN BOOLEAN;
48 
49   FUNCTION C_VENDOR_WHEREFORMULA RETURN VARCHAR2;
50 
51   FUNCTION C_SHIPMENT_DATE_WHEREFORMULA RETURN VARCHAR2;
52 
53   FUNCTION CF_DOCUMENT_NOFORMULA(OLD_PACKSLIP_NUMBER IN NUMBER
54                                 ,CS_VENDOR_COUNT IN NUMBER
55                                 ,CF_DOC_NUM IN NUMBER
56                                 ,TRANS_ID IN NUMBER) RETURN NUMBER;
57 
58   FUNCTION CF_DOC_NUMFORMULA(OLD_PACKSLIP_NUMBER IN NUMBER
59                             ,CS_VENDOR_COUNT IN NUMBER
60 			    ,VENDOR IN NUMBER) RETURN NUMBER;
61 
62   FUNCTION G_TRANSACTIONGROUPFILTER(TRANS_ID IN NUMBER) RETURN BOOLEAN;
63 
64   FUNCTION CF_SHIPPED_DATEFORMULA(TRANS_DATE IN DATE) RETURN CHAR;
65 
66   FUNCTION CF_DOC_DATEFORMULA(DOC_DATE IN DATE) RETURN CHAR;
67 
68   FUNCTION CF_TAX_REGISTRATION_NUMBERFORM RETURN VARCHAR2;
69 
70   FUNCTION C_MESSAGE_NO_DATA_P RETURN VARCHAR2;
71 
72 
73 END INV_INVPOPSR_XMLP_PKG;
74