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.

[Home] [Help]

APPS.OKC_ARTICLE_VERSIONS_PVT dependencies on STANDARD

Line 913: p_standard_yn IN VARCHAR2,

909: ----------------------------------------------
910: FUNCTION Validate_Attributes (
911: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
912: p_import_action IN VARCHAR2 := NULL,
913: p_standard_yn IN VARCHAR2,
914:
915: p_article_version_id IN NUMBER,
916: p_article_id IN NUMBER,
917: p_article_version_number IN NUMBER,

Line 984: AND AA.STANDARD_YN = 'Y';

980: SELECT '!'
981: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV
982: WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
983: AND AV.ARTICLE_VERSION_ID = p_std_article_version_id
984: AND AA.STANDARD_YN = 'Y';
985:
986: -- Below Added for FAR/DFAR Import
987: CURSOR l_date_published_csr is
988: SELECT av.date_published

Line 998: -- Article row will always be needed to test if this is a standard or not even for not null or FK checks

994: IF (l_debug = 'Y') THEN
995: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
996: END IF;
997:
998: -- Article row will always be needed to test if this is a standard or not even for not null or FK checks
999:
1000: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
1001: IF (l_debug = 'Y') THEN
1002: Okc_Debug.Log('1300: required values validation', 2);

Line 1099: IF p_standard_yn = 'Y' OR p_import_action IS NOT NULL Then

1095: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_LANGUAGE');
1096: l_return_status := G_RET_STS_ERROR;
1097: END IF;
1098:
1099: IF p_standard_yn = 'Y' OR p_import_action IS NOT NULL Then
1100: IF (l_debug = 'Y') THEN
1101: Okc_Debug.Log('1400: - attribute START_DATE ', 2);
1102: END IF;
1103: IF ( p_start_date IS NULL) THEN

Line 1449: l_standard_yn VARCHAR2(1) ;

1445: l_dummy_var VARCHAR2(1) := '?';
1446: l_dummy_var1 VARCHAR2(1) ;
1447: l_dummy_var2 VARCHAR2(1) ;
1448:
1449: l_standard_yn VARCHAR2(1) ;
1450: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1451: l_global_start_date DATE := TO_DATE('12313999','MMDDYYYY');
1452: l_rownotfound BOOLEAN := FALSE;
1453:

Line 1509: SELECT standard_yn, article_language

1505: WHERE S.START_DATE = S.MAX_START_DATE;
1506: */
1507:
1508: CURSOR l_article_id_csr(p_article_id IN NUMBER) is
1509: SELECT standard_yn, article_language
1510: FROM OKC_ARTICLES_ALL
1511: WHERE ARTICLE_ID = p_article_id;
1512:
1513: -- Bug#3672511: Validation of start date of a localized clause should be >= start date of global clause.

Line 1559: l_standard_yn := 'Y';

1555: end if;
1556: */
1557:
1558: IF p_import_action in ('N', 'V', 'U') THEN
1559: l_standard_yn := 'Y';
1560: l_article_language := p_article_language;
1561: ELSIF p_article_id IS NOT NULL THEN
1562: l_standard_yn := '?';
1563: OPEN l_article_id_csr(p_article_id);

Line 1562: l_standard_yn := '?';

1558: IF p_import_action in ('N', 'V', 'U') THEN
1559: l_standard_yn := 'Y';
1560: l_article_language := p_article_language;
1561: ELSIF p_article_id IS NOT NULL THEN
1562: l_standard_yn := '?';
1563: OPEN l_article_id_csr(p_article_id);
1564: FETCH l_article_id_csr INTO l_standard_yn, l_article_language;
1565: CLOSE l_article_id_csr;
1566: IF (l_standard_yn = '?') THEN

Line 1564: FETCH l_article_id_csr INTO l_standard_yn, l_article_language;

1560: l_article_language := p_article_language;
1561: ELSIF p_article_id IS NOT NULL THEN
1562: l_standard_yn := '?';
1563: OPEN l_article_id_csr(p_article_id);
1564: FETCH l_article_id_csr INTO l_standard_yn, l_article_language;
1565: CLOSE l_article_id_csr;
1566: IF (l_standard_yn = '?') THEN
1567: IF (l_debug = 'Y') THEN
1568: Okc_Debug.Log('2300: - attribute ARTICLE_ID is invalid', 2);

Line 1566: IF (l_standard_yn = '?') THEN

1562: l_standard_yn := '?';
1563: OPEN l_article_id_csr(p_article_id);
1564: FETCH l_article_id_csr INTO l_standard_yn, l_article_language;
1565: CLOSE l_article_id_csr;
1566: IF (l_standard_yn = '?') THEN
1567: IF (l_debug = 'Y') THEN
1568: Okc_Debug.Log('2300: - attribute ARTICLE_ID is invalid', 2);
1569: END IF;
1570: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_ID');

Line 1580: p_standard_yn => l_standard_yn, -- Introduced for checks related to Std version only.

1576: --- Validate all non-missing attributes (Item Level Validation)
1577: l_return_status := Validate_Attributes(
1578: p_validation_level => p_validation_level,
1579: p_import_action => p_import_action,
1580: p_standard_yn => l_standard_yn, -- Introduced for checks related to Std version only.
1581: p_article_version_id => p_article_version_id,
1582: p_article_id => p_article_id,
1583: p_article_version_number => p_article_version_number,
1584: p_article_text => p_article_text,

Line 1640: -- 1. Validate the current article attributes in the case of Standard Article from a previous version (if record level

1636: RETURN G_RET_STS_UNEXP_ERROR;
1637: END IF;
1638:
1639: -- The following lines will be used to:
1640: -- 1. Validate the current article attributes in the case of Standard Article from a previous version (if record level
1641: -- validation is desired).
1642: -- 2. Generate the version number later in the case of inserts of a article version in insert_row API using the
1643: -- x_previous_version_number parameter (even if record level validation is not desired).
1644: -- 3. Validate the effectivity even in case of approved.

Line 1654: IF (l_standard_yn = 'Y') AND -- All cases of Standard Articles Only (except first version of Import)

1650: -- We would still need to check that an article cannot be imported as approved/
1651: -- pending approval if earlier version is draft/pending approval/rejected.
1652:
1653:
1654: IF (l_standard_yn = 'Y') AND -- All cases of Standard Articles Only (except first version of Import)
1655: (nvl(p_import_action,'X') <> 'N') THEN
1656: IF p_article_status in ('DRAFT','REJECTED','PENDING_APPROVAL') OR -- All Non Approved or Local or Start Date as null
1657: p_global_yn = 'N' OR
1658: p_import_action = 'V' OR -- Added by MSENGUPT on 05/24 Bug#3648236 as earlier version check is needed for new version of import

Line 1685: Okc_Debug.Log('1300: attribute START_DATE IS greater then end date for standard article', 2);

1681:
1682: IF ( p_end_date is NOT NULL ) THEN
1683: IF ( p_end_date < p_start_date ) THEN
1684: IF (l_debug = 'Y') THEN
1685: Okc_Debug.Log('1300: attribute START_DATE IS greater then end date for standard article', 2);
1686: END IF;
1687: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_START_GT_END_DATE');
1688: l_return_status := G_RET_STS_ERROR;
1689: ELSIF p_article_status in ('DRAFT','REJECTED','PENDING_APPROVAL') AND

Line 1692: Okc_Debug.Log('1300: attribute END_DATE IS less then system date for standard article', 2);

1688: l_return_status := G_RET_STS_ERROR;
1689: ELSIF p_article_status in ('DRAFT','REJECTED','PENDING_APPROVAL') AND
1690: p_end_date < trunc(sysdate) THEN -- Added for Bug 3517002
1691: IF (l_debug = 'Y') THEN
1692: Okc_Debug.Log('1300: attribute END_DATE IS less then system date for standard article', 2);
1693: END IF;
1694: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_END_LT_SYS_DATE');
1695: l_return_status := G_RET_STS_ERROR;
1696: END IF;

Line 1717: Okc_Debug.Log('1300: attribute END_DATE IS less then approved date for standard article', 2);

1713: /*
1714: IF ( p_date_approved is NOT NULL ) THEN
1715: IF ( p_date_approved > nvl(p_end_date,p_date_approved + 1) ) THEN
1716: IF (l_debug = 'Y') THEN
1717: Okc_Debug.Log('1300: attribute END_DATE IS less then approved date for standard article', 2);
1718: END IF;
1719: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_APPROVED_GT_END_DATE');
1720: l_return_status := G_RET_STS_ERROR;
1721: END IF;

Line 1724: -- In case of Standard Articles ONLY

1720: l_return_status := G_RET_STS_ERROR;
1721: END IF;
1722: END IF;
1723: */
1724: -- In case of Standard Articles ONLY
1725: -- Validate that a global standard article cannot be created at a local org
1726: -- From the earlier version check
1727: -- 1. If global, current version cannot be local
1728: -- 2. earlier version cannot be status = DRAFT, REJECTED, PENDING APPROVAL'

Line 1725: -- Validate that a global standard article cannot be created at a local org

1721: END IF;
1722: END IF;
1723: */
1724: -- In case of Standard Articles ONLY
1725: -- Validate that a global standard article cannot be created at a local org
1726: -- From the earlier version check
1727: -- 1. If global, current version cannot be local
1728: -- 2. earlier version cannot be status = DRAFT, REJECTED, PENDING APPROVAL'
1729: -- 3. Date Overlap

Line 1731: IF l_standard_yn = 'Y' THEN

1727: -- 1. If global, current version cannot be local
1728: -- 2. earlier version cannot be status = DRAFT, REJECTED, PENDING APPROVAL'
1729: -- 3. Date Overlap
1730:
1731: IF l_standard_yn = 'Y' THEN
1732: IF (G_CURRENT_ORG_ID <> G_GLOBAL_ORG_ID AND
1733: p_global_yn = 'Y') Then
1734: IF (l_debug = 'Y') THEN
1735: Okc_Debug.Log('2300: - attribute Global Article cannot be created at a local org', 2);

Line 1885: END IF; -- if l_standard_yn = Y

1881: RETURN l_return_status ;
1882: end if;
1883: -- fix for bug#4006749 end
1884:
1885: END IF; -- if l_standard_yn = Y
1886: x_earlier_version_number := l_highest_version_rec.article_version_number;
1887: x_article_language := l_article_language;
1888: x_earlier_version_id := l_highest_version_rec.article_version_id;
1889: x_earlier_adoption_type := l_highest_version_rec.adoption_type;