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_TERMS_COPY_PVT dependencies on OKC_K_ARTICLES_B

Line 51: okc_k_articles_b kart,

47: l_api_name CONSTANT VARCHAR2(30) := 'get_orig_var_val_xml';
48: CURSOR csr_orig_target_dtls IS
49: SELECT kart1.id
50: FROM okc_articles_all lib,
51: okc_k_articles_b kart,
52: okc_k_articles_b kart1
53: WHERE lib.article_id = kart.sav_sae_id
54: AND kart.id= p_cat_id
55: AND kart1.document_id = p_source_doc_id

Line 52: okc_k_articles_b kart1

48: CURSOR csr_orig_target_dtls IS
49: SELECT kart1.id
50: FROM okc_articles_all lib,
51: okc_k_articles_b kart,
52: okc_k_articles_b kart1
53: WHERE lib.article_id = kart.sav_sae_id
54: AND kart.id= p_cat_id
55: AND kart1.document_id = p_source_doc_id
56: AND kart1.document_type = p_source_doc_type

Line 104: okc_k_articles_b kart

100: SELECT NVL(standard_yn,'N') standard_flag,
101: kart.article_version_id,
102: kart.ORIG_SYSTEM_REFERENCE_ID1
103: FROM okc_articles_all lib,
104: okc_k_articles_b kart
105: WHERE lib.article_id = kart.sav_sae_id
106: AND kart.id= p_cat_id;
107:
108: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS

Line 110: FROM okc_k_articles_b

106: AND kart.id= p_cat_id;
107:
108: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS
109: SELECT article_version_id
110: FROM okc_k_articles_b
111: WHERE id = p_cat_id;
112:
113: CURSOR csr_source_value_id(p_cat_id IN NUMBER,p_variable_code IN VARCHAR2) IS
114: SELECT VAR.VARIABLE_VALUE_ID

Line 154: okc_k_articles_b kart,

150: l_api_name CONSTANT VARCHAR2(30) := 'get_orig_var_val';
151: CURSOR csr_orig_target_dtls IS
152: SELECT kart1.id
153: FROM okc_articles_all lib,
154: okc_k_articles_b kart,
155: okc_k_articles_b kart1
156: WHERE lib.article_id = kart.sav_sae_id
157: AND kart.id= p_cat_id
158: AND kart1.document_id = p_source_doc_id

Line 155: okc_k_articles_b kart1

151: CURSOR csr_orig_target_dtls IS
152: SELECT kart1.id
153: FROM okc_articles_all lib,
154: okc_k_articles_b kart,
155: okc_k_articles_b kart1
156: WHERE lib.article_id = kart.sav_sae_id
157: AND kart.id= p_cat_id
158: AND kart1.document_id = p_source_doc_id
159: AND kart1.document_type = p_source_doc_type

Line 213: okc_k_articles_b kart

209: SELECT NVL(standard_yn,'N') standard_flag,
210: kart.article_version_id,
211: kart.ORIG_SYSTEM_REFERENCE_ID1
212: FROM okc_articles_all lib,
213: okc_k_articles_b kart
214: WHERE lib.article_id = kart.sav_sae_id
215: AND kart.id= p_cat_id;
216:
217: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS

Line 219: FROM okc_k_articles_b

215: AND kart.id= p_cat_id;
216:
217: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS
218: SELECT article_version_id
219: FROM okc_k_articles_b
220: WHERE id = p_cat_id;
221:
222: CURSOR csr_source_value(p_cat_id IN NUMBER,p_variable_code IN VARCHAR2) IS
223: SELECT VAR.VARIABLE_VALUE

Line 376: OKC_K_ARTICLES_B KART,

372: ,KART.orig_system_reference_id1
373: )
374: ,NULL) SourceCatId
375: FROM OKC_ARTICLE_VARIABLES VAR,
376: OKC_K_ARTICLES_B KART,
377: OKC_BUS_VARIABLES_B BUSVAR
378: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
379: AND KART.DOCUMENT_TYPE=p_target_doc_type
380: AND KART.DOCUMENT_ID=p_target_doc_id

Line 398: OKC_K_ARTICLES_B KART,

394: VAR.mr_variable_html,
395: VAR.mr_variable_xml,
396: KART1.cat_id SourceCatId
397: FROM OKC_K_ART_VARIABLES VAR,
398: OKC_K_ARTICLES_B KART,
399: OKC_K_ARTICLES_B KART1,
400: OKC_BUS_VARIABLES_B BUSVAR
401: WHERE KART.DOCUMENT_TYPE=p_target_doc_type
402: AND KART.DOCUMENT_ID=p_target_doc_id

Line 399: OKC_K_ARTICLES_B KART1,

