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 OKC_ART_INTERFACE_ALL

Line 41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

37:
38: -- For Error
39: TYPE list_err_batch_process_id IS TABLE OF OKC_ART_INT_ERRORS.BATCH_PROCESS_ID%TYPE INDEX BY BINARY_INTEGER ;
40: TYPE list_err_interface_id IS TABLE OF OKC_ART_INT_ERRORS.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE list_err_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
42: TYPE list_err_error_number IS TABLE OF OKC_ART_INT_ERRORS.ERROR_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
43: TYPE list_err_object_version_number IS TABLE OF OKC_ART_INT_ERRORS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE list_err_error_type IS TABLE OF OKC_ART_INT_ERRORS.ERROR_TYPE%TYPE INDEX BY BINARY_INTEGER ;
45: TYPE list_err_error_description IS TABLE OF OKC_ART_INT_ERRORS.ERROR_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

Line 198: from okc_art_int_errors a,okc_art_interface_all b,

194: CURSOR get_art_info_csr IS
195: SELECT a.interface_id,a.entity,error_description,
196: b.article_title,b.article_number,
197: hr.name org_name
198: from okc_art_int_errors a,okc_art_interface_all b,
199: hr_organization_units hr
200: where a.interface_id = b.interface_id
201: and b.org_id = hr.organization_id
202: and b.batch_number = p_batch_number

Line 541: FROM okc_art_interface_all a,hr_organization_units hr

537: l_check_access VARCHAR2(1);
538:
539: Cursor Pur_org_csr IS
540: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
541: FROM okc_art_interface_all a,hr_organization_units hr
542: WHERE a.org_id IS NOT NULL
543: AND batch_number = p_batch_number
544: AND a.org_id = hr.organization_id(+)
545: UNION ALL

Line 552: (SELECT 1 FROM okc_art_interface_all b

548: WHERE a.org_id IS NOT NULL
549: AND batch_number = p_batch_number
550: AND a.org_id = hr.organization_id(+)
551: AND NOT EXISTS
552: (SELECT 1 FROM okc_art_interface_all b
553: WHERE a.org_id = b.org_id
554: AND b.batch_number = p_batch_number);
555:
556: BEGIN

Line 606: FROM OKC_ART_INTERFACE_ALL

602: FROM OKC_ART_INT_BATPROCS_ALL
603: WHERE org_id = G_CURRENT_ORG_ID
604: AND batch_number in
605: (SELECT batch_number
606: FROM OKC_ART_INTERFACE_ALL
607: WHERE org_id = G_CURRENT_ORG_ID));
608:
609: DELETE FROM OKC_ART_INTERFACE_ALL
610: WHERE org_id = G_CURRENT_ORG_ID;

Line 609: DELETE FROM OKC_ART_INTERFACE_ALL

605: (SELECT batch_number
606: FROM OKC_ART_INTERFACE_ALL
607: WHERE org_id = G_CURRENT_ORG_ID));
608:
609: DELETE FROM OKC_ART_INTERFACE_ALL
610: WHERE org_id = G_CURRENT_ORG_ID;
611:
612: -- Below Added for FAR/DFAR Content Import
613: DELETE FROM OKC_VARIABLES_INTERFACE ;

Line 622: FROM OKC_ART_INTERFACE_ALL

618:
619: ELSE
620: DELETE FROM OKC_ART_INT_ERRORS
621: WHERE interface_id in ( SELECT interface_id
622: FROM OKC_ART_INTERFACE_ALL
623: WHERE last_update_date >= trunc(l_start_date)
624: AND last_update_date <= l_end_date
625: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
626: AND (process_status = p_process_status OR p_process_status IS NULL)

Line 628: DELETE FROM OKC_ART_INTERFACE_ALL

624: AND last_update_date <= l_end_date
625: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
626: AND (process_status = p_process_status OR p_process_status IS NULL)
627: AND org_id = G_CURRENT_ORG_ID);
628: DELETE FROM OKC_ART_INTERFACE_ALL
629: WHERE last_update_date >= trunc(l_start_date)
630: AND last_update_date <= l_end_date
631: AND (batch_number = p_batch_number OR p_batch_number IS NULL)
632: AND (process_status = p_process_status OR p_process_status IS NULL)

