DBA Data[Home] [Help]

PACKAGE: APPS.WIP_WIPREDAT_XMLP_PKG

Source


1 PACKAGE WIP_WIPREDAT_XMLP_PKG AS
2 /* $Header: WIPREDATS.pls 120.1 2008/01/31 12:33:38 npannamp noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_ORG_ID NUMBER;
6 
7   P_CMPL_LOCATOR VARCHAR2(500);
8 
9   P_MTL_VAL_ACCT VARCHAR2(700);
10 
11   P_MTL_OH_VAL_ACCT VARCHAR2(700);
12 
13   P_RES_VAL_ACCT VARCHAR2(700);
14 
15   P_OUT_PROC_VAL_ACCT VARCHAR2(700);
16 
17   P_OH_VAL_ACCT VARCHAR2(700);
18 
19   P_MTL_VARIANCE VARCHAR2(700);
20 
21   P_STD_COST_VARIANCE VARCHAR2(700);
22 
23   P_RES_VARIANCE VARCHAR2(700);
24 
25   P_OUT_PROC_VARIANCE VARCHAR2(700);
26 
27   P_OH_VARIANCE VARCHAR2(700);
28 
29   P_COMPONENT_ITEM VARCHAR2(500);
30 
31   P_SUPPLY_LOCATOR VARCHAR2(500);
32 
33   P_FROM_ASSEMBLY VARCHAR2(850);
34 
35   P_TO_ASSEMBLY VARCHAR2(850);
36 
37   P_TO_LINE VARCHAR2(40);
38 
39   P_FROM_LINE VARCHAR2(40);
40 
41   P_ITEM_GRP_BY VARCHAR2(500);
42 
43   P_FROM_START_DATE DATE;
44 
45   P_TO_START_DATE DATE;
46 
47   P_QTY_PRECISION NUMBER;
48 
49   CHART_OF_ACCOUNTS_ID_DEF NUMBER;
50 
51   P_STATUS_LIMITER VARCHAR2(240);
52 
53   P_DEBUG VARCHAR2(1);
54 
55   function get_precision(qty_precision in number) return VARCHAR2;
56 
57   FUNCTION BEFOREREPORT RETURN BOOLEAN;
58 
59   FUNCTION AFTERREPORT RETURN BOOLEAN;
60 
61   FUNCTION LINE_LIMITER RETURN CHARACTER;
62 
63   FUNCTION ASSEMBLY_LIMITER RETURN CHARACTER;
64 
65   FUNCTION FUS_DATE_LIMITER RETURN CHARACTER;
66 
67   FUNCTION C_STATUS_LIMITERFORMULA RETURN VARCHAR2;
68 
69   FUNCTION AFTERPFORM RETURN BOOLEAN;
70 
71 END WIP_WIPREDAT_XMLP_PKG;
72