APPS.CCT_QDE_PUB dependencies on UTL_RAW

Line 81: if utl_raw.length(agent_id) > utl_raw.length(route_result)

77: short_len number;
78: BEGIN
79: --dbms_output.put_line('IS_BIT_SET' || 'agent_id= '
80: --|| agent_id || 'route_result = ' || route_result);
81: if utl_raw.length(agent_id) > utl_raw.length(route_result)
82: then
83: -- truncate agent_id to size of route result.
84: short_len := utl_raw.length(route_result);
85: short_raw := utl_raw.substr(agent_id,-short_len,short_len);

Line 84: short_len := utl_raw.length(route_result);

80: --|| agent_id || 'route_result = ' || route_result);
81: if utl_raw.length(agent_id) > utl_raw.length(route_result)
82: then
83: -- truncate agent_id to size of route result.
84: short_len := utl_raw.length(route_result);
85: short_raw := utl_raw.substr(agent_id,-short_len,short_len);
86: return utl_raw.compare(utl_raw.bit_and(short_raw, route_result), short_raw);
87: else
88: -- truncate route_result to size of agent_id

Line 85: short_raw := utl_raw.substr(agent_id,-short_len,short_len);

81: if utl_raw.length(agent_id) > utl_raw.length(route_result)
82: then
83: -- truncate agent_id to size of route result.
84: short_len := utl_raw.length(route_result);
85: short_raw := utl_raw.substr(agent_id,-short_len,short_len);
86: return utl_raw.compare(utl_raw.bit_and(short_raw, route_result), short_raw);
87: else
88: -- truncate route_result to size of agent_id
89: short_len := utl_raw.length(agent_id);

Line 86: return utl_raw.compare(utl_raw.bit_and(short_raw, route_result), short_raw);

82: then
83: -- truncate agent_id to size of route result.
84: short_len := utl_raw.length(route_result);
85: short_raw := utl_raw.substr(agent_id,-short_len,short_len);
86: return utl_raw.compare(utl_raw.bit_and(short_raw, route_result), short_raw);
87: else
88: -- truncate route_result to size of agent_id
89: short_len := utl_raw.length(agent_id);
90: short_raw := utl_raw.substr(route_result,-short_len,short_len);

Line 89: short_len := utl_raw.length(agent_id);

85: short_raw := utl_raw.substr(agent_id,-short_len,short_len);
86: return utl_raw.compare(utl_raw.bit_and(short_raw, route_result), short_raw);
87: else
88: -- truncate route_result to size of agent_id
89: short_len := utl_raw.length(agent_id);
90: short_raw := utl_raw.substr(route_result,-short_len,short_len);
91: --dbms_output.put_line('resutl ' || utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id));
92: return utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id);
93: end if;

Line 90: short_raw := utl_raw.substr(route_result,-short_len,short_len);

86: return utl_raw.compare(utl_raw.bit_and(short_raw, route_result), short_raw);
87: else
88: -- truncate route_result to size of agent_id
89: short_len := utl_raw.length(agent_id);
90: short_raw := utl_raw.substr(route_result,-short_len,short_len);
91: --dbms_output.put_line('resutl ' || utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id));
92: return utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id);
93: end if;
94:

Line 91: --dbms_output.put_line('resutl ' || utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id));

87: else
88: -- truncate route_result to size of agent_id
89: short_len := utl_raw.length(agent_id);
90: short_raw := utl_raw.substr(route_result,-short_len,short_len);
91: --dbms_output.put_line('resutl ' || utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id));
92: return utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id);
93: end if;
94:
95: END IS_BIT_SET;

Line 92: return utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id);

88: -- truncate route_result to size of agent_id
89: short_len := utl_raw.length(agent_id);
90: short_raw := utl_raw.substr(route_result,-short_len,short_len);
91: --dbms_output.put_line('resutl ' || utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id));
92: return utl_raw.compare(utl_raw.bit_and(short_raw, agent_id), agent_id);
93: end if;
94:
95: END IS_BIT_SET;
96: