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

Line 110: x_standard_yn OUT NOCOPY VARCHAR2,

106:
107: x_article_title OUT NOCOPY VARCHAR2,
108: x_org_id OUT NOCOPY NUMBER,
109: x_article_number OUT NOCOPY VARCHAR2,
110: x_standard_yn OUT NOCOPY VARCHAR2,
111: x_article_intent OUT NOCOPY VARCHAR2,
112: x_article_language OUT NOCOPY VARCHAR2,
113: x_article_type OUT NOCOPY VARCHAR2,
114: x_orig_system_reference_code OUT NOCOPY VARCHAR2,

Line 151: STANDARD_YN,

147: SELECT
148: ARTICLE_TITLE,
149: ORG_ID,
150: ARTICLE_NUMBER,
151: STANDARD_YN,
152: ARTICLE_INTENT,
153: ARTICLE_LANGUAGE,
154: ARTICLE_TYPE,
155: ORIG_SYSTEM_REFERENCE_CODE,

Line 199: x_standard_yn,

195: FETCH OKC_ARTICLES_ALL_pk_csr INTO
196: x_article_title,
197: x_org_id,
198: x_article_number,
199: x_standard_yn,
200: x_article_intent,
201: x_article_language,
202: x_article_type,
203: x_orig_system_reference_code,

Line 274: p_standard_yn IN VARCHAR2,

270: p_article_id IN NUMBER,
271: p_article_title IN VARCHAR2,
272: p_org_id IN NUMBER,
273: p_article_number IN VARCHAR2,
274: p_standard_yn IN VARCHAR2,
275: p_article_intent IN VARCHAR2,
276: p_article_language IN VARCHAR2,
277: p_article_type IN VARCHAR2,
278: p_orig_system_reference_code IN VARCHAR2,

Line 307: x_standard_yn OUT NOCOPY VARCHAR2,

303:
304: x_article_title OUT NOCOPY VARCHAR2,
305: x_org_id OUT NOCOPY NUMBER,
306: x_article_number OUT NOCOPY VARCHAR2,
307: x_standard_yn OUT NOCOPY VARCHAR2,
308: x_article_intent OUT NOCOPY VARCHAR2,
309: x_article_language OUT NOCOPY VARCHAR2,
310: x_article_type OUT NOCOPY VARCHAR2,
311: x_orig_system_reference_code OUT NOCOPY VARCHAR2,

Line 355: x_standard_yn => x_standard_yn,

351: p_article_id => p_article_id,
352: x_article_title => x_article_title,
353: x_org_id => x_org_id,
354: x_article_number => x_article_number,
355: x_standard_yn => x_standard_yn,
356: x_article_intent => x_article_intent,
357: x_article_language => x_article_language,
358: x_article_type => x_article_type,
359: x_orig_system_reference_code => x_orig_system_reference_code,

Line 419: IF (p_standard_yn = G_MISS_CHAR) THEN

415: ELSIF (p_ARTICLE_NUMBER IS NOT NULL) THEN
416: x_article_number := p_article_number;
417: END IF;
418:
419: IF (p_standard_yn = G_MISS_CHAR) THEN
420: x_standard_yn := NULL;
421: ELSIF (p_STANDARD_YN IS NOT NULL) THEN
422: -- x_standard_yn := p_standard_yn; -- Modified
423: x_standard_yn := UPPER(p_standard_yn);

Line 420: x_standard_yn := NULL;

416: x_article_number := p_article_number;
417: END IF;
418:
419: IF (p_standard_yn = G_MISS_CHAR) THEN
420: x_standard_yn := NULL;
421: ELSIF (p_STANDARD_YN IS NOT NULL) THEN
422: -- x_standard_yn := p_standard_yn; -- Modified
423: x_standard_yn := UPPER(p_standard_yn);
424: END IF;

Line 421: ELSIF (p_STANDARD_YN IS NOT NULL) THEN

417: END IF;
418:
419: IF (p_standard_yn = G_MISS_CHAR) THEN
420: x_standard_yn := NULL;
421: ELSIF (p_STANDARD_YN IS NOT NULL) THEN
422: -- x_standard_yn := p_standard_yn; -- Modified
423: x_standard_yn := UPPER(p_standard_yn);
424: END IF;
425:

Line 422: -- x_standard_yn := p_standard_yn; -- Modified