395: VAR.mr_variable_xml,
396: KART1.cat_id SourceCatId
397: FROM OKC_K_ART_VARIABLES VAR,
398: OKC_K_ARTICLES_B KART,
399: OKC_K_ARTICLES_B KART1,
400: OKC_BUS_VARIABLES_B BUSVAR
401: WHERE KART.DOCUMENT_TYPE=p_target_doc_type
402: AND KART.DOCUMENT_ID=p_target_doc_id
403: AND KART1.DOCUMENT_TYPE=p_source_doc_type

Line 644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;

640: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
641: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
642: k NUMBER := 0;
643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

641: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
642: k NUMBER := 0;
643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;

Line 646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

642: k NUMBER := 0;
643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;

Line 647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;

Line 648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;

Line 649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;

645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;

Line 650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;

646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;

Line 651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;

647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;

Line 652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;

648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;

649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
657: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;

650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
657: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
658: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;

651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
657: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
658: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
659:

Line 656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
657: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
658: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
659:
660: sav_sae_tbl SavSaeIdList;

Line 657: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
657: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
658: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
659:
660: sav_sae_tbl SavSaeIdList;
661: Attribute_category_tbl AttributeCategoryList;

Line 658: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
657: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
658: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
659:
660: sav_sae_tbl SavSaeIdList;
661: Attribute_category_tbl AttributeCategoryList;
662: Attribute1_tbl AttributeList;

Line 790: FROM OKC_K_ARTICLES_B KART,

786: DISPLAY_SEQUENCE,
787: ref_article_id,
788: ref_article_version_id,
789: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,sav_sae_id,orig_article_id) orig_article_id
790: FROM OKC_K_ARTICLES_B KART,
791: OKC_SECTIONS_B SCN
792: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
793: AND KART.DOCUMENT_ID=p_source_doc_id
794: AND SCN.DOCUMENT_TYPE = p_target_doc_type

Line 844: FROM OKC_K_ARTICLES_B KART,

840: KART.DISPLAY_SEQUENCE,
841: KART.ref_article_id,
842: KART.ref_article_version_id,
843: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
844: FROM OKC_K_ARTICLES_B KART,
845: OKC_SECTIONS_B SCN,
846: OKC_SECTIONS_B SCN1,
847: OKC_K_ARTICLES_B KART1
848: WHERE KART.DOCUMENT_TYPE= p_source_doc_type

Line 847: OKC_K_ARTICLES_B KART1

843: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
844: FROM OKC_K_ARTICLES_B KART,
845: OKC_SECTIONS_B SCN,
846: OKC_SECTIONS_B SCN1,
847: OKC_K_ARTICLES_B KART1
848: WHERE KART.DOCUMENT_TYPE= p_source_doc_type
849: AND KART.DOCUMENT_ID= p_source_doc_id
850: AND SCN.DOCUMENT_TYPE = p_target_doc_type
851: AND SCN.DOCUMENT_ID = p_target_doc_id

Line 892: FROM OKC_K_ARTICLES_BH KART,

888: DISPLAY_SEQUENCE,
889: ref_article_id,
890: ref_article_version_id,
891: orig_article_id
892: FROM OKC_K_ARTICLES_BH KART,
893: OKC_SECTIONS_B SCN
894: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
895: AND KART.DOCUMENT_ID=p_source_doc_id
896: AND KART.MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)

Line 972: SELECT Max(DISPLAY_SEQUENCE) FROM okc_k_articles_b

968: l_local_article_id NUMBER;
969: l_max_sequence NUMBER;
970:
971: CURSOR l_art_sqn_csr IS
972: SELECT Max(DISPLAY_SEQUENCE) FROM okc_k_articles_b
973: WHERE DOCUMENT_TYPE=P_TARGET_DOC_TYPE
974: AND DOCUMENT_ID=P_TARGET_DOC_ID;
975:
976:

Line 981: FROM okc_k_articles_b tgt, okc_k_entity_locks lck, okc_sections_b tgtsec

977: -------------------- CONC MOD CHANGES START -------------
978: CURSOR cur_orphan_clauses
979: IS
980: SELECT tgt.id,tgtsec.id, lck.k_entity_lock_id
981: FROM okc_k_articles_b tgt, okc_k_entity_locks lck, okc_sections_b tgtsec
982: WHERE tgt.document_type= p_target_doc_type
983: AND tgt.document_id= p_target_doc_id
984: AND tgt.summary_amend_operation_code = 'ADDED'
985: AND lck.entity_name='DUMMYSEC'

Line 997: FROM okc_k_articles_b tgtart

