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 49: okc_k_articles_b kart

45: SELECT NVL(standard_yn,'N') standard_flag,
46: kart.article_version_id,
47: kart.ORIG_SYSTEM_REFERENCE_ID1
48: FROM okc_articles_all lib,
49: okc_k_articles_b kart
50: WHERE lib.article_id = kart.sav_sae_id
51: AND kart.id= p_cat_id;
52:
53: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS

Line 55: FROM okc_k_articles_b

51: AND kart.id= p_cat_id;
52:
53: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS
54: SELECT article_version_id
55: FROM okc_k_articles_b
56: WHERE id = p_cat_id;
57:
58: CURSOR csr_source_value_id(p_cat_id IN NUMBER,p_variable_code IN VARCHAR2) IS
59: SELECT VAR.VARIABLE_VALUE_ID

Line 99: okc_k_articles_b kart,

95: l_api_name CONSTANT VARCHAR2(30) := 'get_orig_var_val';
96: CURSOR csr_orig_target_dtls IS
97: SELECT kart1.id
98: FROM okc_articles_all lib,
99: okc_k_articles_b kart,
100: okc_k_articles_b kart1
101: WHERE lib.article_id = kart.sav_sae_id
102: AND kart.id= p_cat_id
103: AND kart1.document_id = p_source_doc_id

Line 100: okc_k_articles_b kart1

96: CURSOR csr_orig_target_dtls IS
97: SELECT kart1.id
98: FROM okc_articles_all lib,
99: okc_k_articles_b kart,
100: okc_k_articles_b kart1
101: WHERE lib.article_id = kart.sav_sae_id
102: AND kart.id= p_cat_id
103: AND kart1.document_id = p_source_doc_id
104: AND kart1.document_type = p_source_doc_type

Line 146: okc_k_articles_b kart

142: SELECT NVL(standard_yn,'N') standard_flag,
143: kart.article_version_id,
144: kart.ORIG_SYSTEM_REFERENCE_ID1
145: FROM okc_articles_all lib,
146: okc_k_articles_b kart
147: WHERE lib.article_id = kart.sav_sae_id
148: AND kart.id= p_cat_id;
149:
150: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS

Line 152: FROM okc_k_articles_b

148: AND kart.id= p_cat_id;
149:
150: CURSOR csr_source_dtls(p_cat_id IN NUMBER) IS
151: SELECT article_version_id
152: FROM okc_k_articles_b
153: WHERE id = p_cat_id;
154:
155: CURSOR csr_source_value(p_cat_id IN NUMBER,p_variable_code IN VARCHAR2) IS
156: SELECT VAR.VARIABLE_VALUE

Line 214: OKC_K_ARTICLES_B KART,

210: P_SOURCE_DOC_ID,P_SOURCE_DOC_TYPE,'ID'),
211: get_variable_value_id(KART.ID,VAR.VARIABLE_CODE)) VARIABLE_VALUE_ID,
212: 'N' OVERRIDE_GLOBAL_YN
213: FROM OKC_ARTICLE_VARIABLES VAR,
214: OKC_K_ARTICLES_B KART,
215: OKC_BUS_VARIABLES_B BUSVAR
216: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
217: AND KART.DOCUMENT_TYPE=p_target_doc_type
218: AND KART.DOCUMENT_ID=p_target_doc_id

Line 233: OKC_K_ARTICLES_B KART,

229: VAR.VARIABLE_VALUE,
230: VAR.VARIABLE_VALUE_ID,
231: VAR.OVERRIDE_GLOBAL_YN
232: FROM OKC_K_ART_VARIABLES VAR,
233: OKC_K_ARTICLES_B KART,
234: OKC_K_ARTICLES_B KART1,
235: OKC_BUS_VARIABLES_B BUSVAR
236: WHERE KART.DOCUMENT_TYPE=p_target_doc_type
237: AND KART.DOCUMENT_ID=p_target_doc_id

Line 234: OKC_K_ARTICLES_B KART1,

230: VAR.VARIABLE_VALUE_ID,
231: VAR.OVERRIDE_GLOBAL_YN
232: FROM OKC_K_ART_VARIABLES VAR,
233: OKC_K_ARTICLES_B KART,
234: OKC_K_ARTICLES_B KART1,
235: OKC_BUS_VARIABLES_B BUSVAR
236: WHERE KART.DOCUMENT_TYPE=p_target_doc_type
237: AND KART.DOCUMENT_ID=p_target_doc_id
238: AND KART1.DOCUMENT_TYPE=p_source_doc_type

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

