1 PACKAGE RLM_VALIDATEDEMAND_SV AUTHID CURRENT_USER as
2 /* $Header: RLMDPVDS.pls 120.2.12000000.1 2007/01/18 18:32:00 appldev ship $*/
3 --<TPA_PUBLIC_NAME=RLM_TPA_SV>
4 --<TPA_PUBLIC_FILE_NAME=RLMTPDP>
5
6 /*===========================================================================
7 PACKAGE NAME: RLM_VALIDATEDEMAND_SV
8
9 DESCRIPTION: Contains all server side code for the rla validate-demand.
10
11 CLIENT/SERVER: Server
12
13 LIBRARY NAME: None
14
15 OWNER: mnandell
16
17 PROCEDURE/FUNCTIONS:
18
19 GLOBALS: g_LineId
20 g_Lines_Tab
21 g_SDEBUG
22 g_TDEBUG
23 g_DEBUG
24
25 ===========================================================================*/
26
27 -- the t_line_rec includes all the attributes which are part of the
28 -- rlm_interface_Lines table. We could have used just the %ROWTYPE but
29 -- in order to revalidate after the sourcing rules have been applied we
30 -- we need another column line_source which will have values
31 -- k_original_line and k_mrp_sourced
32 -- if mrp_sourced then the derive ids will be called again and the
33 -- shipfrom orgs and purchase order number and other ids dependent on
34 -- ship from will be recalculated
35 --
36 -- KEEP IN MIND
37 -- if there is a change in the datamodel additions to interface_lines table
38 -- this record will have to be changed
39 --
40 t_lines_rec RLM_INTERFACE_LINES%ROWTYPE;
41
42 TYPE t_Lines_Tab IS TABLE OF RLM_INTERFACE_LINES%ROWTYPE INDEX BY BINARY_INTEGER;
43
44 TYPE g_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
45
46
47 TYPE AGREEMENT_ID_T IS TABLE OF RLM_INTERFACE_LINES.AGREEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
48 TYPE ATO_DATA_TYPE_T IS TABLE OF RLM_INTERFACE_LINES.ATO_DATA_TYPE%TYPE INDEX BY BINARY_INTEGER;
49 TYPE BILL_TO_ADDRESS_1_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_ADDRESS_1_EXT%TYPE INDEX BY BINARY_INTEGER;
50 TYPE BILL_TO_ADDRESS_2_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_ADDRESS_2_EXT%TYPE INDEX BY BINARY_INTEGER;
51 TYPE BILL_TO_ADDRESS_3_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_ADDRESS_3_EXT%TYPE INDEX BY BINARY_INTEGER;
52 TYPE BILL_TO_ADDRESS_4_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_ADDRESS_4_EXT%TYPE INDEX BY BINARY_INTEGER;
53 TYPE BILL_TO_ADDRESS_ID_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;
54 TYPE INVOICE_TO_ORG_ID_T IS TABLE OF RLM_INTERFACE_LINES.INVOICE_TO_ORG_ID %TYPE INDEX BY BINARY_INTEGER;
55 TYPE BILL_TO_CITY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_CITY_EXT%TYPE INDEX BY BINARY_INTEGER;
56 TYPE BILL_TO_COUNTRY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_COUNTRY_EXT%TYPE INDEX BY BINARY_INTEGER;
57 TYPE BILL_TO_COUNTY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_COUNTY_EXT%TYPE INDEX BY BINARY_INTEGER;
58 TYPE BILL_TO_NAME_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_NAME_EXT%TYPE INDEX BY BINARY_INTEGER;
59 TYPE BILL_TO_POSTAL_CD_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_POSTAL_CD_EXT%TYPE INDEX BY BINARY_INTEGER;
60 TYPE BILL_TO_PROVINCE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_PROVINCE_EXT%TYPE INDEX BY BINARY_INTEGER;
61 TYPE BILL_TO_SITE_USE_ID_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
62 TYPE BILL_TO_STATE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.BILL_TO_STATE_EXT%TYPE INDEX BY BINARY_INTEGER;
63 TYPE CARRIER_ID_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CARRIER_ID_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
64 TYPE CARRIER_QUALIFIER_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CARRIER_QUALIFIER_EXT%TYPE INDEX BY BINARY_INTEGER;
65 TYPE COMMODITY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.COMMODITY_EXT%TYPE INDEX BY BINARY_INTEGER;
66 TYPE COUNTRY_OF_ORIGIN_EXT_T IS TABLE OF RLM_INTERFACE_LINES.COUNTRY_OF_ORIGIN_EXT%TYPE INDEX BY BINARY_INTEGER;
67 TYPE CUST_ASSEMBLY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_ASSEMBLY_EXT%TYPE INDEX BY BINARY_INTEGER;
68 TYPE CUST_ASSIGNED_ID_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_ASSIGNED_ID_EXT%TYPE INDEX BY BINARY_INTEGER;
69 TYPE CUST_BILL_TO_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_BILL_TO_EXT%TYPE INDEX BY BINARY_INTEGER;
70 TYPE CUST_CONTRACT_NUM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_CONTRACT_NUM_EXT%TYPE INDEX BY BINARY_INTEGER;
71 TYPE CUSTOMER_DOCK_CODE_T IS TABLE OF RLM_INTERFACE_LINES.CUSTOMER_DOCK_CODE%TYPE INDEX BY BINARY_INTEGER;
72 TYPE CUST_INTRMD_SHIP_TO_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_INTRMD_SHIP_TO_EXT%TYPE INDEX BY BINARY_INTEGER;
73 TYPE CUST_ITEM_PRICE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_ITEM_PRICE_EXT%TYPE INDEX BY BINARY_INTEGER;
74 TYPE CUST_ITEM_PRICE_UOM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_ITEM_PRICE_UOM_EXT%TYPE INDEX BY BINARY_INTEGER;
75 TYPE CUSTOMER_ITEM_REVISION_T IS TABLE OF RLM_INTERFACE_LINES.CUSTOMER_ITEM_REVISION%TYPE INDEX BY BINARY_INTEGER;
76 TYPE CUSTOMER_JOB_T IS TABLE OF RLM_INTERFACE_LINES.CUSTOMER_JOB%TYPE INDEX BY BINARY_INTEGER;
77 TYPE CUST_MANUFACTURER_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_MANUFACTURER_EXT%TYPE INDEX BY BINARY_INTEGER;
78 TYPE CUST_MODEL_NUMBER_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_MODEL_NUMBER_EXT%TYPE INDEX BY BINARY_INTEGER;
79 TYPE CUST_MODEL_SERIAL_NUMBER_T IS TABLE OF RLM_INTERFACE_LINES.CUST_MODEL_SERIAL_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80 TYPE CUST_ORDER_NUM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_ORDER_NUM_EXT%TYPE INDEX BY BINARY_INTEGER;
81 TYPE CUST_PROCESS_NUM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_PROCESS_NUM_EXT%TYPE INDEX BY BINARY_INTEGER;
82 TYPE CUST_SET_NUM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_SET_NUM_EXT%TYPE INDEX BY BINARY_INTEGER;
83 TYPE CUST_SHIP_FROM_ORG_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_SHIP_FROM_ORG_EXT%TYPE INDEX BY BINARY_INTEGER;
84 TYPE CUST_SHIP_TO_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_SHIP_TO_EXT%TYPE INDEX BY BINARY_INTEGER;
85 TYPE CUST_UOM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUST_UOM_EXT%TYPE INDEX BY BINARY_INTEGER;
86 TYPE CUSTOMER_ITEM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.CUSTOMER_ITEM_EXT%TYPE INDEX BY BINARY_INTEGER;
87 TYPE CUSTOMER_ITEM_ID_T IS TABLE OF RLM_INTERFACE_LINES.CUSTOMER_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
88 TYPE REQUEST_DATE_T IS TABLE OF RLM_INTERFACE_LINES.REQUEST_DATE%TYPE INDEX BY BINARY_INTEGER;
89 TYPE SCHEDULE_DATE_T IS TABLE OF RLM_INTERFACE_LINES.SCHEDULE_DATE%TYPE INDEX BY BINARY_INTEGER;
90 TYPE DATE_TYPE_CODE_T IS TABLE OF RLM_INTERFACE_LINES.DATE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
91 TYPE DATE_TYPE_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.DATE_TYPE_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
92 TYPE DELIVERY_LEAD_TIME_T IS TABLE OF RLM_INTERFACE_LINES.DELIVERY_LEAD_TIME%TYPE INDEX BY BINARY_INTEGER;
93 TYPE END_DATE_TIME_T IS TABLE OF RLM_INTERFACE_LINES.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
94 TYPE EQUIPMENT_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.EQUIPMENT_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
95 TYPE EQUIPMENT_NUMBER_EXT_T IS TABLE OF RLM_INTERFACE_LINES.EQUIPMENT_NUMBER_EXT%TYPE INDEX BY BINARY_INTEGER;
96 TYPE HANDLING_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.HANDLING_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
97 TYPE HAZARD_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.HAZARD_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
98 TYPE HAZARD_CODE_QUAL_EXT_T IS TABLE OF RLM_INTERFACE_LINES.HAZARD_CODE_QUAL_EXT%TYPE INDEX BY BINARY_INTEGER;
99 TYPE HAZARD_DESCRIPTION_EXT_T IS TABLE OF RLM_INTERFACE_LINES.HAZARD_DESCRIPTION_EXT%TYPE INDEX BY BINARY_INTEGER;
100 TYPE IMPORT_LICENSE_DATE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.IMPORT_LICENSE_DATE_EXT%TYPE INDEX BY BINARY_INTEGER;
101 TYPE IMPORT_LICENSE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.IMPORT_LICENSE_EXT%TYPE INDEX BY BINARY_INTEGER;
102 TYPE INDUSTRY_ATTRIBUTE1_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
103 TYPE INDUSTRY_ATTRIBUTE10_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
104 TYPE INDUSTRY_ATTRIBUTE11_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
105 TYPE INDUSTRY_ATTRIBUTE12_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
106 TYPE INDUSTRY_ATTRIBUTE13_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
107 TYPE INDUSTRY_ATTRIBUTE14_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
108 TYPE INDUSTRY_ATTRIBUTE15_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
109 TYPE INDUSTRY_ATTRIBUTE2_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
110 TYPE INDUSTRY_ATTRIBUTE3_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
111 TYPE INDUSTRY_ATTRIBUTE4_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
112 TYPE INDUSTRY_ATTRIBUTE5_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
113 TYPE INDUSTRY_ATTRIBUTE6_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
114 TYPE INDUSTRY_ATTRIBUTE7_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
115 TYPE INDUSTRY_ATTRIBUTE8_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
116 TYPE INDUSTRY_ATTRIBUTE9_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
117 TYPE INDUSTRY_CONTEXT_T IS TABLE OF RLM_INTERFACE_LINES.INDUSTRY_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
118 TYPE INTRMD_SHIP_TO_ID_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_SHIP_TO_ID%TYPE INDEX BY BINARY_INTEGER;
119 TYPE SHIP_TO_ORG_ID_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_ORG_ID %TYPE INDEX BY BINARY_INTEGER;
120 TYPE INTRMD_ST_ADDRESS_1_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_ADDRESS_1_EXT%TYPE INDEX BY BINARY_INTEGER;
121 TYPE INTRMD_ST_ADDRESS_2_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_ADDRESS_2_EXT%TYPE INDEX BY BINARY_INTEGER;
122 TYPE INTRMD_ST_ADDRESS_3_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_ADDRESS_3_EXT%TYPE INDEX BY BINARY_INTEGER;
123 TYPE INTRMD_ST_ADDRESS_4_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_ADDRESS_4_EXT%TYPE INDEX BY BINARY_INTEGER;
124 TYPE INTRMD_ST_CITY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_CITY_EXT%TYPE INDEX BY BINARY_INTEGER;
125 TYPE INTRMD_ST_COUNTRY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_COUNTRY_EXT%TYPE INDEX BY BINARY_INTEGER;
126 TYPE INTRMD_ST_COUNTY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_COUNTY_EXT%TYPE INDEX BY BINARY_INTEGER;
127 TYPE INTRMD_ST_NAME_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_NAME_EXT%TYPE INDEX BY BINARY_INTEGER;
128 TYPE INTRMD_ST_POSTAL_CD_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_POSTAL_CD_EXT%TYPE INDEX BY BINARY_INTEGER;
129 TYPE INTRMD_ST_PROVINCE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_PROVINCE_EXT%TYPE INDEX BY BINARY_INTEGER;
130 TYPE INTRMD_ST_STATE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_STATE_EXT%TYPE INDEX BY BINARY_INTEGER;
131 TYPE INTRMD_ST_SITE_USE_ID_T IS TABLE OF RLM_INTERFACE_LINES.INTRMD_ST_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
132 TYPE INVENTORY_ITEM_ID_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
133 TYPE INVENTORY_ITEM_SEGMENT1_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
134 TYPE INVENTORY_ITEM_SEGMENT10_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT10%TYPE INDEX BY BINARY_INTEGER;
135 TYPE INVENTORY_ITEM_SEGMENT11_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT11%TYPE INDEX BY BINARY_INTEGER;
136 TYPE INVENTORY_ITEM_SEGMENT12_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT12%TYPE INDEX BY BINARY_INTEGER;
137 TYPE INVENTORY_ITEM_SEGMENT13_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT13%TYPE INDEX BY BINARY_INTEGER;
138 TYPE INVENTORY_ITEM_SEGMENT14_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT14%TYPE INDEX BY BINARY_INTEGER;
139 TYPE INVENTORY_ITEM_SEGMENT15_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT15%TYPE INDEX BY BINARY_INTEGER;
140 TYPE INVENTORY_ITEM_SEGMENT16_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT16%TYPE INDEX BY BINARY_INTEGER;
141 TYPE INVENTORY_ITEM_SEGMENT17_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT17%TYPE INDEX BY BINARY_INTEGER;
142 TYPE INVENTORY_ITEM_SEGMENT18_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT18%TYPE INDEX BY BINARY_INTEGER;
143 TYPE INVENTORY_ITEM_SEGMENT19_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT19%TYPE INDEX BY BINARY_INTEGER;
144 TYPE INVENTORY_ITEM_SEGMENT2_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT2%TYPE INDEX BY BINARY_INTEGER;
145 TYPE INVENTORY_ITEM_SEGMENT20_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT20%TYPE INDEX BY BINARY_INTEGER;
146 TYPE INVENTORY_ITEM_SEGMENT3_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT3%TYPE INDEX BY BINARY_INTEGER;
147 TYPE INVENTORY_ITEM_SEGMENT4_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT4%TYPE INDEX BY BINARY_INTEGER;
148 TYPE INVENTORY_ITEM_SEGMENT5_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT5%TYPE INDEX BY BINARY_INTEGER;
149 TYPE INVENTORY_ITEM_SEGMENT6_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT6%TYPE INDEX BY BINARY_INTEGER;
150 TYPE INVENTORY_ITEM_SEGMENT7_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT7%TYPE INDEX BY BINARY_INTEGER;
151 TYPE INVENTORY_ITEM_SEGMENT8_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT8%TYPE INDEX BY BINARY_INTEGER;
152 TYPE INVENTORY_ITEM_SEGMENT9_T IS TABLE OF RLM_INTERFACE_LINES.INVENTORY_ITEM_SEGMENT9%TYPE INDEX BY BINARY_INTEGER;
153 TYPE ITEM_CONTACT_CODE_1_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_CONTACT_CODE_1%TYPE INDEX BY BINARY_INTEGER;
154 TYPE ITEM_CONTACT_CODE_2_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_CONTACT_CODE_2%TYPE INDEX BY BINARY_INTEGER;
155 TYPE ITEM_CONTACT_VALUE_1_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_CONTACT_VALUE_1%TYPE INDEX BY BINARY_INTEGER;
156 TYPE ITEM_CONTACT_VALUE_2_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_CONTACT_VALUE_2%TYPE INDEX BY BINARY_INTEGER;
157 TYPE ITEM_DESCRIPTION_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DESCRIPTION_EXT%TYPE INDEX BY BINARY_INTEGER;
158 TYPE ITEM_DETAIL_QUANTITY_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
159 TYPE ITEM_DETAIL_REF_CODE_1_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_REF_CODE_1%TYPE INDEX BY BINARY_INTEGER;
160 TYPE ITEM_DETAIL_REF_CODE_2_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_REF_CODE_2%TYPE INDEX BY BINARY_INTEGER;
161 TYPE ITEM_DETAIL_REF_CODE_3_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_REF_CODE_3%TYPE INDEX BY BINARY_INTEGER;
162 TYPE ITEM_DETAIL_REF_VALUE_1_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_REF_VALUE_1%TYPE INDEX BY BINARY_INTEGER;
163 TYPE ITEM_DETAIL_REF_VALUE_2_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_REF_VALUE_2%TYPE INDEX BY BINARY_INTEGER;
164 TYPE ITEM_DETAIL_REF_VALUE_3_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_REF_VALUE_3%TYPE INDEX BY BINARY_INTEGER;
165 TYPE ITEM_DETAIL_SUBTYPE_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_SUBTYPE%TYPE INDEX BY BINARY_INTEGER;
166 TYPE ITEM_DETAIL_SUBTYPE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_SUBTYPE_EXT%TYPE INDEX BY BINARY_INTEGER;
167 TYPE ITEM_DETAIL_TYPE_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_TYPE%TYPE INDEX BY BINARY_INTEGER;
168 TYPE ITEM_DETAIL_TYPE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_DETAIL_TYPE_EXT%TYPE INDEX BY BINARY_INTEGER;
169 TYPE ITEM_ENG_CNG_LVL_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_ENG_CNG_LVL_EXT%TYPE INDEX BY BINARY_INTEGER;
170 TYPE ITEM_MEASUREMENTS_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_MEASUREMENTS_EXT%TYPE INDEX BY BINARY_INTEGER;
171 TYPE ITEM_NOTE_TEXT_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_NOTE_TEXT%TYPE INDEX BY BINARY_INTEGER;
172 TYPE ITEM_REF_CODE_1_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_REF_CODE_1%TYPE INDEX BY BINARY_INTEGER;
173 TYPE ITEM_REF_CODE_2_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_REF_CODE_2%TYPE INDEX BY BINARY_INTEGER;
174 TYPE ITEM_REF_CODE_3_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_REF_CODE_3%TYPE INDEX BY BINARY_INTEGER;
175 TYPE ITEM_REF_VALUE_1_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_REF_VALUE_1%TYPE INDEX BY BINARY_INTEGER;
176 TYPE ITEM_REF_VALUE_2_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_REF_VALUE_2%TYPE INDEX BY BINARY_INTEGER;
177 TYPE ITEM_REF_VALUE_3_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_REF_VALUE_3%TYPE INDEX BY BINARY_INTEGER;
178 TYPE ITEM_RELEASE_STATUS_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ITEM_RELEASE_STATUS_EXT%TYPE INDEX BY BINARY_INTEGER;
179 TYPE LADING_QUANTITY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.LADING_QUANTITY_EXT%TYPE INDEX BY BINARY_INTEGER;
180 TYPE LETTER_CREDIT_EXPDT_EXT_T IS TABLE OF RLM_INTERFACE_LINES.LETTER_CREDIT_EXPDT_EXT%TYPE INDEX BY BINARY_INTEGER;
181 TYPE LETTER_CREDIT_EXT_T IS TABLE OF RLM_INTERFACE_LINES.LETTER_CREDIT_EXT%TYPE INDEX BY BINARY_INTEGER;
182 TYPE LINE_REFERENCE_T IS TABLE OF RLM_INTERFACE_LINES.LINE_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
183 TYPE LINK_TO_LINE_REF_T IS TABLE OF RLM_INTERFACE_LINES.LINK_TO_LINE_REF%TYPE INDEX BY BINARY_INTEGER;
184 TYPE ORDER_HEADER_ID_T IS TABLE OF RLM_INTERFACE_LINES.ORDER_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
185 TYPE OTHER_NAME_CODE_1_T IS TABLE OF RLM_INTERFACE_LINES.OTHER_NAME_CODE_1%TYPE INDEX BY BINARY_INTEGER;
186 TYPE OTHER_NAME_CODE_2_T IS TABLE OF RLM_INTERFACE_LINES.OTHER_NAME_CODE_2%TYPE INDEX BY BINARY_INTEGER;
187 TYPE OTHER_NAME_VALUE_1_T IS TABLE OF RLM_INTERFACE_LINES.OTHER_NAME_VALUE_1%TYPE INDEX BY BINARY_INTEGER;
188 TYPE OTHER_NAME_VALUE_2_T IS TABLE OF RLM_INTERFACE_LINES.OTHER_NAME_VALUE_2%TYPE INDEX BY BINARY_INTEGER;
189 TYPE PACK_SIZE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.PACK_SIZE_EXT%TYPE INDEX BY BINARY_INTEGER;
190 TYPE PACK_UNITS_PER_PACK_EXT_T IS TABLE OF RLM_INTERFACE_LINES.PACK_UNITS_PER_PACK_EXT%TYPE INDEX BY BINARY_INTEGER;
191 TYPE PACK_UOM_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.PACK_UOM_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
192 TYPE PACKAGING_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.PACKAGING_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
193 TYPE PARENT_LINK_LINE_REF_T IS TABLE OF RLM_INTERFACE_LINES.PARENT_LINK_LINE_REF%TYPE INDEX BY BINARY_INTEGER;
194 TYPE CUST_PRODUCTION_SEQ_NUM_T IS TABLE OF RLM_INTERFACE_LINES.CUST_PRODUCTION_SEQ_NUM%TYPE INDEX BY BINARY_INTEGER;
195 TYPE PRICE_LIST_ID_T IS TABLE OF RLM_INTERFACE_LINES.PRICE_LIST_ID%TYPE INDEX BY BINARY_INTEGER;
196 TYPE PRIMARY_QUANTITY_T IS TABLE OF RLM_INTERFACE_LINES.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
197 TYPE PRIMARY_UOM_CODE_T IS TABLE OF RLM_INTERFACE_LINES.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
198 TYPE PRIME_CONTRCTR_PART_EXT_T IS TABLE OF RLM_INTERFACE_LINES.PRIME_CONTRCTR_PART_EXT%TYPE INDEX BY BINARY_INTEGER;
199 TYPE PROCESS_STATUS_T IS TABLE OF RLM_INTERFACE_LINES.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER;
200 TYPE CUST_PO_RELEASE_NUM_T IS TABLE OF RLM_INTERFACE_LINES.CUST_PO_RELEASE_NUM%TYPE INDEX BY BINARY_INTEGER;
201 TYPE CUST_PO_DATE_T IS TABLE OF RLM_INTERFACE_LINES.CUST_PO_DATE%TYPE INDEX BY BINARY_INTEGER;
202 TYPE CUST_PO_LINE_NUM_T IS TABLE OF RLM_INTERFACE_LINES.CUST_PO_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
203 TYPE CUST_PO_NUMBER_T IS TABLE OF RLM_INTERFACE_LINES.CUST_PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
204 TYPE QTY_TYPE_CODE_T IS TABLE OF RLM_INTERFACE_LINES.QTY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
205 TYPE QTY_TYPE_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.QTY_TYPE_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
206 TYPE RETURN_CONTAINER_EXT_T IS TABLE OF RLM_INTERFACE_LINES.RETURN_CONTAINER_EXT%TYPE INDEX BY BINARY_INTEGER;
207 TYPE SCHEDULE_LINE_ID_T IS TABLE OF RLM_INTERFACE_LINES.SCHEDULE_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
208 TYPE ROUTING_DESC_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ROUTING_DESC_EXT%TYPE INDEX BY BINARY_INTEGER;
209 TYPE ROUTING_SEQ_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.ROUTING_SEQ_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
210 TYPE SCHEDULE_ITEM_NUM_T IS TABLE OF RLM_INTERFACE_LINES.SCHEDULE_ITEM_NUM%TYPE INDEX BY BINARY_INTEGER;
211 TYPE SHIP_DEL_PATTERN_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_DEL_PATTERN_EXT%TYPE INDEX BY BINARY_INTEGER;
212 TYPE SHIP_DEL_TIME_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_DEL_TIME_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
213 TYPE SHIP_DEL_RULE_NAME_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_DEL_RULE_NAME%TYPE INDEX BY BINARY_INTEGER;
214 TYPE SHIP_FROM_ADDRESS_1_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_ADDRESS_1_EXT%TYPE INDEX BY BINARY_INTEGER;
215 TYPE SHIP_FROM_ADDRESS_2_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_ADDRESS_2_EXT%TYPE INDEX BY BINARY_INTEGER;
216 TYPE SHIP_FROM_ADDRESS_3_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_ADDRESS_3_EXT%TYPE INDEX BY BINARY_INTEGER;
217 TYPE SHIP_FROM_ADDRESS_4_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_ADDRESS_4_EXT%TYPE INDEX BY BINARY_INTEGER;
218 TYPE SHIP_FROM_CITY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_CITY_EXT%TYPE INDEX BY BINARY_INTEGER;
219 TYPE SHIP_FROM_COUNTRY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_COUNTRY_EXT%TYPE INDEX BY BINARY_INTEGER;
220 TYPE SHIP_FROM_COUNTY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_COUNTY_EXT%TYPE INDEX BY BINARY_INTEGER;
221 TYPE SHIP_FROM_NAME_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_NAME_EXT%TYPE INDEX BY BINARY_INTEGER;
222 TYPE SHIP_FROM_ORG_ID_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_ORG_ID%TYPE INDEX BY BINARY_INTEGER;
223 TYPE SHIP_FROM_POSTAL_CD_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_POSTAL_CD_EXT%TYPE INDEX BY BINARY_INTEGER;
224 TYPE SHIP_FROM_PROVINCE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_PROVINCE_EXT%TYPE INDEX BY BINARY_INTEGER;
225 TYPE SHIP_FROM_STATE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_FROM_STATE_EXT%TYPE INDEX BY BINARY_INTEGER;
226 TYPE SHIP_LABEL_INFO_LINE_1_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_1%TYPE INDEX BY BINARY_INTEGER;
227 TYPE SHIP_LABEL_INFO_LINE_10_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_10%TYPE INDEX BY BINARY_INTEGER;
228 TYPE SHIP_LABEL_INFO_LINE_2_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_2%TYPE INDEX BY BINARY_INTEGER;
229 TYPE SHIP_LABEL_INFO_LINE_3_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_3%TYPE INDEX BY BINARY_INTEGER;
230 TYPE SHIP_LABEL_INFO_LINE_4_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_4%TYPE INDEX BY BINARY_INTEGER;
231 TYPE SHIP_LABEL_INFO_LINE_5_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_5%TYPE INDEX BY BINARY_INTEGER;
232 TYPE SHIP_LABEL_INFO_LINE_6_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_6%TYPE INDEX BY BINARY_INTEGER;
233 TYPE SHIP_LABEL_INFO_LINE_7_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_7%TYPE INDEX BY BINARY_INTEGER;
234 TYPE SHIP_LABEL_INFO_LINE_8_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_8%TYPE INDEX BY BINARY_INTEGER;
235 TYPE SHIP_LABEL_INFO_LINE_9_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_LABEL_INFO_LINE_9%TYPE INDEX BY BINARY_INTEGER;
236 TYPE SHIP_TO_ADDRESS_1_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_ADDRESS_1_EXT%TYPE INDEX BY BINARY_INTEGER;
237 TYPE SHIP_TO_ADDRESS_2_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_ADDRESS_2_EXT%TYPE INDEX BY BINARY_INTEGER;
238 TYPE SHIP_TO_ADDRESS_3_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_ADDRESS_3_EXT%TYPE INDEX BY BINARY_INTEGER;
239 TYPE SHIP_TO_ADDRESS_4_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_ADDRESS_4_EXT%TYPE INDEX BY BINARY_INTEGER;
240 TYPE SHIP_TO_ADDRESS_ID_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;
241 TYPE DELIVER_TO_ORG_ID_T IS TABLE OF RLM_INTERFACE_LINES.DELIVER_TO_ORG_ID %TYPE INDEX BY BINARY_INTEGER;
242 TYPE SHIP_TO_CITY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_CITY_EXT%TYPE INDEX BY BINARY_INTEGER;
243 TYPE SHIP_TO_COUNTRY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_COUNTRY_EXT%TYPE INDEX BY BINARY_INTEGER;
244 TYPE SHIP_TO_COUNTY_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_COUNTY_EXT%TYPE INDEX BY BINARY_INTEGER;
245 TYPE SHIP_TO_NAME_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_NAME_EXT%TYPE INDEX BY BINARY_INTEGER;
246 TYPE SHIP_TO_POSTAL_CD_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_POSTAL_CD_EXT%TYPE INDEX BY BINARY_INTEGER;
247 TYPE SHIP_TO_PROVINCE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_PROVINCE_EXT%TYPE INDEX BY BINARY_INTEGER;
248 TYPE SHIP_TO_SITE_USE_ID_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
249 TYPE SHIP_TO_STATE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_STATE_EXT%TYPE INDEX BY BINARY_INTEGER;
250 TYPE START_DATE_TIME_T IS TABLE OF RLM_INTERFACE_LINES.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
251 TYPE SUBLINE_ASSIGNED_ID_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SUBLINE_ASSIGNED_ID_EXT%TYPE INDEX BY BINARY_INTEGER;
252 TYPE SUBLINE_CONFIG_CODE_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SUBLINE_CONFIG_CODE_EXT%TYPE INDEX BY BINARY_INTEGER;
253 TYPE SUBLINE_CUST_ITEM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SUBLINE_CUST_ITEM_EXT%TYPE INDEX BY BINARY_INTEGER;
254 TYPE SUBLINE_CUST_ITEM_ID_T IS TABLE OF RLM_INTERFACE_LINES.SUBLINE_CUST_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
255 TYPE SUBLINE_MODEL_NUM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SUBLINE_MODEL_NUM_EXT%TYPE INDEX BY BINARY_INTEGER;
256 TYPE SUBLINE_QUANTITY_T IS TABLE OF RLM_INTERFACE_LINES.SUBLINE_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
257 TYPE SUBLINE_UOM_CODE_T IS TABLE OF RLM_INTERFACE_LINES.SUBLINE_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
258 TYPE SUPPLIER_ITEM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.SUPPLIER_ITEM_EXT%TYPE INDEX BY BINARY_INTEGER;
259 TYPE TRANSIT_TIME_EXT_T IS TABLE OF RLM_INTERFACE_LINES.TRANSIT_TIME_EXT%TYPE INDEX BY BINARY_INTEGER;
260 TYPE TRANSIT_TIME_QUAL_EXT_T IS TABLE OF RLM_INTERFACE_LINES.TRANSIT_TIME_QUAL_EXT%TYPE INDEX BY BINARY_INTEGER;
261 TYPE TRANSPORT_LOC_QUAL_EXT_T IS TABLE OF RLM_INTERFACE_LINES.TRANSPORT_LOC_QUAL_EXT%TYPE INDEX BY BINARY_INTEGER;
262 TYPE TRANSPORT_LOCATION_EXT_T IS TABLE OF RLM_INTERFACE_LINES.TRANSPORT_LOCATION_EXT%TYPE INDEX BY BINARY_INTEGER;
263 TYPE TRANSPORT_METHOD_EXT_T IS TABLE OF RLM_INTERFACE_LINES.TRANSPORT_METHOD_EXT%TYPE INDEX BY BINARY_INTEGER;
264 TYPE UOM_CODE_T IS TABLE OF RLM_INTERFACE_LINES.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
265 TYPE WEIGHT_EXT_T IS TABLE OF RLM_INTERFACE_LINES.WEIGHT_EXT%TYPE INDEX BY BINARY_INTEGER;
266 TYPE WEIGHT_QUALIFIER_EXT_T IS TABLE OF RLM_INTERFACE_LINES.WEIGHT_QUALIFIER_EXT%TYPE INDEX BY BINARY_INTEGER;
267 TYPE WEIGHT_UOM_EXT_T IS TABLE OF RLM_INTERFACE_LINES.WEIGHT_UOM_EXT%TYPE INDEX BY BINARY_INTEGER;
268 TYPE FBO_CONFIGURATION_KEY_1_T IS TABLE OF RLM_INTERFACE_LINES.FBO_CONFIGURATION_KEY_1%TYPE INDEX BY BINARY_INTEGER;
269 TYPE FBO_CONFIGURATION_KEY_2_T IS TABLE OF RLM_INTERFACE_LINES.FBO_CONFIGURATION_KEY_2%TYPE INDEX BY BINARY_INTEGER;
270 TYPE FBO_CONFIGURATION_KEY_3_T IS TABLE OF RLM_INTERFACE_LINES.FBO_CONFIGURATION_KEY_3%TYPE INDEX BY BINARY_INTEGER;
271 TYPE FBO_CONFIGURATION_KEY_4_T IS TABLE OF RLM_INTERFACE_LINES.FBO_CONFIGURATION_KEY_4%TYPE INDEX BY BINARY_INTEGER;
272 TYPE FBO_CONFIGURATION_KEY_5_T IS TABLE OF RLM_INTERFACE_LINES.FBO_CONFIGURATION_KEY_5%TYPE INDEX BY BINARY_INTEGER;
273 TYPE MATCH_KEY_ACROSS_T IS TABLE OF RLM_INTERFACE_LINES.MATCH_KEY_ACROSS%TYPE INDEX BY BINARY_INTEGER;
274 TYPE MATCH_KEY_WITHIN_T IS TABLE OF RLM_INTERFACE_LINES.MATCH_KEY_WITHIN%TYPE INDEX BY BINARY_INTEGER;
275 TYPE CRITICAL_KEY_ATTRIBUTES_T IS TABLE OF RLM_INTERFACE_LINES.CRITICAL_KEY_ATTRIBUTES%TYPE INDEX BY BINARY_INTEGER;
276 TYPE ATTRIBUTE_CATEGORY_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
277 TYPE ATTRIBUTE1_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
278 TYPE ATTRIBUTE2_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
279 TYPE ATTRIBUTE3_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
280 TYPE ATTRIBUTE4_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
281 TYPE ATTRIBUTE5_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
282 TYPE ATTRIBUTE6_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
283 TYPE ATTRIBUTE7_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
284 TYPE ATTRIBUTE8_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
285 TYPE ATTRIBUTE9_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
286 TYPE ATTRIBUTE10_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
287 TYPE ATTRIBUTE11_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
288 TYPE ATTRIBUTE12_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
289 TYPE ATTRIBUTE13_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
290 TYPE ATTRIBUTE14_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
291 TYPE ATTRIBUTE15_T IS TABLE OF RLM_INTERFACE_LINES.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
292 TYPE BLANKET_NUMBER_T IS TABLE OF RLM_INTERFACE_LINES.BLANKET_NUMBER%TYPE INDEX BY BINARY_INTEGER;
293 TYPE INTMED_SHIP_TO_ORG_ID_T IS TABLE OF RLM_INTERFACE_LINES.INTMED_SHIP_TO_ORG_ID%TYPE INDEX BY BINARY_INTEGER;
294 TYPE SHIP_TO_CUSTOMER_ID_T IS TABLE OF RLM_INTERFACE_LINES.SHIP_TO_CUSTOMER_ID%TYPE INDEX BY BINARY_INTEGER;
295
296
297 --
298 -- constants
299 --
300 k_ORIGINAL CONSTANT VARCHAR2(1) := 'O';
301 k_MRP_SOURCED CONSTANT VARCHAR2(1) := 'M';
302 --
303 k_PAST_DUE_FIRM CONSTANT VARCHAR2(1) := '0';
304 k_FIRM CONSTANT VARCHAR2(1) := '1';
305 k_FORECAST CONSTANT VARCHAR2(1) := '2';
306 k_MRP_FORECAST CONSTANT VARCHAR2(1) := '6';
307 k_RECT CONSTANT VARCHAR2(1) := '4';
308 k_AUTH CONSTANT VARCHAR2(1) := '3';
309 --
310 /*
311 || This group rec is a record which will have
312 || group_type = 'S' - sequenced
313 || 'N' - Non -sequenced
314 || 'A' - ATO
315 || 'F' - FBO
316 || when group_type = 'N' schedule_item_num will be populated
317 || open issue what goes in grouping for the rest?
318 ||
319 */
320
321 TYPE t_group_rec IS RECORD (
322 group_type VARCHAR2(30),
323 schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
324 cust_ship_from_org_ext rlm_interface_lines.cust_ship_from_org_ext%TYPE,
325 cust_ship_to_ext rlm_interface_lines.cust_ship_to_ext%TYPE,
326 cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
327 customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
328 customer_item_id rlm_interface_lines.customer_item_id%TYPE,
329 ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
330 ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
331 setup_terms_rec rlm_setup_terms_sv.setup_terms_rec_typ);
332
333
334 TYPE t_Cursor_ref IS REF CURSOR;
335
336
337 g_Lines_Tab t_Lines_Tab;
338
339 C_TDEBUG NUMBER :=rlm_core_sv.C_LEVEL4;
340 C_SDEBUG NUMBER :=rlm_core_sv.C_LEVEL5;
341 C_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;
342 k_VNULL CONSTANT VARCHAR2(30) := 'THIS_IS_NULL_VALUE';
343 k_NULL CONSTANT NUMBER := -10000;
344
345 g_header_rec RLM_INTERFACE_HEADERS%ROWTYPE;
346 g_schedule_PS NUMBER;
347 g_line_PS NUMBER;
348 k_PLANNING CONSTANT VARCHAR2(30) := 'PLANNING_RELEASE';
349 k_SHIPPING CONSTANT VARCHAR2(30) := 'SHIPPING';
350 k_SEQUENCED CONSTANT VARCHAR2(30) := 'SEQUENCED';
351 k_ORIG CONSTANT VARCHAR2(30) := 'ORIGINAL';
352 k_REPLACE CONSTANT VARCHAR2(30) := 'REPLACE';
353 k_REPLACE_ALL CONSTANT VARCHAR2(30) := 'REPLACE_ALL';
354 k_CHANGE CONSTANT VARCHAR2(30) := 'CHANGE';
355 k_CANCEL CONSTANT VARCHAR2(30) := 'CANCELLATION';
356 k_DELETE CONSTANT VARCHAR2(30) := 'DELETE';
357 k_ADD CONSTANT VARCHAR2(30) := 'ADD';
358
359 g_warned BOOLEAN DEFAULT FALSE;
360 --CR Changes
361 g_LineLevelShipTo BOOLEAN DEFAULT FALSE;
362
363
364 k_REQUEST_DATE_MA CONSTANT VARCHAR2(30) := 'REQUEST_DATE,C';
365 k_CUST_PO_NUMBER_MA CONSTANT VARCHAR2(30) := 'CUST_PO_NUMBER,E';
366 k_CUSTOMER_ITEM_REVISION_MA CONSTANT VARCHAR2(30) := 'CUSTOMER_ITEM_REVISION,F';
367 k_CUSTOMER_DOCK_CODE_MA CONSTANT VARCHAR2(30) := 'CUSTOMER_DOCK_CODE,B';
368 k_CUSTOMER_JOB_MA CONSTANT VARCHAR2(30) := 'CUSTOMER_JOB,G';
369 k_CUST_PRODUCTION_LINE_MA CONSTANT VARCHAR2(30) := 'CUSTOMER_PRODUCTION_LINE,A';
370 k_CUST_MODEL_SERIAL_NUMBER_MA CONSTANT VARCHAR2(30) := 'CUST_MODEL_SERIAL_NUMBER,H';
371 k_CUST_PRODUCTION_SEQ_NUM_MA CONSTANT VARCHAR2(30) := 'CUST_PRODUCTION_SEQ_NUM,$';
372 k_INDUSTRY_ATTRIBUTE1_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE1,I';
373 k_INDUSTRY_ATTRIBUTE2_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE2,J';
374 k_INDUSTRY_ATTRIBUTE4_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE4,K';
375 k_INDUSTRY_ATTRIBUTE5_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE5,L';
376 k_INDUSTRY_ATTRIBUTE6_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE6,M';
377 k_INDUSTRY_ATTRIBUTE10_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE10,O';
378 k_INDUSTRY_ATTRIBUTE11_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE11,P';
379 k_INDUSTRY_ATTRIBUTE12_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE12,Q';
380 k_INDUSTRY_ATTRIBUTE13_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE13,R';
381 k_INDUSTRY_ATTRIBUTE14_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE14,S';
382 k_INDUSTRY_ATTRIBUTE15_MA CONSTANT VARCHAR2(30) := 'INDUSTRY_ATTRIBUTE15,T';
383 k_ATTRIBUTE1_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE1,U';
384 k_ATTRIBUTE2_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE2,V';
385 k_ATTRIBUTE3_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE3,W';
386 k_ATTRIBUTE4_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE4,X';
387 k_ATTRIBUTE5_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE5,Y';
388 k_ATTRIBUTE6_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE6,Z';
389 k_ATTRIBUTE7_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE7,1';
390 k_ATTRIBUTE8_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE8,2';
391 k_ATTRIBUTE9_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE9,3';
392 k_ATTRIBUTE10_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE10,4';
393 k_ATTRIBUTE11_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE11,5';
394 k_ATTRIBUTE12_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE12,6';
395 k_ATTRIBUTE13_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE13,7';
396 k_ATTRIBUTE14_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE14,8';
397 k_ATTRIBUTE15_MA CONSTANT VARCHAR2(30) := 'ATTRIBUTE15,9';
398
399 k_non_unique CONSTANT NUMBER := 1;
400 g_convert_uom BOOLEAN DEFAULT FALSE; /* Bug 4176961 */
401
402 /*===========================================================================
403 PROCEDURE NAME: GroupValidateDemand
404
405 DESCRIPTION: This procedure is the wrapper procedure to
406 Validate_Demand. It validates, defaults and derives Ids
407 by calling the appropriate sub procedures.
408
409 PARAMETERS: x_Header_Id IN NUMBER
410 x_Procedure_Status OUT NOCOPY BOOLEAN
411
412 DESIGN REFERENCES: rladpvdp.rtf
413
414 NOTES:
415
416 OPEN ISSUES:
417
418 CLOSED ISSUES:
419
420 CHANGE HISTORY: mnandell 07/01 created
421 ===========================================================================*/
422
423 PROCEDURE GroupValidateDemand(x_Header_Id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE,
424 x_Procedure_Status OUT NOCOPY NUMBER);
425
426 /*===========================================================================
427 PROCEDURE NAME: InitializeGroup
428
429 DESCRIPTION: This procedure sets up the group cursor.
430
431 PARAMETERS: x_header_id IN NUMBER
432 x_Group_ref IN OUT NOCOPY t_Cursor_ref
433
434 DESIGN REFERENCES: rladpvdd.rtf
435
436 ALGORITHM:
437
438 NOTES:
439
440 OPEN ISSUES:
441
442 CLOSED ISSUES:
443
444 CHANGE HISTORY: created mnandell 03/08/99
445 ===========================================================================*/
446 Procedure InitializeGroup(x_header_id IN NUMBER,
447 x_Group_ref IN OUT NOCOPY t_Cursor_ref,
448 p_caller IN VARCHAR2 DEFAULT NULL);
449
450 /*===========================================================================
451 FUNCTION NAME: FetchGroup
452
453 DESCRIPTION: This function fetches next group
454
455 PARAMETERS: x_Group_ref IN OUT NOCOPY t_Cursor_ref
456 x_Group_rec IN OUT NOCOPY t_Group_rec
457
458 DESIGN REFERENCES: rladpvdd.rtf
459
460 ALGORITHM:
461
462 NOTES:
463
464 OPEN ISSUES:
465
466 CLOSED ISSUES:
467
468 CHANGE HISTORY: created mnandell 03/08/99
469 ===========================================================================*/
470 Function FetchGroup(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
471 x_Group_rec IN OUT NOCOPY t_Group_rec)
472 RETURN BOOLEAN;
473
474 /*===========================================================================
475 PROCEDURE NAME: PopulateLinesTab
476
477 DESCRIPTION: This procedure populates lines in PL/SQL table.
478
479 PARAMETERS: p_schedule_item_num IN NUMBER
480 RETURNS BOOLEAN
481 TRUE : Success
482 False : Failure
483
484 DESIGN REFERENCES: rladpvdp.rtf
485
486 NOTES:
487
488 OPEN ISSUES:
489
490 CLOSED ISSUES:
491
492 CHANGE HISTORY: mnandell 07/01 created
493 abkulkar 03/25 modified
494 ===========================================================================*/
495 PROCEDURE PopulateLinesTab (v_Group_rec IN t_Group_rec);
496
497 /*===========================================================================
498 PROCEDURE NAME: CheckCUMKeyPO
499
500 DESCRIPTION: This procedure checks for CUM Key based on PO.
501
502 PARAMETERS:
503
504
505 DESIGN REFERENCES: rladpvdp.rtf
506
507 NOTES:
508
509 OPEN ISSUES:
510
511 CLOSED ISSUES:
512
513 CHANGE HISTORY: mnandell 07/01 created
514 ===========================================================================*/
515 PROCEDURE CheckCUMKeyPO(
516 x_group_rec IN RLM_VALIDATEDEMAND_SV.t_group_rec,
517 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
518 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
519 --<TPA_PUBLIC_NAME>
520
521 /*===========================================================================
522 PROCEDURE NAME: ValidPlanningProdSeqNum
523
524 DESCRIPTION: This procedure validates planning production seqeunce
525 number and checks if customer production sequence
526 is used as a match within key
527 PARAMETERS:
528
529
530 DESIGN REFERENCES: rladpvdp.rtf
531
532 NOTES:
533
534 OPEN ISSUES:
535
536 CLOSED ISSUES:
537
538 CHANGE HISTORY: mnandell 07/01 created
539 ===========================================================================*/
540 PROCEDURE ValidPlanningProdSeqNum(
541 x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
542 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
543 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
544 --<TPA_PUBLIC_NAME>
545
546 /*===========================================================================
547 PROCEDURE NAME: ValidLineScheduleType
548
549 DESCRIPTION: This procedure validates schedule type
550
551 PARAMETERS:
552
553
554 DESIGN REFERENCES: rladpvdp.rtf
555
556 NOTES:
557
558 OPEN ISSUES:
559
560 CLOSED ISSUES:
561
562 CHANGE HISTORY: mnandell 07/01 created
563 ===========================================================================*/
564 PROCEDURE ValidLineScheduleType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
565 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
566 --<TPA_PUBLIC_NAME>
567
568 /*===========================================================================
569 PROCEDURE NAME: ValidateLineDetails
570
571 DESCRIPTION: This procedure is the wrapper procedure to
572 Validate line details.
573
574 PARAMETERS:
575
576
577 DESIGN REFERENCES: rladpvdp.rtf
578
579 NOTES:
580
581 OPEN ISSUES:
582
583 CLOSED ISSUES:
584
585 CHANGE HISTORY: mnandell 07/01 created
586 ===========================================================================*/
587 PROCEDURE ValidateLineDetails(
588 x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
589 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
590 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
591 x_line_source IN VARCHAR2);
592 --<TPA_PUBLIC_NAME>
593 /*===========================================================================
594 PROCEDURE NAME: ValidOrderHeaderId
595
596 DESCRIPTION: This procedure validates Order Header Id
597
598 PARAMETERS:
599
600
601 DESIGN REFERENCES: rladpvdp.rtf
602
603 NOTES:
604
605 OPEN ISSUES:
606
607 CLOSED ISSUES:
608
609 CHANGE HISTORY: mnandell 07/01 created
610 ===========================================================================*/
611 PROCEDURE ValidOrderHeaderId(
612 x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
613 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
614 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
615 --<TPA_PUBLIC_NAME>
616
617 /*===========================================================================
618 PROCEDURE NAME: ValidateUOM
619
620 DESCRIPTION: This procedure validates UOM code.
621
622 PARAMETERS:
623
624
625 DESIGN REFERENCES: rladpvdp.rtf
626
627 NOTES:
628
629 OPEN ISSUES:
630
631 CLOSED ISSUES:
632
633 CHANGE HISTORY: mnandell 07/01 created
634 ===========================================================================*/
635 PROCEDURE ValidateUOM(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
636 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
637 --<TPA_PUBLIC_NAME>
638
639 /*===========================================================================
640 PROCEDURE NAME: ValidDateRange
641
642 DESCRIPTION: This procedure validates date range
643
644 PARAMETERS:
645
646
647 DESIGN REFERENCES: rladpvdp.rtf
648
649 NOTES:
650
651 OPEN ISSUES:
652
653 CLOSED ISSUES:
654
655 CHANGE HISTORY: mnandell 07/01 created
656 ===========================================================================*/
657 PROCEDURE ValidDateRange(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
658 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
659 --<TPA_PUBLIC_NAME>
660
661 /*===========================================================================
662 PROCEDURE NAME: ValidDateTypeCode
663
664 DESCRIPTION: This procedure validates date type code
665
666 PARAMETERS:
667
668
669 DESIGN REFERENCES: rladpvdp.rtf
670
671 NOTES:
672
673 OPEN ISSUES:
674
675 CLOSED ISSUES:
676
677 CHANGE HISTORY: mnandell 07/01 created
678 ===========================================================================*/
679 PROCEDURE ValidDateTypeCode(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
680 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
681 --<TPA_PUBLIC_NAME>
682
683 /*===========================================================================
684 PROCEDURE NAME: ValidItemDetailQty
685
686 DESCRIPTION: This procedure validates item detail quantity
687
688 PARAMETERS:
689
690
691 DESIGN REFERENCES: rladpvdp.rtf
692
693 NOTES:
694
695 OPEN ISSUES:
696
697 CLOSED ISSUES:
698
699 CHANGE HISTORY: mnandell 07/01 created
700 ===========================================================================*/
701 PROCEDURE ValidItemDetailQty(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
702 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
703 --<TPA_PUBLIC_NAME>
704
705 /*===========================================================================
706 PROCEDURE NAME: ValidQtyTypeCode
707
708 DESCRIPTION: This procedure validates quantity type code.
709
710 PARAMETERS:
711
712
713 DESIGN REFERENCES: rladpvdp.rtf
714
715 NOTES:
716
717 OPEN ISSUES:
718
719 CLOSED ISSUES:
720
721 CHANGE HISTORY: mnandell 07/01 created
722 ===========================================================================*/
723 PROCEDURE ValidQtyTypeCode(
724 x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
725 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
726 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
727 --<TPA_PUBLIC_NAME>
728
729 /*===========================================================================
730 PROCEDURE NAME: ValidItemDetailSubtype
731
732 DESCRIPTION: This procedure validates item detail subtype code.
733
734 PARAMETERS:
735
736
737 DESIGN REFERENCES: rladpvdp.rtf
738
739 NOTES:
740
741 OPEN ISSUES:
742
743 CLOSED ISSUES:
744
745 CHANGE HISTORY: mnandell 07/01 created
746 ===========================================================================*/
747 PROCEDURE ValidItemDetailSubtype(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
748 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
749 --<TPA_PUBLIC_NAME>
750
751 /*===========================================================================
752 PROCEDURE NAME: ValidItemDetailType
753
754 DESCRIPTION: This procedure validates item detail type code.
755
756 PARAMETERS:
757
758
759 DESIGN REFERENCES: rladpvdp.rtf
760
761 NOTES:
762
763 OPEN ISSUES:
764
765 CLOSED ISSUES:
766
767 CHANGE HISTORY: mnandell 07/01 created
768 ===========================================================================*/
769 PROCEDURE ValidItemDetailType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
770 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
771 --<TPA_PUBLIC_NAME>
772
773 --PROCEDURE valid_sfst_terms(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
774 -- x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE) ;
775
776 /*===========================================================================
777 PROCEDURE NAME: BuildHeaderRec
778
779 DESCRIPTION: This procedure builds the header record PL/SQL table.
780
781 PARAMETERS:
782
783
784 DESIGN REFERENCES: rladpvdp.rtf
785
786 NOTES:
787
788 OPEN ISSUES:
789
790 CLOSED ISSUES:
791
792 CHANGE HISTORY: mnandell 07/01 created
793 ===========================================================================*/
794 FUNCTION BuildHeaderRec(x_header_id IN rlm_interface_headers.header_id%TYPE)
795 RETURN BOOLEAN ;
796
797 /*===========================================================================
798 PROCEDURE NAME: ApplyHeaderDefaults
799
800 DESCRIPTION: This procedure applies the defaiults to header record.
801
802 PARAMETERS:
803
804
805 DESIGN REFERENCES: rladpvdp.rtf
806
807 NOTES:
808
809 OPEN ISSUES:
810
811 CLOSED ISSUES:
812
813 CHANGE HISTORY: mnandell 07/01 created
814 ===========================================================================*/
815 PROCEDURE ApplyHeaderDefaults(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
816
817 /*===========================================================================
818 PROCEDURE NAME: GetDateFromTable
819
820 DESCRIPTION: This procedure gets date from table.
821
822 PARAMETERS:
823
824
825 DESIGN REFERENCES: rladpvdp.rtf
826
827 NOTES:
828
829 OPEN ISSUES:
830
831 CLOSED ISSUES:
832
833 CHANGE HISTORY: mnandell 07/01 created
834 ===========================================================================*/
835 FUNCTION GetDateFromTable(p_date_criteria VARCHAR2)
836 RETURN DATE;
837
838 /*===========================================================================
839 PROCEDURE NAME: ValidScheduleHeader
840
841 DESCRIPTION: This procedure validates schedule header.
842
843 PARAMETERS:
844
845
846 DESIGN REFERENCES: rladpvdp.rtf
847
848 NOTES:
849
850 OPEN ISSUES:
851
852 CLOSED ISSUES:
853
854 CHANGE HISTORY: mnandell 07/01 created
855 ===========================================================================*/
856 PROCEDURE ValidScheduleHeader(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
857 --<TPA_PUBLIC_NAME>
858
859 /*===========================================================================
860 PROCEDURE NAME: ValidNumberLines
861
862 DESCRIPTION: This procedure validates number of lines.
863
864 PARAMETERS:
865
866
867 DESIGN REFERENCES: rladpvdp.rtf
868
869 NOTES:
870
871 OPEN ISSUES:
872
873 CLOSED ISSUES:
874
875 CHANGE HISTORY: mnandell 07/01 created
876 ===========================================================================*/
877 PROCEDURE ValidNumberLines(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
878 --<TPA_PUBLIC_NAME>
879
880 /*===========================================================================
881 PROCEDURE NAME: ValidScheduleSource
882
883 DESCRIPTION: This procedure validates schedule source.
884
885 PARAMETERS:
886
887
888 DESIGN REFERENCES: rladpvdp.rtf
889
890 NOTES:
891
892 OPEN ISSUES:
893
894 CLOSED ISSUES:
895
896 CHANGE HISTORY: mnandell 07/01 created
897 ===========================================================================*/
898
899 PROCEDURE ValidScheduleSource(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
900 --<TPA_PUBLIC_NAME>
901
902 /*===========================================================================
903 PROCEDURE NAME: ValidHorizonDates
904
905 DESCRIPTION: This procedure validates horizon dates.
906
907 PARAMETERS:
908
909
910 DESIGN REFERENCES: rladpvdp.rtf
911
912 NOTES:
913
914 OPEN ISSUES:
915
916 CLOSED ISSUES:
917
918 CHANGE HISTORY: mnandell 07/01 created
919 ===========================================================================*/
920 PROCEDURE ValidHorizonDates(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
921 --<TPA_PUBLIC_NAME>
922
923 /*===========================================================================
924 PROCEDURE NAME: ValidScheduleReferenceNum
925
926 DESCRIPTION: This procedure validates schedule reference number
927
928 PARAMETERS:
929
930
931 DESIGN REFERENCES: rladpvdp.rtf
932
933 NOTES:
934
935 OPEN ISSUES:
936
937 CLOSED ISSUES:
938
939 CHANGE HISTORY: mnandell 07/01 created
940 ===========================================================================*/
941 PROCEDURE ValidScheduleReferenceNum(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
942 --<TPA_PUBLIC_NAME>
943
944 /*===========================================================================
945 PROCEDURE NAME: ValidScheduleType
946
947 DESCRIPTION: This procedure validates schedule type.
948
949 PARAMETERS:
950
951
952 DESIGN REFERENCES: rladpvdp.rtf
953
954 NOTES:
955
956 OPEN ISSUES:
957
958 CLOSED ISSUES:
959
960 CHANGE HISTORY: mnandell 07/01 created
961 ===========================================================================*/
962 PROCEDURE ValidScheduleType(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
963 --<TPA_PUBLIC_NAME>
964
965 /*===========================================================================
966 PROCEDURE NAME: ValidLookup
967
968 DESCRIPTION: This procedure validates against given lookup.
969
970 PARAMETERS:
971
972
973 DESIGN REFERENCES: rladpvdp.rtf
974
975 NOTES:
976
977 OPEN ISSUES:
978
979 CLOSED ISSUES:
980
981 CHANGE HISTORY: mnandell 07/01 created
982 ===========================================================================*/
983
984 FUNCTION ValidLookup(p_lookup_type IN VARCHAR2,
985 p_lookup_code IN VARCHAR2,
986 p_date IN DATE)
987 RETURN BOOLEAN;
988 --<TPA_PUBLIC_NAME>
989
990 /*===========================================================================
991 PROCEDURE NAME: ValidSchedulePurpose
992
993 DESCRIPTION: This procedure validates schedule purpose.
994
995 PARAMETERS:
996
997
998 DESIGN REFERENCES: rladpvdp.rtf
999
1000 NOTES:
1001
1002 OPEN ISSUES:
1003
1004 CLOSED ISSUES:
1005
1006 CHANGE HISTORY: mnandell 07/01 created
1007 ===========================================================================*/
1008 PROCEDURE ValidSchedulePurpose(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
1009 --<TPA_PUBLIC_NAME>
1010
1011 /*===========================================================================
1012 PROCEDURE NAME: CallSetups
1013
1014 DESCRIPTION: This procedure calls Setup terms API.
1015
1016 PARAMETERS:
1017
1018
1019 DESIGN REFERENCES: rladpvdp.rtf
1020
1021 NOTES:
1022
1023 OPEN ISSUES:
1024
1025 CLOSED ISSUES:
1026
1027 CHANGE HISTORY: mnandell 07/01 created
1028 ===========================================================================*/
1029 FUNCTION CallSetups(
1030 x_Group_rec IN OUT NOCOPY t_Group_rec,
1031 x_header_rec IN rlm_interface_headers%ROWTYPE,
1032 x_lines_rec IN rlm_interface_lines%ROWTYPE)
1033 RETURN BOOLEAN;
1034
1035 /*===========================================================================
1036 PROCEDURE NAME: DeriveIDs
1037
1038 DESCRIPTION: This procedure is the wrapper procedure to derive
1039 different ids.
1040
1041 PARAMETERS:
1042
1043
1044 DESIGN REFERENCES: rladpvdp.rtf
1045
1046 NOTES:
1047
1048 OPEN ISSUES:
1049
1050 CLOSED ISSUES:
1051
1052 CHANGE HISTORY: mnandell 07/01 created
1053 ===========================================================================*/
1054 PROCEDURE DeriveIDs(
1055 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1056 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1057
1058 /*===========================================================================
1059 PROCEDURE NAME: DeriveOrgDependentIDs
1060
1061 DESCRIPTION: This procedure derives org dependent ids.
1062
1063 PARAMETERS:
1064
1065
1066 DESIGN REFERENCES: rladpvdp.rtf
1067
1068 NOTES:
1069
1070 OPEN ISSUES:
1071
1072 CLOSED ISSUES:
1073
1074 CHANGE HISTORY: mnandell 07/01 created
1075 ===========================================================================*/
1076 PROCEDURE DeriveOrgDependentIDs(
1077 x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1078 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1079 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1080
1081 /*===========================================================================
1082 PROCEDURE NAME: DeriveInventoryItemId
1083
1084 DESCRIPTION: This procedure derives inventory item id.
1085
1086 PARAMETERS:
1087
1088
1089 DESIGN REFERENCES: rladpvdp.rtf
1090
1091 NOTES:
1092
1093 OPEN ISSUES:
1094
1095 CLOSED ISSUES:
1096
1097 CHANGE HISTORY: mnandell 07/01 created
1098 ===========================================================================*/
1099 PROCEDURE DeriveInventoryItemId(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1100 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1101
1102 --<TPA_PUBLIC_NAME>
1103
1104 /*===========================================================================
1105 PROCEDURE NAME: ValidateCustomerItem
1106
1107 DESCRIPTION: This procedure validates customer item id
1108
1109 PARAMETERS:
1110
1111
1112 DESIGN REFERENCES: rladpvdp.rtf
1113
1114 NOTES:
1115
1116 OPEN ISSUES:
1117
1118 CLOSED ISSUES:
1119
1120 CHANGE HISTORY: mnandell 07/01 created
1121 ===========================================================================*/
1122 PROCEDURE ValidateCustomerItem(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1123 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1124 --<TPA_PUBLIC_NAME>
1125
1126 /*===========================================================================
1127 PROCEDURE NAME: DerivePurchaseOrder
1128
1129 DESCRIPTION: This procedure derives purchase order.
1130
1131 PARAMETERS:
1132
1133
1134 DESIGN REFERENCES: rladpvdp.rtf
1135
1136 NOTES:
1137
1138 OPEN ISSUES:
1139
1140 CLOSED ISSUES:
1141
1142 CHANGE HISTORY: mnandell 07/01 created
1143 ===========================================================================*/
1144 PROCEDURE DerivePurchaseOrder(
1145 x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1146 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1147 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1148
1149 /*===========================================================================
1150 PROCEDURE NAME: DeriveCustomerID
1151
1152 DESCRIPTION: This procedure derives customer id.
1153
1154 PARAMETERS:
1155
1156
1157 DESIGN REFERENCES: rladpvdp.rtf
1158
1159 NOTES:
1160
1161 OPEN ISSUES:
1162
1163 CLOSED ISSUES:
1164
1165 CHANGE HISTORY: mnandell 07/01 created
1166 ===========================================================================*/
1167 PROCEDURE DeriveCustomerID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1168 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1169
1170 /*===========================================================================
1171 PROCEDURE NAME: DeriveShipFromOrg
1172
1173 DESCRIPTION: This procedure derives ship from org id.
1174
1175 PARAMETERS:
1176
1177
1178 DESIGN REFERENCES: rladpvdp.rtf
1179
1180 NOTES:
1181
1182 OPEN ISSUES:
1183
1184 CLOSED ISSUES:
1185
1186 CHANGE HISTORY: mnandell 07/01 created
1187 ===========================================================================*/
1188 PROCEDURE DeriveShipFromOrg(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1189 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1190
1191 /*===========================================================================
1192 PROCEDURE NAME: DeriveIntrmdShipToID
1193
1194 DESCRIPTION: This procedure derives Intermediate ship To Id.
1195
1196 PARAMETERS:
1197
1198
1199 DESIGN REFERENCES: rladpvdp.rtf
1200
1201 NOTES:
1202
1203 OPEN ISSUES:
1204
1205 CLOSED ISSUES:
1206
1207 CHANGE HISTORY: mnandell 07/01 created
1208 ===========================================================================*/
1209 PROCEDURE DeriveIntrmdShipToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1210 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1211
1212 /*===========================================================================
1213 PROCEDURE NAME: DeriveBillToID
1214
1215 DESCRIPTION: This procedure derives bill To Id.
1216
1217 PARAMETERS:
1218
1219
1220 DESIGN REFERENCES: rladpvdp.rtf
1221
1222 NOTES:
1223
1224 OPEN ISSUES:
1225
1226 CLOSED ISSUES:
1227
1228 CHANGE HISTORY: mnandell 07/01 created
1229 ===========================================================================*/
1230 PROCEDURE DeriveBillToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1231 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1232 x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE);
1233
1234 /*===========================================================================
1235 PROCEDURE NAME: DeriveShipToID
1236
1237 DESCRIPTION: This procedure derives ship to id.
1238
1239 PARAMETERS:
1240
1241
1242 DESIGN REFERENCES: rladpvdp.rtf
1243
1244 NOTES:
1245
1246 OPEN ISSUES:
1247
1248 CLOSED ISSUES:
1249
1250 CHANGE HISTORY: mnandell 07/01 created
1251 ===========================================================================*/
1252 PROCEDURE DeriveShipToID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1253 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1254
1255 /*===========================================================================
1256 PROCEDURE NAME: UpdateInterfaceHeaders
1257
1258 DESCRIPTION: This procedure updates interface headers.
1259
1260 PARAMETERS:
1261
1262 DESIGN REFERENCES: rladpvdp.rtf
1263
1264 NOTES:
1265
1266 OPEN ISSUES:
1267
1268 CLOSED ISSUES:
1269
1270 CHANGE HISTORY: mnandell 07/01 created
1271 ===========================================================================*/
1272 PROCEDURE UpdateInterfaceHeaders;
1273
1274 /*===========================================================================
1275 PROCEDURE NAME: UpdateInterfaceLines
1276
1277 DESCRIPTION: This procedure updates interface lines.
1278
1279 PARAMETERS:
1280
1281 DESIGN REFERENCES: rladpvdp.rtf
1282
1283 NOTES:
1284
1285 OPEN ISSUES:
1286
1287 CLOSED ISSUES:
1288
1289 CHANGE HISTORY: mnandell 07/01 created
1290 ===========================================================================*/
1291 PROCEDURE UpdateInterfaceLines(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE);
1292 --<TPA_PUBLIC_NAME>
1293 /*===========================================================================
1294 PROCEDURE NAME: PostValidation
1295
1296 DESCRIPTION: This procedure performs post validation steps.
1297
1298 PARAMETERS:
1299
1300 DESIGN REFERENCES: rladpvdp.rtf
1301
1302 NOTES:
1303
1304 OPEN ISSUES:
1305
1306 CLOSED ISSUES:
1307
1308 CHANGE HISTORY: mnandell 07/01 created
1309 ===========================================================================*/
1310 PROCEDURE PostValidation;
1311 --<TPA_PUBLIC_NAME>
1312
1313 /*===========================================================================
1314 PROCEDURE NAME: PrintTable
1315
1316 DESCRIPTION: This procedure prints the lines in the Lines table.
1317
1318 PARAMETERS:
1319
1320
1321 DESIGN REFERENCES: rladpvdp.rtf
1322
1323 NOTES:
1324
1325 OPEN ISSUES:
1326
1327 CLOSED ISSUES:
1328
1329 CHANGE HISTORY: mnandell 07/01 created
1330 ===========================================================================*/
1331 PROCEDURE PrintTable(v_LinesTab IN t_Lines_Tab,
1332 i IN NUMBER DEFAULT NULL);
1333
1334 /*===========================================================================
1335 PROCEDURE NAME: GetTPContext
1336
1337 DESCRIPTION: This procedure returns the TP Context.
1338 Do not use this procedure when trying to
1339 customize procedures (e.g. ValidSchedulePurpose)
1340 that take only one header record as input
1341 parameter. Instead, use GetHdrTPContext.
1342
1343 PARAMETERS:
1344
1345
1346 DESIGN REFERENCES: rladpvdp.rtf
1347
1348 NOTES:
1349
1350 OPEN ISSUES:
1351
1352 CLOSED ISSUES:
1353
1354 CHANGE HISTORY: mnandell 10/10/99 created
1355 ===========================================================================*/
1356 PROCEDURE GetTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1357 x_lines_rec IN RLM_INTERFACE_LINES%ROWTYPE DEFAULT NULL,
1358 x_customer_number OUT NOCOPY VARCHAR2,
1359 x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1360 x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
1361 x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1362 x_tp_group_code OUT NOCOPY VARCHAR2);
1363 --<TPA_TPS>
1364
1365 /*===========================================================================
1366 PROCEDURE NAME: GetHdrTPContext
1367
1368 DESCRIPTION: Same as GetTPContext except that the only
1369 input parameter is header record. No line
1370 record is required as an input. Bill-To
1371 Location Code and Intermediate Ship-To
1372 Location Code can not be derived using
1373 this procedure. Do not use this procedure
1374 to customize procedures that have both
1375 header record and line record as input
1376 parameters.
1377
1378 PARAMETERS:
1379
1380
1381 DESIGN REFERENCES: rladpvdp.rtf
1382
1383 NOTES:
1384
1385 OPEN ISSUES:
1386
1387 CLOSED ISSUES:
1388
1389 CHANGE HISTORY: jautomo 10/25/00 created
1390 ===========================================================================*/
1391 PROCEDURE GetHdrTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1392 x_customer_number OUT NOCOPY VARCHAR2,
1393 x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1394 x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
1395 x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1396 x_tp_group_code OUT NOCOPY VARCHAR2);
1397 --<TPA_TPS>
1398
1399 /*===========================================================================
1400
1401 PROCEDURE NAME: ValidateCriticalKeys
1402
1403 DESCRIPTION: This procedure will validate the critical key attributes
1404 to ensure that they are not null values.
1405
1406 PARAMETERS: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ
1407 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1408 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
1409
1410
1411 DESIGN REFERENCES: RLADPHLD.rtf
1412 RLADPRDD.rtf
1413
1414 ALGORITHM:
1415
1416 NOTES:
1417
1418 OPEN ISSUES:
1419
1420 CLOSED ISSUES:
1421
1422 CHANGE HISTORY: created mnnaraya 11/22/99
1423 ===========================================================================*/
1424 PROCEDURE ValidateCriticalKeys(
1425 x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1426 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1427 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1428
1429 /*=============================================================================
1430 PROCEDURE NAME: ValidForecastDesig
1431
1432 DESCRIPTION: This procedure checks if forecast designator exits
1433
1434 PARAMETERS: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ
1435 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1436 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
1437 x_ForecastDesignator IN OUT NOCOPY VARCHAR2
1438
1439
1440 DESIGN REFERENCES: RLADPHLD.rtf
1441 RLADPRDD.rtf
1442
1443 ALGORITHM:
1444
1445
1446 ==============================================================================*/
1447 PROCEDURE ValidForecastDesig(
1448 x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1449 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1450 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1451 x_ForecastDesignator IN OUT NOCOPY VARCHAR2);
1452
1453 /*=============================================================================
1454 PROCEDURE NAME: SetTPAttCategory
1455
1456 DESCRIPTION: This procedure sets TP Attribute Category with TP Group
1457 Code
1458 ==============================================================================*/
1459 PROCEDURE SetTPAttCategory (
1460 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1461 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1462 x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec);
1463 --<TPA_PUBLIC_NAME>
1464
1465 /*=============================================================================
1466 PROCEDURE NAME: SetTPHdrAttCategory
1467
1468 DESCRIPTION: This procedure sets TP Attribute Category with TP Group
1469 Code
1470
1471 PARAMETERS: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
1472
1473 ==============================================================================*/
1474 PROCEDURE SetHdrTPAttCategory (
1475 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
1476
1477 --<TPA_PUBLIC_NAME>
1478
1479 /*=============================================================================
1480 PROCEDURE NAME: SetLineTPAttCategory
1481
1482 DESCRIPTION: This procedure sets TP Attribute Category with TP Group
1483 Code
1484
1485 PARAMETERS: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
1486 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
1487 x_group_rec IN OUT NOCOPY t_Group_rec
1488
1489 ==============================================================================*/
1490 PROCEDURE SetLineTPAttCategory (
1491 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1492 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1493 x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec);
1494 --<TPA_PUBLIC_NAME>
1495
1496
1497 /*=============================================================================
1498 FUNCTION NAME: CustomerRelationship
1499
1500 DESCRIPTION: This function validates the customer relationship
1501
1502 ==============================================================================*/
1503
1504 FUNCTION CustomerRelationship(x_RelatedCustomerId IN NUMBER,
1505 x_customer_id IN NUMBER,
1506 x_header_id IN NUMBER,
1507 x_site_use_code IN VARCHAR2 DEFAULT 'BILL_TO')
1508 RETURN BOOLEAN;
1509
1510
1511 PROCEDURE validateWithCumRec(
1512 x_cum_key_record IN rlm_cum_sv.cum_key_attrib_rec_type, -- 4307505
1513 x_group_rec IN t_group_rec,
1514 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1515
1516
1517 PROCEDURE validateWithoutCumRec(
1518 x_customer_id IN NUMBER,
1519 x_group_rec IN t_group_rec,
1520 x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1521
1522 /*===========================================================================
1523 PROCEDURE NAME: ValidateDateTypeATP
1524
1525 DESCRIPTION: This procedure warns when RLM date type does not
1526 match OM date type -- For ATP items only
1527
1528 PARAMETERS: x_line IN rlm_dp_sv.t_group_rec
1529
1530 CHANGE HISTORY: created jautomo 03/07/02
1531 ===========================================================================*/
1532 PROCEDURE ValidateDateTypeATP(x_line IN RLM_INTERFACE_LINES%ROWTYPE);
1533
1534 /*===========================================================================
1535 PROCEDURE NAME: DeriveBlanketPO
1536
1537 DESCRIPTION: This procedure warns when PO on schedule does not
1538 match the PO on the blanket order. Applicable
1539 only when blanket orders are setup in processing
1540 rules.
1541
1542 PARAMETERS: x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE
1543 x_Group_rec IN t_group_rec
1544 x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE
1545
1546 CHANGE HISTORY: created rlanka 10/10/02
1547 ===========================================================================*/
1548 PROCEDURE DeriveBlanketPO(x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE,
1549 x_Group_rec IN t_Group_rec,
1550 x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE);
1551
1552
1553 /*===========================================================================
1554 FUNCTION NAME: ValidateBlanket
1555
1556 DESCRIPTION: This function returns an error when the start date
1557 times on the schedule do not fall between the effective
1558 start and end dates of the blanket header
1559
1560 PARAMETERS: x_Group_rec IN t_group_rec
1561 x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1562
1563 CHANGE HISTORY: created rlanka 10/10/02
1564 modified rlanka 03/31/03
1565 - Removed x_line_rec as a parameter.
1566 ===========================================================================*/
1567 FUNCTION ValidateBlanket(x_Group_rec IN t_Group_rec,
1568 x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE)
1569 RETURN BOOLEAN;
1570
1571
1572 /*===========================================================================
1573 FUNCTION NAME: GetOrderNumber
1574
1575 DESCRIPTION: This function returns the sales order number
1576 when the order header id is provided as input. Earlier
1577 this was a private function in RLMDPVDB.pls, made it
1578 accessible to other DSP modules as well.
1579
1580 PARAMETERS: x_order_header_id IN NUMBER
1581
1582 CHANGE HISTORY: created jautomo 03/07/02
1583 ===========================================================================*/
1584 FUNCTION GetOrderNumber(x_order_header_id IN NUMBER) RETURN NUMBER;
1585
1586 PROCEDURE CheckHeaderECETpLocCode(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1587 x_ReturnStatus OUT NOCOPY NUMBER);
1588
1589 END RLM_VALIDATEDEMAND_SV;