PACKAGE: APPS.GMF_GMFINVAL_XMLP_PKG

Source

1 PACKAGE GMF_GMFINVAL_XMLP_PKG AS
2 /* $Header: GMFINVALS.pls 120.0 2007/12/21 11:41:36 krreddy noship $ */
3   P_FROM_ITEM_ID NUMBER;
4   P_TO_ITEM_ID NUMBER;
5   P_FROM_ORGANIZATION_ID NUMBER;
6   P_TO_ORGANIZATION_ID NUMBER;
7   P_CURRENT VARCHAR2(1);
8   NONBLOCKSQL VARCHAR2(3);
9   Q1ORQ2 VARCHAR2(1) := '3';
10   P_CURRENCY_CODE VARCHAR2(4);
11   P_EXCHANGE_RATE NUMBER;
12   CURRENT_DUMMY VARCHAR2(1);
13   P_PERIOD_NUM VARCHAR2(32767);
14   P_PERIOD_YEAR VARCHAR2(32767);
15   P_LEGAL_ENTITY_ID NUMBER;
16   FROM_ORGN_CODE VARCHAR2(4);
17   LFROM_ORGN_CODE VARCHAR2(4);
18   TO_ORGN_CODE VARCHAR2(4);
19   LTO_ORGN_CODE VARCHAR2(4);
20   FROM_ITEM_NUM VARCHAR2(2000);
21   LFROM_ITEM_NUM VARCHAR2(2000);
22   TO_ITEM_NUM VARCHAR2(2000);
23   LTO_ITEM_NUM VARCHAR2(2000);
24   SY_ALL VARCHAR2(3);
25   P_CONC_REQUEST_ID NUMBER;
26   P_ORGANIZATION_CONTEXT NUMBER;
27   TOTALCOSTCP NUMBER;
28   UNITCOSTCP NUMBER := 0.00;
29   BALANCECP VARCHAR2(200);
30   ORGANIZATIONCP VARCHAR2(2000):='and 1=1';
31   ITEMCP VARCHAR2(2000):='and 1=1';
32   FUNCTION BEFOREREPORT RETURN BOOLEAN;
33   PROCEDURE HEADER;
34   FUNCTION AFTERPFORM RETURN BOOLEAN;
35   FUNCTION UNITCOSTCFFORMULA(INVENTORY_ITEM_ID IN NUMBER
36                             ,ORGANIZATION_ID IN NUMBER
37                             ,TRANSDATE IN DATE) RETURN NUMBER;
38   FUNCTION TOTALCOSTCFFORMULA(ITEM_PRIMARY_QUANTITY_CS IN NUMBER) RETURN NUMBER;
39   FUNCTION BALANCECFFORMULA RETURN VARCHAR2;
40   FUNCTION CF_BASE_CURRENCYFORMULA RETURN VARCHAR2;
41   FUNCTION AFTERREPORT RETURN BOOLEAN;
42   FUNCTION ORGANIZATIONCPFORMULA(ORGANIZATIONCF IN VARCHAR2) RETURN VARCHAR2;
43   FUNCTION ITEMCPFORMULA(ITEMCF IN VARCHAR2) RETURN CHAR;
44   FUNCTION ITEMCFFORMULA RETURN CHAR;
45   FUNCTION ORGANIZATIONCFFORMULA RETURN VARCHAR2;
46   FUNCTION LEGAL_ENTITY_NAME_CFFORMULA RETURN VARCHAR2;
47   FUNCTION TOTALCOSTCP_P RETURN NUMBER;
48   FUNCTION UNITCOSTCP_P RETURN NUMBER;
49   FUNCTION BALANCECP_P RETURN VARCHAR2;
50   FUNCTION ORGANIZATIONCP_P RETURN VARCHAR2;
51   FUNCTION ITEMCP_P RETURN VARCHAR2;
52 END GMF_GMFINVAL_XMLP_PKG;
53