PACKAGE: APPS.EAM_EAMMIPCK_XMLP_PKG

Source

1 PACKAGE EAM_EAMMIPCK_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: EAMMIPCKS.pls 120.0 2007/12/28 10:47:56 dwkrishn noship $ */
3   P_WHERE_CLAUSE VARCHAR2(1000) := '1=1';
4  P_ORG_ID_V boolean;
5 
6   P_WHERE_CLAUSE1 VARCHAR2(1000);
7 
8   P_ORG_ID NUMBER;
9 
10   P_REQUEST_NUMBER_START NUMBER;
11 
12   P_REQUEST_NUMBER_END NUMBER;
13 
14   P_DATE_REQUIRED_START DATE;
15 
16   P_DATE_REQUIRED_END DATE;
17 
18   P_SOURCE_SUBINVENTORY VARCHAR2(200);
19 
20   P_SOURCE_LOCATOR NUMBER;
21 
22   P_REQUESTER VARCHAR2(32767);
23 
24   P_WORK_ORDER NUMBER;
25 
26   P_MATERIAL NUMBER;
27 
28   P_ORG_NAME VARCHAR2(32767);
29 
30   P_ORDER_BY VARCHAR2(50) := 'mrl.request_number';
31 
32   P_ORDER_BY_USED NUMBER;
33 
34   P_WORK_ORDER_NAME VARCHAR2(240);
35 
36   P_MATERIAL_NAME VARCHAR2(2000);
37 
38   P_ORDER_BY_DISP VARCHAR2(100);
39 
40   P_SOURCE_LOCATOR_NAME VARCHAR2(2000);
41 
42   P_REQUESTER_NAME VARCHAR2(240);
43 
44   P_CONC_REQUEST_ID NUMBER;
45 
46   FUNCTION CF_REASONFORMULA RETURN CHAR;
47 
48   FUNCTION CF_QTY_PICKEDFORMULA RETURN CHAR;
49 
50   FUNCTION BEFOREREPORT RETURN BOOLEAN;
51 
52   FUNCTION P_ORG_IDVALIDTRIGGER RETURN BOOLEAN;
53 
54   FUNCTION CF_REFFORMULA RETURN CHAR;
55 
56   FUNCTION P_WORK_ORDERVALIDTRIGGER RETURN BOOLEAN;
57 
58   FUNCTION P_MATERIALVALIDTRIGGER RETURN BOOLEAN;
59 
60   FUNCTION P_ORDER_BY_USEDVALIDTRIGGER RETURN BOOLEAN;
61 
62   FUNCTION P_SOURCE_LOCATORVALIDTRIGGER RETURN BOOLEAN;
63 
64   FUNCTION AFTERREPORT RETURN BOOLEAN;
65 
66 END EAM_EAMMIPCK_XMLP_PKG;
67 
68