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.OKL_VP_CAT_PVT dependencies on OKC_K_ARTICLES_B

Line 49: FROM OKC_K_ARTICLES_B B --fixed bug 3321017 by kmotepal

45: BEGIN
46: DELETE FROM OKC_K_ARTICLES_TL T
47: WHERE NOT EXISTS (
48: SELECT NULL
49: FROM OKC_K_ARTICLES_B B --fixed bug 3321017 by kmotepal
50: WHERE B.ID = T.ID
51: );
52:
53: UPDATE OKC_K_ARTICLES_TL T SET (

Line 145: -- FUNCTION get_rec for: OKC_K_ARTICLES_B

141:
142: END add_language;
143:
144: ---------------------------------------------------------------------------
145: -- FUNCTION get_rec for: OKC_K_ARTICLES_B
146: ---------------------------------------------------------------------------
147: FUNCTION get_rec (
148: p_cat_rec IN cat_rec_type,
149: x_no_data_found OUT NOCOPY BOOLEAN

Line 151: CURSOR okc_k_articles_b_pk_csr (p_id IN NUMBER) IS

147: FUNCTION get_rec (
148: p_cat_rec IN cat_rec_type,
149: x_no_data_found OUT NOCOPY BOOLEAN
150: ) RETURN cat_rec_type IS
151: CURSOR okc_k_articles_b_pk_csr (p_id IN NUMBER) IS
152: SELECT
153: ID,
154: SAV_SAE_ID,
155: SBT_CODE,

Line 185: FROM Okc_K_Articles_B

181: ATTRIBUTE13,
182: ATTRIBUTE14,
183: ATTRIBUTE15,
184: SECURITY_GROUP_ID
185: FROM Okc_K_Articles_B
186: WHERE okc_k_articles_b.id = p_id;
187: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;
188: l_cat_rec cat_rec_type;
189: BEGIN

Line 186: WHERE okc_k_articles_b.id = p_id;

182: ATTRIBUTE14,
183: ATTRIBUTE15,
184: SECURITY_GROUP_ID
185: FROM Okc_K_Articles_B
186: WHERE okc_k_articles_b.id = p_id;
187: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;
188: l_cat_rec cat_rec_type;
189: BEGIN
190: x_no_data_found := TRUE;

Line 187: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;

183: ATTRIBUTE15,
184: SECURITY_GROUP_ID
185: FROM Okc_K_Articles_B
186: WHERE okc_k_articles_b.id = p_id;
187: l_okc_k_articles_b_pk okc_k_articles_b_pk_csr%ROWTYPE;
188: l_cat_rec cat_rec_type;
189: BEGIN
190: x_no_data_found := TRUE;
191: -- Get current database values

Line 192: OPEN okc_k_articles_b_pk_csr (p_cat_rec.id);

188: l_cat_rec cat_rec_type;
189: BEGIN
190: x_no_data_found := TRUE;
191: -- Get current database values
192: OPEN okc_k_articles_b_pk_csr (p_cat_rec.id);
193: FETCH okc_k_articles_b_pk_csr INTO
194: l_cat_rec.ID,
195: l_cat_rec.SAV_SAE_ID,
196: l_cat_rec.SBT_CODE,

Line 193: FETCH okc_k_articles_b_pk_csr INTO

189: BEGIN
190: x_no_data_found := TRUE;
191: -- Get current database values
192: OPEN okc_k_articles_b_pk_csr (p_cat_rec.id);
193: FETCH okc_k_articles_b_pk_csr INTO
194: l_cat_rec.ID,
195: l_cat_rec.SAV_SAE_ID,
196: l_cat_rec.SBT_CODE,
197: l_cat_rec.CAT_TYPE,

Line 226: x_no_data_found := okc_k_articles_b_pk_csr%NOTFOUND;

222: l_cat_rec.ATTRIBUTE13,
223: l_cat_rec.ATTRIBUTE14,
224: l_cat_rec.ATTRIBUTE15,
225: l_cat_rec.SECURITY_GROUP_ID;
226: x_no_data_found := okc_k_articles_b_pk_csr%NOTFOUND;
227: CLOSE okc_k_articles_b_pk_csr;
228: RETURN(l_cat_rec);
229: END get_rec;
230:

Line 227: CLOSE okc_k_articles_b_pk_csr;

223: l_cat_rec.ATTRIBUTE14,
224: l_cat_rec.ATTRIBUTE15,
225: l_cat_rec.SECURITY_GROUP_ID;
226: x_no_data_found := okc_k_articles_b_pk_csr%NOTFOUND;
227: CLOSE okc_k_articles_b_pk_csr;
228: RETURN(l_cat_rec);
229: END get_rec;
230:
231: FUNCTION get_rec (

Line 670: from OKC_K_ARTICLES_B

666: p_catv_rec IN catv_rec_TYPE) is
667: l_dummy_var varchar2(1) := '?';
668: cursor l_cat_csr is
669: select '!'
670: from OKC_K_ARTICLES_B
671: where id = p_catv_rec.cat_id;
672: begin
673: x_return_status := OKC_API.G_RET_STS_SUCCESS;
674: if (p_catv_rec.cat_id = OKC_API.G_MISS_NUM or p_catv_rec.cat_id is NULL) then

Line 1567: -- insert_row for:OKC_K_ARTICLES_B --

1563: ---------------------------------------------------------------------------
1564: -- PROCEDURE insert_row
1565: ---------------------------------------------------------------------------
1566: -------------------------------------
1567: -- insert_row for:OKC_K_ARTICLES_B --
1568: -------------------------------------
1569: PROCEDURE insert_row(
1570: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1571: x_return_status OUT NOCOPY VARCHAR2,

Line 1583: -- Set_Attributes for:OKC_K_ARTICLES_B --

1579: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1580: l_cat_rec cat_rec_type := p_cat_rec;
1581: l_def_cat_rec cat_rec_type;
1582: -----------------------------------------
1583: -- Set_Attributes for:OKC_K_ARTICLES_B --
1584: -----------------------------------------
1585: FUNCTION Set_Attributes (
1586: p_cat_rec IN cat_rec_type,
1587: x_cat_rec OUT NOCOPY cat_rec_type

Line 1614: INSERT INTO OKC_K_ARTICLES_B(

1610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1612: RAISE OKC_API.G_EXCEPTION_ERROR;
1613: END IF;
1614: INSERT INTO OKC_K_ARTICLES_B(
1615: id,
1616: sav_sae_id,
1617: sbt_code,
1618: cat_type,

Line 2074: -- lock_row for:OKC_K_ARTICLES_B --

2070: ---------------------------------------------------------------------------
2071: -- PROCEDURE lock_row
2072: ---------------------------------------------------------------------------
2073: -----------------------------------
2074: -- lock_row for:OKC_K_ARTICLES_B --
2075: -----------------------------------
2076: PROCEDURE lock_row(
2077: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2078: x_return_status OUT NOCOPY VARCHAR2,

Line 2087: FROM OKC_K_ARTICLES_B

2083: E_Resource_Busy EXCEPTION;
2084: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2085: CURSOR lock_csr (p_cat_rec IN cat_rec_type) IS
2086: SELECT OBJECT_VERSION_NUMBER
2087: FROM OKC_K_ARTICLES_B
2088: WHERE ID = p_cat_rec.id
2089: AND OBJECT_VERSION_NUMBER = p_cat_rec.object_version_number
2090: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2091:

Line 2094: FROM OKC_K_ARTICLES_B

2090: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2091:
2092: CURSOR lchk_csr (p_cat_rec IN cat_rec_type) IS
2093: SELECT OBJECT_VERSION_NUMBER
2094: FROM OKC_K_ARTICLES_B
2095: WHERE ID = p_cat_rec.id;
2096: l_api_version CONSTANT NUMBER := 1;
2097: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2098: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2099: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

2095: WHERE ID = p_cat_rec.id;
2096: l_api_version CONSTANT NUMBER := 1;
2097: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2098: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2099: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2100: lc_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2101: l_row_notfound BOOLEAN := FALSE;
2102: lc_row_notfound BOOLEAN := FALSE;
2103: BEGIN

Line 2100: lc_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;

2096: l_api_version CONSTANT NUMBER := 1;
2097: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2098: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2099: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2100: lc_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2101: l_row_notfound BOOLEAN := FALSE;
2102: lc_row_notfound BOOLEAN := FALSE;
2103: BEGIN
2104: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2427: -- update_row for:OKC_K_ARTICLES_B --

2423: ---------------------------------------------------------------------------
2424: -- PROCEDURE update_row
2425: ---------------------------------------------------------------------------
2426: -------------------------------------
2427: -- update_row for:OKC_K_ARTICLES_B --
2428: -------------------------------------
2429: PROCEDURE update_row(
2430: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2431: x_return_status OUT NOCOPY VARCHAR2,

Line 2591: -- Set_Attributes for:OKC_K_ARTICLES_B --

2587: END IF;
2588: RETURN(l_return_status);
2589: END populate_new_record;
2590: -----------------------------------------
2591: -- Set_Attributes for:OKC_K_ARTICLES_B --
2592: -----------------------------------------
2593: FUNCTION Set_Attributes (
2594: p_cat_rec IN cat_rec_type,
2595: x_cat_rec OUT NOCOPY cat_rec_type

Line 2628: UPDATE OKC_K_ARTICLES_B

2624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2625: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2626: RAISE OKC_API.G_EXCEPTION_ERROR;
2627: END IF;
2628: UPDATE OKC_K_ARTICLES_B
2629: SET SAV_SAE_ID = l_def_cat_rec.sav_sae_id,
2630: SBT_CODE = l_def_cat_rec.sbt_code,
2631: CAT_TYPE = l_def_cat_rec.cat_type,
2632: CHR_ID = l_def_cat_rec.chr_id,

Line 3305: -- delete_row for:OKC_K_ARTICLES_B --

3301: ---------------------------------------------------------------------------
3302: -- PROCEDURE delete_row
3303: ---------------------------------------------------------------------------
3304: -------------------------------------
3305: -- delete_row for:OKC_K_ARTICLES_B --
3306: -------------------------------------
3307: PROCEDURE delete_row(
3308: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3309: x_return_status OUT NOCOPY VARCHAR2,

Line 3329: DELETE FROM OKC_K_ARTICLES_B

3325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3326: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3327: RAISE OKC_API.G_EXCEPTION_ERROR;
3328: END IF;
3329: DELETE FROM OKC_K_ARTICLES_B
3330: WHERE ID = l_cat_rec.id;
3331:
3332: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3333: EXCEPTION

Line 3702: INTO OKC_K_ARTICLES_B

3698: END LOOP;
3699:
3700: FORALL i in 1..l_tabsize
3701: INSERT
3702: INTO OKC_K_ARTICLES_B
3703: (
3704: id,
3705: sav_sae_id,
3706: sbt_code,

Line 3828: INSERT INTO okc_k_articles_bh

3824:
3825: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3826:
3827: BEGIN
3828: INSERT INTO okc_k_articles_bh
3829: (
3830: major_version,
3831: id,
3832: sav_sae_id,

Line 3898: FROM okc_k_articles_b

3894: attribute13,
3895: attribute14,
3896: attribute15,
3897: security_group_id
3898: FROM okc_k_articles_b
3899: WHERE dnz_chr_id = p_chr_id;
3900:
3901: --------------------------------
3902: -- Versioning TL Table

Line 3944: WHERE id in (select id from okc_k_articles_b

3940: last_update_login,
3941: security_group_id,
3942: sav_sav_release
3943: FROM okc_k_articles_tl
3944: WHERE id in (select id from okc_k_articles_b
3945: where dnz_chr_id = p_chr_id);
3946:
3947: RETURN l_return_status;
3948: EXCEPTION

Line 4014: FROM okc_k_articles_bh

4010: security_group_id,
4011: sav_sav_release
4012: FROM okc_k_articles_tlh
4013: WHERE id in (SELECT id
4014: FROM okc_k_articles_bh
4015: WHERE dnz_chr_id = p_chr_id)
4016: AND major_version = p_major_version;
4017:
4018: -----------------------------------------

Line 4022: INSERT INTO okc_k_articles_b

4018: -----------------------------------------
4019: -- Restoring Base Table
4020: -----------------------------------------
4021:
4022: INSERT INTO okc_k_articles_b
4023: (
4024: id,
4025: sav_sae_id,
4026: sbt_code,

Line 4090: FROM okc_k_articles_bh

4086: attribute13,
4087: attribute14,
4088: attribute15,
4089: security_group_id
4090: FROM okc_k_articles_bh
4091: WHERE dnz_chr_id = p_chr_id
4092: AND major_version = p_major_version;
4093:
4094: RETURN l_return_status;