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_STD_ARTICLE_PUB dependencies on OKC_STD_ARTICLE_PVT

Line 136: OKC_STD_ARTICLE_PVT.add_language;

132: --Procedures pertaining to Setting up of a standard Article
133:
134: PROCEDURE add_language IS
135: BEGIN
136: OKC_STD_ARTICLE_PVT.add_language;
137: END add_language;
138:
139: --Procedures pertaining to Std Article Objects
140:

Line 157: OKC_STD_ARTICLE_PVT.create_std_article(

153: x_saiv_tbl OUT NOCOPY saiv_tbl_type,
154: x_samv_tbl OUT NOCOPY samv_tbl_type) IS
155: BEGIN
156: x_return_status := OKC_API.G_RET_STS_SUCCESS;
157: OKC_STD_ARTICLE_PVT.create_std_article(
158: p_api_version => p_api_version,
159: p_init_msg_list => p_init_msg_list,
160: x_return_status => x_return_status,
161: x_msg_count => x_msg_count,

Line 201: OKC_STD_ARTICLE_PVT.update_std_article(

197: x_saiv_tbl OUT NOCOPY saiv_tbl_type,
198: x_samv_tbl OUT NOCOPY samv_tbl_type) IS
199: BEGIN
200: x_return_status := OKC_API.G_RET_STS_SUCCESS;
201: OKC_STD_ARTICLE_PVT.update_std_article(
202: p_api_version => p_api_version,
203: p_init_msg_list => p_init_msg_list,
204: x_return_status => x_return_status,
205: x_msg_count => x_msg_count,

Line 241: OKC_STD_ARTICLE_PVT.validate_std_article(

237: p_saiv_tbl IN saiv_tbl_type,
238: p_samv_tbl IN samv_tbl_type) IS
239: BEGIN
240: x_return_status := OKC_API.G_RET_STS_SUCCESS;
241: OKC_STD_ARTICLE_PVT.validate_std_article(
242: p_api_version => p_api_version,
243: p_init_msg_list => p_init_msg_list,
244: x_return_status => x_return_status,
245: x_msg_count => x_msg_count,

Line 297: OKC_STD_ARTICLE_PVT.create_std_article(

293: raise OKC_API.G_EXCEPTION_ERROR;
294: END IF;
295: l_saev_rec := migrate_saev(l_saev_rec, g_saev_rec);
296:
297: OKC_STD_ARTICLE_PVT.create_std_article(
298: p_api_version => p_api_version,
299: p_init_msg_list => p_init_msg_list,
300: x_return_status => x_return_status,
301: x_msg_count => x_msg_count,

Line 429: OKC_STD_ARTICLE_PVT.update_std_article(

425: raise OKC_API.G_EXCEPTION_ERROR;
426: END IF;
427: l_saev_rec := migrate_saev(l_saev_rec, g_saev_rec);
428:
429: OKC_STD_ARTICLE_PVT.update_std_article(
430: p_api_version => p_api_version,
431: p_init_msg_list => p_init_msg_list,
432: x_return_status => x_return_status,
433: x_msg_count => x_msg_count,

Line 560: OKC_STD_ARTICLE_PVT.delete_std_article(

556: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
557: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
558: raise OKC_API.G_EXCEPTION_ERROR;
559: END IF;
560: OKC_STD_ARTICLE_PVT.delete_std_article(
561: p_api_version => p_api_version,
562: p_init_msg_list => p_init_msg_list,
563: x_return_status => x_return_status,
564: x_msg_count => x_msg_count,

Line 667: OKC_STD_ARTICLE_PVT.validate_std_article(

663: x_msg_data OUT NOCOPY VARCHAR2,
664: p_saev_rec IN saev_rec_type) IS
665: BEGIN
666:
667: OKC_STD_ARTICLE_PVT.validate_std_article(
668: p_api_version => p_api_version,
669: p_init_msg_list => p_init_msg_list,
670: x_return_status => x_return_status,
671: x_msg_count => x_msg_count,

Line 734: OKC_STD_ARTICLE_PVT.lock_std_article(

730: x_msg_count OUT NOCOPY NUMBER,
731: x_msg_data OUT NOCOPY VARCHAR2,
732: p_saev_rec IN saev_rec_type) IS
733: BEGIN
734: OKC_STD_ARTICLE_PVT.lock_std_article(
735: p_api_version => p_api_version,
736: p_init_msg_list => p_init_msg_list,
737: x_return_status => x_return_status,
738: x_msg_count => x_msg_count,

Line 801: OKC_STD_ARTICLE_PVT.Validate_Name(p_api_version => p_api_version,

797: x_msg_count OUT NOCOPY NUMBER,
798: x_msg_data OUT NOCOPY VARCHAR2,
799: p_saev_rec IN saev_rec_type) IS
800: BEGIN
801: OKC_STD_ARTICLE_PVT.Validate_Name(p_api_version => p_api_version,
802: p_init_msg_list => p_init_msg_list,
803: x_return_status => x_return_status,
804: x_msg_count => x_msg_count,
805: x_msg_data => x_msg_data,

Line 862: OKC_STD_ARTICLE_PVT.Validate_no_k_attached(

858: PROCEDURE validate_no_k_attached(
859: p_saev_rec IN saev_rec_type,
860: x_return_status OUT NOCOPY VARCHAR2) IS
861: BEGIN
862: OKC_STD_ARTICLE_PVT.Validate_no_k_attached(
863: x_return_status => x_return_status,
864: p_saev_rec => p_saev_rec);
865:
866: End Validate_no_k_attached;

Line 941: OKC_STD_ARTICLE_PVT.create_std_art_version(

937: raise OKC_API.G_EXCEPTION_ERROR;
938: END IF;
939: l_savv_rec := migrate_savv(l_savv_rec, g_savv_rec);
940:
941: OKC_STD_ARTICLE_PVT.create_std_art_version(
942: p_api_version => p_api_version,
943: p_init_msg_list => p_init_msg_list,
944: x_return_status => x_return_status,
945: x_msg_count => x_msg_count,

Line 1075: OKC_STD_ARTICLE_PVT.update_std_art_version(

1071: raise OKC_API.G_EXCEPTION_ERROR;
1072: END IF;
1073: l_savv_rec := migrate_savv(l_savv_rec, g_savv_rec);
1074:
1075: OKC_STD_ARTICLE_PVT.update_std_art_version(
1076: p_api_version => p_api_version,
1077: p_init_msg_list => p_init_msg_list,
1078: x_return_status => x_return_status,
1079: x_msg_count => x_msg_count,

Line 1184: OKC_STD_ARTICLE_PVT.lock_std_art_version(

1180: x_msg_count OUT NOCOPY NUMBER,
1181: x_msg_data OUT NOCOPY VARCHAR2,
1182: p_savv_rec IN savv_rec_type) IS
1183: BEGIN
1184: OKC_STD_ARTICLE_PVT.lock_std_art_version(
1185: p_api_version => p_api_version,
1186: p_init_msg_list => p_init_msg_list,
1187: x_return_status => x_return_status,
1188: x_msg_count => x_msg_count,

Line 1271: OKC_STD_ARTICLE_PVT.delete_std_art_version(

1267: raise OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: l_savv_rec := migrate_savv(l_savv_rec, g_savv_rec);
1270:
1271: OKC_STD_ARTICLE_PVT.delete_std_art_version(
1272: p_api_version => p_api_version,
1273: p_init_msg_list => p_init_msg_list,
1274: x_return_status => x_return_status,
1275: x_msg_count => x_msg_count,

Line 1377: OKC_STD_ARTICLE_PVT.validate_std_art_version(

1373: x_msg_data OUT NOCOPY VARCHAR2,
1374: p_savv_rec IN savv_rec_type) IS
1375: BEGIN
1376:
1377: OKC_STD_ARTICLE_PVT.validate_std_art_version(
1378: p_api_version => p_api_version,
1379: p_init_msg_list => p_init_msg_list,
1380: x_return_status => x_return_status,
1381: x_msg_count => x_msg_count,

Line 1443: OKC_STD_ARTICLE_PVT.Validate_sav_release(p_api_version => p_api_version,

1439: x_msg_count OUT NOCOPY NUMBER,
1440: x_msg_data OUT NOCOPY VARCHAR2,
1441: p_savv_rec IN savv_rec_type) IS
1442: BEGIN
1443: OKC_STD_ARTICLE_PVT.Validate_sav_release(p_api_version => p_api_version,
1444: p_init_msg_list => p_init_msg_list,
1445: x_return_status => x_return_status,
1446: x_msg_count => x_msg_count,
1447: x_msg_data => x_msg_data,

Line 1509: OKC_STD_ARTICLE_PVT.Validate_date_active(p_api_version => p_api_version,

1505: x_msg_count OUT NOCOPY NUMBER,
1506: x_msg_data OUT NOCOPY VARCHAR2,
1507: p_savv_rec IN savv_rec_type) IS
1508: BEGIN
1509: OKC_STD_ARTICLE_PVT.Validate_date_active(p_api_version => p_api_version,
1510: p_init_msg_list => p_init_msg_list,
1511: x_return_status => x_return_status,
1512: x_msg_count => x_msg_count,
1513: x_msg_data => x_msg_data,

Line 1575: OKC_STD_ARTICLE_PVT.Validate_updatable(p_api_version => p_api_version,

1571: x_msg_count OUT NOCOPY NUMBER,
1572: x_msg_data OUT NOCOPY VARCHAR2,
1573: p_savv_rec IN savv_rec_type) IS
1574: BEGIN
1575: OKC_STD_ARTICLE_PVT.Validate_updatable(p_api_version => p_api_version,
1576: p_init_msg_list => p_init_msg_list,
1577: x_return_status => x_return_status,
1578: x_msg_count => x_msg_count,
1579: x_msg_data => x_msg_data,

Line 1637: OKC_STD_ARTICLE_PVT.Validate_no_k_attached(

1633: PROCEDURE validate_no_k_attached(
1634: p_savv_rec IN savv_rec_type,
1635: x_return_status OUT NOCOPY VARCHAR2) IS
1636: BEGIN
1637: OKC_STD_ARTICLE_PVT.Validate_no_k_attached(
1638: x_return_status => x_return_status,
1639: p_savv_rec => p_savv_rec);
1640:
1641: End Validate_no_k_attached;

Line 1689: OKC_STD_ARTICLE_PVT.Validate_latest(

1685: PROCEDURE validate_latest(
1686: p_savv_rec IN savv_rec_type,
1687: x_return_status OUT NOCOPY VARCHAR2) IS
1688: BEGIN
1689: OKC_STD_ARTICLE_PVT.Validate_latest(
1690: x_return_status => x_return_status,
1691: p_savv_rec => p_savv_rec);
1692:
1693: End Validate_latest;

Line 1746: OKC_STD_ARTICLE_PVT.Validate_short_description(p_api_version => p_api_version,

1742: x_msg_count OUT NOCOPY NUMBER,
1743: x_msg_data OUT NOCOPY VARCHAR2,
1744: p_savv_rec IN savv_rec_type) IS
1745: BEGIN
1746: OKC_STD_ARTICLE_PVT.Validate_short_description(p_api_version => p_api_version,
1747: p_init_msg_list => p_init_msg_list,
1748: x_return_status => x_return_status,
1749: x_msg_count => x_msg_count,
1750: x_msg_data => x_msg_data,

Line 1835: OKC_STD_ARTICLE_PVT.create_std_art_incmpt(

1831: raise OKC_API.G_EXCEPTION_ERROR;
1832: END IF;
1833: l_saiv_rec := migrate_saiv(l_saiv_rec, g_saiv_rec);
1834:
1835: OKC_STD_ARTICLE_PVT.create_std_art_incmpt(
1836: p_api_version => p_api_version,
1837: p_init_msg_list => p_init_msg_list,
1838: x_return_status => x_return_status,
1839: x_msg_count => x_msg_count,

Line 1967: OKC_STD_ARTICLE_PVT.update_std_art_incmpt(

1963: raise OKC_API.G_EXCEPTION_ERROR;
1964: END IF;
1965: l_saiv_rec := migrate_saiv(l_saiv_rec, g_saiv_rec);
1966:
1967: OKC_STD_ARTICLE_PVT.update_std_art_incmpt(
1968: p_api_version => p_api_version,
1969: p_init_msg_list => p_init_msg_list,
1970: x_return_status => x_return_status,
1971: x_msg_count => x_msg_count,

Line 2075: OKC_STD_ARTICLE_PVT.lock_std_art_incmpt(

2071: x_msg_count OUT NOCOPY NUMBER,
2072: x_msg_data OUT NOCOPY VARCHAR2,
2073: p_saiv_rec IN saiv_rec_type) IS
2074: BEGIN
2075: OKC_STD_ARTICLE_PVT.lock_std_art_incmpt(
2076: p_api_version => p_api_version,
2077: p_init_msg_list => p_init_msg_list,
2078: x_return_status => x_return_status,
2079: x_msg_count => x_msg_count,

Line 2162: OKC_STD_ARTICLE_PVT.delete_std_art_incmpt(

2158: raise OKC_API.G_EXCEPTION_ERROR;
2159: END IF;
2160: l_saiv_rec := migrate_saiv(l_saiv_rec, g_saiv_rec);
2161:
2162: OKC_STD_ARTICLE_PVT.delete_std_art_incmpt(
2163: p_api_version => p_api_version,
2164: p_init_msg_list => p_init_msg_list,
2165: x_return_status => x_return_status,
2166: x_msg_count => x_msg_count,

Line 2268: OKC_STD_ARTICLE_PVT.validate_std_art_incmpt(

2264: x_msg_data OUT NOCOPY VARCHAR2,
2265: p_saiv_rec IN saiv_rec_type) IS
2266: BEGIN
2267:
2268: OKC_STD_ARTICLE_PVT.validate_std_art_incmpt(
2269: p_api_version => p_api_version,
2270: p_init_msg_list => p_init_msg_list,
2271: x_return_status => x_return_status,
2272: x_msg_count => x_msg_count,

Line 2335: OKC_STD_ARTICLE_PVT.Validate_Unique(p_api_version => p_api_version,

2331: x_msg_count OUT NOCOPY NUMBER,
2332: x_msg_data OUT NOCOPY VARCHAR2,
2333: p_saiv_rec IN saiv_rec_type) IS
2334: BEGIN
2335: OKC_STD_ARTICLE_PVT.Validate_Unique(p_api_version => p_api_version,
2336: p_init_msg_list => p_init_msg_list,
2337: x_return_status => x_return_status,
2338: x_msg_count => x_msg_count,
2339: x_msg_data => x_msg_data,

Line 2424: OKC_STD_ARTICLE_PVT.create_std_art_classing(

2420: raise OKC_API.G_EXCEPTION_ERROR;
2421: END IF;
2422: l_sacv_rec := migrate_sacv(l_sacv_rec, g_sacv_rec);
2423:
2424: OKC_STD_ARTICLE_PVT.create_std_art_classing(
2425: p_api_version => p_api_version,
2426: p_init_msg_list => p_init_msg_list,
2427: x_return_status => x_return_status,
2428: x_msg_count => x_msg_count,

Line 2555: OKC_STD_ARTICLE_PVT.update_std_art_classing(

2551: raise OKC_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: l_sacv_rec := migrate_sacv(l_sacv_rec, g_sacv_rec);
2554:
2555: OKC_STD_ARTICLE_PVT.update_std_art_classing(
2556: p_api_version => p_api_version,
2557: p_init_msg_list => p_init_msg_list,
2558: x_return_status => x_return_status,
2559: x_msg_count => x_msg_count,

Line 2666: OKC_STD_ARTICLE_PVT.lock_std_art_classing(

2662: x_msg_count OUT NOCOPY NUMBER,
2663: x_msg_data OUT NOCOPY VARCHAR2,
2664: p_sacv_rec IN sacv_rec_type) IS
2665: BEGIN
2666: OKC_STD_ARTICLE_PVT.lock_std_art_classing(
2667: p_api_version => p_api_version,
2668: p_init_msg_list => p_init_msg_list,
2669: x_return_status => x_return_status,
2670: x_msg_count => x_msg_count,

Line 2754: OKC_STD_ARTICLE_PVT.delete_std_art_classing(

2750: raise OKC_API.G_EXCEPTION_ERROR;
2751: END IF;
2752: l_sacv_rec := migrate_sacv(l_sacv_rec, g_sacv_rec);
2753:
2754: OKC_STD_ARTICLE_PVT.delete_std_art_classing(
2755: p_api_version => p_api_version,
2756: p_init_msg_list => p_init_msg_list,
2757: x_return_status => x_return_status,
2758: x_msg_count => x_msg_count,

Line 2860: OKC_STD_ARTICLE_PVT.validate_std_art_classing(

2856: x_msg_count OUT NOCOPY NUMBER,
2857: x_msg_data OUT NOCOPY VARCHAR2,
2858: p_sacv_rec IN sacv_rec_type) IS
2859: BEGIN
2860: OKC_STD_ARTICLE_PVT.validate_std_art_classing(
2861: p_api_version => p_api_version,
2862: p_init_msg_list => p_init_msg_list,
2863: x_return_status => x_return_status,
2864: x_msg_count => x_msg_count,

Line 2926: OKC_STD_ARTICLE_PVT.Validate_price_type(p_api_version => p_api_version,

2922: x_msg_count OUT NOCOPY NUMBER,
2923: x_msg_data OUT NOCOPY VARCHAR2,
2924: p_sacv_rec IN sacv_rec_type) IS
2925: BEGIN
2926: OKC_STD_ARTICLE_PVT.Validate_price_type(p_api_version => p_api_version,
2927: p_init_msg_list => p_init_msg_list,
2928: x_return_status => x_return_status,
2929: x_msg_count => x_msg_count,
2930: x_msg_data => x_msg_data,

Line 2991: OKC_STD_ARTICLE_PVT.Validate_scs_code(p_api_version => p_api_version,

2987: x_msg_count OUT NOCOPY NUMBER,
2988: x_msg_data OUT NOCOPY VARCHAR2,
2989: p_sacv_rec IN sacv_rec_type) IS
2990: BEGIN
2991: OKC_STD_ARTICLE_PVT.Validate_scs_code(p_api_version => p_api_version,
2992: p_init_msg_list => p_init_msg_list,
2993: x_return_status => x_return_status,
2994: x_msg_count => x_msg_count,
2995: x_msg_data => x_msg_data,

Line 3079: OKC_STD_ARTICLE_PVT.create_std_art_set_mem(

3075: raise OKC_API.G_EXCEPTION_ERROR;
3076: END IF;
3077: l_samv_rec := migrate_samv(l_samv_rec, g_samv_rec);
3078:
3079: OKC_STD_ARTICLE_PVT.create_std_art_set_mem(
3080: p_api_version => p_api_version,
3081: p_init_msg_list => p_init_msg_list,
3082: x_return_status => x_return_status,
3083: x_msg_count => x_msg_count,

Line 3211: OKC_STD_ARTICLE_PVT.update_std_art_set_mem(

3207: raise OKC_API.G_EXCEPTION_ERROR;
3208: END IF;
3209: l_samv_rec := migrate_samv(l_samv_rec, g_samv_rec);
3210:
3211: OKC_STD_ARTICLE_PVT.update_std_art_set_mem(
3212: p_api_version => p_api_version,
3213: p_init_msg_list => p_init_msg_list,
3214: x_return_status => x_return_status,
3215: x_msg_count => x_msg_count,

Line 3319: OKC_STD_ARTICLE_PVT.lock_std_art_set_mem(

3315: x_msg_count OUT NOCOPY NUMBER,
3316: x_msg_data OUT NOCOPY VARCHAR2,
3317: p_samv_rec IN samv_rec_type) IS
3318: BEGIN
3319: OKC_STD_ARTICLE_PVT.lock_std_art_set_mem(
3320: p_api_version => p_api_version,
3321: p_init_msg_list => p_init_msg_list,
3322: x_return_status => x_return_status,
3323: x_msg_count => x_msg_count,

Line 3407: OKC_STD_ARTICLE_PVT.delete_std_art_set_mem(

3403: raise OKC_API.G_EXCEPTION_ERROR;
3404: END IF;
3405: l_samv_rec := migrate_samv(l_samv_rec, g_samv_rec);
3406:
3407: OKC_STD_ARTICLE_PVT.delete_std_art_set_mem(
3408: p_api_version => p_api_version,
3409: p_init_msg_list => p_init_msg_list,
3410: x_return_status => x_return_status,
3411: x_msg_count => x_msg_count,

Line 3514: OKC_STD_ARTICLE_PVT.validate_std_art_set_mem(

3510: x_msg_data OUT NOCOPY VARCHAR2,
3511: p_samv_rec IN samv_rec_type) IS
3512: BEGIN
3513:
3514: OKC_STD_ARTICLE_PVT.validate_std_art_set_mem(
3515: p_api_version => p_api_version,
3516: p_init_msg_list => p_init_msg_list,
3517: x_return_status => x_return_status,
3518: x_msg_count => x_msg_count,

Line 3579: OKC_STD_ARTICLE_PVT.Validate_Unique(p_api_version => p_api_version,

3575: x_msg_count OUT NOCOPY NUMBER,
3576: x_msg_data OUT NOCOPY VARCHAR2,
3577: p_samv_rec IN samv_rec_type) IS
3578: BEGIN
3579: OKC_STD_ARTICLE_PVT.Validate_Unique(p_api_version => p_api_version,
3580: p_init_msg_list => p_init_msg_list,
3581: x_return_status => x_return_status,
3582: x_msg_count => x_msg_count,
3583: x_msg_data => x_msg_data,

Line 3648: RETURN okc_std_article_pvt.art_used_in_contracts(p_sav_sae_id,p_sav_sav_release);

3644: RETURN VARCHAR2 IS
3645:
3646: BEGIN
3647:
3648: RETURN okc_std_article_pvt.art_used_in_contracts(p_sav_sae_id,p_sav_sav_release);
3649:
3650: END used_in_contracts;
3651:
3652: FUNCTION empclob

Line 3656: RETURN okc_std_article_pvt.empclob;

3652: FUNCTION empclob
3653: RETURN CLOB IS
3654:
3655: BEGIN
3656: RETURN okc_std_article_pvt.empclob;
3657:
3658: END empclob;
3659:
3660: FUNCTION latest_release

Line 3668: RETURN okc_std_article_pvt.latest_release(p_sav_sae_id);

3664: RETURN VARCHAR2 IS
3665:
3666: BEGIN
3667:
3668: RETURN okc_std_article_pvt.latest_release(p_sav_sae_id);
3669:
3670: END latest_release;
3671:
3672: --BUG 3188215 - KOL: BACKWARD COMPATIBILITY CHANGES

Line 3684: RETURN okc_std_article_pvt.latest_art_release(p_sav_sae_id,p_article_version_number);

3680: RETURN VARCHAR2 IS
3681:
3682: BEGIN
3683:
3684: RETURN okc_std_article_pvt.latest_art_release(p_sav_sae_id,p_article_version_number);
3685:
3686: END latest_release;
3687:
3688: -- BUG 3188215 - KOL: BACKWARD COMPATIBILITY CHANGES

Line 3701: RETURN okc_std_article_pvt.latest_or_future_art_release(p_sav_sae_id,p_article_version_number,p_date_active);

3697: RETURN VARCHAR2 IS
3698:
3699: BEGIN
3700:
3701: RETURN okc_std_article_pvt.latest_or_future_art_release(p_sav_sae_id,p_article_version_number,p_date_active);
3702:
3703: END latest_or_future_release;
3704:
3705: