PACKAGE: APPS.WSH_WSHRDSDL_XMLP_PKG

Source

1 PACKAGE WSH_WSHRDSDL_XMLP_PKG AS
2 /* $Header: WSHRDSDLS.pls 120.2 2007/12/25 07:29:21 nchinnam noship $ */
3   LP_ITEM_SELECT VARCHAR2(240);
4   P_ORDER_BY_1 VARCHAR2(32767);
5   P_ORDER_BY_2 VARCHAR2(32767);
6   P_ORDER_BY_3 VARCHAR2(32767);
7   P_SHIP_FROM_ORG_ID NUMBER;
8   P_SHIP_DATE_LOW VARCHAR2(32767);
9   P_SHIP_DATE_HIGH VARCHAR2(32767);
10   LP_SHIP_DATE VARCHAR2(240):=' ';
11   P_DELIVERY_LOW VARCHAR2(30);
12   P_DELIVERY_HIGH VARCHAR2(30);
13   LP_DELIVERY VARCHAR2(240):=' ';
14   P_CUSTOMER_NAME_LOW NUMBER;
15   P_CUSTOMER_NAME_HIGH NUMBER;
16   LP_CUSTOMER_NAME VARCHAR2(240):=' ';
17   P_SHIP_METHOD VARCHAR2(80);
18   P_ITEM NUMBER;
19   P_ORDER_TYPE NUMBER;
20   P_ORDER_NUMBER_LOW VARCHAR2(150);
21   P_ORDER_NUMBER_HIGH VARCHAR2(150);
22   LP_ORDER_NUMBER VARCHAR2(240):=' ';
23   LP_ORDER_BY VARCHAR2(1000) := 'WDD.DELIVERY_DETAIL_ID';
24   LP_SHIP_METHOD VARCHAR2(240):=' ';
25   LP_ITEM VARCHAR2(240):=' ';
26   LP_ORDER_TYPE VARCHAR2(240):=' ';
27   P_CONC_REQUEST_ID NUMBER := 0;
28   P_ITEM_DISPLAY VARCHAR2(32767);
29   LP_SHIP_FROM_ORG_ID VARCHAR2(240):=' ';
30   LP_STRUCTURE_NUM NUMBER := 101;
31   P_ITEM_FLEX_CODE VARCHAR2(32767);
32   P_ORGANIZATION_ID NUMBER;
33   P_SOURCE_SYSTEM VARCHAR2(32767);
34   LP_TABLE_NAME VARCHAR2(240) := 'WSH_TRIP_STOPS  WTS';
35   LP_WHERE_CLAUSE VARCHAR2(240):= ' and 1=1';
36   REPORT_SORT_BY_1 VARCHAR2(80);
37   REPORT_SORT_BY_2 VARCHAR2(80);
38   REPORT_SORT_BY_3 VARCHAR2(80);
39   REPORT_SHIP_FROM VARCHAR2(240);
40   REPORT_ITEM_DISPLAY VARCHAR2(80);
41   REPORT_ITEM VARCHAR2(2000);
42   REPORT_SHIP_METHOD VARCHAR2(80);
43   REPORT_ORDER_TYPE VARCHAR2(30);
44   REPORT_DELIVERY_FROM VARCHAR2(40);
45   REPORT_DELIVERY_TO VARCHAR2(40);
46   REPORT_ORDER_NUMBER_FROM VARCHAR2(150);
47   REPORT_ORDER_NUMBER_TO VARCHAR2(150);
48   REPORT_CUSTOMER_FROM VARCHAR2(40);
49   REPORT_CUSTOMER_TO VARCHAR2(40);
50   REPORT_SHIP_DATE_FROM VARCHAR2(40);
51   REPORT_SHIP_DATE_TO VARCHAR2(40);
52   REPORT_NAME VARCHAR2(240);
53   FUNCTION BEFOREREPORT RETURN BOOLEAN;
54   FUNCTION AFTERPFORM RETURN BOOLEAN;
55   FUNCTION AFTERREPORT RETURN BOOLEAN;
56   FUNCTION CF_RELEASED_QUANTITYFORMULA(DELIVERY_LINE IN NUMBER
57                                       ,SOURCE_HEADER_ID IN NUMBER) RETURN NUMBER;
58   FUNCTION CF_ITEM_DISPLAYFORMULA(INVENTORY_ITEM_ID IN NUMBER
59                                  ,SHIP_FROM_ORGANIZATION IN NUMBER) RETURN VARCHAR2;
60   FUNCTION CF_SHIP_FROM_ORGANIZATION_NAME(SHIP_FROM_ORGANIZATION IN NUMBER) RETURN CHAR;
61   FUNCTION CF_SHIP_DATEFORMULA(STOP_ID_1 IN NUMBER) RETURN VARCHAR2;
62   FUNCTION REPORT_SORT_BY_1_P RETURN VARCHAR2;
63   FUNCTION REPORT_SORT_BY_2_P RETURN VARCHAR2;
64   FUNCTION REPORT_SORT_BY_3_P RETURN VARCHAR2;
65   FUNCTION REPORT_SHIP_FROM_P RETURN VARCHAR2;
66   FUNCTION REPORT_ITEM_DISPLAY_P RETURN VARCHAR2;
67   FUNCTION REPORT_ITEM_P RETURN VARCHAR2;
68   FUNCTION REPORT_SHIP_METHOD_P RETURN VARCHAR2;
69   FUNCTION REPORT_ORDER_TYPE_P RETURN VARCHAR2;
70   FUNCTION REPORT_DELIVERY_FROM_P RETURN VARCHAR2;
71   FUNCTION REPORT_DELIVERY_TO_P RETURN VARCHAR2;
72   FUNCTION REPORT_ORDER_NUMBER_FROM_P RETURN VARCHAR2;
73   FUNCTION REPORT_ORDER_NUMBER_TO_P RETURN VARCHAR2;
74   FUNCTION REPORT_CUSTOMER_FROM_P RETURN VARCHAR2;
75   FUNCTION REPORT_CUSTOMER_TO_P RETURN VARCHAR2;
76   FUNCTION REPORT_SHIP_DATE_FROM_P RETURN VARCHAR2;
77   FUNCTION REPORT_SHIP_DATE_TO_P RETURN VARCHAR2;
78   FUNCTION REPORT_NAME_P RETURN VARCHAR2;
79 END WSH_WSHRDSDL_XMLP_PKG;
80