APPS.FND_HTTP_TICKET dependencies on UTL_RAW

Line 90: return(UTL_RAW.CONCAT(X_TICKET, X_OLD_TICKET));

86: commit;
87: else
88: rollback;
89: end if;
90: return(UTL_RAW.CONCAT(X_TICKET, X_OLD_TICKET));
91: exception when OTHERS then
92: rollback;
93: return(null);
94: end SET_SERVICE_TICKET;

Line 109: return(UTL_RAW.CONCAT(X_TICKET, X_OLD_TICKET));

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));
110: exception when OTHERS then
111: return(null);
112: end GET_SERVICE_TICKET;
113: --

Line 120: return(FND_CRYPTO.ENCODE(UTL_RAW.SUBSTR(X_TICKETS,1,16),

116: is
117: X_TICKETS raw(32);
118: begin
119: X_TICKETS := GET_SERVICE_TICKET(P_SERVICE);
120: return(FND_CRYPTO.ENCODE(UTL_RAW.SUBSTR(X_TICKETS,1,16),
121: FND_CRYPTO.ENCODE_URL)||
122: FND_CRYPTO.ENCODE(UTL_RAW.SUBSTR(X_TICKETS,17,16),
123: FND_CRYPTO.ENCODE_URL));
124: end GET_SERVICE_TICKET_STRING;

Line 122: FND_CRYPTO.ENCODE(UTL_RAW.SUBSTR(X_TICKETS,17,16),

118: begin
119: X_TICKETS := GET_SERVICE_TICKET(P_SERVICE);
120: return(FND_CRYPTO.ENCODE(UTL_RAW.SUBSTR(X_TICKETS,1,16),
121: FND_CRYPTO.ENCODE_URL)||
122: FND_CRYPTO.ENCODE(UTL_RAW.SUBSTR(X_TICKETS,17,16),
123: FND_CRYPTO.ENCODE_URL));
124: end GET_SERVICE_TICKET_STRING;
125: --
126: function COMPARE_SERVICE_TICKETS(P_TICKET1 in raw, P_TICKET2 in raw)

Line 137: X_TICKET11 := UTL_RAW.SUBSTR(P_TICKET1,1,16);

133: begin
134: if ((P_TICKET1 is null) or (P_TICKET2 is null)) then
135: return(false);
136: end if;
137: X_TICKET11 := UTL_RAW.SUBSTR(P_TICKET1,1,16);
138: X_TICKET12 := UTL_RAW.SUBSTR(P_TICKET1,17,16);
139: X_TICKET21 := UTL_RAW.SUBSTR(P_TICKET2,1,16);
140: X_TICKET22 := UTL_RAW.SUBSTR(P_TICKET2,17,16);
141: return((X_TICKET11 = X_TICKET21) or (X_TICKET12 = X_TICKET21) or

Line 138: X_TICKET12 := UTL_RAW.SUBSTR(P_TICKET1,17,16);

134: if ((P_TICKET1 is null) or (P_TICKET2 is null)) then
135: return(false);
136: end if;
137: X_TICKET11 := UTL_RAW.SUBSTR(P_TICKET1,1,16);
138: X_TICKET12 := UTL_RAW.SUBSTR(P_TICKET1,17,16);
139: X_TICKET21 := UTL_RAW.SUBSTR(P_TICKET2,1,16);
140: X_TICKET22 := UTL_RAW.SUBSTR(P_TICKET2,17,16);
141: return((X_TICKET11 = X_TICKET21) or (X_TICKET12 = X_TICKET21) or
142: (X_TICKET11 = X_TICKET22) or (X_TICKET12 = X_TICKET22));

Line 139: X_TICKET21 := UTL_RAW.SUBSTR(P_TICKET2,1,16);

135: return(false);
136: end if;
137: X_TICKET11 := UTL_RAW.SUBSTR(P_TICKET1,1,16);
138: X_TICKET12 := UTL_RAW.SUBSTR(P_TICKET1,17,16);
139: X_TICKET21 := UTL_RAW.SUBSTR(P_TICKET2,1,16);
140: X_TICKET22 := UTL_RAW.SUBSTR(P_TICKET2,17,16);
141: return((X_TICKET11 = X_TICKET21) or (X_TICKET12 = X_TICKET21) or
142: (X_TICKET11 = X_TICKET22) or (X_TICKET12 = X_TICKET22));
143: end COMPARE_SERVICE_TICKETS;

Line 140: X_TICKET22 := UTL_RAW.SUBSTR(P_TICKET2,17,16);

136: end if;
137: X_TICKET11 := UTL_RAW.SUBSTR(P_TICKET1,1,16);
138: X_TICKET12 := UTL_RAW.SUBSTR(P_TICKET1,17,16);
139: X_TICKET21 := UTL_RAW.SUBSTR(P_TICKET2,1,16);
140: X_TICKET22 := UTL_RAW.SUBSTR(P_TICKET2,17,16);
141: return((X_TICKET11 = X_TICKET21) or (X_TICKET12 = X_TICKET21) or
142: (X_TICKET11 = X_TICKET22) or (X_TICKET12 = X_TICKET22));
143: end COMPARE_SERVICE_TICKETS;
144: --