APPS.IEX_CASE_OWNER_PUB dependencies on IEX_CASES_ALL_B

Line 55: /* this procedure will run load balance on table iex_cases_all_b

51: RETCODE := l_return_status;
52:
53: END IEX_CASE_OWNER_CONCUR;
54:
55: /* this procedure will run load balance on table iex_cases_all_b
56: */
57: PROCEDURE Run_Load_Balance(p_api_version IN NUMBER,
58: p_commit IN VARCHAR2,
59: p_init_msg_list IN VARCHAR2,

Line 75: FROM iex_cases_all_b;

71: l_user NUMBER := FND_GLOBAL.USER_ID;
72:
73: CURSOR c_parties IS
74: SELECT DISTINCT party_id
75: FROM iex_cases_all_b;
76:
77: --Begin bug#5246309 schekuri 29-Jun-2006
78: --Changed the query to get the resource from hz_customer_profiles
79: CURSOR c_party_resource(p_party_id NUMBER) IS

Line 108: FROM iex_cases_all_b

104: --End bug#5246309 schekuri 29-Jun-2006
105:
106: CURSOR c_party_case_count(p_party_id NUMBER) IS
107: SELECT count(1)
108: FROM iex_cases_all_b
109: WHERE party_id = p_party_id;
110:
111: CURSOR c_party_case_id(p_party_id NUMBER) IS
112: SELECT cas_id

Line 113: FROM iex_cases_all_b

109: WHERE party_id = p_party_id;
110:
111: CURSOR c_party_case_id(p_party_id NUMBER) IS
112: SELECT cas_id
113: FROM iex_cases_all_b
114: WHERE party_id = p_party_id;
115:
116: TYPE number_tab_type IS TABLE OF NUMBER;
117: l_p_rs_id_tab number_tab_type;

Line 214: UPDATE iex_cases_all_b

210: || ':assigned_count=' || l_p_rs_cnt_tab(l_idx)
211: || ':case_id=' || l_p_case_id_tab(i));
212: END IF;
213:
214: UPDATE iex_cases_all_b
215: SET owner_resource_id = l_p_rs_id_tab(l_idx)
216: WHERE cas_id = l_p_case_id_tab(i);
217:
218: l_p_rs_cnt_tab(l_idx) := l_p_rs_cnt_tab(l_idx) + 1;