PACKAGE: APPS.RLM_RLMDMCOM_XMLP_PKG

Source

1 PACKAGE RLM_RLMDMCOM_XMLP_PKG AS
2 /* $Header: RLMDMCOMS.pls 120.0 2008/01/25 09:37:02 krreddy noship $ */
3   P_SCHEDULE_TYPE VARCHAR2(80);
4 
5   P_SHIP_FROM_ORG_ID NUMBER;
6 
7   P_CUSTOMER_NAME_FROM VARCHAR2(150);
8 
9   P_CUSTOMER_NAME_TO VARCHAR2(150);
10 
11   P_CUSTOMER_ITEM_FROM VARCHAR2(50);
12 
13   P_CUSTOMER_ITEM_TO VARCHAR2(50);
14 
15   P_INTERNAL_ITEM_FROM VARCHAR2(50);
16 
17   P_TP_CODE_FROM VARCHAR2(50);
18 
19   P_TP_CODE_TO VARCHAR2(50);
20 
21   P_TP_LOCATION_FROM VARCHAR2(50);
22 
23   P_TP_LOCATION_TO VARCHAR2(35);
24 
25   P_ISSUE_DATE_FROM VARCHAR2(32767);
26 
27   P_ISSUE_DATE_TO VARCHAR2(32767);
28 
29   P_PROCESS_DATE_FROM VARCHAR2(32767);
30 
31   P_PROCESS_DATE_TO VARCHAR2(32767);
32 
33   P_REQUEST_DATE_FROM VARCHAR2(32767);
34 
35   P_REQUEST_DATE_TO VARCHAR2(32767);
36 
37   P_INTERNAL_ITEM_TO VARCHAR2(50);
38 
39   P_DEMAND_TYPE VARCHAR2(32767);
40 
41   P_SCHEDULE_REFERENCE_NUM VARCHAR2(35);
42 
43   P_SEQ_MATCH_ATTRIBUTE VARCHAR2(150);
44 
45   P_TITLE VARCHAR2(150);
46 
47   P_DISCREPANCIES_ONLY VARCHAR2(32767);
48 
49   P_SHIP_TO NUMBER;
50 
51   P_ORG_ID NUMBER;
52 
53   P_CONC_REQUEST_ID NUMBER;
54 
55   CP_SEQ_MATCH_LABEL VARCHAR2(240);
56 
57   CP_SEQ_COLUMN VARCHAR2(35);
58 
59   CP_P_SCHEDULE_TYPE VARCHAR2(240);
60 
61   CP_P_SHIP_TO VARCHAR2(50);
62 
63   CP_P_SEQ_MATCH_LABEL VARCHAR2(240);
64 
65   CP_P_DEMAND_TYPE VARCHAR2(120);
66 
67   CP_P_DISCREPANCIES_ONLY VARCHAR2(20);
68 
69   CP_P_SCHEDULE_REF_NUM VARCHAR2(35);
70 
71   CP_P_SHIP_FROM VARCHAR2(80);
72 
73   CP_DEFAULT_OU VARCHAR2(240);
74 
75   FUNCTION BEFOREREPORT RETURN BOOLEAN;
76 
77   FUNCTION CF_SHIP_FROM_ORG_IDFORMULA(SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR;
78 
79   FUNCTION CF_SHIP_TOFORMULA(SHIP_TO_ADDRESS_ID IN NUMBER) RETURN CHAR;
80 
81   FUNCTION CF_PRE_HORIZON_DISP_CODEFORMUL(PREHORIZON_DESPOSITION_CODE IN VARCHAR2) RETURN CHAR;
82 
83   FUNCTION CF_INTRANSIT_CALC_BASISFORMULA(INTRANSIT_CALC_BASIS IN VARCHAR2) RETURN CHAR;
84 
85   FUNCTION CF_MATCH_SEQFORMULA(CUSTOMER_ITEM_REVISION IN VARCHAR2
86                               ,CUSTOMER_DOCK_CODE IN VARCHAR2
87                               ,CUSTOMER_JOB IN VARCHAR2
88                               ,CUST_PRODUCTION_LINE IN VARCHAR2
89                               ,CUST_MODEL_SERIAL_NUMBER IN VARCHAR2
90                               ,SCH_PO_NUMBER IN VARCHAR2
91                               ,CUST_PRODUCTION_SEQ_NUM IN VARCHAR2
92                               ,RECORD_YEAR IN VARCHAR2
93                               ,CUSTOMER_REQUEST_DATE IN VARCHAR2
94                               ,PULL_SIGNAL_REF_NUM IN VARCHAR2
95                               ,PULL_SIGNAL_START_SERIAL_NUM IN VARCHAR2
96                               ,PULL_SIGNAL_END_SERIAL_NUM IN VARCHAR2
97                               ,REQUEST_DATE_TIME IN DATE) RETURN CHAR;
98 
99   FUNCTION IS_SEQUENCED RETURN BOOLEAN;
100 
101   FUNCTION IS_NON_SEQUENCED RETURN BOOLEAN;
102 
103   FUNCTION CF_ORDERNUMFORMULA(ORDER_NUMBER IN NUMBER) RETURN NUMBER;
104 
105   FUNCTION CF_CUSTOMER_NUMBER_MEANFORMULA(CUSTOMER_NUMBER IN NUMBER) RETURN CHAR;
106 
107   FUNCTION CF_FROZEN_FLAGFORMULA(FROZEN_FLAG IN VARCHAR2) RETURN CHAR;
108 
109   FUNCTION CF_TIME_UOM_CODEFORMULA(TIME_UOM_CODE IN VARCHAR2) RETURN CHAR;
110 
111   FUNCTION CF_EXCLUDE_NONWORKDAYSFORMULA(EXCLUDE_NON_WORKDAYS_FLAG IN VARCHAR2) RETURN CHAR;
112 
113   FUNCTION AFTERREPORT RETURN BOOLEAN;
114 
115   FUNCTION CP_SEQ_MATCH_LABEL_P RETURN VARCHAR2;
116 
117   FUNCTION CP_SEQ_COLUMN_P RETURN VARCHAR2;
118 
119   FUNCTION CP_P_SCHEDULE_TYPE_P RETURN VARCHAR2;
120 
121   FUNCTION CP_P_SHIP_TO_P RETURN VARCHAR2;
122 
123   FUNCTION CP_P_SEQ_MATCH_LABEL_P RETURN VARCHAR2;
124 
125   FUNCTION CP_P_DEMAND_TYPE_P RETURN VARCHAR2;
126 
127   FUNCTION CP_P_DISCREPANCIES_ONLY_P RETURN VARCHAR2;
128 
129   FUNCTION CP_P_SCHEDULE_REF_NUM_P RETURN VARCHAR2;
130 
131   FUNCTION CP_P_SHIP_FROM_P RETURN VARCHAR2;
132 
133   FUNCTION CP_DEFAULT_OU_P RETURN VARCHAR2;
134 
135 END RLM_RLMDMCOM_XMLP_PKG;