APPS.WSH_OTM_HTTP_UTL dependencies on FND_HTTP_TICKET

Line 496: FROM FND_HTTP_TICKETS

492: l_debug_on BOOLEAN;
493:
494: CURSOR c_get_ticket_details (c_operation VARCHAR2, c_argument VARCHAR2) IS
495: SELECT ticket, operation, argument, end_date
496: FROM FND_HTTP_TICKETS
497: WHERE operation = c_operation
498: AND argument = c_argument;
499:
500: --CURSOR c_get_ticket_end_date (c_ticket RAW) IS

Line 502: --FROM FND_HTTP_TICKETS

498: AND argument = c_argument;
499:
500: --CURSOR c_get_ticket_end_date (c_ticket RAW) IS
501: --SELECT to_char(end_date,'yyyy/mm/dd hh:mi:ss')
502: --FROM FND_HTTP_TICKETS
503: --WHERE ticket = c_ticket;
504:
505: CURSOR c_get_sysdate IS
506: SELECT SYSDATE FROM DUAL;

Line 552: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);

548: IF l_debug_on THEN
549: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists but expired.Delete existing');
550: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
551: END IF;
552: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');
555: END IF;
556: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

Line 556: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

552: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');
555: END IF;
556: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
557: ,p_argument
558: ,G_WSH_TKT_LIFESPAN
559: );
560: --5226917

Line 570: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

566: ELSE
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.log(l_module_name,'ticket doesnt exist . Create a new ticket');
569: END IF;
570: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
571: ,p_argument
572: ,G_WSH_TKT_LIFESPAN
573: );
574: END IF;