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_GRP dependencies on OKC_ARTICLES_ALL

Line 635: FROM OKC_ARTICLES_ALL

631: ;
632:
633: CURSOR l_ensure_unique_csr (cp_article_number IN VARCHAR2, cp_org_id IN NUMBER ) IS
634: SELECT ARTICLE_NUMBER
635: FROM OKC_ARTICLES_ALL
636: WHERE ARTICLE_NUMBER = cp_article_number
637: AND ORG_ID = cp_org_id
638: AND ROWNUM < 2;
639:

Line 652: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE := NULL;

648: ;
649:
650: l_row_notfound BOOLEAN := FALSE;
651: l_row_notfound1 BOOLEAN := FALSE;
652: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE := NULL;
653:
654: BEGIN
655:
656: -- Initialize API return status to success

Line 1063: OKC_ARTICLES_ALL_PVT.Validate_Row(

1059:
1060: --------------------------------------------
1061: -- Calling Simple API for Article Validation
1062: --------------------------------------------
1063: OKC_ARTICLES_ALL_PVT.Validate_Row(
1064: p_validation_level => p_validation_level,
1065: p_import_action => p_import_action,
1066: x_return_status => l_return_status,
1067: p_article_id => p_article_id,

Line 1275: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;

1271: ) IS
1272:
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
1275: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1276: l_doc_sequence_type VARCHAR2(1);
1277: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

Line 1277: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

1273: l_api_version CONSTANT NUMBER := 1;
1274: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
1275: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1276: l_doc_sequence_type VARCHAR2(1);
1277: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1280: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1281: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;

1274: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
1275: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1276: l_doc_sequence_type VARCHAR2(1);
1277: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1280: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1281: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1282: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

Line 1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

1275: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1276: l_doc_sequence_type VARCHAR2(1);
1277: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1280: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1281: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1282: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1283: BEGIN

Line 1280: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;

1276: l_doc_sequence_type VARCHAR2(1);
1277: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1280: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1281: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1282: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1283: BEGIN
1284:

Line 1281: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

1277: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1280: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1281: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1282: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1283: BEGIN
1284:
1285: --dbms_output.put_line('600: Entered create_article from copy');

Line 1282: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

1278: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1279: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1280: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1281: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1282: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1283: BEGIN
1284:
1285: --dbms_output.put_line('600: Entered create_article from copy');
1286: IF (l_debug = 'Y') THEN

Line 1342: OKC_ARTICLES_ALL_PVT.Insert_Row(

1338: END IF;
1339: --------------------------------------------
1340: -- Calling Simple API for Creating Article Row
1341: --------------------------------------------
1342: OKC_ARTICLES_ALL_PVT.Insert_Row(
1343: p_validation_level => p_validation_level,
1344: x_return_status => x_return_status,
1345: p_article_title => p_article_title,
1346: p_org_id => G_CURRENT_ORG_ID,

Line 1523: OKC_ARTICLES_ALL_PVT.lock_row(

1519:
1520: --------------------------------------------
1521: -- Calling Simple API for Locking A Row
1522: --------------------------------------------
1523: OKC_ARTICLES_ALL_PVT.lock_row(
1524: x_return_status => x_return_status,
1525: p_article_id => p_article_id,
1526: p_object_version_number => p_object_version_number
1527: );

Line 1669: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;

1665: ) IS
1666:
1667: l_api_version CONSTANT NUMBER := 1;
1668: l_api_name CONSTANT VARCHAR2(30) := 'g_update_article';
1669: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1670:
1671: BEGIN
1672:
1673: IF (l_debug = 'Y') THEN

Line 1707: OKC_ARTICLES_ALL_PVT.Update_Row(

1703:
1704: --------------------------------------------
1705: -- Calling Simple API for Updating A Row
1706: --------------------------------------------
1707: OKC_ARTICLES_ALL_PVT.Update_Row(
1708: p_validation_level => p_validation_level,
1709: x_return_status => x_return_status,
1710: x_article_intent => l_article_intent,
1711: p_article_id => p_article_id,

Line 1871: FROM okc_article_versions av,okc_articles_all aa

1867:
1868: Cursor l_status_csr (cp_article_id IN NUMBER,
1869: cp_article_version_id IN NUMBER) IS
1870: SELECT article_status,standard_yn, adoption_type
1871: FROM okc_article_versions av,okc_articles_all aa
1872: WHERE aa.article_id = av.article_id
1873: AND av.article_id = cp_article_id
1874: AND av.article_version_id = cp_article_version_id;
1875:

Line 1951: OKC_ARTICLES_ALL_PVT.Delete_Row(

1947: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_USED_IN_RULES');
1948: x_return_status := G_RET_STS_ERROR;
1949: RAISE FND_API.G_EXC_ERROR;
1950: ELSE
1951: OKC_ARTICLES_ALL_PVT.Delete_Row(
1952: x_return_status => x_return_status,
1953: p_article_id => p_article_id,
1954: p_object_version_number => NULL
1955: );

Line 1971: OKC_ARTICLES_ALL_PVT.Delete_Row(

1967: END IF;
1968: END IF;
1969: END IF;
1970: ELSE -- in the case of non standard articles
1971: OKC_ARTICLES_ALL_PVT.Delete_Row(
1972: x_return_status => x_return_status,
1973: p_article_id => p_article_id,
1974: p_object_version_number => NULL
1975: );

Line 3104: UPDATE OKC_ARTICLES_ALL

3100: RAISE FND_API.G_EXC_ERROR ;
3101: END IF;
3102: END IF;
3103: IF l_article_status = 'APPROVED' THEN
3104: UPDATE OKC_ARTICLES_ALL
3105: SET cz_transfer_status_flag = 'R'
3106: WHERE ARTICLE_ID = l_article_id;
3107: END IF;
3108:

Line 3176: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;

3172: x_msg_count OUT NOCOPY NUMBER,
3173: x_msg_data OUT NOCOPY VARCHAR2
3174: ) IS
3175: -- Article Attributes
3176: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3177: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;

Line 3177: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;

3173: x_msg_data OUT NOCOPY VARCHAR2
3174: ) IS
3175: -- Article Attributes
3176: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3177: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;

Line 3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;

3174: ) IS
3175: -- Article Attributes
3176: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3177: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;

Line 3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;

3175: -- Article Attributes
3176: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3177: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;

Line 3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;

3176: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3177: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;

Line 3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;

3177: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

Line 3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;

3178: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3186: l_doc_sequence_type VARCHAR2(1);

Line 3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;

3179: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3186: l_doc_sequence_type VARCHAR2(1);
3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;

3180: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3186: l_doc_sequence_type VARCHAR2(1);
3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

3181: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3182: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3186: l_doc_sequence_type VARCHAR2(1);
3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

3183: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3186: l_doc_sequence_type VARCHAR2(1);
3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;

Line 3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

3184: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3186: l_doc_sequence_type VARCHAR2(1);
3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;

Line 3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

3185: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3186: l_doc_sequence_type VARCHAR2(1);
3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;

Line 3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;

3186: l_doc_sequence_type VARCHAR2(1);
3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;

Line 3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;

3187: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;

Line 3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;

3188: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;

Line 3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;

3189: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;

Line 3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;

3190: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;

Line 3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;

3191: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;

Line 3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;

3192: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;

Line 3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;

3193: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;

Line 3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;

3194: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;

Line 3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;

3195: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;

Line 3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;

3196: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;

Line 3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;

3197: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;

Line 3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;

3198: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;

Line 3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;

3199: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;

Line 3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;

3200: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;

Line 3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;

3201: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;

Line 3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;

3202: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;

Line 3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;

3203: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;

Line 3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;

3204: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

Line 3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;

3205: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

Line 3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;

3206: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;

Line 3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;

3207: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

3208: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3216:

Line 3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

3209: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3216:
3217: -- Article Version Attributes

Line 3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;

3210: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3216:
3217: -- Article Version Attributes
3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;

Line 3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

3211: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3212: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3213: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3214: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3215: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3216:
3217: -- Article Version Attributes
3218: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3219: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;

Line 3296: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av

3292: i NUMBER := 0;
3293:
3294: CURSOR l_article_csr (cp_article_version_id IN NUMBER) is
3295: SELECT aa.standard_yn,av.article_id
3296: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av
3297: WHERE aa.ARTICLE_ID = av.ARTICLE_ID
3298: AND av.ARTICLE_VERSION_ID = cp_article_version_id;
3299:
3300: CURSOR l_relationship_csr (cp_article_id IN NUMBER,

Line 3349: l_return_status := OKC_ARTICLES_ALL_PVT.Get_Rec(

3345: IF l_p_article_id IS NOT NULL THEN
3346: -- Get Current Database values for Article
3347:
3348: --dbms_output.put_line('2700: Before Get_Rec1 ');
3349: l_return_status := OKC_ARTICLES_ALL_PVT.Get_Rec(
3350: p_article_id => l_p_article_id,
3351: x_article_title => l_article_title,
3352: x_org_id => l_org_id,
3353: x_article_number => l_old_article_number,

Line 3525: OKC_ARTICLES_ALL_PVT.Insert_Row(

3521: lv_orig_system_reference_code := 'OKCARTV';
3522: lv_orig_system_reference_id1 := to_char(p_article_version_id);
3523:
3524: --dbms_output.put_line('Before Create Article ');
3525: OKC_ARTICLES_ALL_PVT.Insert_Row(
3526: p_validation_level => p_validation_level,
3527: x_return_status => x_return_status,
3528: p_article_title => nvl(p_new_article_title,l_article_title),
3529: p_org_id => G_CURRENT_ORG_ID,

Line 4081: FROM OKC_ARTICLES_ALL A, OKC_ARTICLES_ALL B

4077:
4078: CURSOR l_approved_csr (cp_src_global_article_id IN NUMBER,
4079: cp_tar_global_article_id IN NUMBER) IS
4080: SELECT '1'
4081: FROM OKC_ARTICLES_ALL A, OKC_ARTICLES_ALL B
4082: WHERE A.ARTICLE_ID = cp_src_global_article_id
4083: AND B.ARTICLE_ID = cp_tar_global_article_id
4084: AND EXISTS
4085: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V

Line 4447: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

4443: l_api_name CONSTANT VARCHAR2(30) := 'g_auto_adoption';
4444: j NUMBER := 0;
4445: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4446: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4447: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4448: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4449: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4450:
4451: l_article_number_tbl l_article_number_list ;