[Home] [Help]
PACKAGE: APPS.INV_INVARPSL_XMLP_PKG
Source
1 PACKAGE INV_INVARPSL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVARPSLS.pls 120.1.12020000.2 2012/07/09 08:03:14 asugandh ship $ */
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 -- bug13722951 changing the function argument from OUTERMOST_LPN_ID to P_OUTERMOST_LPN_ID
58 FUNCTION CF_OUTERMOST_LPNFORMULA(P_OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR;
59
60 -- bug13722951 changing the function argument from PARENT_LPN_ID to P_PARENT_LPN_ID
61 FUNCTION CF_PARENT_LPNFORMULA(P_PARENT_LPN_ID IN NUMBER) RETURN CHAR;
62
63 -- bug13722951 changing the function argument from COST_GROUP_ID to P_COST_GROUP_ID
64 FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN CHAR;
65
66 END INV_INVARPSL_XMLP_PKG;
67