418:
419: IF (p_standard_yn = G_MISS_CHAR) THEN
420: x_standard_yn := NULL;
421: ELSIF (p_STANDARD_YN IS NOT NULL) THEN
422: -- x_standard_yn := p_standard_yn; -- Modified
423: x_standard_yn := UPPER(p_standard_yn);
424: END IF;
425:
426: IF (p_article_intent = G_MISS_CHAR) THEN

Line 423: x_standard_yn := UPPER(p_standard_yn);

419: IF (p_standard_yn = G_MISS_CHAR) THEN
420: x_standard_yn := NULL;
421: ELSIF (p_STANDARD_YN IS NOT NULL) THEN
422: -- x_standard_yn := p_standard_yn; -- Modified
423: x_standard_yn := UPPER(p_standard_yn);
424: END IF;
425:
426: IF (p_article_intent = G_MISS_CHAR) THEN
427: x_article_intent := NULL;

Line 594: -- ?? x_standard_yn := Upper( x_standard_yn );

590:
591: -- ?? converting to uppercase all _YN columns
592: -- ?? per performance reason it can be moved into corresponding
593: -- ?? ELSIF( column IS NOT NULL) section above
594: -- ?? x_standard_yn := Upper( x_standard_yn );
595: ELSE
596: x_article_title := p_article_title;
597: x_org_id := p_org_id;
598: x_article_number := p_article_number;

Line 599: x_standard_yn := p_standard_yn;

595: ELSE
596: x_article_title := p_article_title;
597: x_org_id := p_org_id;
598: x_article_number := p_article_number;
599: x_standard_yn := p_standard_yn;
600: x_article_intent := p_article_intent;
601: x_article_language := p_article_language;
602: x_article_type := p_article_type;
603: x_orig_system_reference_code := p_orig_system_reference_code;

Line 673: p_standard_yn IN VARCHAR2,

669: p_article_id IN NUMBER,
670: p_article_title IN VARCHAR2,
671: p_org_id IN NUMBER,
672: p_article_number IN VARCHAR2,
673: p_standard_yn IN VARCHAR2,
674: p_article_intent IN VARCHAR2,
675: p_article_language IN VARCHAR2,
676: p_article_type IN VARCHAR2,
677: p_orig_system_reference_code IN VARCHAR2,

Line 748: ELSIF p_import_action = 'N' AND p_standard_yn = 'Y' AND p_article_number IS NULL THEN

