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.IEX_CASES_PVT dependencies on IEX_CASES_ALL_B

Line 32: v_org_id iex_cases_all_b.org_id%TYPE;

28:
29: IS
30: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CAS';
31: l_api_version_number CONSTANT NUMBER := 2.0;
32: v_org_id iex_cases_all_b.org_id%TYPE;
33: v_cas_id iex_cases_all_b.cas_id%TYPE;
34: v_case_number iex_cases_all_b.case_number%TYPE;
35: v_active_flag iex_cases_all_b.active_flag%TYPE;
36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;

Line 33: v_cas_id iex_cases_all_b.cas_id%TYPE;

29: IS
30: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CAS';
31: l_api_version_number CONSTANT NUMBER := 2.0;
32: v_org_id iex_cases_all_b.org_id%TYPE;
33: v_cas_id iex_cases_all_b.cas_id%TYPE;
34: v_case_number iex_cases_all_b.case_number%TYPE;
35: v_active_flag iex_cases_all_b.active_flag%TYPE;
36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;
37: v_status_code iex_cases_all_b.status_code%TYPE;

Line 34: v_case_number iex_cases_all_b.case_number%TYPE;

30: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CAS';
31: l_api_version_number CONSTANT NUMBER := 2.0;
32: v_org_id iex_cases_all_b.org_id%TYPE;
33: v_cas_id iex_cases_all_b.cas_id%TYPE;
34: v_case_number iex_cases_all_b.case_number%TYPE;
35: v_active_flag iex_cases_all_b.active_flag%TYPE;
36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;
37: v_status_code iex_cases_all_b.status_code%TYPE;
38: v_case_state iex_cases_all_b.case_state%TYPE;

Line 35: v_active_flag iex_cases_all_b.active_flag%TYPE;

31: l_api_version_number CONSTANT NUMBER := 2.0;
32: v_org_id iex_cases_all_b.org_id%TYPE;
33: v_cas_id iex_cases_all_b.cas_id%TYPE;
34: v_case_number iex_cases_all_b.case_number%TYPE;
35: v_active_flag iex_cases_all_b.active_flag%TYPE;
36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;
37: v_status_code iex_cases_all_b.status_code%TYPE;
38: v_case_state iex_cases_all_b.case_state%TYPE;
39: v_CASE_ESTABLISHED_DATE DATE;

Line 36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;

32: v_org_id iex_cases_all_b.org_id%TYPE;
33: v_cas_id iex_cases_all_b.cas_id%TYPE;
34: v_case_number iex_cases_all_b.case_number%TYPE;
35: v_active_flag iex_cases_all_b.active_flag%TYPE;
36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;
37: v_status_code iex_cases_all_b.status_code%TYPE;
38: v_case_state iex_cases_all_b.case_state%TYPE;
39: v_CASE_ESTABLISHED_DATE DATE;
40: v_rowid VARCHAR2(24);

Line 37: v_status_code iex_cases_all_b.status_code%TYPE;

33: v_cas_id iex_cases_all_b.cas_id%TYPE;
34: v_case_number iex_cases_all_b.case_number%TYPE;
35: v_active_flag iex_cases_all_b.active_flag%TYPE;
36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;
37: v_status_code iex_cases_all_b.status_code%TYPE;
38: v_case_state iex_cases_all_b.case_state%TYPE;
39: v_CASE_ESTABLISHED_DATE DATE;
40: v_rowid VARCHAR2(24);
41: Cursor c2 is SELECT IEX_CASES_ALL_B_S.nextval from dual;

Line 38: v_case_state iex_cases_all_b.case_state%TYPE;

34: v_case_number iex_cases_all_b.case_number%TYPE;
35: v_active_flag iex_cases_all_b.active_flag%TYPE;
36: v_object_version_number iex_cases_all_b.object_version_number%TYPE;
37: v_status_code iex_cases_all_b.status_code%TYPE;
38: v_case_state iex_cases_all_b.case_state%TYPE;
39: v_CASE_ESTABLISHED_DATE DATE;
40: v_rowid VARCHAR2(24);
41: Cursor c2 is SELECT IEX_CASES_ALL_B_S.nextval from dual;
42:

Line 41: Cursor c2 is SELECT IEX_CASES_ALL_B_S.nextval from dual;

37: v_status_code iex_cases_all_b.status_code%TYPE;
38: v_case_state iex_cases_all_b.case_state%TYPE;
39: v_CASE_ESTABLISHED_DATE DATE;
40: v_rowid VARCHAR2(24);
41: Cursor c2 is SELECT IEX_CASES_ALL_B_S.nextval from dual;
42:
43: BEGIN
44: -- IF PG_DEBUG < 10 THEN
45: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 170: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Insert_Row)

166: -- IF PG_DEBUG < 10 THEN
167: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
168: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'Before Calling iex_cases_pkg.insert_row');
169: END IF;
170: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Insert_Row)
171: IEX_CASES_PKG.Insert_Row(
172: x_rowid =>v_rowid,
173: x_CAS_ID => v_CAS_ID,
174: x_CASE_NUMBER => v_CASE_NUMBER,

Line 304: l_object_version_number iex_cases_all_b.object_version_number%TYPE:=p_cas_rec.object_version_number;

300:
301: IS
302: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CAS';
303: l_api_version_number CONSTANT NUMBER := 2.0;
304: l_object_version_number iex_cases_all_b.object_version_number%TYPE:=p_cas_rec.object_version_number;
305:
306: BEGIN
307: -- IF PG_DEBUG < 10 THEN
308: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 342: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Update_Row)

338: -- IF PG_DEBUG < 10 THEN
339: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
340: IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.lock_row');
341: END IF;
342: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Update_Row)
343: -- call locking table handler
344: IEX_CASES_PKG.lock_row (
345: p_cas_rec.cas_id,
346: l_object_version_number