DBA Data[Home] [Help]

PACKAGE: APPS.INV_INVARPIA_XMLP_PKG

Source


1 PACKAGE INV_INVARPIA_XMLP_PKG AS
2 /* $Header: INVARPIAS.pls 120.3 2008/01/08 06:23:51 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_STRUCT_NUM NUMBER;
8 
9   P_CAT_STRUCT_NUM NUMBER;
10 
11   P_ITEM_FLEX VARCHAR2(800);
12 
13   P_CAT_FLEX VARCHAR2(800);
14 
15   P_CATEGORY_SET_ID NUMBER;
16 
17   P_LOC_FLEX VARCHAR2(800);
18 
19   P_CONDITION VARCHAR2(40);
20 
21   P_SORT_ID NUMBER;
22 
23   P_PHYS_INV_ID NUMBER;
24 
25   P_QTY_PRECISION NUMBER;
26 
27   P_CAT_SORT VARCHAR2(900);
28 
29   P_ORDER_ITEM VARCHAR2(900);
30 
31   P_CBO_FLAG NUMBER;
32 
33   P_TRACE_FLAG NUMBER;
34 
35   P_INCLUDE_REJ_ITEMS VARCHAR2(32767);
36 
37   P_INCLUDE_REJ_ITEMS_OPT VARCHAR2(100);
38 
39   P_REJ_OPT_TITLE VARCHAR2(100);
40 
41   FUNCTION BEFOREREPORT RETURN BOOLEAN;
42 
43   FUNCTION AFTERREPORT RETURN BOOLEAN;
44 
45   FUNCTION AFTERPFORM RETURN BOOLEAN;
46 
47   FUNCTION C_PHYS_INV_NAMEFORMULA RETURN VARCHAR2;
48 
49   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
50 
51   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
52 
53   FUNCTION C_ADJ_PER_CATFORMULA(C_CNT_VAL_CAT IN NUMBER
54                                ,C_ADJ_VAL_CAT IN NUMBER
55                                ,C_STD_PREC IN NUMBER) RETURN NUMBER;
56 
57   FUNCTION C_ADJ_PER_TOTFORMULA(C_CNT_VAL_SUM IN NUMBER
58                                ,C_ADJ_VAL_SUM IN NUMBER
59                                ,C_STD_PREC IN NUMBER) RETURN NUMBER;
60 
61   FUNCTION C_SORTFORMULA RETURN VARCHAR2;
62 
63   FUNCTION C_CAT_PADFORMULA(C_CAT_PAD IN VARCHAR2) RETURN VARCHAR2;
64 
65 END INV_INVARPIA_XMLP_PKG;
66