APPS.IEX_CASE_UTL_PUB dependencies on IEX_CASES_ALL_B

Line 264: select * from iex_cases_all_b

260: /** Populate Case Record **/
261: PROCEDURE PopCaseRec(p_cas_id IN NUMBER,
262: x_cas_rec OUT NOCOPY iex_cases_pvt.cas_rec_type) IS
263: Cursor Case_rec_cur (p_cas_id in number)is
264: select * from iex_cases_all_b
265: where cas_id =p_cas_id
266: and active_flag ='Y';
267:
268: Cursor Case_comments_cur (p_cas_id in number)is

Line 551: select iex_cases_all_b_s.nextval

547:
548:
549: BEGIN
550:
551: select iex_cases_all_b_s.nextval
552: into itemkey
553: from dual;
554:
555: -- IF PG_DEBUG < 10 THEN

Line 714: l_case_sql VARCHAR2(2000):= ' and exists (select null from iex_cases_all_b ICAS where ICAS.cas_id = a.cas_id'||

710:
711: l_column_name VARCHAR2(1000) :=P_case_definition_tbl(1).column_name;
712: l_column_value VARCHAR2(1000) :=P_case_definition_tbl(1).column_value;
713: l_table_name VARCHAR2(1000) :=P_case_definition_tbl(1).table_name;
714: l_case_sql VARCHAR2(2000):= ' and exists (select null from iex_cases_all_b ICAS where ICAS.cas_id = a.cas_id'||
715: ' and ICAS.case_state='||'''OPEN''' ||
716: ' and ICAS.active_flag='||'''Y''' ||' ) ';
717:
718: -- clchang updated for sql bind var 05/07/2003

Line 1001: FROM iex_cases_all_b

997: IF (l_cas_id IS NOT NULL) AND (l_cas_id <> FND_API.G_MISS_NUM) THEN
998: --May have to check for status_code too.
999: SELECT cas_id,object_version_number
1000: INTO l_cas_id,l_object_version_number
1001: FROM iex_cases_all_b
1002: WHERE cas_id = p_cas_id
1003: AND case_state = 'OPEN'
1004: and active_flag ='Y';
1005: ELSE

Line 1470: FROM iex_cases_all_b

1466: -- Check for valid cas_id or Case Definition has to be passed
1467: BEGIN
1468: IF (l_cas_id IS NOT NULL) AND (l_cas_id <> FND_API.G_MISS_NUM) THEN
1469: SELECT cas_id INTO l_cas_id
1470: FROM iex_cases_all_b
1471: WHERE cas_id = p_cas_id
1472: AND case_state = 'OPEN'
1473: and active_flag ='Y';
1474:

Line 1963: iex_Cases_all_b b

1959:
1960: cursor c_getname(p_old_case_id IN NUMBER) is
1961: Select user_name
1962: from jtf_rs_resource_extns a,
1963: iex_Cases_all_b b
1964: where b.cas_id =p_old_case_id
1965: and a.resource_id = nvl(b.access_resource_id,
1966: fnd_profile.value('IEX_DEFAULT_CASE_AGENT'));
1967:

Line 2096: FROM iex_cases_all_b

2092: -- Check for valid cas_id or Case Definition has to be passed
2093: BEGIN
2094: IF (l_cas_id IS NOT NULL) AND (l_cas_id <> FND_API.G_MISS_NUM) THEN
2095: SELECT cas_id INTO l_cas_id
2096: FROM iex_cases_all_b
2097: WHERE cas_id = p_cas_id
2098: AND case_state = 'OPEN'
2099: and active_flag ='Y';
2100:

Line 2716: FROM iex_cases_all_b

2712: IF (p_cas_rec.cas_id IS NOT NULL) AND (p_cas_rec.cas_id <> FND_API.G_MISS_NUM) THEN
2713: --May have to check for status_code too.
2714: SELECT cas_id,object_version_number
2715: INTO l_cas_id,l_object_version_number
2716: FROM iex_cases_all_b
2717: WHERE cas_id = p_cas_rec.cas_id
2718: and active_flag ='Y';
2719:
2720: ELSE