APPS.FND_HTTP_TICKET dependencies on FND_HTTP_TICKET

Line 1: package body FND_HTTP_TICKET as

1: package body FND_HTTP_TICKET as
2: /* $Header: AFSTCKTB.pls 120.1 2005/07/02 04:18:30 appldev noship $ */
3: --
4: C_SECS_PER_DAY constant number := 24*60*60;
5: --

Line 37: insert into FND_HTTP_TICKETS (TICKET, OPERATION, ARGUMENT,

33: ' '||to_char(to_date(to_char(X_END_SEC), 'SSSSS'),
34: 'HH24:MI:SS');
35: X_END_DATE := to_date(X_END_STR,'YYYY/MM/DD HH24:MI:SS');
36: end if;
37: insert into FND_HTTP_TICKETS (TICKET, OPERATION, ARGUMENT,
38: START_DATE, END_DATE)
39: values (X_TICKET, P_OPERATION, P_ARGUMENT,
40: X_START_DATE, X_END_DATE);
41: commit;

Line 181: from FND_HTTP_TICKETS

177: X_END_DATE date;
178: begin
179: select OPERATION, ARGUMENT, END_DATE
180: into P_OPERATION, P_ARGUMENT, X_END_DATE
181: from FND_HTTP_TICKETS
182: where TICKET = P_TICKET;
183: if (X_END_DATE is not null) then
184: if (X_END_DATE < SYSDATE) then
185: return(false);

Line 225: update FND_HTTP_TICKETS

221: is
222: pragma AUTONOMOUS_TRANSACTION;
223: X_END_DATE date;
224: begin
225: update FND_HTTP_TICKETS
226: set OPERATION = P_OPERATION,
227: ARGUMENT = P_ARGUMENT
228: where TICKET = P_TICKET
229: returning END_DATE into X_END_DATE;

Line 262: delete from FND_HTTP_TICKETS

258: pragma AUTONOMOUS_TRANSACTION;
259: X_END_DATE date;
260: X_TICKET raw(16);
261: begin
262: delete from FND_HTTP_TICKETS
263: where TICKET = P_TICKET
264: returning TICKET, OPERATION, ARGUMENT, END_DATE
265: into X_TICKET, P_OPERATION, P_ARGUMENT, X_END_DATE;
266: commit;

Line 296: delete from FND_HTTP_TICKETS where TICKET = P_TICKET;

292: procedure DESTROY_TICKET(P_TICKET in raw)
293: is
294: pragma AUTONOMOUS_TRANSACTION;
295: begin
296: delete from FND_HTTP_TICKETS where TICKET = P_TICKET;
297: commit;
298: exception when OTHERS then
299: rollback; -- ignore failures
300: end DESTROY_TICKET;

Line 313: delete from FND_HTTP_TICKETS

309: is
310: pragma AUTONOMOUS_TRANSACTION;
311: begin
312: if (P_MAX_LIFESPAN is not null) then
313: delete from FND_HTTP_TICKETS
314: where SYSDATE > END_DATE
315: or (SYSDATE - START_DATE) > (P_MAX_LIFESPAN/C_SECS_PER_DAY);
316: else
317: delete from FND_HTTP_TICKETS where SYSDATE > END_DATE;

Line 317: delete from FND_HTTP_TICKETS where SYSDATE > END_DATE;

313: delete from FND_HTTP_TICKETS
314: where SYSDATE > END_DATE
315: or (SYSDATE - START_DATE) > (P_MAX_LIFESPAN/C_SECS_PER_DAY);
316: else
317: delete from FND_HTTP_TICKETS where SYSDATE > END_DATE;
318: end if;
319: commit;
320: exception when OTHERS then
321: rollback; -- ignore failures

Line 324: end FND_HTTP_TICKET;

320: exception when OTHERS then
321: rollback; -- ignore failures
322: end PURGE_TICKETS;
323: --
324: end FND_HTTP_TICKET;