9: -- This is the global cache table used to store the crossdock criteria records
10: -- encountered during crossdock pegging. This is defined solely in the package body
11: -- so only the procedures and functions in this package can access it directly.
12: -- Set, Get, Delete, and Clear functions will be provided for outside callers.
13: TYPE crossdock_criteria_tb IS TABLE OF wms_crossdock_criteria%ROWTYPE
14: INDEX BY BINARY_INTEGER;
15: g_crossdock_criteria_tb crossdock_criteria_tb;
16:
17: -- This is the global cache table used to store the default routing ID for supplies
110: -- Test setting the crossdock criteria record for a crossdock criterion that
111: -- has not yet been cached. }}
112: SELECT *
113: INTO g_crossdock_criteria_tb(p_criterion_id)
114: FROM wms_crossdock_criteria
115: WHERE criterion_id = p_criterion_id;
116: RETURN TRUE;
117: END IF;
118: EXCEPTION
122:
123:
124: -- This function will retrieve the crossdock criteria record inputted from the cache
125: FUNCTION get_crossdock_criteria
126: (p_criterion_id IN NUMBER) RETURN wms_crossdock_criteria%ROWTYPE
127: IS
128: BEGIN
129: IF (p_criterion_id IS NULL) THEN
130: RETURN NULL;
135: -- Test retrieving a crossdock criteria record for a crossdock criterion that
136: -- has not yet been cached. }}
137: SELECT *
138: INTO g_crossdock_criteria_tb(p_criterion_id)
139: FROM wms_crossdock_criteria
140: WHERE criterion_id = p_criterion_id;
141: END IF;
142: -- {{
143: -- Test retrieving a crossdock criteria record for a crossdock criterion that