PACKAGE: APPS.WMS_WMSSTCON_XMLP_PKG

Source

1 PACKAGE WMS_WMSSTCON_XMLP_PKG AS
2 /* $Header: WMSSTCONS.pls 120.3 2007/12/25 08:02:23 nchinnam noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_WHERE_CLAUSE VARCHAR2(1000) := '1 = 1';
6 
7   P_ORG_ID NUMBER;
8 
9   P_TRIP_ID NUMBER;
10 
11   P_DELIVERY_ID NUMBER;
12 
13   P_SALES_ORDER_HEADER_ID NUMBER;
14 
15   P_ITEM_FLEX_DATA VARCHAR2(1000);
16 
17   P_LOC_FLEX_DATA VARCHAR2(1000);
18 
19   RP_REPORT_NAME VARCHAR2(200) := 'Consolidation Report ';
20 
21   P_MULTIPLE_YES VARCHAR2(5);
22 
23   P_MULTIPLE_NO VARCHAR2(5);
24 
25   P_MULTIPLE_ASSOCIATION_CHECK NUMBER;
26 
27   P_CUSTOMER_ID NUMBER;
28 
29   P_ORDER_TYPE_ID NUMBER;
30 
31   P_ORDER_ITEM VARCHAR2(500);
32 
33   P_ORDER_LOC VARCHAR2(500);
34 
35   P_TRIP_NAME VARCHAR2(30);
36 
37   P_DELIVERY_NAME VARCHAR2(30);
38 
39   P_SALES_ORDER NUMBER;
40 
41   P_CUSTOMER_NAME VARCHAR2(50);
42 
43   P_ORG_CODE VARCHAR2(5);
44 
45   P_ORG_NAME VARCHAR2(240);
46 
47   P_CUSTOMER_NUMBER VARCHAR2(30);
48 
49   FUNCTION BEFOREREPORT RETURN BOOLEAN;
50 
51   FUNCTION AFTERREPORT RETURN BOOLEAN;
52 
53   FUNCTION INMULTIPLESOFORMULA(LPN_ID IN NUMBER) RETURN CHAR;
54 
55   FUNCTION INMULTIPLEDELIVERYFORMULA(LPN_ID IN NUMBER) RETURN CHAR;
56 
57   FUNCTION INMULTIPLETRIPFORMULA(LPN_ID IN NUMBER) RETURN CHAR;
58 
59   FUNCTION P_TRIP_NAME_P RETURN VARCHAR2;
60 
61   FUNCTION P_DELIVERY_NAME_P RETURN VARCHAR2;
62 
63   FUNCTION P_SALES_ORDER_P RETURN NUMBER;
64 
65   FUNCTION P_CUSTOMER_NAME_P RETURN VARCHAR2;
66 
67   FUNCTION P_ORG_CODE_P RETURN VARCHAR2;
68 
69   FUNCTION P_ORG_NAME_P RETURN VARCHAR2;
70 
71   FUNCTION P_CUSTOMER_NUMBER_P RETURN VARCHAR2;
72 
73 END WMS_WMSSTCON_XMLP_PKG;
74