PACKAGE: APPS.GMF_CMRGLR_XMLP_PKG

Source

1 PACKAGE GMF_CMRGLR_XMLP_PKG AS
2 /* $Header: CMRGLRS.pls 120.0 2007/12/24 13:28:34 nchinnam noship $ */
3   P_CALENDAR_CODE VARCHAR2(40);
4   P_PERIOD_CODE VARCHAR2(10);
5 x boolean;
6   FROM_ORGN VARCHAR2(3);
7   REPORT_TYPE VARCHAR2(40):=' ';
8   TO_ORGN VARCHAR2(3);
9   ORDERBY VARCHAR2(1);
10   FROM_ITEM VARCHAR2(2000);
11   TO_ITEM VARCHAR2(2000);
12   FROM_COST_CATEGORY VARCHAR2(2000);
13   TO_COST_CATEGORY VARCHAR2(2000);
14   P_LEGAL_ENTITY_ID NUMBER;
15   P_START_DATE VARCHAR2(40);
16   P_CURRENCY_CODE VARCHAR2(15);
17   P_END_DATE VARCHAR2(40);
18   SY_ALL VARCHAR2(3);
19   NONBLOCKSQL VARCHAR2(5);
20   P_REPORT_CURRENCY VARCHAR2(4);
21   P_EXCHANGE_RATE NUMBER;
22   P_CONC_REQUEST_ID NUMBER;
23   P_COST_TYPE_ID NUMBER;
24   P_FROM_ORGANIZATION_ID NUMBER;
25   P_TO_ORGANIZATION_ID NUMBER;
26   P_FROM_ITEM_ID NUMBER;
27   P_TO_ITEM_ID NUMBER;
28   P_FROM_COST_CATEGORY_ID NUMBER;
29   P_TO_COST_CATEGORY_ID NUMBER;
30   P_L_START_DATE DATE;
31   P_L_END_DATE DATE;
32   P_CATEGORY_STRUCTURE_ID NUMBER;
33   FORMULA_NOCP VARCHAR2(40);
34   FORMULA_VERCP VARCHAR2(40);
35   ROUTING_NOCP VARCHAR2(40);
36   ROUTING_VERCP VARCHAR2(40);
37   FORMULA_NO1CP VARCHAR2(40);
38   FORMULA_VER1CP VARCHAR2(40);
39   ROUTING_NO1CP VARCHAR2(40);
40   ROUTING_VER1CP VARCHAR2(40);
41   COSTCATEGORYCP VARCHAR2(700);
42   ITEMCP VARCHAR2(800);
43   ORGANIZATIONCP VARCHAR2(800);
44   REPORT_TYPECP VARCHAR2(800);
45   ORDERCP VARCHAR2(100) := 'ic.item_number,mp.organization_code';
46   ORDER1CP VARCHAR2(200) := 'ic.item_number, mp.organization_code, mst.cost_cmpntcls_code,dtl.cost_analysis_code';
47   PERIOD_STATUS VARCHAR2(20);
48   DATESCP VARCHAR2(100):=' ';
49   FUNCTION ORGANIZATIONCFFORMULA RETURN VARCHAR2;
50   FUNCTION ORGANIZATIONCPFORMULA(ORGANIZATIONCF IN VARCHAR2) RETURN VARCHAR2;
51   FUNCTION REPORT_TYPECPFORMULA(REPORT_TYPECF IN VARCHAR2) RETURN VARCHAR2;
52   FUNCTION REPORT_TYPECFFORMULA RETURN VARCHAR2;
53   FUNCTION ITEMCPFORMULA(ITEMCF IN VARCHAR2) RETURN VARCHAR2;
54   FUNCTION ITEMCFFORMULA RETURN VARCHAR2;
55   --FUNCTION COSTCATEGORYCPFORMULA(COSTCATEGORYCF IN VARCHAR2) RETURN VARCHAR2;
56   FUNCTION COSTCATEGORYCFFORMULA RETURN VARCHAR2;
57   FUNCTION FORMULA_NOCPFORMULA(SUM_FORMULACF IN VARCHAR2) RETURN VARCHAR2;
58   FUNCTION FORMULA_VERCPFORMULA(SUM_FORMULACF IN VARCHAR2) RETURN VARCHAR2;
59   FUNCTION ROUTING_NOCPFORMULA(SUM_FORMULACF IN VARCHAR2) RETURN VARCHAR2;
60   FUNCTION ROUTING_VERCPFORMULA(SUM_FORMULACF IN VARCHAR2) RETURN VARCHAR2;
61   FUNCTION G_CMGLR_SUMMARYGROUPFILTER RETURN BOOLEAN;
62   FUNCTION G_CMGLR_DTLGROUPFILTER RETURN BOOLEAN;
63   FUNCTION SUM_FORMULACFFORMULA(FRM_ID IN NUMBER) RETURN VARCHAR2;
64   FUNCTION DET_FORMULACFFORMULA(FRM_ID_DTL IN NUMBER) RETURN VARCHAR2;
65   FUNCTION AFTERPFORM RETURN BOOLEAN;
66   FUNCTION ORDERCFFORMULA RETURN VARCHAR2;
67   FUNCTION ORDER1CFFORMULA RETURN VARCHAR2;
68   PROCEDURE GMF_CMRGLR_XMLP_PKG_HEADER;
69   FUNCTION BEFOREREPORT RETURN BOOLEAN;
70   FUNCTION AFTERREPORT RETURN BOOLEAN;
71   FUNCTION ORDERCPFORMULA(ORDERCF IN VARCHAR2) RETURN CHAR;
72   FUNCTION ORDER1CPFORMULA(ORDER1CF IN VARCHAR2) RETURN CHAR;
73   FUNCTION CF_COST_MTHDFORMULA RETURN CHAR;
74   FUNCTION CF_LEGAL_ENTITYFORMULA RETURN CHAR;
75   FUNCTION PERIOD_IDFORMULA RETURN NUMBER;
76   FUNCTION DATESCPFORMULA(DATESCF IN VARCHAR2) RETURN CHAR;
77   FUNCTION DATESCFFORMULA RETURN VARCHAR2;
78   FUNCTION BEFOREPFORM RETURN BOOLEAN;
79   FUNCTION FORMULA_NOCP_P RETURN VARCHAR2;
80   FUNCTION FORMULA_VERCP_P RETURN VARCHAR2;
81   FUNCTION ROUTING_NOCP_P RETURN VARCHAR2;
82   FUNCTION ROUTING_VERCP_P RETURN VARCHAR2;
83   FUNCTION FORMULA_NO1CP_P RETURN VARCHAR2;
84   FUNCTION FORMULA_VER1CP_P RETURN VARCHAR2;
85   FUNCTION ROUTING_NO1CP_P RETURN VARCHAR2;
86   FUNCTION ROUTING_VER1CP_P RETURN VARCHAR2;
87   FUNCTION COSTCATEGORYCP_P RETURN VARCHAR2;
88   FUNCTION ITEMCP_P RETURN VARCHAR2;
89   FUNCTION ORGANIZATIONCP_P RETURN VARCHAR2;
90   FUNCTION REPORT_TYPECP_P RETURN VARCHAR2;
91   FUNCTION ORDERCP_P RETURN VARCHAR2;
92   FUNCTION ORDER1CP_P RETURN VARCHAR2;
93   FUNCTION PERIOD_STATUS_P RETURN VARCHAR2;
94   FUNCTION DATESCP_P RETURN VARCHAR2;
95 END GMF_CMRGLR_XMLP_PKG;
96