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 624: FROM OKC_ARTICLES_ALL

620: ;
621:
622: CURSOR l_ensure_unique_csr (cp_article_number IN VARCHAR2, cp_org_id IN NUMBER ) IS
623: SELECT ARTICLE_NUMBER
624: FROM OKC_ARTICLES_ALL
625: WHERE ARTICLE_NUMBER = cp_article_number
626: AND ORG_ID = cp_org_id
627: AND ROWNUM < 2;
628:

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

637: ;
638:
639: l_row_notfound BOOLEAN := FALSE;
640: l_row_notfound1 BOOLEAN := FALSE;
641: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE := NULL;
642:
643: BEGIN
644:
645: -- Initialize API return status to success

Line 1047: OKC_ARTICLES_ALL_PVT.Validate_Row(

1043:
1044: --------------------------------------------
1045: -- Calling Simple API for Article Validation
1046: --------------------------------------------
1047: OKC_ARTICLES_ALL_PVT.Validate_Row(
1048: p_validation_level => p_validation_level,
1049: p_import_action => p_import_action,
1050: x_return_status => l_return_status,
1051: p_article_id => p_article_id,

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

1244: ) IS
1245:
1246: l_api_version CONSTANT NUMBER := 1;
1247: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
1248: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1249: l_doc_sequence_type VARCHAR2(1);
1250: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

Line 1250: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

1246: l_api_version CONSTANT NUMBER := 1;
1247: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
1248: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1249: l_doc_sequence_type VARCHAR2(1);
1250: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1253: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1254: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;

1247: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
1248: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1249: l_doc_sequence_type VARCHAR2(1);
1250: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1253: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1254: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1255: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

Line 1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

1248: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
1249: l_doc_sequence_type VARCHAR2(1);
1250: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1253: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1254: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1255: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1256: BEGIN

Line 1253: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;

1249: l_doc_sequence_type VARCHAR2(1);
1250: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1253: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1254: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1255: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1256: BEGIN
1257:

Line 1254: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

1250: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1253: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1254: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1255: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1256: BEGIN
1257:
1258: --dbms_output.put_line('600: Entered create_article from copy');

Line 1255: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

1251: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
1252: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
1253: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
1254: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
1255: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
1256: BEGIN
1257:
1258: --dbms_output.put_line('600: Entered create_article from copy');
1259: IF (l_debug = 'Y') THEN

Line 1315: OKC_ARTICLES_ALL_PVT.Insert_Row(

1311: END IF;
1312: --------------------------------------------
1313: -- Calling Simple API for Creating Article Row
1314: --------------------------------------------
1315: OKC_ARTICLES_ALL_PVT.Insert_Row(
1316: p_validation_level => p_validation_level,
1317: x_return_status => x_return_status,
1318: p_article_title => p_article_title,
1319: p_org_id => G_CURRENT_ORG_ID,

Line 1491: OKC_ARTICLES_ALL_PVT.lock_row(

1487:
1488: --------------------------------------------
1489: -- Calling Simple API for Locking A Row
1490: --------------------------------------------
1491: OKC_ARTICLES_ALL_PVT.lock_row(
1492: x_return_status => x_return_status,
1493: p_article_id => p_article_id,
1494: p_object_version_number => p_object_version_number
1495: );

Line 1632: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;

1628: ) IS
1629:
1630: l_api_version CONSTANT NUMBER := 1;
1631: l_api_name CONSTANT VARCHAR2(30) := 'g_update_article';
1632: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
1633:
1634: BEGIN
1635:
1636: IF (l_debug = 'Y') THEN

Line 1670: OKC_ARTICLES_ALL_PVT.Update_Row(

1666:
1667: --------------------------------------------
1668: -- Calling Simple API for Updating A Row
1669: --------------------------------------------
1670: OKC_ARTICLES_ALL_PVT.Update_Row(
1671: p_validation_level => p_validation_level,
1672: x_return_status => x_return_status,
1673: x_article_intent => l_article_intent,
1674: p_article_id => p_article_id,

Line 1829: FROM okc_article_versions av,okc_articles_all aa

1825:
1826: Cursor l_status_csr (cp_article_id IN NUMBER,
1827: cp_article_version_id IN NUMBER) IS
1828: SELECT article_status,standard_yn, adoption_type
1829: FROM okc_article_versions av,okc_articles_all aa
1830: WHERE aa.article_id = av.article_id
1831: AND av.article_id = cp_article_id
1832: AND av.article_version_id = cp_article_version_id;
1833:

Line 1909: OKC_ARTICLES_ALL_PVT.Delete_Row(

1905: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_USED_IN_RULES');
1906: x_return_status := G_RET_STS_ERROR;
1907: RAISE FND_API.G_EXC_ERROR;
1908: ELSE
1909: OKC_ARTICLES_ALL_PVT.Delete_Row(
1910: x_return_status => x_return_status,
1911: p_article_id => p_article_id,
1912: p_object_version_number => NULL
1913: );

Line 1929: OKC_ARTICLES_ALL_PVT.Delete_Row(

1925: END IF;
1926: END IF;
1927: END IF;
1928: ELSE -- in the case of non standard articles
1929: OKC_ARTICLES_ALL_PVT.Delete_Row(
1930: x_return_status => x_return_status,
1931: p_article_id => p_article_id,
1932: p_object_version_number => NULL
1933: );

Line 2992: UPDATE OKC_ARTICLES_ALL

2988: RAISE FND_API.G_EXC_ERROR ;
2989: END IF;
2990: END IF;
2991: IF l_article_status = 'APPROVED' THEN
2992: UPDATE OKC_ARTICLES_ALL
2993: SET cz_transfer_status_flag = 'R'
2994: WHERE ARTICLE_ID = l_article_id;
2995: END IF;
2996:

Line 3064: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;

3060: x_msg_count OUT NOCOPY NUMBER,
3061: x_msg_data OUT NOCOPY VARCHAR2
3062: ) IS
3063: -- Article Attributes
3064: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3065: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;

Line 3065: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;

3061: x_msg_data OUT NOCOPY VARCHAR2
3062: ) IS
3063: -- Article Attributes
3064: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3065: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;

Line 3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;

3062: ) IS
3063: -- Article Attributes
3064: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3065: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;

Line 3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;

3063: -- Article Attributes
3064: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3065: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;

Line 3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;

3064: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE ;
3065: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;

Line 3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;

3065: l_org_id OKC_ARTICLES_ALL.ORG_ID%TYPE ;
3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

Line 3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;

3066: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3074: l_doc_sequence_type VARCHAR2(1);

Line 3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;

3067: l_old_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE ;
3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3074: l_doc_sequence_type VARCHAR2(1);
3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

Line 3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;

3068: l_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE ;
3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3074: l_doc_sequence_type VARCHAR2(1);
3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

3069: l_object_version_number OKC_ARTICLES_ALL.OBJECT_VERSION_NUMBER%TYPE ;
3070: l_standard_yn OKC_ARTICLES_ALL.STANDARD_YN%TYPE;
3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3074: l_doc_sequence_type VARCHAR2(1);
3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;

3071: l_article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE;
3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3074: l_doc_sequence_type VARCHAR2(1);
3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;

Line 3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

3072: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3074: l_doc_sequence_type VARCHAR2(1);
3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;

Line 3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

3073: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
3074: l_doc_sequence_type VARCHAR2(1);
3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;

Line 3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;

3074: l_doc_sequence_type VARCHAR2(1);
3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;

Line 3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;

3075: l_orig_system_reference_code OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;

Line 3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;

3076: l_orig_system_reference_id1 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;

Line 3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;

3077: l_orig_system_reference_id2 OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;

Line 3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;

3078: l_cz_transfer_status_flag OKC_ARTICLES_ALL.CZ_TRANSFER_STATUS_FLAG%TYPE;
3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;

Line 3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;

3079: l_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE ;
3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;

Line 3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;

3080: l_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE ;
3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;

Line 3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;

3081: l_program_application_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE ;
3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;

Line 3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;

3082: l_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE ;
3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;

Line 3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;

3083: l_attribute_category OKC_ARTICLES_ALL.ATTRIBUTE_CATEGORY%TYPE;
3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;

Line 3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;

3084: l_attribute1 OKC_ARTICLES_ALL.ATTRIBUTE1%TYPE;
3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;

Line 3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;

3085: l_attribute2 OKC_ARTICLES_ALL.ATTRIBUTE2%TYPE;
3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;

Line 3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;

3086: l_attribute3 OKC_ARTICLES_ALL.ATTRIBUTE3%TYPE;
3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;

Line 3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;

3087: l_attribute4 OKC_ARTICLES_ALL.ATTRIBUTE4%TYPE;
3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;

Line 3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;

3088: l_attribute5 OKC_ARTICLES_ALL.ATTRIBUTE5%TYPE;
3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;

Line 3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;

3089: l_attribute6 OKC_ARTICLES_ALL.ATTRIBUTE6%TYPE;
3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;

Line 3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;

3090: l_attribute7 OKC_ARTICLES_ALL.ATTRIBUTE7%TYPE;
3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;

Line 3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;

3091: l_attribute8 OKC_ARTICLES_ALL.ATTRIBUTE8%TYPE;
3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;

Line 3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;

3092: l_attribute9 OKC_ARTICLES_ALL.ATTRIBUTE9%TYPE;
3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

Line 3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;

3093: l_attribute10 OKC_ARTICLES_ALL.ATTRIBUTE10%TYPE;
3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

Line 3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;

3094: l_attribute11 OKC_ARTICLES_ALL.ATTRIBUTE11%TYPE;
3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;

Line 3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;

3095: l_attribute12 OKC_ARTICLES_ALL.ATTRIBUTE12%TYPE;
3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;

3096: l_attribute13 OKC_ARTICLES_ALL.ATTRIBUTE13%TYPE;
3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3104:

Line 3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;

3097: l_attribute14 OKC_ARTICLES_ALL.ATTRIBUTE14%TYPE;
3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3104:
3105: -- Article Version Attributes

Line 3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;

3098: l_attribute15 OKC_ARTICLES_ALL.ATTRIBUTE15%TYPE;
3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3104:
3105: -- Article Version Attributes
3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;

Line 3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;

3099: l_created_by OKC_ARTICLES_ALL.CREATED_BY%TYPE;
3100: l_creation_date OKC_ARTICLES_ALL.CREATION_DATE%TYPE;
3101: l_last_update_date OKC_ARTICLES_ALL.LAST_UPDATE_DATE%TYPE;
3102: l_last_updated_by OKC_ARTICLES_ALL.LAST_UPDATED_BY%TYPE;
3103: l_last_update_login OKC_ARTICLES_ALL.LAST_UPDATE_LOGIN%TYPE;
3104:
3105: -- Article Version Attributes
3106: lv_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE ;
3107: lv_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE ;

Line 3179: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av

3175: i NUMBER := 0;
3176:
3177: CURSOR l_article_csr (cp_article_version_id IN NUMBER) is
3178: SELECT aa.standard_yn,av.article_id
3179: FROM OKC_ARTICLES_ALL aa,OKC_ARTICLE_VERSIONS av
3180: WHERE aa.ARTICLE_ID = av.ARTICLE_ID
3181: AND av.ARTICLE_VERSION_ID = cp_article_version_id;
3182:
3183: CURSOR l_relationship_csr (cp_article_id IN NUMBER,

Line 3232: l_return_status := OKC_ARTICLES_ALL_PVT.Get_Rec(

3228: IF l_p_article_id IS NOT NULL THEN
3229: -- Get Current Database values for Article
3230:
3231: --dbms_output.put_line('2700: Before Get_Rec1 ');
3232: l_return_status := OKC_ARTICLES_ALL_PVT.Get_Rec(
3233: p_article_id => l_p_article_id,
3234: x_article_title => l_article_title,
3235: x_org_id => l_org_id,
3236: x_article_number => l_old_article_number,

Line 3404: OKC_ARTICLES_ALL_PVT.Insert_Row(

3400: lv_orig_system_reference_code := 'OKCARTV';
3401: lv_orig_system_reference_id1 := to_char(p_article_version_id);
3402:
3403: --dbms_output.put_line('Before Create Article ');
3404: OKC_ARTICLES_ALL_PVT.Insert_Row(
3405: p_validation_level => p_validation_level,
3406: x_return_status => x_return_status,
3407: p_article_title => nvl(p_new_article_title,l_article_title),
3408: p_org_id => G_CURRENT_ORG_ID,

Line 3914: FROM OKC_ARTICLES_ALL A, OKC_ARTICLES_ALL B

3910:
3911: CURSOR l_approved_csr (cp_src_global_article_id IN NUMBER,
3912: cp_tar_global_article_id IN NUMBER) IS
3913: SELECT '1'
3914: FROM OKC_ARTICLES_ALL A, OKC_ARTICLES_ALL B
3915: WHERE A.ARTICLE_ID = cp_src_global_article_id
3916: AND B.ARTICLE_ID = cp_tar_global_article_id
3917: AND EXISTS
3918: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V

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

4276: l_api_name CONSTANT VARCHAR2(30) := 'g_auto_adoption';
4277: j NUMBER := 0;
4278: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4279: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4280: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4281: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4282: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4283:
4284: l_article_number_tbl l_article_number_list ;