APPS.IEM_TAG_KEY_PVT dependencies on IEM_ACCOUNT_TAG_KEYS

Line 98: FROM IEM_ACCOUNT_TAG_KEYS

94: raise IEM_TAG_NOT_DELETED;
95: end if;
96:
97: DELETE
98: FROM IEM_ACCOUNT_TAG_KEYS
99: WHERE TAG_KEY_ID = p_tagKey_ids_tbl(i);
100: end if;
101:
102: END LOOP;

Line 109: FROM IEM_ACCOUNT_TAG_KEYS

105: --if ( p_tagKey_ids_tbl.count <> 0 ) then
106: /* FOR i IN p_tagKey_ids_tbl.FIRST..p_tagKey_ids_tbl.LAST LOOP
107:
108: DELETE
109: FROM IEM_ACCOUNT_TAG_KEYS
110: WHERE TAG_KEY_ID = p_tagKey_ids_tbl(i);
111:
112: END LOOP;
113: */

Line 216: delete from iem_account_tag_keys where email_account_id = l_acct_id;

212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: --Actual API starts here
215: l_acct_id := LTRIM(RTRIM(p_email_acct_id));
216: delete from iem_account_tag_keys where email_account_id = l_acct_id;
217:
218: --Standard check of p_commit
219: IF FND_API.to_Boolean(p_commit) THEN
220: COMMIT WORK;

Line 629: SELECT IEM_ACCOUNT_TAG_KEYS_s1.nextval

625: raise IEM_TAG_ACCT_ID_NOT_EXIST;
626: end if;
627:
628: --actual API begins here
629: SELECT IEM_ACCOUNT_TAG_KEYS_s1.nextval
630: INTO l_seq_id
631: FROM dual;
632:
633: INSERT INTO IEM_ACCOUNT_TAG_KEYS

Line 633: INSERT INTO IEM_ACCOUNT_TAG_KEYS

629: SELECT IEM_ACCOUNT_TAG_KEYS_s1.nextval
630: INTO l_seq_id
631: FROM dual;
632:
633: INSERT INTO IEM_ACCOUNT_TAG_KEYS
634: (
635: ACCOUNT_TAG_KEY_ID,
636: EMAIL_ACCOUNT_ID,
637: TAG_KEY_ID,

Line 804: delete from iem_account_tag_keys a where a.email_account_id=p_account_id and a.tag_key_id =

800: l_out_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_out_key_id);
801:
802: --delete association based on OUT list
803: for i in 1..l_out_tab.count() loop
804: delete from iem_account_tag_keys a where a.email_account_id=p_account_id and a.tag_key_id =
805: (select b.tag_key_id from iem_tag_keys b where UPPER(b.tag_id) = UPPER(l_out_tab(i)) );
806: end loop;
807:
808: --add association based on IN list

Line 810: select count(*) into l_count from iem_account_tag_keys a, iem_tag_keys b

806: end loop;
807:
808: --add association based on IN list
809: for j in 1..l_in_tab.count() loop
810: select count(*) into l_count from iem_account_tag_keys a, iem_tag_keys b
811: where a.email_account_id=p_account_id and a.tag_key_id=b.tag_key_id and b.tag_id=l_in_tab(j);
812:
813: if l_count=0 then
814: select tag_key_id into l_tag_key_id from iem_tag_keys where UPPER(tag_id) = UPPER(l_in_tab(j));