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_ARTICLES_IMPORT_GRP dependencies on STANDARD

Line 1841: AND ART.STANDARD_YN(+) = 'Y'

1837: AND INTRFC.ORG_ID = cp_local_org_id
1838: AND BATCH_NUMBER = cp_batch_number
1839: AND RTRIM(INTRFC.ARTICLE_TITLE) = ART.ARTICLE_TITLE(+)
1840: AND INTRFC.ORG_ID = ART.ORG_ID(+)
1841: AND ART.STANDARD_YN(+) = 'Y'
1842: ORDER BY RTRIM(INTRFC.ARTICLE_TITLE) ASC;
1843:
1844: -- Cursor returns article status, version id and version number
1845: -- for the most recent version with article_id

Line 2095: -- Standard Start of API savepoint

2091: ------------------------------------------------------------------------
2092: -- Variable Initialization
2093: -------------------------------------------------------------------------
2094:
2095: -- Standard Start of API savepoint
2096: FND_MSG_PUB.initialize;
2097: -- Initialize API return status to success
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;
2099: l_return_status := G_RET_STS_SUCCESS;

Line 2654: p_standard_yn => 'Y',

2650: p_article_id => inf_article_id_tbl(i),
2651: p_article_title => inf_article_title_tbl(i),
2652: p_org_id => G_CURRENT_ORG_ID,
2653: p_article_number => inf_article_number_tbl(i),
2654: p_standard_yn => 'Y',
2655: p_article_intent => inf_article_intent_tbl(i),
2656: p_article_language => inf_article_language_tbl(i),
2657: p_article_type => inf_article_type_tbl(i),
2658: p_orig_system_reference_code => inf_art_reference_code_tbl(i),

Line 3362: STANDARD_YN,

3358: ARTICLE_ID,
3359: ARTICLE_TITLE,
3360: ORG_ID,
3361: ARTICLE_NUMBER,
3362: STANDARD_YN,
3363: ARTICLE_INTENT,
3364: ARTICLE_LANGUAGE,
3365: ARTICLE_TYPE,
3366: ORIG_SYSTEM_REFERENCE_CODE,

Line 4643: -- Standard Start of API savepoint

4639: ------------------------------------------------------------------------
4640: -- Variable Initialization
4641: -------------------------------------------------------------------------
4642:
4643: -- Standard Start of API savepoint
4644: FND_MSG_PUB.initialize;
4645: -- Initialize API return status to success
4646: x_return_status := FND_API.G_RET_STS_SUCCESS;
4647: l_return_status := G_RET_STS_SUCCESS;

Line 6080: -- Standard Start of API savepoint

6076: -- Variable Initialization
6077: -------------------------------------------------------------------------
6078:
6079:
6080: -- Standard Start of API savepoint
6081: FND_MSG_PUB.initialize;
6082: -- Initialize API return status to success
6083: x_return_status := FND_API.G_RET_STS_SUCCESS;
6084: l_return_status := G_RET_STS_SUCCESS;

Line 7168: -- Standard Start of API savepoint

7164: ------------------------------------------------------------------------
7165: -- Variable Initialization
7166: -------------------------------------------------------------------------
7167:
7168: -- Standard Start of API savepoint
7169: FND_MSG_PUB.initialize;
7170: -- Initialize API return status to success
7171: x_return_status := FND_API.G_RET_STS_SUCCESS;
7172: l_return_status := G_RET_STS_SUCCESS;

Line 7355: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD

7351:
7352: -- Check if format_type is set properly
7353: -- 'N' for Numeric
7354: -- 'C' for Character
7355: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7356: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7357: -- For Standard Date , Default Max size is 11
7358: -- For Standard DateTime , Default Max size is 12
7359:

Line 7356: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS

7352: -- Check if format_type is set properly
7353: -- 'N' for Numeric
7354: -- 'C' for Character
7355: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7356: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7357: -- For Standard Date , Default Max size is 11
7358: -- For Standard DateTime , Default Max size is 12
7359:
7360: IF nvl(vsinf_format_type_tbl(i),'*') not in ('N','C','X','Y') THEN

Line 7357: -- For Standard Date , Default Max size is 11

7353: -- 'N' for Numeric
7354: -- 'C' for Character
7355: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7356: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7357: -- For Standard Date , Default Max size is 11
7358: -- For Standard DateTime , Default Max size is 12
7359:
7360: IF nvl(vsinf_format_type_tbl(i),'*') not in ('N','C','X','Y') THEN
7361: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 7358: -- For Standard DateTime , Default Max size is 12

7354: -- 'C' for Character
7355: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7356: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7357: -- For Standard Date , Default Max size is 11
7358: -- For Standard DateTime , Default Max size is 12
7359:
7360: IF nvl(vsinf_format_type_tbl(i),'*') not in ('N','C','X','Y') THEN
7361: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7362: p_msg_name => 'OKC_INVALID_FORMATTYPE');

Line 8259: -- Standard Start of API savepoint

8255: ------------------------------------------------------------------------
8256: -- Variable Initialization
8257: -------------------------------------------------------------------------
8258:
8259: -- Standard Start of API savepoint
8260: FND_MSG_PUB.initialize;
8261: -- Initialize API return status to success
8262: x_return_status := FND_API.G_RET_STS_SUCCESS;
8263: l_return_status := G_RET_STS_SUCCESS;