PACKAGE: APPS.ONT_OEXOHHSA_XMLP_PKG

Source

1 PACKAGE ONT_OEXOHHSA_XMLP_PKG AS
2 /* $Header: OEXOHHSAS.pls 120.1 2007/12/25 07:29:39 npannamp noship $ */
3   P_SOB_ID NUMBER;
4 
5   P_HOLD_NAME_LO VARCHAR2(30);
6 
7   P_HOLD_NAME_HI VARCHAR2(30);
8 
9   P_CONC_REQUEST_ID NUMBER := 0;
10 
11   P_ACTIVITY_DATE_LO DATE;
12   P_ACTIVITY_DATE_LO_V varchar2(40);
13   P_ACTIVITY_DATE_HI_V varchar2(40);
14   P_ACTIVITY_DATE_HI DATE;
15 
16   P_ACTIVITY VARCHAR2(40);
17 
18   P_HOLD_TYPE_LO VARCHAR2(40);
19 
20   P_HOLD_TYPE_HI VARCHAR2(40);
21 
22   P_ORGANIZATION_ID NUMBER;
23   P_ORGANIZATION_ID_V NUMBER;
24 
25   --LP_ACTIVITY_DATE_WHERE VARCHAR2(500);
26   LP_ACTIVITY_DATE_WHERE VARCHAR2(500):=' ';
27 
28   --LP_ACTIVITY_TYPE_WHERE VARCHAR2(240);
29   LP_ACTIVITY_TYPE_WHERE VARCHAR2(240):= ' ';
30 
31   LP_HOLD_WHERE VARCHAR2(200);
32 
33   LP_HOLD_TYPE_WHERE VARCHAR2(240);
34 
35   FUNCTION SOB_NAMEFORMULA RETURN VARCHAR2;
36 
37   FUNCTION BEFOREREPORT RETURN BOOLEAN;
38 
39   FUNCTION AFTERREPORT RETURN BOOLEAN;
40 
41   FUNCTION C_ACTIVITY_MEANINGFORMULA RETURN VARCHAR2;
42 
43   FUNCTION C_HOLD_TYPE_WHERE RETURN VARCHAR2;
44 
45   FUNCTION C_HOLD_NAME_WHERE RETURN VARCHAR2;
46 
47   FUNCTION C_ENTITY_VALUE(OBJECT_TYPE_CODE IN VARCHAR2
48                          ,OBJECT_ID IN NUMBER) RETURN VARCHAR2;
49 
50   FUNCTION AFTERPFORM RETURN BOOLEAN;
51 
52   FUNCTION C_ENTITY_VALUE2(OBJECT_TYPE_CODE2 IN VARCHAR2
53                           ,OBJECT_ID2 IN NUMBER) RETURN VARCHAR2;
54 
55 END ONT_OEXOHHSA_XMLP_PKG;
56 
57