993:
994: CURSOR cur_orphan_upd_clauses
995: IS
996: SELECT tgtart.id,tgtsec.id
997: FROM okc_k_articles_b tgtart
998: ,okc_k_articles_b srcart
999: ,okc_sections_b tgtsec
1000: WHERE 1 = 1
1001: -- Target document clauses

Line 998: ,okc_k_articles_b srcart

994: CURSOR cur_orphan_upd_clauses
995: IS
996: SELECT tgtart.id,tgtsec.id
997: FROM okc_k_articles_b tgtart
998: ,okc_k_articles_b srcart
999: ,okc_sections_b tgtsec
1000: WHERE 1 = 1
1001: -- Target document clauses
1002: AND tgtart.document_type= p_target_doc_type

Line 1012: TYPE CatList IS TABLE OF okc_k_articles_b.ID%TYPE INDEX BY BINARY_INTEGER;

1008: AND tgtsec.document_type = p_target_doc_type
1009: AND tgtsec.document_id = p_target_doc_id
1010: AND srcart.scn_id=tgtsec.ORIG_SYSTEM_REFERENCE_ID1;
1011:
1012: TYPE CatList IS TABLE OF okc_k_articles_b.ID%TYPE INDEX BY BINARY_INTEGER;
1013:
1014: tgt_cat_tbl CatList;
1015: tgt_scn_tbl CatList;
1016: tgt_scn_upd_lock_tbl CatList;