Line 668: FROM OKC_ART_INTERFACE_ALL

664: FROM OKC_ART_INT_BATPROCS_ALL
665: WHERE org_id = G_CURRENT_ORG_ID
666: AND batch_number not in
667: (SELECT batch_number
668: FROM OKC_ART_INTERFACE_ALL
669: WHERE org_id = G_CURRENT_ORG_ID));
670:
671: END IF;
672:

Line 731: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;

727: l_msg_data VARCHAR2(1000);
728: l_init_msg_list VARCHAR2(3) := 'F';
729: l_user_id NUMBER;
730: l_login_id NUMBER;
731: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
732: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
733: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
734: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
735: l_batch_process_id NUMBER;

Line 732: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;

728: l_init_msg_list VARCHAR2(3) := 'F';
729: l_user_id NUMBER;
730: l_login_id NUMBER;
731: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
732: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
733: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
734: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
735: l_batch_process_id NUMBER;
736: lc_batch_process_id NUMBER;

Line 733: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;

729: l_user_id NUMBER;
730: l_login_id NUMBER;
731: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
732: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
733: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
734: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
735: l_batch_process_id NUMBER;
736: lc_batch_process_id NUMBER;
737: l_first_time VARCHAR2(1) := 'Y';

Line 734: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;

730: l_login_id NUMBER;
731: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
732: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
733: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
734: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
735: l_batch_process_id NUMBER;
736: lc_batch_process_id NUMBER;
737: l_first_time VARCHAR2(1) := 'Y';
738: l_wrap_up VARCHAR2(1) := 'Y';

Line 762: FROM okc_art_interface_all a,hr_organization_units hr

758: l_check_access VARCHAR2(1);
759:
760: Cursor Org_csr IS
761: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
762: FROM okc_art_interface_all a,hr_organization_units hr
763: WHERE a.org_id IS NOT NULL
764: AND batch_number = p_batch_number
765: AND a.org_id = hr.organization_id(+)
766: UNION ALL