744: END IF;
745: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_ID');
746: l_return_status := G_RET_STS_ERROR;
747: END IF;
748: ELSIF p_import_action = 'N' AND p_standard_yn = 'Y' AND p_article_number IS NULL THEN
749: -- Check Sequence is defined or not
750: OKC_ARTICLES_GRP.GET_ARTICLE_SEQ_NUMBER
751: (p_article_number => p_article_number,
752: p_seq_type_info_only => 'Y',

Line 792: IF nvl(p_import_action,'X') <> 'N' AND p_standard_yn = 'Y' THEN

788:
789: IF (l_debug = 'Y') THEN
790: Okc_Debug.Log('1400: - attribute ARTICLE_NUMBER ', 2);
791: END IF;
792: IF nvl(p_import_action,'X') <> 'N' AND p_standard_yn = 'Y' THEN
793: IF ( p_article_number IS NULL) THEN
794: IF (l_debug = 'Y') THEN
795: Okc_Debug.Log('1500: - attribute ARTICLE_NUMBER is invalid', 2);
796: END IF;

Line 803: Okc_Debug.Log('1400: - attribute STANDARD_YN ', 2);

799: END IF;
800: END IF;
801:
802: IF (l_debug = 'Y') THEN
803: Okc_Debug.Log('1400: - attribute STANDARD_YN ', 2);
804: END IF;
805: IF ( p_standard_yn IS NULL) THEN
806: IF (l_debug = 'Y') THEN
807: Okc_Debug.Log('1500: - attribute STANDARD_YN is invalid', 2);

Line 805: IF ( p_standard_yn IS NULL) THEN

801:
802: IF (l_debug = 'Y') THEN
803: Okc_Debug.Log('1400: - attribute STANDARD_YN ', 2);
804: END IF;
805: IF ( p_standard_yn IS NULL) THEN
806: IF (l_debug = 'Y') THEN
807: Okc_Debug.Log('1500: - attribute STANDARD_YN is invalid', 2);
808: END IF;
809: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');

Line 807: Okc_Debug.Log('1500: - attribute STANDARD_YN is invalid', 2);

803: Okc_Debug.Log('1400: - attribute STANDARD_YN ', 2);
804: END IF;
805: IF ( p_standard_yn IS NULL) THEN
806: IF (l_debug = 'Y') THEN
807: Okc_Debug.Log('1500: - attribute STANDARD_YN is invalid', 2);
808: END IF;
809: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');
810: l_return_status := G_RET_STS_ERROR;
811: END IF;

Line 809: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');

805: IF ( p_standard_yn IS NULL) THEN
806: IF (l_debug = 'Y') THEN
807: Okc_Debug.Log('1500: - attribute STANDARD_YN is invalid', 2);
808: END IF;
809: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');
810: l_return_status := G_RET_STS_ERROR;
811: END IF;
812:
813: IF (l_debug = 'Y') THEN

Line 843: Okc_Debug.Log('1700: - attribute STANDARD_YN ', 2);

839: Okc_Debug.Log('1600: static values and range validation', 2);
840: END IF;
841: -- Modified
842: IF (l_debug = 'Y') THEN
843: Okc_Debug.Log('1700: - attribute STANDARD_YN ', 2);
844: END IF;
845: IF p_standard_yn NOT IN ('Y','N') THEN
846: IF (l_debug = 'Y') THEN
847: Okc_Debug.Log('1800: - attribute STANDARD_YN is invalid', 2);

Line 845: IF p_standard_yn NOT IN ('Y','N') THEN

841: -- Modified
842: IF (l_debug = 'Y') THEN
843: Okc_Debug.Log('1700: - attribute STANDARD_YN ', 2);
844: END IF;
845: IF p_standard_yn NOT IN ('Y','N') THEN
846: IF (l_debug = 'Y') THEN
847: Okc_Debug.Log('1800: - attribute STANDARD_YN is invalid', 2);
848: END IF;
849: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');

Line 847: Okc_Debug.Log('1800: - attribute STANDARD_YN is invalid', 2);

843: Okc_Debug.Log('1700: - attribute STANDARD_YN ', 2);
844: END IF;
845: IF p_standard_yn NOT IN ('Y','N') THEN
846: IF (l_debug = 'Y') THEN
847: Okc_Debug.Log('1800: - attribute STANDARD_YN is invalid', 2);
848: END IF;
849: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');
850: l_return_status := G_RET_STS_ERROR;
851: END IF;

Line 849: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');

845: IF p_standard_yn NOT IN ('Y','N') THEN
846: IF (l_debug = 'Y') THEN
847: Okc_Debug.Log('1800: - attribute STANDARD_YN is invalid', 2);
848: END IF;
849: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');
850: l_return_status := G_RET_STS_ERROR;
851: END IF;
852:
853: IF (l_debug = 'Y') THEN

Line 877: -- Standard clauses will be checked for valid lookup code the way it is now

873: IF (l_debug = 'Y') THEN
874: Okc_Debug.Log('2000: - attribute ARTICLE_TYPE ', 2);
875: END IF;
876:
877: -- Standard clauses will be checked for valid lookup code the way it is now
878: -- Non Standard clauses - just check for existence of the lookup code and do not
879: -- care whether it is effective or not.
880: -- Use a new message suggested by PMs
881:

Line 878: -- Non Standard clauses - just check for existence of the lookup code and do not

874: Okc_Debug.Log('2000: - attribute ARTICLE_TYPE ', 2);
875: END IF;
876:
877: -- Standard clauses will be checked for valid lookup code the way it is now
878: -- Non Standard clauses - just check for existence of the lookup code and do not
879: -- care whether it is effective or not.
880: -- Use a new message suggested by PMs
881:
882: IF p_article_type IS NOT NULL THEN

Line 884: IF p_standard_yn = 'N' THEN

880: -- Use a new message suggested by PMs
881:
882: IF p_article_type IS NOT NULL THEN
883: l_dummy_var := '?';
884: IF p_standard_yn = 'N' THEN
885: OPEN l_article_type_csr;
886: FETCH l_article_type_csr INTO l_dummy_var;
887: CLOSE l_article_type_csr;
888: IF (l_dummy_var = '?') THEN

Line 895: ELSIF p_standard_yn = 'Y' THEN

891: END IF;
892: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');
893: l_return_status := G_RET_STS_ERROR;
894: END IF;
895: ELSIF p_standard_yn = 'Y' THEN
896: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_SUBJECT',p_article_type);
897: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
898: IF (l_debug = 'Y') THEN
899: Okc_Debug.Log('2300: - attribute ARTICLE_TYPE is invalid for std clause', 2);

Line 1004: p_standard_yn IN VARCHAR2,

1000: p_article_id IN NUMBER,
1001: p_article_title IN VARCHAR2,
1002: p_org_id IN NUMBER,
1003: p_article_number IN VARCHAR2,
1004: p_standard_yn IN VARCHAR2,
1005: p_article_intent IN VARCHAR2,
1006: p_article_language IN VARCHAR2,
1007: p_article_type IN VARCHAR2,
1008: p_orig_system_reference_code IN VARCHAR2,

Line 1044: AND standard_yn = 'Y'

1040: CURSOR l_unq_csr(p_org_id IN NUMBER, p_article_id IN NUMBER, p_article_title IN VARCHAR2) is
1041: SELECT '1' FROM OKC_ARTICLES_ALL
1042: WHERE article_title = p_article_title
1043: AND org_id = p_org_id
1044: AND standard_yn = 'Y'
1045: AND article_id <> nvl(p_article_id,-99)
1046: AND rownum < 2
1047: UNION ALL
1048: SELECT '1'

Line 1072: p_standard_yn => p_standard_yn,

1068: p_article_id => p_article_id,
1069: p_article_title => p_article_title,
1070: p_org_id => p_org_id,
1071: p_article_number => p_article_number,
1072: p_standard_yn => p_standard_yn,
1073: p_article_intent => p_article_intent,
1074: p_article_language => p_article_language,
1075: p_article_type => p_article_type,
1076: p_orig_system_reference_code => p_orig_system_reference_code,

Line 1116: IF ( p_standard_yn = 'Y' AND p_article_type IS NULL) THEN

1112: END IF;
1113: /*+++++++++++++start of hand code +++++++++++++++++++*/
1114: -- manual coding for Record Level Validations if required
1115: --dbms_output.put_line('checking for p_article_type2: '||p_article_type||'*'||length(p_article_type));
1116: IF ( p_standard_yn = 'Y' AND p_article_type IS NULL) THEN
1117: IF (l_debug = 'Y') THEN
1118: Okc_Debug.Log('1300: - attribute ARTICLE_TYPE is null for standard article', 2);
1119: END IF;
1120: --dbms_output.put_line('attribute ARTICLE_TYPE is null for standard article');

Line 1118: Okc_Debug.Log('1300: - attribute ARTICLE_TYPE is null for standard article', 2);

1114: -- manual coding for Record Level Validations if required
1115: --dbms_output.put_line('checking for p_article_type2: '||p_article_type||'*'||length(p_article_type));
1116: IF ( p_standard_yn = 'Y' AND p_article_type IS NULL) THEN
1117: IF (l_debug = 'Y') THEN
1118: Okc_Debug.Log('1300: - attribute ARTICLE_TYPE is null for standard article', 2);
1119: END IF;
1120: --dbms_output.put_line('attribute ARTICLE_TYPE is null for standard article');
1121: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TYPE');
1122: l_return_status := G_RET_STS_ERROR;

Line 1120: --dbms_output.put_line('attribute ARTICLE_TYPE is null for standard article');

1116: IF ( p_standard_yn = 'Y' AND p_article_type IS NULL) THEN
1117: IF (l_debug = 'Y') THEN
1118: Okc_Debug.Log('1300: - attribute ARTICLE_TYPE is null for standard article', 2);
1119: END IF;
1120: --dbms_output.put_line('attribute ARTICLE_TYPE is null for standard article');
1121: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TYPE');
1122: l_return_status := G_RET_STS_ERROR;
1123: END IF;
1124: l_dummy_var := '?';

Line 1128: IF ( p_standard_yn = 'Y' ) THEN

1124: l_dummy_var := '?';
1125:
1126: --dbms_output.put_line('Checking for uniqueness '||p_org_id||'*'||p_article_title||'*'|| p_article_id);
1127: l_row_found := TRUE;
1128: IF ( p_standard_yn = 'Y' ) THEN
1129: IF p_org_id is NOT NULL and p_article_title is NOT NULL THEN
1130: OPEN l_unq_csr (p_org_id, p_article_id, p_article_title);
1131: FETCH l_unq_csr INTO l_dummy_var;
1132: l_row_found := l_unq_csr%FOUND;

Line 1191: p_standard_yn IN VARCHAR2,

1187: p_article_id IN NUMBER,
1188: p_article_title IN VARCHAR2,
1189: p_org_id IN NUMBER,
1190: p_article_number IN VARCHAR2,
1191: p_standard_yn IN VARCHAR2,
1192: p_article_intent IN VARCHAR2,
1193: p_article_language IN VARCHAR2,
1194: p_article_type IN VARCHAR2,
1195: p_orig_system_reference_code IN VARCHAR2,

Line 1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;

1221: ) IS
1222: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
1223: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
1224: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1225: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
1226: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1227: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1228: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1229: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 1270: l_standard_yn := p_standard_yn;

