PACKAGE: APPS.INV_INVARPSL_XMLP_PKG

Source

1 PACKAGE INV_INVARPSL_XMLP_PKG AS
2 /* $Header: INVARPSLS.pls 120.1 2007/12/25 10:09:30 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 := 101;
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) :='and 1=1';
20 
21   P_SORT_OPTION NUMBER;
22 
23   P_ORDER_ITEM VARCHAR2(300);
24 
25   P_ORDER_CAT VARCHAR2(300);
26 
27   P_PHYS_INV_ID NUMBER;
28 
29   P_QTY_PRECISION NUMBER;
30 
31   P_CBO_FLAG NUMBER;
32 
33   P_TRACE_FLAG NUMBER;
34 
35   P_WMS_INSTALLED VARCHAR2(32767) := 'FALSE';
36 
37   FUNCTION C_TOTAL_VALUEFORMULA(QUANTITY IN NUMBER
38                                ,COST IN NUMBER
39                                ,C_STD_PREC IN NUMBER) RETURN NUMBER;
40 
41   FUNCTION BEFOREREPORT RETURN BOOLEAN;
42 
43   FUNCTION AFTERREPORT RETURN BOOLEAN;
44 
45   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
46 
47   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
48 
49   FUNCTION C_PHYS_INV_NAMEFORMULA RETURN VARCHAR2;
50 
51   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
52 
53   FUNCTION AFTERPFORM RETURN BOOLEAN;
54 
55   FUNCTION GET_P_STRUCT_NUM RETURN BOOLEAN;
56 
57   FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR;
58 
59   FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN_ID IN NUMBER) RETURN CHAR;
60 
61   FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR;
62 
63 END INV_INVARPSL_XMLP_PKG;
64