PACKAGE: APPS.INV_INVARPAR_XMLP_PKG

Source

1 PACKAGE INV_INVARPAR_XMLP_PKG AS
2 /* $Header: INVARPARS.pls 120.2 2008/01/08 06:22: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_ITEM_FLEX VARCHAR2(800);
10 
11   P_LOC_FLEX VARCHAR2(800);
12 
13   P_CONDITION VARCHAR2(40);
14 
15   P_SORT_ID NUMBER;
16 
17   P_ORDER_ITEM VARCHAR2(300);
18 
19   P_PHYS_INV_ID NUMBER;
20 
21   P_BREAK_ID NUMBER;
22 
23   P_QTY_PRECISION NUMBER;
24 
25   P_INCLUDE_REJ_ITEMS NUMBER;
26 
27   P_INCLUDE_REJ_ITEMS_OPT VARCHAR2(100);
28 
29   P_REJ_OPT_TITLE VARCHAR2(100);
30 
31   P_WMS_INSTALLED VARCHAR2(6) := 'FALSE';
32 
33   FUNCTION BEFOREREPORT RETURN BOOLEAN;
34 
35   FUNCTION AFTERREPORT RETURN BOOLEAN;
36 
37   FUNCTION C_PHYS_INV_NAMEFORMULA RETURN VARCHAR2;
38 
39   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
40 
41   FUNCTION C_SORTFORMULA RETURN VARCHAR2;
42 
43   FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR;
44 
45   FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR;
46 
47   FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN_ID IN NUMBER) RETURN CHAR;
48 
49   FUNCTION CF_APPROVER_FORMULA(EMP_ID IN NUMBER) RETURN CHAR;
50 
51   FUNCTION CF_APPROVERFORMULA(EMP_ID IN NUMBER) RETURN CHAR;
52 
53 END INV_INVARPAR_XMLP_PKG;
54