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_K_ARTICLES_PVT dependencies on OKC_K_ARTICLES_BH

Line 206: CURSOR OKC_K_ARTICLES_BH_pk_csr (cp_id IN NUMBER, cp_major_version VARCHAR2) IS

202: LAST_AMENDMENT_DATE,
203: MANDATORY_RWA
204: FROM OKC_K_ARTICLES_B t
205: WHERE t.ID = cp_id;
206: CURSOR OKC_K_ARTICLES_BH_pk_csr (cp_id IN NUMBER, cp_major_version VARCHAR2) IS
207: SELECT
208: SAV_SAE_ID,
209: DOCUMENT_TYPE,
210: DOCUMENT_ID,

Line 253: FROM OKC_K_ARTICLES_BH t

249: LAST_UPDATE_DATE,
250: LAST_AMENDED_BY,
251: LAST_AMENDMENT_DATE,
252: MANDATORY_RWA
253: FROM OKC_K_ARTICLES_BH t
254: WHERE t.ID = cp_id and major_version=cp_major_version;
255: BEGIN
256:
257: IF (l_debug = 'Y') THEN

Line 329: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);

325: Okc_Debug.Log('402: Get history database values', 2);
326: END IF;
327:
328: -- Get history database values
329: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);
330: FETCH OKC_K_ARTICLES_BH_pk_csr INTO
331: x_sav_sae_id,
332: x_document_type,
333: x_document_id,

Line 330: FETCH OKC_K_ARTICLES_BH_pk_csr INTO

326: END IF;
327:
328: -- Get history database values
329: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);
330: FETCH OKC_K_ARTICLES_BH_pk_csr INTO
331: x_sav_sae_id,
332: x_document_type,
333: x_document_id,
334: x_cle_id,

Line 377: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN

373: x_last_amended_by,
374: x_last_amendment_date,
375: x_mandatory_rwa;
376:
377: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN
378: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
379: 'ENTITYNAME','OKC_K_ARTICLES_BH',
380: 'PKEY',p_id,
381: 'OVN',p_major_version

Line 379: 'ENTITYNAME','OKC_K_ARTICLES_BH',

375: x_mandatory_rwa;
376:
377: IF OKC_K_ARTICLES_BH_pk_csr%NOTFOUND THEN
378: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
379: 'ENTITYNAME','OKC_K_ARTICLES_BH',
380: 'PKEY',p_id,
381: 'OVN',p_major_version
382: );
383: RAISE NO_DATA_FOUND;

Line 385: CLOSE OKC_K_ARTICLES_BH_pk_csr;

381: 'OVN',p_major_version
382: );
383: RAISE NO_DATA_FOUND;
384: END IF;
385: CLOSE OKC_K_ARTICLES_BH_pk_csr;
386: END IF;
387:
388: IF (l_debug = 'Y') THEN
389: Okc_Debug.Log('500: Leaving get_rec ', 2);

Line 402: -- 'ENTITYNAME','OKC_K_ARTICLES_BH',

398: END IF;
399:
400: -- moved upper where an exception is raised
401: -- Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
402: -- 'ENTITYNAME','OKC_K_ARTICLES_BH',
403: -- 'PKEY',p_id,
404: -- 'OVN',p_major_version
405: -- );
406:

Line 411: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN

407: IF OKC_K_ARTICLES_B_pk_csr%ISOPEN THEN
408: CLOSE OKC_K_ARTICLES_B_pk_csr;
409: END IF;
410:
411: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
412: CLOSE OKC_K_ARTICLES_BH_pk_csr;
413: END IF;
414:
415: RETURN G_RET_STS_ERROR ;

Line 412: CLOSE OKC_K_ARTICLES_BH_pk_csr;

408: CLOSE OKC_K_ARTICLES_B_pk_csr;
409: END IF;
410:
411: IF OKC_K_ARTICLES_BH_pk_csr%ISOPEN THEN
412: CLOSE OKC_K_ARTICLES_BH_pk_csr;
413: END IF;
414:
415: RETURN G_RET_STS_ERROR ;
416:

Line 2824: FROM OKC_K_ARTICLES_BH

2820: FROM okc_k_articles_b
2821: WHERE article_version_id = cp_article_version_id
2822: UNION ALL
2823: SELECT 'Y'
2824: FROM OKC_K_ARTICLES_BH
2825: WHERE article_version_id = cp_article_version_id;
2826:
2827: BEGIN
2828:

Line 3120: INSERT INTO OKC_K_ARTICLES_BH (

3116:
3117: -----------------------------------------
3118: -- Saving Base Table
3119: -----------------------------------------
3120: INSERT INTO OKC_K_ARTICLES_BH (
3121: major_version,
3122: ID,
3123: SAV_SAE_ID,
3124: SAV_SAV_RELEASE,

Line 3461: FROM OKC_K_ARTICLES_BH

3457: ORIG_ARTICLE_ID,
3458: LAST_AMENDED_BY,
3459: LAST_AMENDMENT_DATE,
3460: MANDATORY_RWA
3461: FROM OKC_K_ARTICLES_BH
3462: WHERE document_type = p_doc_type
3463: AND document_id = p_doc_id
3464: AND major_version = p_major_version;
3465:

Line 3509: FROM OKC_K_ARTICLES_BH

3505: -----------------------------------------
3506: -- Restoring Base Table
3507: -----------------------------------------
3508: DELETE
3509: FROM OKC_K_ARTICLES_BH
3510: WHERE document_type = p_doc_type
3511: AND document_id = p_doc_id
3512: AND major_version = p_major_version;
3513: