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.FTE_SEL_GROUPS_PKG dependencies on FTE_SEL_GROUPS

Line 1: PACKAGE BODY FTE_SEL_GROUPS_PKG AS

1: PACKAGE BODY FTE_SEL_GROUPS_PKG AS
2: /* $Header: FTESELGB.pls 120.4 2005/08/18 12:09:12 parkhj noship $ */
3:
4: TYPE rule_rest_rec IS RECORD (
5: rule_attribute_id NUMBER,

Line 38: fte_sel_groups gr

34:
35: CURSOR c_assign IS
36: SELECT start_date, end_date
37: FROM fte_sel_group_assignments ga,
38: fte_sel_groups gr
39: WHERE gr.group_id = ga.group_id AND
40: gr.group_id <> p_group_id AND
41: ga.customer_id = p_assignee_id AND
42: p_assignee_type = 'CUST'

Line 46: fte_sel_groups gr

42: p_assignee_type = 'CUST'
43: UNION ALL
44: SELECT start_date, end_date
45: FROM fte_sel_group_assignments ga,
46: fte_sel_groups gr
47: WHERE gr.group_id = ga.group_id AND
48: gr.group_id <> p_group_id AND
49: ga.customer_site_id = p_assignee_id AND
50: p_assignee_type = 'CUST_SITE'

Line 54: fte_sel_groups gr

50: p_assignee_type = 'CUST_SITE'
51: UNION ALL
52: SELECT start_date, end_date
53: FROM fte_sel_group_assignments ga,
54: fte_sel_groups gr
55: WHERE gr.group_id = ga.group_id AND
56: gr.group_id <> p_group_id AND
57: ga.organization_id = p_assignee_id AND
58: p_assignee_type = 'ORG'

Line 62: fte_sel_groups gr

58: p_assignee_type = 'ORG'
59: UNION ALL
60: SELECT start_date, end_date
61: FROM fte_sel_group_assignments ga,
62: fte_sel_groups gr
63: WHERE gr.group_id = ga.group_id AND
64: gr.group_id <> p_group_id AND
65: ga.organization_id is null AND
66: ga.customer_id is null AND

Line 150: FROM fte_sel_groups

146: x_msg_data OUT NOCOPY VARCHAR2) IS
147:
148: CURSOR c_unique_name IS
149: SELECT name
150: FROM fte_sel_groups
151: WHERE name = p_name AND
152: group_id <> p_group_id;
153:
154: CURSOR c_assignee IS

Line 269: FROM fte_sel_groups

265: x_msg_data OUT NOCOPY VARCHAR2) IS
266:
267: CURSOR c_valid_assign IS
268: SELECT group_id, start_date, end_date
269: FROM fte_sel_groups
270: WHERE name = p_group_name and
271: object_id = 1 and
272: nvl(end_date, sysdate) >= sysdate and
273: p_assignee_type = 'CUST' and

Line 282: FROM fte_sel_groups

278: customer_id is null and
279: customer_site_id is null)
280: UNION ALL
281: SELECT group_id, start_date, end_date
282: FROM fte_sel_groups
283: WHERE name = p_group_name and
284: object_id = 1 and
285: nvl(end_date, sysdate) >= sysdate and
286: p_assignee_type = 'CUST_SITE' and

Line 295: FROM fte_sel_groups

291: customer_id is null and
292: customer_site_id is null)
293: UNION ALL
294: SELECT group_id, start_date, end_date
295: FROM fte_sel_groups
296: WHERE name = p_group_name and
297: object_id = 1 and
298: nvl(end_date, sysdate) >= sysdate and
299: p_assignee_type = 'ORG' and

Line 306: FROM fte_sel_groups

302: customer_id is not null or -- CUST
303: customer_site_id is not null) -- CUST_SITE
304: UNION ALL
305: SELECT group_id, start_date, end_date
306: FROM fte_sel_groups
307: WHERE name = p_group_name and
308: object_id = 1 and
309: nvl(end_date, sysdate) >= sysdate and
310: p_assignee_type = 'ENT' and

Line 439: select fte_sel_groups_s.nextval

435: x_msg_data OUT NOCOPY VARCHAR2) IS
436:
437:
438: cursor c_get_next_group_id IS
439: select fte_sel_groups_s.nextval
440: from dual;
441:
442: l_new_group_id NUMBER;
443:

Line 592: -- 1) FTE_SEL_GROUPS

588: BEGIN
589:
590: --
591: -- Copy group:
592: -- 1) FTE_SEL_GROUPS
593: -- 2) FTE_SEL_GROUP_ATTRIBUTES
594: -- 3) FTE_SEL_RULES
595: -- 4) FTE_SEL_RULE_RESTRICTIONS
596: -- 5) FTE_SEL_RESULTS

Line 625: -- 1) FTE_SEL_GROUPS

621: l_t_new_group_id := to_char(l_new_group_id);
622:
623:
624: --
625: -- 1) FTE_SEL_GROUPS
626: --
627: BEGIN
628: SAVEPOINT insert_fte_sel_groups;
629:

Line 628: SAVEPOINT insert_fte_sel_groups;

624: --
625: -- 1) FTE_SEL_GROUPS
626: --
627: BEGIN
628: SAVEPOINT insert_fte_sel_groups;
629:
630: INSERT INTO fte_sel_groups(GROUP_ID,
631: NAME,
632: DESCRIPTION,

Line 630: INSERT INTO fte_sel_groups(GROUP_ID,

626: --
627: BEGIN
628: SAVEPOINT insert_fte_sel_groups;
629:
630: INSERT INTO fte_sel_groups(GROUP_ID,
631: NAME,
632: DESCRIPTION,
633: OBJECT_ID,
634: START_DATE,

Line 656: FROM fte_sel_groups

652: -1,
653: -1,
654: 'N',
655: group_status_flag
656: FROM fte_sel_groups
657: WHERE group_id = p_group_id);
658:
659:
660: -- substr(name,1,decode(instr(name, '('),0,30,instr(name,'('))-2)||' (Copy# '||l_new_group_id||')',

Line 664: ROLLBACK TO insert_fte_sel_groups;

660: -- substr(name,1,decode(instr(name, '('),0,30,instr(name,'('))-2)||' (Copy# '||l_new_group_id||')',
661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: ROLLBACK TO insert_fte_sel_groups;
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
666: RETURN;
667: END;
668:

Line 1146: WSH_UTIL_CORE.Println('The unexpected error from FTE_SEL_GROUPS_PKG.COPY_GROUP is ' ||l_error_text);

1142: WHEN OTHERS THEN
1143: x_group_id := null;
1144: l_error_code := SQLCODE;
1145: l_error_text := SQLERRM;
1146: WSH_UTIL_CORE.Println('The unexpected error from FTE_SEL_GROUPS_PKG.COPY_GROUP is ' ||l_error_text);
1147: WSH_UTIL_CORE.default_handler('FTE_SEL_GROUPS_PKG.COPY_GROUP');
1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1149: RETURN;
1150:

Line 1147: WSH_UTIL_CORE.default_handler('FTE_SEL_GROUPS_PKG.COPY_GROUP');

1143: x_group_id := null;
1144: l_error_code := SQLCODE;
1145: l_error_text := SQLERRM;
1146: WSH_UTIL_CORE.Println('The unexpected error from FTE_SEL_GROUPS_PKG.COPY_GROUP is ' ||l_error_text);
1147: WSH_UTIL_CORE.default_handler('FTE_SEL_GROUPS_PKG.COPY_GROUP');
1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1149: RETURN;
1150:
1151: END COPY_GROUP;

Line 1195: END FTE_SEL_GROUPS_PKG;

1191: RETURN all_valid;
1192:
1193: END Is_Valid_Region;
1194:
1195: END FTE_SEL_GROUPS_PKG;