PACKAGE: APPS.WIP_WIPTRTXN_XMLP_PKG

Source

1 PACKAGE WIP_WIPTRTXN_XMLP_PKG AS
2 /* $Header: WIPTRTXNS.pls 120.1 2008/01/31 13:09:42 npannamp noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_FLEXDATA VARCHAR2(850);
8 
9   P_SORT NUMBER;
10 
11   P_SHOW_DETAILS NUMBER;
12 
13   P_FROM_DATE DATE;
14 
15   P_TO_DATE DATE;
16 
17   P_FROM_DATE1 varchar2(25);
18 
19   P_TO_DATE1 varchar2(25);
20 
21 
22   P_FROM_EMPLOYEE VARCHAR2(240);
23 
24   P_TO_EMPLOYEE VARCHAR2(240);
25 
26   P_FROM_JOB VARCHAR2(40);
27 
28   P_TO_JOB VARCHAR2(40);
29 
30   P_FROM_LINE VARCHAR2(10);
31 
32   P_TO_LINE VARCHAR2(10);
33 
34   P_FROM_REASON VARCHAR2(30);
35 
36   P_TO_REASON VARCHAR2(30);
37 
38   P_FROM_ACTIVITY VARCHAR2(10);
39 
40   P_TO_ACTIVITY VARCHAR2(10);
41 
42   P_FLEXWHERE VARCHAR2(2400);
43 
44   P_TO_ASSEMBLY VARCHAR2(850);
45 
46   P_FROM_ASSEMBLY VARCHAR2(850);
47 
48   P_QTY_PRECISION NUMBER;
49 
50   P_FROM_RESOURCE VARCHAR2(10);
51 
52   P_TO_RESOURCE VARCHAR2(10);
53 
54   P_DEBUG NUMBER;
55 
56   FUNCTION BEFOREREPORT RETURN BOOLEAN;
57 
58   FUNCTION LIMIT_DATES RETURN CHARACTER;
59 
60   FUNCTION LIMIT_EMPLOYEES RETURN CHARACTER;
61 
62   FUNCTION LIMIT_JOBS RETURN CHARACTER;
63 
64   FUNCTION LIMIT_LINES RETURN CHARACTER;
65 
66   FUNCTION LIMIT_REASONS RETURN CHARACTER;
67 
68   FUNCTION LIMIT_ACTIVITIES RETURN CHARACTER;
69 
70   FUNCTION LIMIT_EMPLOYEE RETURN CHARACTER;
71 
72   FUNCTION C_LIMIT_DATESFORMULA RETURN VARCHAR2;
73 
74   FUNCTION C_LIMIT_ACTIVITIESFORMULA RETURN VARCHAR2;
75 
76   FUNCTION C_LIMIT_REASONSFORMULA RETURN VARCHAR2;
77 
78   FUNCTION C_LIMIT_LINESFORMULA RETURN VARCHAR2;
79 
80   FUNCTION C_LIMIT_JOBSFORMULA RETURN VARCHAR2;
81 
82   FUNCTION C_LIMIT_ASSEMBLIESFORMULA RETURN VARCHAR2;
83 
84   FUNCTION AFTERREPORT RETURN BOOLEAN;
85 
86   FUNCTION C_FLEX_MASTER_SORTFORMULA(C_FLEX_MASTER_SORT IN VARCHAR2) RETURN VARCHAR2;
87 
88   FUNCTION LIMIT_RESOURCE RETURN CHARACTER;
89 
90   FUNCTION AFTERPFORM RETURN BOOLEAN;
91 
92 END WIP_WIPTRTXN_XMLP_PKG;
93