APPS.WMS_OTM_DOCK_SYNC dependencies on FND_HTTP_TICKET

Line 167: FROM FND_HTTP_TICKETS

163: l_sysdate TimeStamp;
164:
165: CURSOR c_get_ticket_details (c_operation VARCHAR2, c_argument VARCHAR2) IS
166: SELECT ticket, operation, argument, end_date
167: FROM FND_HTTP_TICKETS
168: WHERE operation = c_operation
169: AND argument = c_argument;
170:
171: CURSOR c_get_sysdate IS

Line 200: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);

196: ELSIF ( l_edate IS NOT NULL) AND ( l_edate < SYSDATE) THEN
197: IF g_debug = 1 THEN
198: print_debug('Tickets Exists but expired. Delete existing', 4);
199: END IF;
200: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
201:
202: IF g_debug = 1 THEN
203: print_debug('Creating new ticket ...', 4);
204: END IF;

Line 205: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

201:
202: IF g_debug = 1 THEN
203: print_debug('Creating new ticket ...', 4);
204: END IF;
205: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
206: ,p_argument
207: ,36000 --10 hrs
208: );
209: ELSE

Line 213: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

209: ELSE
210: IF g_debug = 1 THEN
211: print_debug('ticket does not exist. Create a new ticket', 4);
212: END IF;
213: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
214: ,p_argument
215: ,36000 --10 hrs
216: );
217: END IF;