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.OKC_CHR_PVT dependencies on OKC_K_HEADERS_B

Line 297: --Replaced table okc_k_headers_b with headers_All_b table

293: l_dummy_var VARCHAR2(1) := '?';
294: CURSOR l_chrv_csr IS
295: SELECT 'x'
296: --npalepu 08-11-2005 modified for bug # 4691662.
297: --Replaced table okc_k_headers_b with headers_All_b table
298: /* FROM OKC_K_HEADERS_B */
299: FROM OKC_K_HEADERS_ALL_B
300: --end npalepu
301: WHERE id = p_chrv_rec.chr_id_response;

Line 298: /* FROM OKC_K_HEADERS_B */

294: CURSOR l_chrv_csr IS
295: SELECT 'x'
296: --npalepu 08-11-2005 modified for bug # 4691662.
297: --Replaced table okc_k_headers_b with headers_All_b table
298: /* FROM OKC_K_HEADERS_B */
299: FROM OKC_K_HEADERS_ALL_B
300: --end npalepu
301: WHERE id = p_chrv_rec.chr_id_response;
302:

Line 381: --Replaced table okc_k_headers_b with headers_All_b table

377: l_dummy_var VARCHAR2(1) := '?';
378: CURSOR l_chrv_csr IS
379: SELECT 'x'
380: --npalepu 08-11-2005 modified for bug # 4691662.
381: --Replaced table okc_k_headers_b with headers_All_b table
382: /* FROM OKC_K_HEADERS_B */
383: FROM OKC_K_HEADERS_ALL_B
384: --end npalepu
385: WHERE id = p_chrv_rec.chr_id_award;

Line 382: /* FROM OKC_K_HEADERS_B */

378: CURSOR l_chrv_csr IS
379: SELECT 'x'
380: --npalepu 08-11-2005 modified for bug # 4691662.
381: --Replaced table okc_k_headers_b with headers_All_b table
382: /* FROM OKC_K_HEADERS_B */
383: FROM OKC_K_HEADERS_ALL_B
384: --end npalepu
385: WHERE id = p_chrv_rec.chr_id_award;
386:

Line 2361: SELECT okc_k_headers_b_s.NEXTVAL

2357:
2358: l_id NUMBER;
2359:
2360: CURSOR l_seq_csr IS
2361: SELECT okc_k_headers_b_s.NEXTVAL
2362: FROM dual;
2363:
2364: BEGIN
2365:

Line 2449: FROM OKC_K_HEADERS_B B

