DBA Data[Home] [Help]

PACKAGE: APPS.GMF_CMRCWA_XMLP_PKG

Source


1 PACKAGE GMF_CMRCWA_XMLP_PKG AS
2 /* $Header: CMRCWAS.pls 120.0 2007/12/24 13:27:33 nchinnam noship $ */
3   SORT_BY VARCHAR2(40);
4   FROM_COST_ORGN VARCHAR2(240);
5   TO_COST_ORGN VARCHAR2(240);
6   FROM_INV_ORGN VARCHAR2(240);
7   TO_INV_ORGN VARCHAR2(240);
8   SY_ALL VARCHAR2(3);
9   NONBLOCKSQL VARCHAR2(5);
10   P_FROM_COST_ORGN_ID NUMBER;
11   P_TO_COST_ORGN_ID NUMBER;
12   P_FROM_INV_ORGN_ID NUMBER;
13   P_TO_INV_ORGN_ID NUMBER;
14   P_CONC_REQUEST_ID NUMBER;
15   --COST_ORGNCP VARCHAR2(500);
16   COST_ORGNCP VARCHAR2(500):= 'and 1=1';
17   --INV_ORGNCP VARCHAR2(500);
18   INV_ORGNCP VARCHAR2(500):= 'and 1=1';
19   FUNCTION G_COST_ORGANIZATIONGROUPFILTER RETURN BOOLEAN;
20   FUNCTION G_INV_ORGANIZATIONGROUPFILTER RETURN BOOLEAN;
21   FUNCTION COST_ORGNCPFORMULA(COST_ORGNCF IN VARCHAR2) RETURN VARCHAR2;
22   FUNCTION COST_ORGNCFFORMULA RETURN VARCHAR2;
23   FUNCTION INV_ORGNCPFORMULA(INV_ORGNCF IN VARCHAR2) RETURN VARCHAR2;
24   FUNCTION INV_ORGNCFFORMULA RETURN VARCHAR2;
25   FUNCTION AFTERPFORM RETURN BOOLEAN;
26   PROCEDURE GMF_CMRCWA_XMLP_PKG_HEADER;
27   FUNCTION BEFOREREPORT RETURN BOOLEAN;
28   FUNCTION AFTERREPORT RETURN BOOLEAN;
29   FUNCTION COST_ORGNCP_P RETURN VARCHAR2;
30   FUNCTION INV_ORGNCP_P RETURN VARCHAR2;
31 END GMF_CMRCWA_XMLP_PKG;
32