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_CAT_PVT dependencies on OKC_K_ARTICLES_B

Line 65: FROM OKC_K_ARTICLES_B B

61:
62: DELETE FROM OKC_K_ARTICLES_TL T
63: WHERE NOT EXISTS (
64: SELECT NULL
65: FROM OKC_K_ARTICLES_B B
66: WHERE B.ID = T.ID
67: );
68:
69: UPDATE OKC_K_ARTICLES_TL T SET (

Line 158: FROM OKC_K_ARTICLES_BH B

154: );
155: DELETE FROM OKC_K_ARTICLES_TLH T
156: WHERE NOT EXISTS (
157: SELECT NULL
158: FROM OKC_K_ARTICLES_BH B
159: WHERE B.ID = T.ID
160: AND B.MAJOR_VERSION = T.MAJOR_VERSION
161: );
162:

Line 262: -- FUNCTION get_rec for: OKC_K_ARTICLES_B

258:
259: END add_language;
260:
261: ---------------------------------------------------------------------------
262: -- FUNCTION get_rec for: OKC_K_ARTICLES_B
263: ---------------------------------------------------------------------------
264: FUNCTION get_rec (
265: p_cat_rec IN cat_rec_type,
266: x_no_data_found OUT NOCOPY BOOLEAN

Line 268: CURSOR okc_k_articles_b_pk_csr (p_id IN NUMBER) IS

264: FUNCTION get_rec (
265: p_cat_rec IN cat_rec_type,
266: x_no_data_found OUT NOCOPY BOOLEAN
267: ) RETURN cat_rec_type IS
268: CURSOR okc_k_articles_b_pk_csr (p_id IN NUMBER) IS
269: SELECT
270: ID,
271: SAV_SAE_ID,
272: SBT_CODE,

Line 301: FROM Okc_K_Articles_B

297: ATTRIBUTE12,
298: ATTRIBUTE13,
299: ATTRIBUTE14,
300: ATTRIBUTE15
301: FROM Okc_K_Articles_B
302: WHERE okc_k_articles_b.id = p_id;
303: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;
304: l_cat_rec cat_rec_type;
305: BEGIN

Line 302: WHERE okc_k_articles_b.id = p_id;

298: ATTRIBUTE13,
299: ATTRIBUTE14,
300: ATTRIBUTE15
301: FROM Okc_K_Articles_B
302: WHERE okc_k_articles_b.id = p_id;
303: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;
304: l_cat_rec cat_rec_type;
305: BEGIN
306:

Line 303: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;

299: ATTRIBUTE14,
300: ATTRIBUTE15
301: FROM Okc_K_Articles_B
302: WHERE okc_k_articles_b.id = p_id;
303: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;
304: l_cat_rec cat_rec_type;
305: BEGIN
306:
307: IF (l_debug = 'Y') THEN

Line 314: OPEN okc_k_articles_b_pk_csr (p_cat_rec.id);

310: END IF;
311:
312: x_no_data_found := TRUE;
313: -- Get current database values
314: OPEN okc_k_articles_b_pk_csr (p_cat_rec.id);
315: FETCH okc_k_articles_b_pk_csr INTO
316: l_cat_rec.ID,
317: l_cat_rec.SAV_SAE_ID,
318: l_cat_rec.SBT_CODE,

Line 315: FETCH okc_k_articles_b_pk_csr INTO

311:
312: x_no_data_found := TRUE;
313: -- Get current database values
314: OPEN okc_k_articles_b_pk_csr (p_cat_rec.id);
315: FETCH okc_k_articles_b_pk_csr INTO
316: l_cat_rec.ID,
317: l_cat_rec.SAV_SAE_ID,
318: l_cat_rec.SBT_CODE,
319: l_cat_rec.CAT_TYPE,

Line 347: x_no_data_found := okc_k_articles_b_pk_csr%NOTFOUND;

343: l_cat_rec.ATTRIBUTE12,
344: l_cat_rec.ATTRIBUTE13,
345: l_cat_rec.ATTRIBUTE14,
346: l_cat_rec.ATTRIBUTE15;
347: x_no_data_found := okc_k_articles_b_pk_csr%NOTFOUND;
348: CLOSE okc_k_articles_b_pk_csr;
349:
350: IF (l_debug = 'Y') THEN
351: okc_debug.log('800: Leaving get_rec ', 2);

Line 348: CLOSE okc_k_articles_b_pk_csr;

344: l_cat_rec.ATTRIBUTE13,
345: l_cat_rec.ATTRIBUTE14,
346: l_cat_rec.ATTRIBUTE15;
347: x_no_data_found := okc_k_articles_b_pk_csr%NOTFOUND;
348: CLOSE okc_k_articles_b_pk_csr;
349:
350: IF (l_debug = 'Y') THEN
351: okc_debug.log('800: Leaving get_rec ', 2);
352: okc_debug.Reset_Indentation;

Line 901: from OKC_K_ARTICLES_B

897: p_catv_rec IN catv_rec_TYPE) is
898: l_dummy_var varchar2(1) := '?';
899: cursor l_cat_csr is
900: select '!'
901: from OKC_K_ARTICLES_B
902: where id = p_catv_rec.cat_id;
903: begin
904:
905: IF (l_debug = 'Y') THEN