Line 773: (SELECT 1 FROM okc_art_interface_all b

769: WHERE a.org_id IS NOT NULL
770: AND batch_number = p_batch_number
771: AND a.org_id = hr.organization_id(+)
772: AND NOT EXISTS
773: (SELECT 1 FROM okc_art_interface_all b
774: WHERE a.org_id = b.org_id
775: AND b.batch_number = p_batch_number);
776:
777:

Line 1835: FROM OKC_ART_INTERFACE_ALL INTRFC, OKC_ARTICLES_ALL ART

1831: --Clause editing in word
1832: INTRFC.EDITED_IN_WORD,
1833: INTRFC.ARTICLE_TEXT_IN_WORD,
1834: TO_NUMBER(NULL) ARTICLE_VERSION_ID
1835: FROM OKC_ART_INTERFACE_ALL INTRFC, OKC_ARTICLES_ALL ART
1836: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
1837: AND INTRFC.ORG_ID = cp_local_org_id
1838: AND BATCH_NUMBER = cp_batch_number
1839: AND RTRIM(INTRFC.ARTICLE_TITLE) = ART.ARTICLE_TITLE(+)

Line 1903: TYPE l_inf_interface_id IS TABLE OF OKC_ART_INTERFACE_ALL.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;

1899: AND BVT.LANGUAGE = cp_lang;
1900:
1901: -- Interface Rows
1902:
1903: TYPE l_inf_interface_id IS TABLE OF OKC_ART_INTERFACE_ALL.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
1904: TYPE l_inf_batch_number IS TABLE OF OKC_ART_INTERFACE_ALL.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 1904: TYPE l_inf_batch_number IS TABLE OF OKC_ART_INTERFACE_ALL.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

1900:
1901: -- Interface Rows
1902:
1903: TYPE l_inf_interface_id IS TABLE OF OKC_ART_INTERFACE_ALL.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
1904: TYPE l_inf_batch_number IS TABLE OF OKC_ART_INTERFACE_ALL.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

Line 1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

1901: -- Interface Rows
1902:
1903: TYPE l_inf_interface_id IS TABLE OF OKC_ART_INTERFACE_ALL.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
1904: TYPE l_inf_batch_number IS TABLE OF OKC_ART_INTERFACE_ALL.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;

Line 1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

1902:
1903: TYPE l_inf_interface_id IS TABLE OF OKC_ART_INTERFACE_ALL.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
1904: TYPE l_inf_batch_number IS TABLE OF OKC_ART_INTERFACE_ALL.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

Line 1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;

1903: TYPE l_inf_interface_id IS TABLE OF OKC_ART_INTERFACE_ALL.INTERFACE_ID%TYPE INDEX BY BINARY_INTEGER ;
1904: TYPE l_inf_batch_number IS TABLE OF OKC_ART_INTERFACE_ALL.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;

Line 1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;

1904: TYPE l_inf_batch_number IS TABLE OF OKC_ART_INTERFACE_ALL.BATCH_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

Line 1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;

1905: TYPE l_inf_object_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

1906: TYPE l_inf_article_title IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;

1907: TYPE l_inf_org_id IS TABLE OF OKC_ART_INTERFACE_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;

Line 1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

1908: TYPE l_inf_process_status IS TABLE OF OKC_ART_INTERFACE_ALL.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;

Line 1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

1909: TYPE l_inf_action IS TABLE OF OKC_ART_INTERFACE_ALL.ACTION%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;

Line 1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;

1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;

1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;

Line 1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;

1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;

Line 1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;

1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;

1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;

Line 1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;

1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;

Line 1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;

1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;

Line 1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;

1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;

Line 1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;

1919: TYPE l_inf_provision_yn IS TABLE OF OKC_ART_INTERFACE_ALL.PROVISION_YN%TYPE INDEX BY BINARY_INTEGER ;
1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

Line 1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;

1920: TYPE l_inf_insert_by_reference IS TABLE OF OKC_ART_INTERFACE_ALL.INSERT_BY_REFERENCE%TYPE INDEX BY BINARY_INTEGER ;
1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;

Line 1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;

1921: TYPE l_inf_lock_text IS TABLE OF OKC_ART_INTERFACE_ALL.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;

Line 1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;

1922: TYPE l_inf_global_yn IS TABLE OF OKC_ART_INTERFACE_ALL.GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER ;
1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;

Line 1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

1923: TYPE l_inf_article_status IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_STATUS%TYPE INDEX BY BINARY_INTEGER ;
1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;

Line 1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;

1924: TYPE l_inf_start_date IS TABLE OF OKC_ART_INTERFACE_ALL.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;

Line 1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;

1925: TYPE l_inf_end_date IS TABLE OF OKC_ART_INTERFACE_ALL.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;

Line 1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;

1926: TYPE l_inf_display_name IS TABLE OF OKC_ART_INTERFACE_ALL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;

Line 1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;

1927: TYPE l_inf_article_description IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;

Line 1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;

1928: TYPE l_inf_date_approved IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_APPROVED%TYPE INDEX BY BINARY_INTEGER ;
1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;

Line 1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;

1929: TYPE l_inf_default_section IS TABLE OF OKC_ART_INTERFACE_ALL.DEFAULT_SECTION%TYPE INDEX BY BINARY_INTEGER ;
1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;

Line 1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;

1930: TYPE l_inf_reference_source IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;

Line 1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;

1931: TYPE l_inf_reference_text IS TABLE OF OKC_ART_INTERFACE_ALL.REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;

Line 1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;

1932: TYPE l_inf_ver_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;

Line 1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;

1933: TYPE l_inf_ver_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;

Line 1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;

1934: TYPE l_inf_ver_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.VER_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;

Line 1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;

1935: TYPE l_inf_instructions IS TABLE OF OKC_ART_INTERFACE_ALL.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER ;
1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;

Line 1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;

1936: TYPE l_inf_date_published IS TABLE OF OKC_ART_INTERFACE_ALL.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;

Line 1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;

1937: TYPE l_inf_attribute_category IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;

Line 1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;

1938: TYPE l_inf_attribute1 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;

Line 1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;

1939: TYPE l_inf_attribute2 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER ;
1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;

Line 1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;

1940: TYPE l_inf_attribute3 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER ;
1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;

Line 1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;

1941: TYPE l_inf_attribute4 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER ;
1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;

Line 1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;

1942: TYPE l_inf_attribute5 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER ;
1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;

Line 1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;

1943: TYPE l_inf_attribute6 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER ;
1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;

Line 1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;

1944: TYPE l_inf_attribute7 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;

Line 1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;

1945: TYPE l_inf_attribute8 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1953: --Clause Editing

Line 1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;

1946: TYPE l_inf_attribute9 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1953: --Clause Editing
1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;

Line 1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;

1947: TYPE l_inf_attribute10 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1953: --Clause Editing
1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;

Line 1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;

1948: TYPE l_inf_attribute11 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1953: --Clause Editing
1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;

1950: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1953: --Clause Editing
1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1958: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER ;

Line 1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;

1951: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1953: --Clause Editing
1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1958: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1959: --clm

Line 1957: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;

1953: --Clause Editing
1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1958: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1959: --clm
1960: -- TYPE l_inf_variable_code IS TABLE OF OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1961:

Line 2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;

2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2057: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
2058: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;

Line 2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;

2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2057: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
2058: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;
2059: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%TYPE;

Line 2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;

2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2057: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
2058: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;
2059: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%TYPE;
2060: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

Line 2057: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;

2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2057: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;
2058: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;
2059: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%TYPE;
2060: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
2061: l_return_status VARCHAR2(1);

Line 3810: FROM OKC_ART_INTERFACE_ALL VI

3806: vi.object_version_number+1,
3807: l_user_id,
3808: l_login_id,
3809: sysdate
3810: FROM OKC_ART_INTERFACE_ALL VI
3811: WHERE inf_action_tbl(i) = 'U'
3812: AND nvl(process_status, 'E') in ('E')
3813: AND inf_process_status_tbl(i) in ('S', 'W')
3814: AND VI.interface_id = inf_interface_id_tbl(i))