402: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
403: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
404: k NUMBER := 0;
405:
406: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
407: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
408: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

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

403: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
404: k NUMBER := 0;
405:
406: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
407: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
408: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;

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

404: k NUMBER := 0;
405:
406: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
407: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
408: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;

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

405:
406: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
407: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
408: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;

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

406: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
407: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
408: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;

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

407: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
408: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;

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

408: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;

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

409: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
417: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

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

410: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
417: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
418: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

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

411: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
417: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
418: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
419: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

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

412: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
417: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
418: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
419: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
420:

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

413: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
417: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
418: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
419: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
420:
421: sav_sae_tbl SavSaeIdList;

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

414: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
417: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
418: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
419: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
420:
421: sav_sae_tbl SavSaeIdList;
422: Attribute_category_tbl AttributeCategoryList;

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

415: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
416: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
417: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
418: TYPE RefArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
419: TYPE OrigArticleIdList IS TABLE OF OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
420:
421: sav_sae_tbl SavSaeIdList;
422: Attribute_category_tbl AttributeCategoryList;
423: Attribute1_tbl AttributeList;

Line 548: FROM OKC_K_ARTICLES_B KART,

544: DISPLAY_SEQUENCE,
545: ref_article_id,
546: ref_article_version_id,
547: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,sav_sae_id,orig_article_id) orig_article_id
548: FROM OKC_K_ARTICLES_B KART,
549: OKC_SECTIONS_B SCN
550: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
551: AND KART.DOCUMENT_ID=p_source_doc_id
552: AND SCN.DOCUMENT_TYPE = p_target_doc_type

Line 589: FROM OKC_K_ARTICLES_B KART,

585: KART.DISPLAY_SEQUENCE,
586: KART.ref_article_id,
587: KART.ref_article_version_id,
588: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
589: FROM OKC_K_ARTICLES_B KART,
590: OKC_SECTIONS_B SCN,
591: OKC_SECTIONS_B SCN1,
592: OKC_K_ARTICLES_B KART1
593: WHERE KART.DOCUMENT_TYPE= p_source_doc_type

Line 592: OKC_K_ARTICLES_B KART1

588: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
589: FROM OKC_K_ARTICLES_B KART,
590: OKC_SECTIONS_B SCN,
591: OKC_SECTIONS_B SCN1,
592: OKC_K_ARTICLES_B KART1
593: WHERE KART.DOCUMENT_TYPE= p_source_doc_type
594: AND KART.DOCUMENT_ID= p_source_doc_id
595: AND SCN.DOCUMENT_TYPE = p_target_doc_type
596: AND SCN.DOCUMENT_ID = p_target_doc_id

Line 636: FROM OKC_K_ARTICLES_BH KART,

632: DISPLAY_SEQUENCE,
633: ref_article_id,
634: ref_article_version_id,
635: orig_article_id
636: FROM OKC_K_ARTICLES_BH KART,
637: OKC_SECTIONS_B SCN
638: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
639: AND KART.DOCUMENT_ID=p_source_doc_id
640: AND KART.MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)

