PACKAGE: APPS.INV_INVARPAR_XMLP_PKG

Source

1 PACKAGE INV_INVARPAR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVARPARS.pls 120.3 2011/03/02 11:19:02 sanjeevs ship $ */
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   --bug#11737196 changing the function argument
44   FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN CHAR;
45 
46   --bug#11737196 changing the function argument
47   FUNCTION CF_OUTERMOST_LPNFORMULA(P_OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR;
48 
49   --bug#11737196 changing the function argument
50   FUNCTION CF_PARENT_LPNFORMULA(P_PARENT_LPN_ID IN NUMBER) RETURN CHAR;
51 
52   FUNCTION CF_APPROVER_FORMULA(EMP_ID IN NUMBER) RETURN CHAR;
53 
54   FUNCTION CF_APPROVERFORMULA(EMP_ID IN NUMBER) RETURN CHAR;
55 
56 END INV_INVARPAR_XMLP_PKG;
57