1266: IF p_import_action IS NOT NULL THEN
1267: l_article_title := p_article_title;
1268: l_org_id := p_org_id;
1269: l_article_number := p_article_number;
1270: l_standard_yn := p_standard_yn;
1271: l_article_intent := p_article_intent;
1272: l_article_language := p_article_language;
1273: l_article_type := p_article_type;
1274: l_orig_system_reference_code := p_orig_system_reference_code;

Line 1304: p_standard_yn => p_standard_yn,

1300: p_article_id => p_article_id,
1301: p_article_title => p_article_title,
1302: p_org_id => p_org_id,
1303: p_article_number => p_article_number,
1304: p_standard_yn => p_standard_yn,
1305: p_article_intent => p_article_intent,
1306: p_article_language => p_article_language,
1307: p_article_type => p_article_type,
1308: p_orig_system_reference_code => p_orig_system_reference_code,

Line 1336: x_standard_yn => l_standard_yn,

1332: p_object_version_number => p_object_version_number,
1333: x_article_title => l_article_title,
1334: x_org_id => l_org_id,
1335: x_article_number => l_article_number,
1336: x_standard_yn => l_standard_yn,
1337: x_article_intent => l_article_intent,
1338: x_article_language => l_article_language,
1339: x_article_type => l_article_type,
1340: x_orig_system_reference_code => l_orig_system_reference_code,

