APPS.FND_HTTP_TICKET dependencies on FND_HTTP_SERVICE_TICKETS

Line 75: from FND_HTTP_SERVICE_TICKETS

71: X_END_DATE date;
72: begin
73: select TICKET, OLD_TICKET, END_DATE
74: into X_TICKET, X_OLD_TICKET, X_END_DATE
75: from FND_HTTP_SERVICE_TICKETS
76: where SERVICE = P_SERVICE
77: for update;
78: if (X_END_DATE <= SYSDATE) then
79: X_OLD_TICKET := X_TICKET;

Line 81: update FND_HTTP_SERVICE_TICKETS

77: for update;
78: if (X_END_DATE <= SYSDATE) then
79: X_OLD_TICKET := X_TICKET;
80: X_TICKET := FND_CRYPTO.RANDOMBYTES(16);
81: update FND_HTTP_SERVICE_TICKETS
82: set TICKET = X_TICKET,
83: OLD_TICKET = X_OLD_TICKET,
84: END_DATE = SYSDATE + 1
85: where SERVICE = P_SERVICE;

Line 105: from FND_HTTP_SERVICE_TICKETS where SERVICE = P_SERVICE;

101: X_END_DATE date;
102: begin
103: select TICKET, OLD_TICKET, END_DATE
104: into X_TICKET, X_OLD_TICKET, X_END_DATE
105: from FND_HTTP_SERVICE_TICKETS where SERVICE = P_SERVICE;
106: if (X_END_DATE <= SYSDATE) then
107: return(SET_SERVICE_TICKET(P_SERVICE));
108: end if;
109: return(UTL_RAW.CONCAT(X_TICKET, X_OLD_TICKET));