PACKAGE: APPS.INV_INVISMMX_XMLP_PKG

Source

1 PACKAGE INV_INVISMMX_XMLP_PKG AS
2 /* $Header: INVISMMXS.pls 120.2 2008/01/08 06:28:56 dwkrishn noship $ */
3   P_SORT VARCHAR2(2);
4   P_RANGE NUMBER;
5   P_ITEM_SELECT VARCHAR2(1000);
6   P_ITEM_LO VARCHAR2(800);
7   P_ITEM_HI VARCHAR2(800);
8   P_CAT_SELECT VARCHAR2(1000);
9   P_ORG_ID NUMBER;
10   P_LEVEL NUMBER;
11   P_SELECTION NUMBER;
12   P_CAT_SET_ID NUMBER;
13   P_SUBINV VARCHAR2(10);
14   P_ORDER_BY VARCHAR2(40);
15   P_SORTER VARCHAR2(80);
16   P_WIP_BATCH_ID NUMBER;
17   P_LOT_CTL NUMBER;
18   P_RANGE_SQL VARCHAR2(1000) := '1=1';
19   P_MSTK_STRUCT NUMBER;
20   P_MCAT_STRUCT NUMBER;
21   P_D_CUTOFF DATE;
22   P_D_CUTOFF_1 DATE;
23   P_D_CUTOFF_REL NUMBER;
24   P_D_CUTOFF_REL_1 NUMBER;
25   P_S_CUTOFF DATE;
26   P_S_CUTOFF_1 DATE;
27   P_S_CUTOFF_REL NUMBER;
28   P_S_CUTOFF_REL_1 NUMBER;
29   P_USER_ID NUMBER;
30   P_RESTOCK NUMBER;
31   P_HANDLE_REP_ITEM NUMBER := 3;
32   P_DD_LOC_ID NUMBER;
33   P_NET_UNRSV NUMBER;
34   P_INCLUDE_IF NUMBER;
35   P_NET_RSV NUMBER;
36   P_INCLUDE_NONNET NUMBER := 1;
37   P_CONC_REQUEST_ID NUMBER := 0;
38   P_SYSDATE DATE;
39   P_NET_WIP NUMBER := 2;
40   P_DISPLAY_MODE NUMBER;
41   P_SHOW_DESC NUMBER;
42   P_INCLUDE_WIP NUMBER := 2;
43   P_INCLUDE_PO NUMBER;
44   P_APPROVAL NUMBER;
45   P_ENCUM_FLAG VARCHAR2(32767);
46   P_CUST_ID NUMBER;
47   P_CAL_CODE VARCHAR2(32767);
48   P_EXCEPTION_SET_ID NUMBER;
49   P_EMPLOYEE_ID NUMBER;
50   P_PO_ORG_ID NUMBER;
51   P_ORG_NAME VARCHAR2(90);
52   P_DATE_TIME VARCHAR2(17);
53   P_SB_TEXT VARCHAR2(80);
54   P_SELECTION_TEXT VARCHAR2(80);
55   P_LVL_TEXT VARCHAR2(80);
56   P_LOTCTL_TEXT VARCHAR2(80);
57   P_DISPLAY_MODE_TEXT VARCHAR2(80);
58   P_NONET_TEXT VARCHAR2(80);
59   P_RSTK_TEXT VARCHAR2(80);
60   P_REPITM_TEXT VARCHAR2(80);
61   P_DDL_TEXT VARCHAR2(60);
62   P_CSET_TEXT VARCHAR2(40);
63   P_NET_UR_TEXT VARCHAR2(80);
64   P_NET_R_TEXT VARCHAR2(80);
65   P_NET_W_TEXT VARCHAR2(80);
66   P_INC_W_TEXT VARCHAR2(80);
67   P_INC_PO_TEXT VARCHAR2(80);
68   P_INC_IF_TEXT VARCHAR2(80);
69   P_YES_TEXT VARCHAR2(80);
70   P_NO_TEXT VARCHAR2(80);
71   P_TRACE_FLAG NUMBER;
72   P_CATG_LO VARCHAR2(240);
73   P_CATG_HI VARCHAR2(240);
74   P_BUYER_HI VARCHAR2(240);
75   P_BUYER_LO VARCHAR2(240);
76   P_PLANNER_HI VARCHAR2(32767);
77   P_PLANNER_LO VARCHAR2(32767);
78   P_SHOW_DESC_TEXT VARCHAR2(80);
79   P_RANGE_BUYER VARCHAR2(600);
80   P_PUR_REVISION NUMBER;
81   P_MO_LINE_GROUPING NUMBER := 1;
82   P_INCLUDE_MO NUMBER;
83   P_INC_MO_TEXT VARCHAR2(80);
84   P_WARN VARCHAR2(32767) := 'S';
85   FUNCTION BEFOREREPORT RETURN BOOLEAN;
86   FUNCTION AFTERREPORT RETURN BOOLEAN;
87 END INV_INVISMMX_XMLP_PKG;
88