Line 1380: p_standard_yn => l_standard_yn,

1376: p_article_id => p_article_id,
1377: p_article_title => l_article_title,
1378: p_org_id => l_org_id,
1379: p_article_number => l_article_number,
1380: p_standard_yn => l_standard_yn,
1381: p_article_intent => l_article_intent,
1382: p_article_language => l_article_language,
1383: p_article_type => l_article_type,
1384: p_orig_system_reference_code => l_orig_system_reference_code,

Line 1452: p_standard_yn IN VARCHAR2,

1448: p_article_id IN NUMBER,
1449: p_article_title IN VARCHAR2,
1450: p_org_id IN NUMBER,
1451: p_article_number IN VARCHAR2,
1452: p_standard_yn IN VARCHAR2,
1453: p_article_intent IN VARCHAR2,
1454: p_article_language IN VARCHAR2,
1455: p_article_type IN VARCHAR2,
1456: p_orig_system_reference_code IN VARCHAR2,

Line 1526: STANDARD_YN,

1522: ARTICLE_ID,
1523: ARTICLE_TITLE,
1524: ORG_ID,
1525: ARTICLE_NUMBER,
1526: STANDARD_YN,
1527: ARTICLE_INTENT,
1528: ARTICLE_LANGUAGE,
1529: ARTICLE_TYPE,
1530: ORIG_SYSTEM_REFERENCE_CODE,

Line 1565: p_standard_yn,

1561: p_article_id,
1562: p_article_title,
1563: p_org_id,
1564: p_article_number,
1565: p_standard_yn,
1566: p_article_intent,
1567: nvl(p_article_language,USERENV('LANG')),
1568: p_article_type,
1569: p_orig_system_reference_code,

Line 1636: p_standard_yn IN VARCHAR2,

1632: p_article_id IN NUMBER := NULL,
1633: p_article_title IN VARCHAR2,
1634: p_org_id IN NUMBER,
1635: p_article_number IN VARCHAR2,
1636: p_standard_yn IN VARCHAR2,
1637: p_article_intent IN VARCHAR2,
1638: p_article_language IN VARCHAR2,
1639: p_article_type IN VARCHAR2,
1640: p_orig_system_reference_code IN VARCHAR2,

Line 1719: p_standard_yn => p_standard_yn,

