[Home] [Help]
PACKAGE: APPS.INV_INVARPTP_XMLP_PKG
Source
1 PACKAGE INV_INVARPTP_XMLP_PKG AS
2 /* $Header: INVARPTPS.pls 120.1 2007/12/25 10:10:51 dwkrishn noship $ */
3 P_PHYSICAL NUMBER;
4 P_SUBINVENTORY VARCHAR2(40);
5 P_SORT_ID NUMBER;
6 P_ITEM_FLEXDATA VARCHAR2(480);
7 P_LOC_FLEXDATA VARCHAR2(480);
8 P_ITEM_STRUCT NUMBER;
9 P_LOC_STRUCT VARCHAR2(32767);
10 P_CONC_REQUEST_ID NUMBER := 0;
11 P_ORG_ID NUMBER;
12 P_RANGE NUMBER;
13 P_TAG_LO VARCHAR2(40);
14 P_TAG_HI VARCHAR2(40);
15 P_ORDER_BY VARCHAR2(480);
16 P_RANGE_SQL VARCHAR2(4800) := '1=1';
17 P_ITEM_ORDERBY VARCHAR2(480);
18 P_LOC_ORDERBY VARCHAR2(480);
19 P_RANGE_FLEX VARCHAR2(4800);
20 P_LOC_LO VARCHAR2(40);
21 P_LOC_HI VARCHAR2(40);
22 P_ITEM_LO VARCHAR2(40);
23 P_ITEM_HI VARCHAR2(40);
24 P_WMS_INSTALLED VARCHAR2(5) := 'FALSE';
25 FUNCTION AFTERREPORT RETURN BOOLEAN;
26 FUNCTION BEFOREREPORT RETURN BOOLEAN;
27 PROCEDURE WMS_INSTALLED;
28 FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN IN NUMBER) RETURN CHAR;
29 FUNCTION GET_LPN(P_LPN_ID IN NUMBER) RETURN VARCHAR2;
30 FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN IN NUMBER
31 ,PARENT_LPN IN NUMBER) RETURN CHAR;
32 FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID_1 IN NUMBER) RETURN CHAR;
33 END INV_INVARPTP_XMLP_PKG;
34