[Home] [Help]
12: -- p_entity_id - TRIP_ID or DELIVERY_ID
13: -- p_organization_id - The Organization Id
14: --
15: -- x_process_started - 'Y' Process started; 'N' Process not started
16: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
17:
18: -- Description: This Procedure selects and starts a Tracking Workflow process
19: -- for an entity - Trip/Delivery after checking if it is eligible.
20: -- i.e.1) No Process exists already for the Entity
37: -- Parameters: p_entity_id - DELIVERY_ID (Entity is always Delivery)
38: -- p_organization_id - The Organization Id
39: --
40: -- x_process_started - 'Y' Process started; 'N' Process not started
41: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
42: --
43: -- Description: This Procedure starts the 'Ship to Deliver' controlling
44: -- Workflow process for the Delivery after checking
45: -- if it is eligible.
61: -- p_entity_id - TRIP_ID or DELIVERY_ID
62: -- p_organization_id - The Organization Id
63: --
64: -- x_wf_process - Returns the process selected for the Entity
65: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
66: --
67: -- Description: This Procedure selects the process for the entities based on the
68: -- various criteria
69: -- Delivery:
94: -- p_send_date - Optional date to indicate when the event should
95: -- become available for subscription processing.
96: -- p_organization_id - The Organization Id
97: --
98: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
99: --
100: -- Description: This Procedure raises the event in the following scenario
101: -- 1) If a Process already exists for this Entity
102: -- 2) If no process exists, checks the Global and Shipping parameters
118: -- Parameters: p_entity_type - 'TRIP','DELIVERY'
119: -- p_organization_id - The Organization Id
120: --
121: -- x_start_wf_process - Returns 'Y' if process can be started, else 'N'
122: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
123: --
124: -- Description: This Procedure obtains the Global and Shipping parameter
125: -- values for 'Enable Tracking Workflows' and determines
126: -- if a process can be started by,
147: -- Parameters: p_entity_type - 'TRIP','DELIVERY'
148: -- p_entity_id - TRIP_ID or DELIVERY_ID
149: --
150: -- x_wf_process_exists - Returns 'Y' if Wf exists, else 'N'
151: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
152: --
153: -- Description: This Procedure checks from WSH_NEW_DELIVERIES or WSH_TRIPS
154: -- if a workflow process has been started for this entity.
155: ---------------------------------------------------------------------------------------
170: -- p_org_code - The organization code
171: --
172: -- x_wf_process - Returns the custom process name specified
173: -- with the lookups else the orginial process
174: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
175: --
176: -- Description: This Procedure queries from the WSH_LOOKUPS for any custom
177: -- process name specified by the User through the lookups for
178: -- a particular process else returns the original process
185: x_return_status OUT NOCOPY VARCHAR2) ;
186:
187: Procedure Purge_Entity(
188: p_entity_type IN VARCHAR2,
189: p_entity_ids IN WSH_UTIL_CORE.column_tab_type,
190: p_action IN VARCHAR2 DEFAULT 'PURGE',
191: p_docommit IN BOOLEAN DEFAULT FALSE,
192: x_success_count OUT NOCOPY NUMBER,
193: x_return_status OUT NOCOPY VARCHAR2) ;
207:
208: PROCEDURE RESET_APPS_CONTEXT_OFF;
209:
210: /* CURRENTLY NOT IN USE
211: PROCEDURE Get_Carrier(p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
212: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
213: x_return_status OUT NOCOPY VARCHAR2);
214:
215: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
208: PROCEDURE RESET_APPS_CONTEXT_OFF;
209:
210: /* CURRENTLY NOT IN USE
211: PROCEDURE Get_Carrier(p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
212: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
213: x_return_status OUT NOCOPY VARCHAR2);
214:
215: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
216: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
212: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
213: x_return_status OUT NOCOPY VARCHAR2);
214:
215: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
216: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
217: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
218: x_return_status OUT NOCOPY VARCHAR2);
219:
220: PROCEDURE Assign_Unassign_Carrier(p_delivery_id IN NUMBER,
213: x_return_status OUT NOCOPY VARCHAR2);
214:
215: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
216: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
217: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
218: x_return_status OUT NOCOPY VARCHAR2);
219:
220: PROCEDURE Assign_Unassign_Carrier(p_delivery_id IN NUMBER,
221: p_old_carrier_id IN NUMBER,
222: p_new_carrier_id IN NUMBER,
223: x_return_status OUT NOCOPY VARCHAR2);
224:
225: PROCEDURE Get_Deliveries(p_trip_id IN NUMBER,
226: x_del_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
227: x_return_status OUT NOCOPY VARCHAR2);
228: */
229:
230: END WSH_WF_STD;