1715: p_article_id => x_article_id,
1716: p_article_title => p_article_title,
1717: p_org_id => p_org_id,
1718: p_article_number => p_article_number,
1719: p_standard_yn => p_standard_yn,
1720: p_article_intent => p_article_intent,
1721: p_article_language => p_article_language,
1722: p_article_type => p_article_type,
1723: p_orig_system_reference_code => p_orig_system_reference_code,

Line 1767: p_standard_yn => p_standard_yn,

1763: p_article_id => x_article_id,
1764: p_article_title => p_article_title,
1765: p_org_id => p_org_id,
1766: p_article_number => p_article_number,
1767: p_standard_yn => p_standard_yn,
1768: p_article_intent => p_article_intent,
1769: p_article_language => p_article_language,
1770: p_article_type => p_article_type,
1771: p_orig_system_reference_code => p_orig_system_reference_code,

Line 2022: p_standard_yn IN VARCHAR2,

2018: p_article_id IN NUMBER,
2019: p_article_title IN VARCHAR2,
2020: p_org_id IN NUMBER,
2021: p_article_number IN VARCHAR2,
2022: p_standard_yn IN VARCHAR2,
2023: p_article_intent IN VARCHAR2,
2024: p_article_language IN VARCHAR2,
2025: p_article_type IN VARCHAR2,
2026: p_orig_system_reference_code IN VARCHAR2,

Line 2093: STANDARD_YN = p_standard_yn,

2089: UPDATE OKC_ARTICLES_ALL
2090: SET ARTICLE_TITLE = p_article_title,
2091: -- ORG_ID = p_org_id,
2092: ARTICLE_NUMBER = p_article_number,
2093: STANDARD_YN = p_standard_yn,
2094: ARTICLE_INTENT = p_article_intent,
2095: -- ARTICLE_LANGUAGE = p_article_language,
2096: ARTICLE_TYPE = p_article_type,
2097: ORIG_SYSTEM_REFERENCE_CODE = p_orig_system_reference_code,

Line 2171: p_standard_yn IN VARCHAR2,

2167: p_article_id IN NUMBER,
2168: p_article_title IN VARCHAR2,
2169: p_org_id IN NUMBER,
2170: p_article_number IN VARCHAR2,
2171: p_standard_yn IN VARCHAR2,
2172: p_article_intent IN VARCHAR2,
2173: p_article_language IN VARCHAR2,
2174: p_article_type IN VARCHAR2,
2175: p_orig_system_reference_code IN VARCHAR2,

Line 2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;

2204:
2205: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
2206: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE;
2207: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2208: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
2209: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
2210: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
2211: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2212: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 2270: p_standard_yn => p_standard_yn,

2266: p_article_id => p_article_id,
2267: p_article_title => p_article_title,
2268: p_org_id => p_org_id,
2269: p_article_number => p_article_number,
2270: p_standard_yn => p_standard_yn,
2271: p_article_intent => p_article_intent,
2272: p_article_language => p_article_language,
2273: p_article_type => p_article_type,
2274: p_orig_system_reference_code => p_orig_system_reference_code,

Line 2302: x_standard_yn => l_standard_yn,

2298: p_object_version_number => p_object_version_number,
2299: x_article_title => l_article_title,
2300: x_org_id => l_org_id,
2301: x_article_number => l_article_number,
2302: x_standard_yn => l_standard_yn,
2303: x_article_intent => l_article_intent,
2304: x_article_language => l_article_language,
2305: x_article_type => l_article_type,
2306: x_orig_system_reference_code => l_orig_system_reference_code,

Line 2348: p_standard_yn => l_standard_yn,

2344: p_article_id => p_article_id,
2345: p_article_title => l_article_title,
2346: p_org_id => l_org_id,
2347: p_article_number => l_article_number,
2348: p_standard_yn => l_standard_yn,
2349: p_article_intent => l_article_intent,
2350: p_article_language => l_article_language,
2351: p_article_type => l_article_type,
2352: p_orig_system_reference_code => l_orig_system_reference_code,

Line 2410: p_standard_yn => l_standard_yn,

2406: p_article_id => p_article_id,
2407: p_article_title => l_article_title,
2408: p_org_id => l_org_id,
2409: p_article_number => l_article_number,
2410: p_standard_yn => l_standard_yn,
2411: p_article_intent => l_article_intent,
2412: p_article_language => l_article_language,
2413: p_article_type => l_article_type,
2414: p_orig_system_reference_code => l_orig_system_reference_code,