DBA Data[Home] [Help]

PACKAGE: APPS.INV_INVINPSR_XMLP_PKG

Source


1 PACKAGE INV_INVINPSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVINPSRS.pls 120.4 2011/02/11 14:46:10 abhissri ship $ */
3   P_SHIPNO_LO VARCHAR2(40);
4 
5   P_SHIPNO_HIGH VARCHAR2(40);
6 
7   P_SHIP_VIA_LO VARCHAR2(50);
8 
9   P_SHIP_VIA_HIGH VARCHAR2(50);
10 
11   P_PACKSLIP_LO VARCHAR2(32767);
12 
13   P_PACKSLIP_HIGH VARCHAR2(32767);
14 
15   P_CONC_REQUEST_ID NUMBER;
16 
17   P_PRINT_SHIPPER_DETAILS VARCHAR2(1);
18 
19   P_ISSUING_ORG NUMBER;
20 
21   P_RECEIVING_ORG_LO NUMBER;
22 
23   P_RECEIVING_ORG_HIGH NUMBER;
24 
25   P_TRANS_TYPE_ID_LO VARCHAR2(32767);
26 
27   P_TRANS_TYPE_ID_HIGH VARCHAR2(32767);
28 
29   P_SET_OF_BOOKS_ID NUMBER;
30 
31   C_MESSAGE_NO_DATA VARCHAR2(80);
32 
33   FUNCTION INS_PKSLIP_REC(OLD_PACKSLIP_NUMBER IN NUMBER
34                          ,LINE_NO IN NUMBER
35                          ,C_PACKSLIP_NUM IN NUMBER
36                          ,SHIP_HEADER_ID IN NUMBER) RETURN VARCHAR2;
37 
38   FUNCTION PSLIP_NUMBER(OLD_PACKSLIP_NUMBER IN NUMBER
39                        ,LINE_NO IN NUMBER) RETURN NUMBER;
40 
41   FUNCTION AFTERREPORT RETURN BOOLEAN;
42 
43   FUNCTION BEFOREREPORT RETURN BOOLEAN;
44 
45   FUNCTION C_SHIPNUM_WHERE RETURN VARCHAR2;
46 
47   FUNCTION C_PACKSLIP_WHERE RETURN VARCHAR2;
48 
49   FUNCTION C_SHIP_VIA_WHERE RETURN VARCHAR2;
50 
51   FUNCTION C_REC_ORG_WHERE RETURN VARCHAR2;
52 
53   FUNCTION C_TRANS_TYPE_WHERE RETURN VARCHAR2;
54 
55   FUNCTION BEFOREPFORM RETURN BOOLEAN;
56 
57   FUNCTION C_SHIPPED_DATEFORMULA(SHIPPED_DATE IN DATE) RETURN CHAR;
58 
59   FUNCTION CF_BLANKFORMULA RETURN CHAR;
60 
61   FUNCTION CF_TAX_REGISTRATION_NUMBERFORM RETURN VARCHAR2;
62 
63   FUNCTION C_MESSAGE_NO_DATA_P RETURN VARCHAR2;
64 
65 
66 END INV_INVINPSR_XMLP_PKG;
67