Line 3959: UPDATE OKC_ART_INTERFACE_ALL

3955: i:=0;
3956: BEGIN
3957: l_context := 'UPDATING CLAUSE INTERFACE TABLE';
3958: FORALL i in inf_interface_id_tbl.FIRST..inf_interface_id_tbl.LAST
3959: UPDATE OKC_ART_INTERFACE_ALL
3960: SET
3961: -- We don't want to update process_status to 'S' or 'W' in validation_mode
3962: -- because it is not going to be picked up in next run if we do so
3963: PROCESS_STATUS = decode(p_validate_only||inf_process_status_tbl(i)||l_bulk_failed,

Line 4018: -- End of Update OKC_ART_INTERFACE_ALL

4014:
4015: --RAISE FND_API.G_EXC_ERROR ;
4016: END;
4017: --
4018: -- End of Update OKC_ART_INTERFACE_ALL
4019: --
4020: --
4021: --Insert Errors into Error table for this fetch
4022: insert_error_array(

Line 6000: FROM OKC_ART_INTERFACE_ALL

5996: CURSOR clause_exists_csr (cp_article_title IN VARCHAR2,
5997: cp_org_id IN NUMBER,
5998: cp_batch_number IN VARCHAR2) IS
5999: SELECT '1'
6000: FROM OKC_ART_INTERFACE_ALL
6001: WHERE article_title = cp_article_title
6002: AND org_id = cp_org_id
6003: AND batch_number = cp_batch_number
6004: AND nvl(process_status,'X') not in ('E');