APPS.WSH_OTM_HTTP_UTL dependencies on FND_HTTP_TICKET

Line 502: FROM FND_HTTP_TICKETS

498: l_debug_on BOOLEAN;
499:
500: CURSOR c_get_ticket_details (c_operation VARCHAR2, c_argument VARCHAR2) IS
501: SELECT ticket, operation, argument, end_date
502: FROM FND_HTTP_TICKETS
503: WHERE operation = c_operation
504: AND argument = c_argument;
505:
506: --CURSOR c_get_ticket_end_date (c_ticket RAW) IS

Line 508: --FROM FND_HTTP_TICKETS

504: AND argument = c_argument;
505:
506: --CURSOR c_get_ticket_end_date (c_ticket RAW) IS
507: --SELECT to_char(end_date,'yyyy/mm/dd hh:mi:ss')
508: --FROM FND_HTTP_TICKETS
509: --WHERE ticket = c_ticket;
510:
511: CURSOR c_get_sysdate IS
512: SELECT SYSDATE FROM DUAL;

Line 558: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);

554: IF l_debug_on THEN
555: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists but expired.Delete existing');
556: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
557: END IF;
558: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
559: IF l_debug_on THEN
560: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');
561: END IF;
562: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

Line 562: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

558: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
559: IF l_debug_on THEN
560: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');
561: END IF;
562: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
563: ,p_argument
564: ,G_WSH_TKT_LIFESPAN
565: );
566: --5226917

Line 576: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code

572: ELSE
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.log(l_module_name,'ticket doesnt exist . Create a new ticket');
575: END IF;
576: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
577: ,p_argument
578: ,G_WSH_TKT_LIFESPAN
579: );
580: END IF;