[Home] [Help]
PACKAGE: APPS.INV_INVPOPSR_XMLP_PKG
Source
1 PACKAGE INV_INVPOPSR_XMLP_PKG AS
2 /* $Header: INVPOPSRS.pls 120.3 2008/05/30 07:21:36 dwkrishn 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 END INV_INVPOPSR_XMLP_PKG;
73