PACKAGE: APPS.INV_INVARPTS_XMLP_PKG

Source

1 PACKAGE INV_INVARPTS_XMLP_PKG AS
2 /* $Header: INVARPTSS.pls 120.1 2007/12/25 10:12:02 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_STRUCT_NUM NUMBER;
8 
9   P_CONDITION VARCHAR2(40);
10 
11   P_PHYS_INV_ID NUMBER;
12 
13   P_REPORT_OPTION NUMBER;
14 
15   P_SUBINV_NAME VARCHAR2(40);
16 
17   FUNCTION BEFOREREPORT RETURN BOOLEAN;
18 
19   FUNCTION AFTERREPORT RETURN BOOLEAN;
20 
21   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
22 
23   FUNCTION C_PHYS_INV_NAMEFORMULA RETURN VARCHAR2;
24 
25   FUNCTION C_ADJ_PCTFORMULA(ADJMNT_VALUE IN NUMBER
26                            ,COUNT_VALUE IN NUMBER) RETURN NUMBER;
27 
28   FUNCTION C_VAR_PCTFORMULA(ABSOLUTE_VARIANCE IN NUMBER
29                            ,COUNT_VALUE IN NUMBER) RETURN NUMBER;
30 
31   FUNCTION C_ADJ_PCT_SUMFORMULA(C_ADJ_VAL_SUM IN NUMBER
32                                ,C_CNT_VAL_SUM IN NUMBER) RETURN NUMBER;
33 
34   FUNCTION C_VAR_PCT_SUMFORMULA(C_ABS_VAR_SUM IN NUMBER
35                                ,C_CNT_VAL_SUM IN NUMBER) RETURN NUMBER;
36 
37   FUNCTION C_WHERE_OPTIONFORMULA RETURN VARCHAR2;
38 
39   FUNCTION C_NUM_TAGSFORMULA(SUBINV IN VARCHAR2) RETURN NUMBER;
40 
41 END INV_INVARPTS_XMLP_PKG;
42