Line 1657: -- insert_row for:OKC_K_ARTICLES_B --

1653: ---------------------------------------------------------------------------
1654: -- PROCEDURE insert_row
1655: ---------------------------------------------------------------------------
1656: -------------------------------------
1657: -- insert_row for:OKC_K_ARTICLES_B --
1658: -------------------------------------
1659: PROCEDURE insert_row(
1660: p_init_msg_list IN VARCHAR2 ,
1661: x_return_status OUT NOCOPY VARCHAR2,

Line 1673: -- Set_Attributes for:OKC_K_ARTICLES_B --

1669: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1670: l_cat_rec cat_rec_type := p_cat_rec;
1671: l_def_cat_rec cat_rec_type;
1672: -----------------------------------------
1673: -- Set_Attributes for:OKC_K_ARTICLES_B --
1674: -----------------------------------------
1675: FUNCTION Set_Attributes (
1676: p_cat_rec IN cat_rec_type,
1677: x_cat_rec OUT NOCOPY cat_rec_type

Line 1712: INSERT INTO OKC_K_ARTICLES_B(

1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_ERROR;
1711: END IF;
1712: INSERT INTO OKC_K_ARTICLES_B(
1713: id,
1714: sav_sae_id,
1715: sbt_code,
1716: cat_type,

Line 2308: -- lock_row for:OKC_K_ARTICLES_B --

2304: ---------------------------------------------------------------------------
2305: -- PROCEDURE lock_row
2306: ---------------------------------------------------------------------------
2307: -----------------------------------
2308: -- lock_row for:OKC_K_ARTICLES_B --
2309: -----------------------------------
2310: PROCEDURE lock_row(
2311: p_init_msg_list IN VARCHAR2 ,
2312: x_return_status OUT NOCOPY VARCHAR2,

Line 2321: FROM OKC_K_ARTICLES_B

2317: E_Resource_Busy EXCEPTION;
2318: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2319: CURSOR lock_csr (p_cat_rec IN cat_rec_type) IS
2320: SELECT OBJECT_VERSION_NUMBER
2321: FROM OKC_K_ARTICLES_B
2322: WHERE ID = p_cat_rec.id
2323: AND OBJECT_VERSION_NUMBER = p_cat_rec.object_version_number
2324: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2325:

Line 2328: FROM OKC_K_ARTICLES_B

2324: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2325:
2326: CURSOR lchk_csr (p_cat_rec IN cat_rec_type) IS
2327: SELECT OBJECT_VERSION_NUMBER
2328: FROM OKC_K_ARTICLES_B
2329: WHERE ID = p_cat_rec.id;
2330: l_api_version CONSTANT NUMBER := 1;
2331: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2333: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

2329: WHERE ID = p_cat_rec.id;
2330: l_api_version CONSTANT NUMBER := 1;
2331: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2333: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2334: lc_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2335: l_row_notfound BOOLEAN := FALSE;
2336: lc_row_notfound BOOLEAN := FALSE;
2337: BEGIN

Line 2334: lc_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

2330: l_api_version CONSTANT NUMBER := 1;
2331: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2333: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2334: lc_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2335: l_row_notfound BOOLEAN := FALSE;
2336: lc_row_notfound BOOLEAN := FALSE;
2337: BEGIN
2338:

Line 2806: -- update_row for:OKC_K_ARTICLES_B --

2802: ---------------------------------------------------------------------------
2803: -- PROCEDURE update_row
2804: ---------------------------------------------------------------------------
2805: -------------------------------------
2806: -- update_row for:OKC_K_ARTICLES_B --
2807: -------------------------------------
2808: PROCEDURE update_row(
2809: p_init_msg_list IN VARCHAR2 ,
2810: x_return_status OUT NOCOPY VARCHAR2,

Line 2979: -- Set_Attributes for:OKC_K_ARTICLES_B --

2975: RETURN(l_return_status);
2976:
2977: END populate_new_record;
2978: -----------------------------------------
2979: -- Set_Attributes for:OKC_K_ARTICLES_B --
2980: -----------------------------------------
2981: FUNCTION Set_Attributes (
2982: p_cat_rec IN cat_rec_type,
2983: x_cat_rec OUT NOCOPY cat_rec_type

Line 3024: UPDATE OKC_K_ARTICLES_B

3020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3021: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3022: RAISE OKC_API.G_EXCEPTION_ERROR;
3023: END IF;
3024: UPDATE OKC_K_ARTICLES_B
3025: SET SAV_SAE_ID = l_def_cat_rec.sav_sae_id,
3026: SBT_CODE = l_def_cat_rec.sbt_code,
3027: CAT_TYPE = l_def_cat_rec.cat_type,
3028: CHR_ID = l_def_cat_rec.chr_id,

Line 3845: -- delete_row for:OKC_K_ARTICLES_B --

3841: ---------------------------------------------------------------------------
3842: -- PROCEDURE delete_row
3843: ---------------------------------------------------------------------------
3844: -------------------------------------
3845: -- delete_row for:OKC_K_ARTICLES_B --
3846: -------------------------------------
3847: PROCEDURE delete_row(
3848: p_init_msg_list IN VARCHAR2 ,
3849: x_return_status OUT NOCOPY VARCHAR2,

Line 3875: DELETE FROM OKC_K_ARTICLES_B

3871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3872: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3873: RAISE OKC_API.G_EXCEPTION_ERROR;
3874: END IF;
3875: DELETE FROM OKC_K_ARTICLES_B
3876: WHERE ID = l_cat_rec.id;
3877:
3878: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3879:

Line 4375: INTO OKC_K_ARTICLES_B

4371: END LOOP;
4372:
4373: FORALL i in 1..l_tabsize
4374: INSERT
4375: INTO OKC_K_ARTICLES_B
4376: (
4377: id,
4378: sav_sae_id,
4379: sbt_code,

Line 4530: INSERT INTO okc_k_articles_bh

4526: okc_debug.Set_Indentation('OKC_CAT_PVT');
4527: okc_debug.log('14900: Entered create_version', 2);
4528: END IF;
4529:
4530: INSERT INTO okc_k_articles_bh
4531: (
4532: major_version,
4533: id,
4534: sav_sae_id,

Line 4598: FROM okc_k_articles_b

4594: attribute12,
4595: attribute13,
4596: attribute14,
4597: attribute15
4598: FROM okc_k_articles_b
4599: WHERE dnz_chr_id = p_chr_id;
4600:
4601: --------------------------------
4602: -- Versioning TL Table

Line 4642: WHERE id in (select id from okc_k_articles_b

4638: last_update_date,
4639: last_update_login,
4640: sav_sav_release
4641: FROM okc_k_articles_tl
4642: WHERE id in (select id from okc_k_articles_b
4643: where dnz_chr_id = p_chr_id);
4644:
4645: IF (l_debug = 'Y') THEN
4646: okc_debug.log('15000: Leaving create_version', 2);

Line 4729: FROM okc_k_articles_bh

4725: last_update_login,
4726: sav_sav_release
4727: FROM okc_k_articles_tlh
4728: WHERE id in (SELECT id
4729: FROM okc_k_articles_bh
4730: WHERE dnz_chr_id = p_chr_id)
4731: AND major_version = p_major_version;
4732:
4733: -----------------------------------------

Line 4737: INSERT INTO okc_k_articles_b

4733: -----------------------------------------
4734: -- Restoring Base Table
4735: -----------------------------------------
4736:
4737: INSERT INTO okc_k_articles_b
4738: (
4739: id,
4740: sav_sae_id,
4741: sbt_code,

Line 4803: FROM okc_k_articles_bh

4799: attribute12,
4800: attribute13,
4801: attribute14,
4802: attribute15
4803: FROM okc_k_articles_bh
4804: WHERE dnz_chr_id = p_chr_id
4805: AND major_version = p_major_version;
4806:
4807: IF (l_debug = 'Y') THEN