Line 1471: INSERT INTO OKC_K_ARTICLES_B(

1467: END IF;
1468:
1469: IF sav_sae_tbl1.COUNT>0 THEN
1470: FORALL i IN sav_sae_tbl1.FIRST..sav_sae_tbl1.LAST
1471: INSERT INTO OKC_K_ARTICLES_B(
1472: ID,
1473: SAV_SAE_ID,
1474: DOCUMENT_TYPE,
1475: DOCUMENT_ID,

Line 1517: VALUES(OKC_K_ARTICLES_B_S.nextval,

1513: LAST_UPDATED_BY,
1514: LAST_UPDATE_LOGIN,
1515: LAST_UPDATE_DATE,
1516: ORIG_ARTICLE_ID)
1517: VALUES(OKC_K_ARTICLES_B_S.nextval,
1518: sav_sae_tbl1(i),
1519: p_target_doc_type,
1520: p_target_doc_id,
1521: decode(p_target_doc_type,'OKC_BUY',p_target_doc_id,'OKC_SELL',p_target_doc_id, 'OKO',p_target_doc_id,'OKS',p_target_doc_id,'OKE_BUY',p_target_doc_id, 'OKE_SELL',p_target_doc_id, 'OKL',p_target_doc_id,NULL),

Line 1584: UPDATE okc_k_articles_b

1580: CLOSE cur_orphan_clauses;
1581:
1582: IF tgt_cat_tbl.Count > 0 THEN
1583: FORALL i IN tgt_cat_tbl.first..tgt_cat_tbl.last
1584: UPDATE okc_k_articles_b
1585: SET scn_id= tgt_scn_tbl(i)
1586: WHERE id= tgt_cat_tbl(i);
1587:
1588: -- Re-build the lock table.

Line 1602: UPDATE okc_k_articles_b

1598: CLOSE cur_orphan_upd_clauses;
1599:
1600: IF tgt_cat_upd_tbl.Count > 0 THEN
1601: FORALL i IN tgt_cat_upd_tbl.first..tgt_cat_upd_tbl.last
1602: UPDATE okc_k_articles_b
1603: SET scn_id= tgt_scn_upd_tbl(i)
1604: WHERE id= tgt_cat_upd_tbl(i);
1605: -- CASE SECTION IS MODIFED/UPDATED.
1606: -- MODIFY COPY SECTIONS

Line 2153: UPDATE okc_k_articles_b

2149: CLOSE cur_orphan_upd_sections;
2150:
2151: IF tgt_id_upd_tbl.Count > 0 THEN
2152: FORALL i IN tgt_id_upd_tbl.first..tgt_id_upd_tbl.last
2153: UPDATE okc_k_articles_b
2154: SET scn_id= tgt_scn_id_upd_tbl (i)
2155: WHERE id= tgt_id_upd_tbl (i);
2156: END IF;
2157: END IF;

Line 2231: FROM OKC_K_ARTICLES_B

2227:
2228: l_api_name CONSTANT VARCHAR2(30) := 'remove_template_based_articles';
2229: CURSOR l_get_manual_art_csr IS
2230: SELECT count(*)
2231: FROM OKC_K_ARTICLES_B
2232: WHERE DOCUMENT_TYPE = p_doc_type
2233: AND DOCUMENT_ID = p_doc_id
2234: AND SOURCE_FLAG IS NULL;
2235:

Line 2246: SELECT ROWID FROM OKC_K_ARTICLES_B

2242: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
2243: AND SCN_CODE = 'UNASSIGNED';
2244:
2245: CURSOR lock_kart_for_upd_csr IS
2246: SELECT ROWID FROM OKC_K_ARTICLES_B
2247: WHERE DOCUMENT_TYPE = p_doc_type
2248: AND DOCUMENT_ID = p_doc_id
2249: AND SOURCE_FLAG IS NULL FOR UPDATE NOWAIT;
2250:

Line 2254: (SELECT ID FROM OKC_K_ARTICLES_B

2250:
2251: CURSOR lock_var_for_del_csr IS
2252: SELECT ROWID FROM OKC_K_ART_VARIABLES
2253: WHERE CAT_ID IN
2254: (SELECT ID FROM OKC_K_ARTICLES_B
2255: WHERE DOCUMENT_TYPE=p_doc_type
2256: AND DOCUMENT_ID=p_doc_id
2257: AND SOURCE_FLAG IS NOT NULL) FOR UPDATE NOWAIT;
2258:

Line 2260: SELECT ROWID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type

2256: AND DOCUMENT_ID=p_doc_id
2257: AND SOURCE_FLAG IS NOT NULL) FOR UPDATE NOWAIT;
2258:
2259: CURSOR lock_kart_for_del_csr IS
2260: SELECT ROWID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type
2261: AND DOCUMENT_ID=p_doc_id
2262: AND SOURCE_FLAG IS NOT NULL FOR UPDATE NOWAIT;
2263:
2264: CURSOR lock_scn_for_del_csr(b_scn_id NUMBER) IS

Line 2344: UPDATE OKC_K_ARTICLES_B

2340: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2341: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'140: Updating Manually added article sections to unassigned');
2342: END IF;
2343:
2344: UPDATE OKC_K_ARTICLES_B
2345: SET SCN_ID = l_unassigned_scn_id,
2346: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
2347: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
2348: LAST_UPDATE_DATE = sysdate

Line 2363: FROM OKC_K_ARTICLES_B KART

2359: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'150: Deleting Variables ');
2360: END IF;
2361:
2362: DELETE FROM OKC_K_ART_VAR_EXT_B WHERE cat_id IN ( SELECT kart.ID
2363: FROM OKC_K_ARTICLES_B KART
2364: , OKC_BUS_VARIABLES_B BUS_VAR
2365: , OKC_K_ART_VARIABLES KVAR
2366: WHERE kart.document_type=p_doc_type
2367: AND kart.document_id = p_doc_id

Line 2374: (SELECT ID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type

2370: AND KVAR.variable_code=BUS_VAR.variable_code
2371: AND BUS_VAR.MRV_FLAG='Y');
2372:
2373: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN
2374: (SELECT ID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type
2375: AND DOCUMENT_ID=p_doc_id
2376: AND SOURCE_FLAG IS NOT NULL);
2377: OPEN lock_kart_for_del_csr;
2378: CLOSE lock_kart_for_del_csr;

Line 2384: DELETE FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type

2380: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2381: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'160: Deleting Articles ');
2382: END IF;
2383:
2384: DELETE FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type
2385: AND DOCUMENT_ID=p_doc_id
2386: AND SOURCE_FLAG IS NOT NULL;
2387:
2388: OPEN lock_scn_for_del_csr(l_unassigned_scn_id);

Line 3833: OKC_K_ARTICLES_B KART,

3829: VAR.MR_VARIABLE_HTML,
3830: VAR.MR_VARIABLE_XML,
3831: BUS_VAR.MRV_FLAG
3832: FROM OKC_K_ART_VARIABLES_H VAR,
3833: OKC_K_ARTICLES_B KART,
3834: OKC_K_ARTICLES_BH KART1,
3835: OKC_BUS_VARIABLES_B BUS_VAR
3836: WHERE KART.ORIG_SYSTEM_REFERENCE_ID1=KART1.ID
3837: AND VAR.CAT_ID=KART1.ID

Line 3834: OKC_K_ARTICLES_BH KART1,

3830: VAR.MR_VARIABLE_XML,
3831: BUS_VAR.MRV_FLAG
3832: FROM OKC_K_ART_VARIABLES_H VAR,
3833: OKC_K_ARTICLES_B KART,
3834: OKC_K_ARTICLES_BH KART1,
3835: OKC_BUS_VARIABLES_B BUS_VAR
3836: WHERE KART.ORIG_SYSTEM_REFERENCE_ID1=KART1.ID
3837: AND VAR.CAT_ID=KART1.ID
3838: AND KART.DOCUMENT_TYPE=p_target_doc_type