PACKAGE: APPS.WIP_WIPDJDAT_XMLP_PKG

Source

1 PACKAGE WIP_WIPDJDAT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WIPDJDATS.pls 120.1.12020000.2 2012/07/18 07:46:11 ankohli ship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_ORG_ID NUMBER;
6 
7   P_ASSEMBLY VARCHAR2(2000);
8 
9   P_CMPL_LOCATOR VARCHAR2(500);
10 
11   P_BILL_REF VARCHAR2(500);
12 
13   p_item_flex_num number;
14 
15   P_ROUTING_REF VARCHAR2(500);
16 
17   P_MTL_VAL_ACCT VARCHAR2(700);
18 
19   P_MTL_OH_VAL_ACCT VARCHAR2(700);
20 
21   P_RES_VAL_ACCT VARCHAR2(700);
22 
23   P_OUT_PROC_VAL_ACCT VARCHAR2(700);
24 
25   P_OH_VAL_ACCT VARCHAR2(700);
26 
27   P_MTL_VARIANCE VARCHAR2(700);
28 
29   P_STD_COST_VARIANCE VARCHAR2(700);
30 
31   P_RES_VARIANCE VARCHAR2(700);
32 
33   P_OUT_PROC_VARIANCE VARCHAR2(700);
34 
35   P_OH_VARIANCE VARCHAR2(700);
36 
37   P_COMPONENT_ITEM VARCHAR2(500);
38 
39   P_SUPPLY_LOCATOR VARCHAR2(500);
40 
41   P_SALES_ORDER VARCHAR2(500);
42 
43   P_ITEM_GRP_BY VARCHAR2(300);
44 
45   P_FROM_JOB VARCHAR2(240);
46 
47   P_TO_JOB VARCHAR2(240);
48 
49   P_FROM_ASSEMBLY VARCHAR2(850);
50 
51   P_TO_ASSEMBLY VARCHAR2(850);
52 
53   P_FROM_START_DATE DATE;
54 
55   P_TO_START_DATE DATE;
56 
57   P_STATUS_LIMITER NUMBER;
58 
59   P_CLASS_LIMITER VARCHAR2(10);
60 
61   P_SO_ORDER_BY VARCHAR2(300);
62 
63   P_ITEM_WHERE VARCHAR2(10300);
64 
65   P_QTY_PRECISION NUMBER;
66 
67   CHART_OF_ACCOUNTS_ID_DEF NUMBER;
68 
69   P_DEBUG NUMBER;
70 
71   P_OUTER VARCHAR2(32767) := '(+)';
72 
73   P_SCHEDULE_GROUP_FROM VARCHAR2(30);
74 
75   P_SCHEDULE_GROUP_TO VARCHAR2(30);
76 
77   P_SORT_BY NUMBER;
78 
79   P_SG_OUTER VARCHAR2(5) := '(+)';
80 
81   P_OE_ONT_INSTALLED VARCHAR2(3) := 'OE';
82 
83   P_FND_ATTACHMENTS VARCHAR2(2000);
84 
85   P_ITEM_ATTACHMENTS VARCHAR2(2000);
86 
87   FUNCTION BEFOREREPORT RETURN BOOLEAN;
88 
89   FUNCTION AFTERREPORT RETURN BOOLEAN;
90 
91   FUNCTION JOB_LIMITER RETURN CHARACTER;
92 
93   FUNCTION DATE_LIMITER RETURN CHARACTER;
94 
95   FUNCTION C_ASSEMBLY_LIMITERFORMULA RETURN VARCHAR2;
96 
97   FUNCTION AFTERPFORM RETURN BOOLEAN;
98 
99   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
100 
101   FUNCTION C_LIMITER RETURN VARCHAR2;
102 
103 END WIP_WIPDJDAT_XMLP_PKG;
104