PACKAGE: APPS.INV_INVTRREG_XMLP_PKG

Source

1 PACKAGE INV_INVTRREG_XMLP_PKG AS
2 /* $Header: INVTRREGS.pls 120.1 2007/12/25 11:12:05 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4   P_STRUCT_NUM VARCHAR2(15);
5   P_CATG_STRUCT_NUM VARCHAR2(15);
6   P_ITEM_FLEXDATA VARCHAR2(300);
7   P_CATG_FLEXDATA VARCHAR2(820);
8   P_LOC_FLEXDATA VARCHAR2(320);
9   P_MKTS_FLEXDATA VARCHAR2(380);
10   P_GLCC_FLEXDATA VARCHAR2(380);
11   P_MDSP_FLEXDATA VARCHAR2(380);
12   P_ITEM_WHERE VARCHAR2(600);
13   P_CATG_WHERE VARCHAR2(600);
14   P_ITEM_ORDER_BY VARCHAR2(380) := 1;
15   P_CATG_ORDER_BY VARCHAR2(380) := 1;
16   P_CATG_SET_ID NUMBER;
17   P_CATG_LO VARCHAR2(240);
18   P_CATG_HI VARCHAR2(240);
19   P_ITEM_LO VARCHAR2(820);
20   P_ITEM_HI VARCHAR2(820);
21   P_TXN_DATE_LO DATE;
22   P_TXN_DATE_HI DATE;
23   LP_TXN_DATE_HI DATE;
24   LP_TXN_DATE_LO DATE;
25   LP_TXN_DATE_LO1 VARCHAR2(240);
26   LP_TXN_DATE_HI1 VARCHAR2(240);
27   P_QTY_PRECISION NUMBER;
28   QTY_PRECISION varchar2(100);
29   P_REASON_LO VARCHAR2(100);
30   P_REASON_HI VARCHAR2(100);
31   P_SUBINV_LO VARCHAR2(10);
32   P_SUBINV_HI VARCHAR2(10);
33   P_TXN_TYPE_LO VARCHAR2(100);
34   P_TXN_TYPE_HI VARCHAR2(100);
35   P_RPT_QTY_TYPE NUMBER;
36   P_RPT_UOM_TYPE NUMBER;
37   P_AUDIT_DETAIL NUMBER;
38   P_REASON_DETAIL NUMBER;
39   P_LOT_DETAIL NUMBER;
40   P_CATEGORY_DETAIL NUMBER;
41   P_LOC_DETAIL NUMBER;
42   P_SERIAL_DETAIL NUMBER;
43   P_TXN_SOURCE_TYPE_ID NUMBER;
44   P_TXN_SOURCE_LO VARCHAR2(240);
45   P_TXN_SOURCE_HI VARCHAR2(240);
46   P_RPT_UOM NUMBER;
47   P_ORG NUMBER;
48   P_SOURCE_WHERE VARCHAR2(1200);
49   P_ORDER_SOURCE VARCHAR2(1200);
50   P_BREAK_ID NUMBER;
51   P_GLCC_STRUCT_NUM VARCHAR2(15);
52   P_MKTS_ORDER_BY VARCHAR2(600);
53   P_GLCC_ORDER_BY VARCHAR2(600);
54   P_MDSP_ORDER_BY VARCHAR2(600);
55   P_TRACE_FLAG NUMBER;
56   P_OPTIMIZER_CODE NUMBER;
57   FUNCTION P_STRUCT_NUMVALIDTRIGGER RETURN BOOLEAN;
58   FUNCTION WHERE_REASON RETURN VARCHAR2;
59   FUNCTION WHERE_SUBINV RETURN VARCHAR2;
60   FUNCTION WHERE_TXN_TYPE RETURN VARCHAR2;
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62   FUNCTION C_SOURCE_WHEREFORMULA RETURN VARCHAR2;
63   FUNCTION C_TYPE_BREAK_COLUMNFORMULA RETURN VARCHAR2;
64   FUNCTION C_TYPE_BREAK_FROMFORMULA RETURN VARCHAR2;
65   FUNCTION C_TYPE_BREAK_WHEREFORMULA RETURN VARCHAR2;
66   FUNCTION C_RPT_DATE_CUR_TITLEFORMULA(C_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
67   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
68   FUNCTION P_MDSP_ORDER_BYVALIDTRIGGER RETURN BOOLEAN;
69   FUNCTION AFTERREPORT RETURN BOOLEAN;
70   FUNCTION CALC_UNIT_COST(UNROUNDED_QTY IN NUMBER
71                          ,UNROUNDED_TOT_COST IN NUMBER
72                          ,C_EXT_PRECISION IN VARCHAR2) RETURN NUMBER;
73   FUNCTION AFTERPFORM RETURN BOOLEAN;
74   FUNCTION C_SOURCE_TYPE_WHEREFORMULA RETURN VARCHAR2;
75   FUNCTION C_BREAK_DATE_VALUEFORMULA(BREAK_COLUMN IN VARCHAR2) RETURN DATE;
76 END INV_INVTRREG_XMLP_PKG;
77 
78