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 1838: AND ART.STANDARD_YN(+) = 'Y'

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

Line 2081: -- Standard Start of API savepoint

2077: ------------------------------------------------------------------------
2078: -- Variable Initialization
2079: -------------------------------------------------------------------------
2080:
2081: -- Standard Start of API savepoint
2082: FND_MSG_PUB.initialize;
2083: -- Initialize API return status to success
2084: x_return_status := FND_API.G_RET_STS_SUCCESS;
2085: l_return_status := G_RET_STS_SUCCESS;

Line 2612: p_standard_yn => 'Y',

2608: p_article_id => inf_article_id_tbl(i),
2609: p_article_title => inf_article_title_tbl(i),
2610: p_org_id => G_CURRENT_ORG_ID,
2611: p_article_number => inf_article_number_tbl(i),
2612: p_standard_yn => 'Y',
2613: p_article_intent => inf_article_intent_tbl(i),
2614: p_article_language => inf_article_language_tbl(i),
2615: p_article_type => inf_article_type_tbl(i),
2616: p_orig_system_reference_code => inf_art_reference_code_tbl(i),

Line 3311: STANDARD_YN,

3307: ARTICLE_ID,
3308: ARTICLE_TITLE,
3309: ORG_ID,
3310: ARTICLE_NUMBER,
3311: STANDARD_YN,
3312: ARTICLE_INTENT,
3313: ARTICLE_LANGUAGE,
3314: ARTICLE_TYPE,
3315: ORIG_SYSTEM_REFERENCE_CODE,

Line 4577: -- Standard Start of API savepoint

4573: ------------------------------------------------------------------------
4574: -- Variable Initialization
4575: -------------------------------------------------------------------------
4576:
4577: -- Standard Start of API savepoint
4578: FND_MSG_PUB.initialize;
4579: -- Initialize API return status to success
4580: x_return_status := FND_API.G_RET_STS_SUCCESS;
4581: l_return_status := G_RET_STS_SUCCESS;

Line 6012: -- Standard Start of API savepoint

6008: -- Variable Initialization
6009: -------------------------------------------------------------------------
6010:
6011:
6012: -- Standard Start of API savepoint
6013: FND_MSG_PUB.initialize;
6014: -- Initialize API return status to success
6015: x_return_status := FND_API.G_RET_STS_SUCCESS;
6016: l_return_status := G_RET_STS_SUCCESS;

Line 7100: -- Standard Start of API savepoint

7096: ------------------------------------------------------------------------
7097: -- Variable Initialization
7098: -------------------------------------------------------------------------
7099:
7100: -- Standard Start of API savepoint
7101: FND_MSG_PUB.initialize;
7102: -- Initialize API return status to success
7103: x_return_status := FND_API.G_RET_STS_SUCCESS;
7104: l_return_status := G_RET_STS_SUCCESS;

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

7283:
7284: -- Check if format_type is set properly
7285: -- 'N' for Numeric
7286: -- 'C' for Character
7287: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7288: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7289: -- For Standard Date , Default Max size is 11
7290: -- For Standard DateTime , Default Max size is 12
7291:

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

7284: -- Check if format_type is set properly
7285: -- 'N' for Numeric
7286: -- 'C' for Character
7287: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7288: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7289: -- For Standard Date , Default Max size is 11
7290: -- For Standard DateTime , Default Max size is 12
7291:
7292: IF nvl(vsinf_format_type_tbl(i),'*') not in ('N','C','X','Y') THEN

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

7285: -- 'N' for Numeric
7286: -- 'C' for Character
7287: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7288: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7289: -- For Standard Date , Default Max size is 11
7290: -- For Standard DateTime , Default Max size is 12
7291:
7292: IF nvl(vsinf_format_type_tbl(i),'*') not in ('N','C','X','Y') THEN
7293: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

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

7286: -- 'C' for Character
7287: -- 'X' for Standard Date in Canonical Format YYYY/MM/DD
7288: -- 'Y' for Standard DateTime in Canonical Format YYYY/MM/DD HH24:MI:SS
7289: -- For Standard Date , Default Max size is 11
7290: -- For Standard DateTime , Default Max size is 12
7291:
7292: IF nvl(vsinf_format_type_tbl(i),'*') not in ('N','C','X','Y') THEN
7293: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7294: p_msg_name => 'OKC_INVALID_FORMATTYPE');

Line 8191: -- Standard Start of API savepoint

8187: ------------------------------------------------------------------------
8188: -- Variable Initialization
8189: -------------------------------------------------------------------------
8190:
8191: -- Standard Start of API savepoint
8192: FND_MSG_PUB.initialize;
8193: -- Initialize API return status to success
8194: x_return_status := FND_API.G_RET_STS_SUCCESS;
8195: l_return_status := G_RET_STS_SUCCESS;