[Home] [Help]
PACKAGE: APPS.ONT_OEXAUDHR_XMLP_PKG
Source
1 PACKAGE ONT_OEXAUDHR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXAUDHRS.pls 120.1 2007/12/25 07:08:55 npannamp noship $ */
3 P_ATTRIBUTE_ID NUMBER;
4
5 P_ORDER_FROM NUMBER;
6
7 P_START_DATE DATE;
8
9 LP_START_DATE varchar2(30);
10
11 P_END_DATE DATE;
12
13 LP_END_DATE varchar2(30);
14
15 P_WHERE VARCHAR2(1000):=' ';
16
17 P_ENTITY_ID NUMBER;
18
19 P_CONC_REQUEST_ID NUMBER;
20
21 P_USER_ID NUMBER;
22
23 P_SOB_ID NUMBER;
24
25 P_RESP_ID NUMBER;
26
27 P_ORDER_TO NUMBER;
28
29 CP_NO_DATA_FOUND NUMBER;
30
31 CP_ATTRIBUTE_NAME VARCHAR2(50);
32
33 CP_ENTITY_NAME VARCHAR2(50);
34
35 CP_REPORT_NAME VARCHAR2(50);
36
37 CP_USER_NAME VARCHAR2(50);
38
39 CP_RESPONSIBILITY_NAME VARCHAR2(240);
40
41 RP_COMPANY_NAME VARCHAR2(240);
42
43 FUNCTION AFTERPFORM RETURN BOOLEAN;
44
45 FUNCTION CF_NO_DATA_FOUND1FORMULA(ORDER_NUMBER1 IN NUMBER) RETURN NUMBER;
46
47 FUNCTION BEFOREREPORT RETURN BOOLEAN;
48
49 FUNCTION CF_1FORMULA(EID IN NUMBER
50 ,LINEID1 IN NUMBER) RETURN VARCHAR2;
51
52 FUNCTION AFTERREPORT RETURN BOOLEAN;
53
54 FUNCTION CP_NO_DATA_FOUND_P RETURN NUMBER;
55
56 FUNCTION CP_ATTRIBUTE_NAME_P RETURN VARCHAR2;
57
58 FUNCTION CP_ENTITY_NAME_P RETURN VARCHAR2;
59
60 FUNCTION CP_REPORT_NAME_P RETURN VARCHAR2;
61
62 FUNCTION CP_USER_NAME_P RETURN VARCHAR2;
63
64 FUNCTION CP_RESPONSIBILITY_NAME_P RETURN VARCHAR2;
65
66 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
67
68 END ONT_OEXAUDHR_XMLP_PKG;
69