eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_TAG_KEY_PVT dependencies on IEM_TAG_KEYS

Line 74: from iem_tag_keys a, iem_route_rules b

70: l_route_count := 0;
71: l_class_count := 0;
72:
73: select count(*) into l_route_count
74: from iem_tag_keys a, iem_route_rules b
75: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
76:
77: select count(*) into l_class_count
78: from iem_tag_keys a, iem_route_class_rules b

Line 78: from iem_tag_keys a, iem_route_class_rules b

74: from iem_tag_keys a, iem_route_rules b
75: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
76:
77: select count(*) into l_class_count
78: from iem_tag_keys a, iem_route_class_rules b
79: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
80:
81: select count(*) into l_emailproc_count
82: from iem_tag_keys a, iem_emailproc_rules b

Line 82: from iem_tag_keys a, iem_emailproc_rules b

78: from iem_tag_keys a, iem_route_class_rules b
79: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
80:
81: select count(*) into l_emailproc_count
82: from iem_tag_keys a, iem_emailproc_rules b
83: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
84:
85: if (l_route_count > 0 ) or (l_class_count > 0 ) or ( l_emailproc_count > 0 ) then
86: select tag_name into l_tag_name from iem_tag_keys where tag_key_id = p_tagKey_ids_tbl(i);

Line 86: select tag_name into l_tag_name from iem_tag_keys where tag_key_id = p_tagKey_ids_tbl(i);

82: from iem_tag_keys a, iem_emailproc_rules b
83: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
84:
85: if (l_route_count > 0 ) or (l_class_count > 0 ) or ( l_emailproc_count > 0 ) then
86: select tag_name into l_tag_name from iem_tag_keys where tag_key_id = p_tagKey_ids_tbl(i);
87: l_used_tag_name := l_used_tag_name||l_tag_name||', ' ;
88: else
89: DELETE
90: FROM IEM_TAG_KEYS

Line 90: FROM IEM_TAG_KEYS

86: select tag_name into l_tag_name from iem_tag_keys where tag_key_id = p_tagKey_ids_tbl(i);
87: l_used_tag_name := l_used_tag_name||l_tag_name||', ' ;
88: else
89: DELETE
90: FROM IEM_TAG_KEYS
91: WHERE TAG_KEY_ID = p_tagKey_ids_tbl(i);
92:
93: if SQL%NOTFOUND then
94: raise IEM_TAG_NOT_DELETED;

Line 327: select count(*) into l_name_count from iem_tag_keys where UPPER(tag_name) = UPPER(l_key_name);

323: l_key_id_temp := LTRIM(RTRIM(p_key_id));
324: l_key_id := 'IEMS'||l_key_id_temp;
325:
326: --check duplicate value for attribute Name, ID
327: select count(*) into l_name_count from iem_tag_keys where UPPER(tag_name) = UPPER(l_key_name);
328: if l_name_count > 0 then
329: raise IEM_TAG_DUP_KEY_NAME;
330: end if;
331:

Line 332: select count(*) into l_id_count from iem_tag_keys where UPPER(tag_id) = UPPER(l_key_id_temp);

328: if l_name_count > 0 then
329: raise IEM_TAG_DUP_KEY_NAME;
330: end if;
331:
332: select count(*) into l_id_count from iem_tag_keys where UPPER(tag_id) = UPPER(l_key_id_temp);
333: if l_id_count > 0 then
334: raise IEM_TAG_DUP_KEY_ID;
335: end if;
336:

Line 393: SELECT IEM_TAG_KEYS_s1.nextval

389: END IF;
390: end if;
391:
392: --get next sequential number for route_id
393: SELECT IEM_TAG_KEYS_s1.nextval
394: INTO l_seq_id
395: FROM dual;
396:
397: -- G_ROUTE_ID := l_seq_id;

Line 399: INSERT INTO IEM_TAG_KEYS

395: FROM dual;
396:
397: -- G_ROUTE_ID := l_seq_id;
398:
399: INSERT INTO IEM_TAG_KEYS
400: (
401: TAG_KEY_ID,
402: TAG_ID,
403: TAG_NAME,

Line 617: select count(*) into l_count from iem_tag_keys where tag_key_id = p_tag_key_id;

613: -- Initialize API return status to SUCCESS
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615:
616: --valid tag_key_id
617: select count(*) into l_count from iem_tag_keys where tag_key_id = p_tag_key_id;
618: if l_count < 1 then
619: raise IEM_TAG_KEY_ID_NOT_EXIST;
620: end if;
621:

Line 772: l_tag_key_id iem_tag_keys.tag_key_id%type :=0;

768:
769: l_in_tab key_tbl_type ;
770: l_out_tab key_tbl_type ;
771: l_count number;
772: l_tag_key_id iem_tag_keys.tag_key_id%type :=0;
773:
774: l_temp varchar2(256);
775: BEGIN
776: -- Standard Start of API savepoint

Line 805: (select b.tag_key_id from iem_tag_keys b where UPPER(b.tag_id) = UPPER(l_out_tab(i)) );

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
809: for j in 1..l_in_tab.count() loop

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));

Line 814: select tag_key_id into l_tag_key_id from iem_tag_keys where UPPER(tag_id) = UPPER(l_in_tab(j));

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));
815:
816: create_item_account_tags (
817: p_api_version_number => l_api_version_number,
818: p_init_msg_list => FND_API.G_FALSE,

Line 939: select count(*) into l_name_count from iem_tag_keys where UPPER(tag_name) = UPPER(p_key_name) and tag_key_id <> p_tag_key_id;

935: raise IEM_ADM_G_MISS_FOR_NOTNULL;
936: end if;
937:
938: --check duplicate key name
939: select count(*) into l_name_count from iem_tag_keys where UPPER(tag_name) = UPPER(p_key_name) and tag_key_id <> p_tag_key_id;
940:
941: if l_name_count > 0 then
942: raise IEM_TAG_DUP_KEY_NAME;
943: end if;

Line 946: select count(*) into l_id_count from iem_tag_keys where UPPER(tag_id) = UPPER(p_key_id) and tag_key_id <> p_tag_key_id;

942: raise IEM_TAG_DUP_KEY_NAME;
943: end if;
944:
945: --check duplicate key Id
946: select count(*) into l_id_count from iem_tag_keys where UPPER(tag_id) = UPPER(p_key_id) and tag_key_id <> p_tag_key_id;
947:
948: if l_id_count > 0 then
949: raise IEM_TAG_DUP_KEY_ID;
950: end if;

Line 988: update IEM_TAG_KEYS

984: END IF;
985: end if;
986:
987:
988: update IEM_TAG_KEYS
989: set
990: --tag_id=decode(p_key_id,FND_API.G_MISS_CHAR,tag_id,p_key_id),
991: tag_name=decode(p_key_name,null,tag_name,p_key_name),
992: tag_type_code=decode(p_type_type_code,null,tag_type_code,p_type_type_code),