PACKAGE: APPS.INV_INVARPTP_XMLP_PKG

Source

1 PACKAGE INV_INVARPTP_XMLP_PKG AUTHID CURRENT_USER 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