2445:
2446: DELETE FROM OKC_K_HEADERS_TL T
2447: WHERE NOT EXISTS (
2448: SELECT NULL
2449: FROM OKC_K_HEADERS_B B
2450: WHERE B.ID = T.ID
2451: );
2452:
2453: UPDATE OKC_K_HEADERS_TL T SET (

Line 2554: FROM OKC_K_HEADERS_BH B

2550: /*
2551: DELETE FROM OKC_K_HEADERS_TLH T
2552: WHERE NOT EXISTS (
2553: SELECT NULL
2554: FROM OKC_K_HEADERS_BH B
2555: WHERE B.ID = T.ID
2556: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2557: );
2558:

Line 4040: --Replaced table okc_k_headers_b with headers_All_b table

4036: IS
4037: CURSOR l_chr_csr1 IS
4038: SELECT 'x'
4039: --npalepu 08-11-2005 modified for bug # 4691662.
4040: --Replaced table okc_k_headers_b with headers_All_b table
4041: /* FROM okc_k_headers_b */
4042: FROM okc_k_headers_all_b
4043: --end npalepu
4044: WHERE contract_number = p_chrv_rec.contract_number

Line 4041: /* FROM okc_k_headers_b */

4037: CURSOR l_chr_csr1 IS
4038: SELECT 'x'
4039: --npalepu 08-11-2005 modified for bug # 4691662.
4040: --Replaced table okc_k_headers_b with headers_All_b table
4041: /* FROM okc_k_headers_b */
4042: FROM okc_k_headers_all_b
4043: --end npalepu
4044: WHERE contract_number = p_chrv_rec.contract_number
4045: AND contract_number_modifier IS NULL

Line 4051: --Replaced table okc_k_headers_b with headers_All_b table

4047:
4048: CURSOR l_chr_csr2 IS
4049: SELECT 'x'
4050: --npalepu 08-11-2005 modified for bug # 4691662.
4051: --Replaced table okc_k_headers_b with headers_All_b table
4052: /* FROM okc_k_headers_b */
4053: FROM okc_k_headers_all_b
4054: --end npalepu
4055: WHERE contract_number = p_chrv_rec.contract_number

Line 4052: /* FROM okc_k_headers_b */

4048: CURSOR l_chr_csr2 IS
4049: SELECT 'x'
4050: --npalepu 08-11-2005 modified for bug # 4691662.
4051: --Replaced table okc_k_headers_b with headers_All_b table
4052: /* FROM okc_k_headers_b */
4053: FROM okc_k_headers_all_b
4054: --end npalepu
4055: WHERE contract_number = p_chrv_rec.contract_number
4056: AND contract_number_modifier = p_chrv_rec.contract_number_modifier

Line 4125: --Replaced table okc_k_headers_b with headers_All_b table

4121: ) RETURN VARCHAR2 IS
4122: CURSOR l_chr_csr1 IS
4123: SELECT 'x'
4124: --npalepu 08-11-2005 modified for bug # 4691662.
4125: --Replaced table okc_k_headers_b with headers_All_b table
4126: /* FROM okc_k_headers_b */
4127: FROM okc_k_headers_all_b
4128: --end npalepu
4129: WHERE contract_number = p_chrv_rec.contract_number

Line 4126: /* FROM okc_k_headers_b */

4122: CURSOR l_chr_csr1 IS
4123: SELECT 'x'
4124: --npalepu 08-11-2005 modified for bug # 4691662.
4125: --Replaced table okc_k_headers_b with headers_All_b table
4126: /* FROM okc_k_headers_b */
4127: FROM okc_k_headers_all_b
4128: --end npalepu
4129: WHERE contract_number = p_chrv_rec.contract_number
4130: AND contract_number_modifier IS NULL

Line 4136: --Replaced table okc_k_headers_b with headers_All_b table

4132:
4133: CURSOR l_chr_csr2 IS
4134: SELECT 'x'
4135: --npalepu 08-11-2005 modified for bug # 4691662.
4136: --Replaced table okc_k_headers_b with headers_All_b table
4137: /* FROM okc_k_headers_b */
4138: FROM okc_k_headers_all_b
4139: --end npalepu
4140: WHERE contract_number = p_chrv_rec.contract_number

Line 4137: /* FROM okc_k_headers_b */

4133: CURSOR l_chr_csr2 IS
4134: SELECT 'x'
4135: --npalepu 08-11-2005 modified for bug # 4691662.
4136: --Replaced table okc_k_headers_b with headers_All_b table
4137: /* FROM okc_k_headers_b */
4138: FROM okc_k_headers_all_b
4139: --end npalepu
4140: WHERE contract_number = p_chrv_rec.contract_number
4141: AND contract_number_modifier = p_chrv_rec.contract_number_modifier

Line 5663: l_object_version_number OKC_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;

5659: WHERE ID = p_chr_rec.id;
5660: l_api_version CONSTANT NUMBER := 1;
5661: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5662: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5663: l_object_version_number OKC_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
5664: lc_object_version_number OKC_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
5665: l_row_notfound BOOLEAN := FALSE;
5666: lc_row_notfound BOOLEAN := FALSE;
5667: BEGIN

Line 5664: lc_object_version_number OKC_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;

5660: l_api_version CONSTANT NUMBER := 1;
5661: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5662: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5663: l_object_version_number OKC_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
5664: lc_object_version_number OKC_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
5665: l_row_notfound BOOLEAN := FALSE;
5666: lc_row_notfound BOOLEAN := FALSE;
5667: BEGIN
5668: