PACKAGE: APPS.INV_INVTRSHS_XMLP_PKG

Source

1 PACKAGE INV_INVTRSHS_XMLP_PKG AS
2 /* $Header: INVTRSHSS.pls 120.2 2008/01/08 06:44:02 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4   P_ORG_ID NUMBER;
5   P_GROUP_BY NUMBER;
6   P_CATEGORY_SET NUMBER;
7   P_CAT_STRUCT_NUM NUMBER;
8   P_CATEGORY_FROM VARCHAR2(80);
9   P_CATEGORY_TO VARCHAR2(80);
10   P_ITEM_FROM VARCHAR2(80);
11   P_ITEM_TO VARCHAR2(80);
12   P_ITEM_PLANNER VARCHAR2(10);
13   P_SEQ_NUM NUMBER;
14   P_CAT_FLEX VARCHAR2(900) := '(MC.SEGMENT1||''\n''||MC.SEGMENT2||''\n''||MC.SEGMENT3||''\n''||
15   MC.SEGMENT4||''\n''||MC.SEGMENT5||''\n''||MC.SEGMENT6||''\n''||MC.SEGMENT7||''\n''||MC.SEGMENT8||''\n''||MC.SEGMENT9||''\n''||
16   MC.SEGMENT10||''\n''||MC.SEGMENT11||''\n''||MC.SEGMENT12||''\n''||MC.SEGMENT13||''\n''||MC.SEGMENT14||''\n''||
17   MC.SEGMENT15||''\n''||MC.SEGMENT16||''\n''||MC.SEGMENT17||''\n''||MC.SEGMENT18||''\n''||MC.SEGMENT19||''\n''||MC.SEGMENT20)';
18   P_ITEM_FLEX VARCHAR2(900);
19   P_STRUCT_NUM NUMBER;
20   P_CAT_WHERE VARCHAR2(900);
21   P_ITEM_WHERE VARCHAR2(900);
22   P_ORDER_HDR VARCHAR2(32767);
23   P_ORDER_POS VARCHAR2(32767);
24   P_ORDER_ITEM VARCHAR2(32767);
25   P_ONHAND_ONLY_YN NUMBER;
26   P_SEND_NOTIFICATIONS_YN NUMBER;
27   P_INVENTORY_ITEM_ID NUMBER := 0;
28   P_G_TRUE VARCHAR2(1);
29   P_G_FALSE VARCHAR2(1);
30   P_G_RET_STS_SUCCESS VARCHAR2(1);
31   FUNCTION BEFOREREPORT RETURN BOOLEAN;
32   FUNCTION AFTERREPORT RETURN BOOLEAN;
33   FUNCTION C_FROM_CATFORMULA RETURN VARCHAR2;
34   FUNCTION C_CAT_WHEREFORMULA RETURN VARCHAR2;
35   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
36   FUNCTION BEFOREPFORM RETURN BOOLEAN;
37   FUNCTION AFTERPFORM RETURN BOOLEAN;
38   FUNCTION C_HDR_ITEM_PADFORMULA(C_HDR_ITEM_PAD IN VARCHAR2) RETURN VARCHAR2;
39   FUNCTION C_GROUP_OPTION_NAMEFORMULA RETURN VARCHAR2;
40   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
41   FUNCTION C_POS_ITEM_PADFORMULA(C_POS_ITEM_PAD IN VARCHAR2) RETURN VARCHAR2;
42   FUNCTION C_CAT_PADFORMULA(C_CAT_PAD IN VARCHAR2) RETURN VARCHAR2;
43   FUNCTION C_ONHAND_WHEREFORMULA RETURN VARCHAR2;
44   FUNCTION C_ONHAND_ONLY_YNFORMULA RETURN VARCHAR2;
45   FUNCTION C_NET_QTY_HDRFORMULA(C_INVENTORY_ITEM_ID_HDR IN NUMBER) RETURN NUMBER;
46   FUNCTION C_NET_QTY_POSFORMULA(C_INVENTORY_ITEM_ID_POS IN NUMBER) RETURN NUMBER;
47   FUNCTION C_NOTIFICATIONFORMULA(C_INVENTORY_ITEM_ID_HDR IN NUMBER
48                                 ,C_INVENTORY_ITEM_ID_POS IN NUMBER) RETURN NUMBER;
49   FUNCTION C_SEND_NOTIFICATIONS_YNFORMULA RETURN VARCHAR2;
50   FUNCTION C_ITEMPLANNER_WHEREFORMULA RETURN VARCHAR2;
51   PROCEDURE SEND(P_INVENTORY_ITEM_ID IN NUMBER);
52 END INV_INVTRSHS_XMLP_PKG;
53 
54