APPS.WMS_ZONES_PVT dependencies on WMS_ZONE_LOCATORS_TEMP

Line 10: TYPE wms_zone_loc_tbl_t IS TABLE OF wms_zone_locators_temp%ROWTYPE

6: -- Description :
7: -- Notes :
8: -- Modified : Mon Jul 14 14:29:40 GMT+05:30 2003
9:
10: TYPE wms_zone_loc_tbl_t IS TABLE OF wms_zone_locators_temp%ROWTYPE
11: INDEX BY BINARY_INTEGER;
12:
13: TYPE zoneloc_rowid_t IS TABLE OF VARCHAR2(18) INDEX BY BINARY_INTEGER;
14: TYPE zoneloc_messages_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 38: * inserts the locators into the table WMS_ZONE_LOCATORS_TEMP.

34: );
35:
36: /**
37: * Using the filter criteria given in the Add Locators form,
38: * inserts the locators into the table WMS_ZONE_LOCATORS_TEMP.
39:
40: * @param p_fm_zone_id from_zone_id in the range. Will have a null value if the user doesnt choose a from_zone
41: * @param p_to_zone_id to_zone_id in the range. Can have a null value if the user doesnt choose a to_zone
42: * @param p_current_zone_id The zone_id of the current zone, for which more locators are being added

Line 216: * wms_zone_locators_temp to wms_zone_locators. For every

212: );
213:
214: /**
215: * This procedure saves the records from
216: * wms_zone_locators_temp to wms_zone_locators. For every
217: * record at a given index in the table p_zoneloc_messages
218: * table, we get the the corresponding rowid from the input
219: * parameter table p_zoneloc_rowid_t for the same index.
220: * If the value in p_zoneloc_messages_t is 0, the

Line 238: * wms_zone_locators_temp to wms_zone_locators, which have the

234: p_zone_id IN wms_zone_locators.zone_id%TYPE);
235:
236: /**
237: * This procedure saves all the records from
238: * wms_zone_locators_temp to wms_zone_locators, which have the
239: * message field containing the value 'Pending Addition to
240: * Zone'. All the records whose message field has a value
241: * 'Pending Deletion' will be deleted from the table.
242: **/