PACKAGE: APPS.RLM_RLMDPDER_XMLP_PKG

Source

1 PACKAGE RLM_RLMDPDER_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RLMDPDERS.pls 120.0 2008/01/25 09:40:47 krreddy noship $ */
3   P_REQUEST_ID_FROM NUMBER;
4 
5   P_REQUEST_ID_TO NUMBER;
6 
7   P_SORT_BY VARCHAR2(80);
8 
9   P_ORDER_NUMBER_FROM NUMBER;
10 
11   P_ORDER_NUMBER_TO NUMBER;
12 
13   P_EXCEPTION_SEVERITY VARCHAR2(4);
14 
15   P_CUSTOMER_FROM VARCHAR2(60);
16 
17   P_CUSTOMER_TO VARCHAR2(60);
18 
19   P_ORDER_TYPE_FROM NUMBER;
20 
21   P_ORDER_TYPE_TO NUMBER;
22 
23   P_SHIP_FROM_ORG VARCHAR2(32767);
24 
25   P_TRADING_PARTNER_FROM VARCHAR2(30);
26 
27   P_TRADING_PARTNER_TO VARCHAR2(30);
28 
29   P_TP_LOCATION VARCHAR2(40);
30 
31   P_CUSTOMER_ITEM_FROM VARCHAR2(50);
32 
33   P_CUSTOMER_ITEM_TO VARCHAR2(50);
34 
35   P_ITEM_FROM VARCHAR2(50);
36 
37   P_ITEM_TO VARCHAR2(50);
38 
39   P_SCHEDULE_NUMBER_FROM VARCHAR2(35);
40 
41   P_SCHEDULE_NUMBER_TO VARCHAR2(35);
42 
43   P_MESSAGE_CATEGORY_FROM NUMBER;
44 
45   P_MESSAGE_CATEGORY_TO NUMBER;
46 
47   P_CREATION_DATE DATE;
48 
49   P_CREATION_DATE_TO DATE;
50 
51   P_OPTION_OF_DETAILS VARCHAR2(10);
52 
53   P_WHERE_CLAUSE VARCHAR2(2000);
54 
55   P_WHERE_CLAUSE1 VARCHAR2(2000);
56 
57   P_WHERE_CLAUSE2 VARCHAR2(2000);
58 
59   P_SORT_BY1 VARCHAR2(40);
60 
61   P_SORT_BY2 VARCHAR2(40);
62 
63   P_ORDER_BY VARCHAR2(40);
64 
65   P_ORDER_BY1 VARCHAR2(40);
66 
67   P_ORDER_BY2 VARCHAR2(40);
68 
69   P_ORG_ID NUMBER;
70 
71   P_ORDER_TYPE_NAME_FROM VARCHAR2(32767);
72 
73   P_ORDER_TYPE_NAME_TO VARCHAR2(32767);
74 
75   P_CONC_REQUEST_ID NUMBER;
76 
77   CP_DEFAULT_OU VARCHAR2(240);
78 
79   CP_ORG_ID NUMBER;
80 
81   FUNCTION BETWEENPAGE RETURN BOOLEAN;
82 
83   FUNCTION BEFOREPFORM RETURN BOOLEAN;
84 
85   FUNCTION BEFOREREPORT RETURN BOOLEAN;
86 
87   FUNCTION CF_QUANTITY_TYPEFORMULA(QTY_TYPE_CODE IN VARCHAR2) RETURN VARCHAR2;
88 
89   FUNCTION CF_ITEM_DETAIL_TYPEFORMULA(ITEM_DETAIL_TYPE IN VARCHAR2) RETURN VARCHAR2;
90 
91   FUNCTION CF_ITEM_DETAIL_SUBTYPEFORMULA(ITEM_DETAIL_SUBTYPE IN VARCHAR2) RETURN VARCHAR2;
92 
93   FUNCTION CF_ORDER_TYPEFORMULA(ORDER_TYPE_ID IN NUMBER) RETURN VARCHAR2;
94 
95   FUNCTION AFTERREPORT RETURN BOOLEAN;
96 
97   FUNCTION CF_SCHEDULE_TYPEFORMULA(SCHEDULE_TYPE IN VARCHAR2) RETURN VARCHAR2;
98 
99   FUNCTION CF_SCHEDULE_PURPOSEFORMULA(SCHEDULE_PURPOSE IN VARCHAR2) RETURN VARCHAR2;
100 
101   FUNCTION CF_SCHEDULE_SOURCEFORMULA(SCHEDULE_SOURCE IN VARCHAR2) RETURN VARCHAR2;
102 
103   FUNCTION CP_DEFAULT_OU_P RETURN VARCHAR2;
104 
105   FUNCTION CP_ORG_ID_P RETURN NUMBER;
106 
107 END RLM_RLMDPDER_XMLP_PKG;