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 211: * wms_zone_locators_temp to wms_zone_locators. For every

207: p_last_update_login IN NUMBER);
208:
209: /**
210: * This procedure saves the records from
211: * wms_zone_locators_temp to wms_zone_locators. For every
212: * record at a given index in the table p_zoneloc_messages
213: * table, we get the the corresponding rowid from the input
214: * parameter table p_zoneloc_rowid_t for the same index.
215: * If the value in p_zoneloc_messages_t is 0, the

Line 233: * wms_zone_locators_temp to wms_zone_locators, which have the

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