APPS.IEM_ENCRYPT_TAGS_PVT dependencies on IEM_ENCRYPTED_TAG_DTLS

Line 312: FROM IEM_ENCRYPTED_TAG_DTLS

308: raise IEM_MSG_ID_NOT_FOUND;
309: end if;
310:
311: DELETE
312: FROM IEM_ENCRYPTED_TAG_DTLS
313: WHERE ENCRYPTED_ID = l_encpt_id;
314:
315: if SQL%NOTFOUND then
316: null;

Line 562: SELECT IEM_ENCRYPTED_TAG_DTLS_S1.nextval

558: l_key := LTRIM(RTRIM(p_key));
559: l_val := LTRIM(RTRIM(p_val));
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

Line 566: INSERT INTO IEM_ENCRYPTED_TAG_DTLS

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,
569: KEY,
570: VALUE,

Line 804: cursor c_tag_dtls (p_encypted_id iem_encrypted_tag_dtls.encrypted_id%type)

800: l_seq_id number;
801: l_seq_dtl_id number;
802:
803: l_encypted_rec IEM_ENCRYPTED_TAGS%ROWTYPE;
804: cursor c_tag_dtls (p_encypted_id iem_encrypted_tag_dtls.encrypted_id%type)
805: is
806: select key, value from iem_encrypted_tag_dtls where encrypted_id = p_encypted_id;
807:
808:

Line 806: select key, value from iem_encrypted_tag_dtls where encrypted_id = p_encypted_id;

802:
803: l_encypted_rec IEM_ENCRYPTED_TAGS%ROWTYPE;
804: cursor c_tag_dtls (p_encypted_id iem_encrypted_tag_dtls.encrypted_id%type)
805: is
806: select key, value from iem_encrypted_tag_dtls where encrypted_id = p_encypted_id;
807:
808:
809: IEM_MSG_ID_NOT_FOUND EXCEPTION;
810: IEM_NO_ENCRYPTEID_FOR_MSGID EXCEPTION;

Line 910: SELECT IEM_ENCRYPTED_TAG_DTLS_S1.nextval

906: );
907:
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

Line 914: INSERT INTO IEM_ENCRYPTED_TAG_DTLS

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,
917: KEY,
918: VALUE,