Line 1147: INSERT INTO OKC_K_ARTICLES_B(

1143: END IF;
1144:
1145: IF sav_sae_tbl1.COUNT>0 THEN
1146: FORALL i IN sav_sae_tbl1.FIRST..sav_sae_tbl1.LAST
1147: INSERT INTO OKC_K_ARTICLES_B(
1148: ID,
1149: SAV_SAE_ID,
1150: DOCUMENT_TYPE,
1151: DOCUMENT_ID,

Line 1192: VALUES(OKC_K_ARTICLES_B_S.nextval,

1188: LAST_UPDATED_BY,
1189: LAST_UPDATE_LOGIN,
1190: LAST_UPDATE_DATE,
1191: ORIG_ARTICLE_ID)
1192: VALUES(OKC_K_ARTICLES_B_S.nextval,
1193: sav_sae_tbl1(i),
1194: p_target_doc_type,
1195: p_target_doc_id,
1196: 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 1714: FROM OKC_K_ARTICLES_B

1710:
1711: l_api_name CONSTANT VARCHAR2(30) := 'remove_template_based_articles';
1712: CURSOR l_get_manual_art_csr IS
1713: SELECT count(*)
1714: FROM OKC_K_ARTICLES_B
1715: WHERE DOCUMENT_TYPE = p_doc_type
1716: AND DOCUMENT_ID = p_doc_id
1717: AND SOURCE_FLAG IS NULL;
1718:

Line 1729: SELECT ROWID FROM OKC_K_ARTICLES_B

1725: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
1726: AND SCN_CODE = 'UNASSIGNED';
1727:
1728: CURSOR lock_kart_for_upd_csr IS
1729: SELECT ROWID FROM OKC_K_ARTICLES_B
1730: WHERE DOCUMENT_TYPE = p_doc_type
1731: AND DOCUMENT_ID = p_doc_id
1732: AND SOURCE_FLAG IS NULL FOR UPDATE NOWAIT;
1733:

Line 1737: (SELECT ID FROM OKC_K_ARTICLES_B

1733:
1734: CURSOR lock_var_for_del_csr IS
1735: SELECT ROWID FROM OKC_K_ART_VARIABLES
1736: WHERE CAT_ID IN
1737: (SELECT ID FROM OKC_K_ARTICLES_B
1738: WHERE DOCUMENT_TYPE=p_doc_type
1739: AND DOCUMENT_ID=p_doc_id
1740: AND SOURCE_FLAG IS NOT NULL) FOR UPDATE NOWAIT;
1741:

Line 1743: SELECT ROWID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type

1739: AND DOCUMENT_ID=p_doc_id
1740: AND SOURCE_FLAG IS NOT NULL) FOR UPDATE NOWAIT;
1741:
1742: CURSOR lock_kart_for_del_csr IS
1743: SELECT ROWID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type
1744: AND DOCUMENT_ID=p_doc_id
1745: AND SOURCE_FLAG IS NOT NULL FOR UPDATE NOWAIT;
1746:
1747: CURSOR lock_scn_for_del_csr(b_scn_id NUMBER) IS

Line 1818: UPDATE OKC_K_ARTICLES_B

1814: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1815: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'140: Updating Manually added article sections to unassigned');
1816: END IF;
1817:
1818: UPDATE OKC_K_ARTICLES_B
1819: SET SCN_ID = l_unassigned_scn_id,
1820: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
1821: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
1822: LAST_UPDATE_DATE = sysdate

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

1833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'150: Deleting Variables ');
1834: END IF;
1835:
1836: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN
1837: (SELECT ID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type
1838: AND DOCUMENT_ID=p_doc_id
1839: AND SOURCE_FLAG IS NOT NULL);
1840: OPEN lock_kart_for_del_csr;
1841: CLOSE lock_kart_for_del_csr;

Line 1847: DELETE FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type

1843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'160: Deleting Articles ');
1845: END IF;
1846:
1847: DELETE FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type
1848: AND DOCUMENT_ID=p_doc_id
1849: AND SOURCE_FLAG IS NOT NULL;
1850:
1851: OPEN lock_scn_for_del_csr(l_unassigned_scn_id);

Line 3015: OKC_K_ARTICLES_B KART,

3011: VAR.VARIABLE_VALUE,
3012: VAR.VARIABLE_VALUE_ID,
3013: VAR.OVERRIDE_GLOBAL_YN
3014: FROM OKC_K_ART_VARIABLES_H VAR,
3015: OKC_K_ARTICLES_B KART,
3016: OKC_K_ARTICLES_BH KART1
3017: WHERE KART.ORIG_SYSTEM_REFERENCE_ID1=KART1.ID
3018: AND VAR.CAT_ID=KART1.ID
3019: AND KART.DOCUMENT_TYPE=p_target_doc_type

Line 3016: OKC_K_ARTICLES_BH KART1

3012: VAR.VARIABLE_VALUE_ID,
3013: VAR.OVERRIDE_GLOBAL_YN
3014: FROM OKC_K_ART_VARIABLES_H VAR,
3015: OKC_K_ARTICLES_B KART,
3016: OKC_K_ARTICLES_BH KART1
3017: WHERE KART.ORIG_SYSTEM_REFERENCE_ID1=KART1.ID
3018: AND VAR.CAT_ID=KART1.ID
3019: AND KART.DOCUMENT_TYPE=p_target_doc_type
3020: AND KART.DOCUMENT_ID=p_target_doc_id