APPS.IEM_ENCRYPT_TAGS_PVT dependencies on DUAL

Line 87: select to_char(fnd_crypto.randomnumber) into l_ram from dual;

83:
84: --Get random number and shorten it for 5 digits
85: DBMS_RANDOM.INITIALIZE ( 8726527 );
86: --l_ram := TO_CHAR( ABS(DBMS_RANDOM.Random) );
87: select to_char(fnd_crypto.randomnumber) into l_ram from dual;
88:
89: l_ram_len := LENGTH( l_ram );
90: if l_ram_len < 5 then
91: l_token := SUBSTR( l_ram, 1, l_ram_len );

Line 106: FROM dual;

102:
103: --get next sequential number
104: SELECT IEM_ENCRYPTED_TAGS_s1.nextval
105: INTO l_seq_id
106: FROM dual;
107:
108: g_encrypted_id := l_seq_id;
109:
110:

Line 564: FROM dual;

560:
561: --get next sequential number
562: SELECT IEM_ENCRYPTED_TAG_DTLS_S1.nextval
563: INTO l_seq_id
564: FROM dual;
565:
566: INSERT INTO IEM_ENCRYPTED_TAG_DTLS
567: (
568: ENCRYPTED_TAG_DTL_ID,

Line 842: FROM dual;

838: select * into l_encypted_rec from IEM_ENCRYPTED_TAGS where ENCRYPTED_ID=p_encrypted_id;
839:
840: SELECT IEM_ENCRYPTED_TAGS_S1.nextval
841: INTO l_seq_id
842: FROM dual;
843:
844: --l_encypted_rec.ENCRYPTED_ID := l_seq_id;
845: --l_encypted_rec.MESSAGE_ID := p_message_id;
846: --l_encypted_rec.CREATION_DATE := SYSDATE;

Line 912: FROM dual;

908: For v_rec in c_tag_dtls ( p_encrypted_id ) Loop
909: --get next sequential number
910: SELECT IEM_ENCRYPTED_TAG_DTLS_S1.nextval
911: INTO l_seq_dtl_id
912: FROM dual;
913:
914: INSERT INTO IEM_ENCRYPTED_TAG_DTLS
915: (
916: ENCRYPTED_TAG_DTL_ID,