[Home] [Help]
PACKAGE: APPS.WSH_WSHRDVLD_XMLP_PKG
Source
1 PACKAGE WSH_WSHRDVLD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRDVLDS.pls 120.3 2008/01/04 10:38:59 dwkrishn noship $ */
3 P_TRIP_ID NUMBER;
4
5 P_DEBUG VARCHAR2(2);
6
7 P_SOB_ID NUMBER;
8
9 LP_TRIP VARCHAR2(200) := ' ';
10
11 P_FLEX_ITEM_PICKUP VARCHAR2(1000);
12
13 P_ITEM_STRUCT_NUM VARCHAR2(40);
14
15 P_CONC_REQUEST_ID NUMBER := 0;
16
17 P_FLEX_ITEM_DROPOFF VARCHAR2(1000);
18
19 RP_SUB_TITLE VARCHAR2(80);
20
21 FUNCTION BEFOREREPORT RETURN BOOLEAN;
22
23 FUNCTION C_COMPANY_NAME RETURN VARCHAR2;
24
25 FUNCTION AFTERREPORT RETURN BOOLEAN;
26
27 FUNCTION AFTERPFORM RETURN BOOLEAN;
28
29 FUNCTION P_ITEM_STRUCT_NUMVALIDTRIGGER RETURN BOOLEAN;
30
31 FUNCTION CF_PICK_UP_CUST_JOBFORMULA(PICK_SOURCE_CODE IN VARCHAR2
32 ,PICK_SOURCE_LINE_ID IN NUMBER) RETURN CHAR;
33
34 FUNCTION CF_DROP_OFF_CUST_JOBFORMULA(DROP_SOURCE_CODE IN VARCHAR2
35 ,DROP_SOURCE_LINE_ID IN NUMBER) RETURN CHAR;
36
37 FUNCTION CF_PICK_ITEM_DESCFORMULA(PICK_INVENTORY_ITEM_ID IN NUMBER
38 ,PICK_UP_ITEM_DESCRIPTION IN VARCHAR2
39 ,DET_PICK_ITEM_DESC IN VARCHAR2) RETURN CHAR;
40
41 FUNCTION CF_DROP_ITEM_DESCFORMULA(DROP_INVENTORY_ITEM_ID IN NUMBER
42 ,DROP_OFF_ITEM_DESCRIPTION IN VARCHAR2
43 ,DET_DROP_ITEM_DESCRIPTION IN VARCHAR2) RETURN CHAR;
44
45 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
46
47 END WSH_WSHRDVLD_XMLP_PKG;
48