PACKAGE: APPS.WIP_WIPPURGE_XMLP_PKG

Source

1 PACKAGE WIP_WIPPURGE_XMLP_PKG AS
2 /* $Header: WIPPURGES.pls 120.2 2008/01/31 12:31:40 npannamp noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_FLEXDATA VARCHAR2(850);
8 
9   P_DEBUG NUMBER;
10 
11   P_GROUP_ID NUMBER;
12   P_GROUP_ID_V NUMBER;
13 
14   P_REPORT_OPTION NUMBER;
15 
16   P_PURGE_TYPE NUMBER;
17 
18   P_FROM_JOB VARCHAR2(40);
19 
20   P_TO_JOB VARCHAR2(40);
21 
22   P_PRIMARY_ITEM_ID NUMBER;
23 
24   P_LINE_ID NUMBER;
25 
26   P_CONF_FLAG NUMBER;
27 
28   P_HEADER_FLAG NUMBER;
29 
30   P_DETAIL_FLAG NUMBER;
31 
32   P_MOVE_TXN_FLAG NUMBER;
33 
34   P_COST_TRX_FLAG NUMBER;
35 
36   P_OPTION NUMBER;
37 
38   P_CUTOFF_DATE DATE;
39 
40   P_ERR_NUM NUMBER := 0;
41 
42   P_ERROR_TEXT VARCHAR2(500);
43 
44   P_MAX_DATE DATE;
45 
46   P_CUTOFF_DATE_CLIENT DATE;
47 
48  P_CUTOFF_DATE_DISP VARCHAR2(30);
49 
50   P_DAYS_BEFORE_CUTOFF NUMBER;
51 
52   FUNCTION BEFOREREPORT RETURN BOOLEAN;
53 
54   FUNCTION AFTERREPORT RETURN BOOLEAN;
55 
56   FUNCTION AFTERPFORM RETURN BOOLEAN;
57 
58   FUNCTION G_JOB_LINE_TABGROUPFILTER RETURN BOOLEAN;
59 
60   FUNCTION G_JOB_LINE_INFOGROUPFILTER RETURN BOOLEAN;
61 
62   FUNCTION G_EXCEPTION_INFOGROUPFILTER RETURN BOOLEAN;
63 
64   FUNCTION G_SUCCESS_INFOGROUPFILTER RETURN BOOLEAN;
65 
66   FUNCTION PURGE(P_PURGE_TYPE IN NUMBER
67                 ,P_GROUP_ID IN NUMBER
68                 ,P_ORG_ID IN NUMBER
69                 ,P_CUTOFF_DATE IN DATE
70                 ,P_FROM_JOB IN VARCHAR2
71                 ,P_TO_JOB IN VARCHAR2
72                 ,P_PRIMARY_ITEM_ID IN NUMBER
73                 ,P_LINE_ID IN NUMBER
74                 ,P_OPTION IN NUMBER
75                 ,P_CONF_FLAG IN BOOLEAN
76                 ,P_HEADER_FLAG IN BOOLEAN
77                 ,P_DETAIL_FLAG IN BOOLEAN
78                 ,P_MOVE_TRX_FLAG IN BOOLEAN
79                 ,P_COST_TRX_FLAG IN BOOLEAN
80                 ,P_ERR_NUM IN OUT NOCOPY NUMBER
81                 ,P_ERROR_TEXT IN OUT NOCOPY VARCHAR2) RETURN NUMBER;
82 
83 END WIP_WIPPURGE_XMLP_PKG;
84