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

Line 36: id OKC_K_ARTICLES_B.id%type,

32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35: TYPE scn_child_rec_type IS RECORD (
36: id OKC_K_ARTICLES_B.id%type,
37: display_sequence OKC_K_ARTICLES_B.display_sequence%type,
38: OBJECT_TYPE VARCHAR2(30)
39: );
40:

Line 37: display_sequence OKC_K_ARTICLES_B.display_sequence%type,

33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35: TYPE scn_child_rec_type IS RECORD (
36: id OKC_K_ARTICLES_B.id%type,
37: display_sequence OKC_K_ARTICLES_B.display_sequence%type,
38: OBJECT_TYPE VARCHAR2(30)
39: );
40:
41: TYPE scn_child_tbl_type IS TABLE OF scn_child_rec_type INDEX BY BINARY_INTEGER;

Line 70: l_amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE;

66: l_scn_id NUMBER;
67: i NUMBER := 0;
68: l_ref_count NUMBER := 0;
69: l_ref_sequence NUMBER := 0;
70: l_amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE;
71: l_print_text_yn OKC_K_ARTICLES_B.amendment_description%TYPE;
72:
73:
74: CURSOR l_get_scn_child_csr(b_scn_id NUMBER) IS

Line 71: l_print_text_yn OKC_K_ARTICLES_B.amendment_description%TYPE;

67: i NUMBER := 0;
68: l_ref_count NUMBER := 0;
69: l_ref_sequence NUMBER := 0;
70: l_amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE;
71: l_print_text_yn OKC_K_ARTICLES_B.amendment_description%TYPE;
72:
73:
74: CURSOR l_get_scn_child_csr(b_scn_id NUMBER) IS
75: SELECT ID,SECTION_SEQUENCE DISPLAY_SEQ,'SECTION' obj_type

Line 82: FROM OKC_K_ARTICLES_B

78: AND document_id = p_doc_id
79: AND scn_id=b_scn_id
80: UNION ALL
81: SELECT ID,DISPLAY_SEQUENCE DISPLAY_SEQ,'ARTICLE' obj_type
82: FROM OKC_K_ARTICLES_B
83: WHERE document_type = p_doc_type
84: AND document_id = p_doc_id
85: AND scn_id=b_scn_id
86: ORDER BY 2;

Line 89: SELECT SCN_ID FROM OKC_K_ARTICLES_B

85: AND scn_id=b_scn_id
86: ORDER BY 2;
87:
88: CURSOR l_get_scn_csr(b_cat_id NUMBER) IS
89: SELECT SCN_ID FROM OKC_K_ARTICLES_B
90: WHERE ID=b_cat_id;
91:
92: scn_child_rec l_get_scn_child_csr%ROWTYPE;
93: scn_child_tbl scn_child_tbl_type;

Line 454: FROM OKC_K_ARTICLES_B

450: l_dummy NUMBER := FND_API.G_MISS_NUM;
451:
452: CURSOR l_doc_csr(b_cat_id NUMBER) IS
453: SELECT DOCUMENT_TYPE,DOCUMENT_ID
454: FROM OKC_K_ARTICLES_B
455: WHERE id=b_cat_id;
456:
457: CURSOR l_amend_art_csr(b_cat_id NUMBER) IS
458: SELECT object_version_number

Line 459: FROM OKC_K_ARTICLES_B

455: WHERE id=b_cat_id;
456:
457: CURSOR l_amend_art_csr(b_cat_id NUMBER) IS
458: SELECT object_version_number
459: FROM OKC_K_ARTICLES_B
460: WHERE ID=b_cat_id
461: AND AMENDMENT_OPERATION_CODE<>G_AMEND_CODE_UPDATED;
462:
463: BEGIN

Line 707: FROM OKC_K_ARTICLES_B

703: l_doc_id NUMBER;
704:
705: CURSOR l_doc_art_csr(b_id NUMBER) IS
706: SELECT DOCUMENT_TYPE,DOCUMENT_ID
707: FROM OKC_K_ARTICLES_B
708: WHERE id=b_id;
709:
710: CURSOR l_doc_scn_csr(b_id NUMBER) IS
711: SELECT DOCUMENT_TYPE,DOCUMENT_ID

Line 977: l_art_id OKC_K_ARTICLES_B.ID%TYPE;

973: l_query2 VARCHAR2(3900);
974: l_article_effective_date DATE;
975: l_scn_seq NUMBER;
976: l_scn_id OKC_SECTIONS_B.ID%TYPE;
977: l_art_id OKC_K_ARTICLES_B.ID%TYPE;
978: l_art_seq NUMBER;
979: l_articles_dropped NUMBER :=0;
980: l_max_sec_seq NUMBER;
981:

Line 984: OKC_K_ARTICLES_B KART

980: l_max_sec_seq NUMBER;
981:
982: CURSOR l_check_presence_csr( b_article_id NUMBER) IS
983: SELECT 'x' FROM
984: OKC_K_ARTICLES_B KART
985: WHERE document_type=p_doc_type
986: AND document_id=p_doc_id
987: AND source_flag='R'
988: AND orig_article_id = b_article_id

Line 1038: SELECT nvl(max(display_sequence),0)+10 FROM OKC_K_ARTICLES_B

1034: AND NVL(scn_code,'XWY') <> 'UNASSIGNED'
1035: AND scn_id IS NULL;
1036:
1037: CURSOR l_get_art_seq_csr(b_scn_id NUMBER) IS
1038: SELECT nvl(max(display_sequence),0)+10 FROM OKC_K_ARTICLES_B
1039: WHERE document_type=p_doc_type
1040: AND document_id =p_doc_id
1041: AND SCN_ID = b_scn_id;
1042:

Line 1229: l_query1 := 'Select kart.id ,kart.object_version_number from okc_k_articles_b kart where document_type=:l_doc_type and document_id=:l_doc_id and source_flag=''R'' and orig_article_id not in (';

1225: FND_LOG.STRING(G_PROC_LEVEL,
1226: G_PKG_NAME, '100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag );
1227: END IF;
1228:
1229: l_query1 := 'Select kart.id ,kart.object_version_number from okc_k_articles_b kart where document_type=:l_doc_type and document_id=:l_doc_id and source_flag=''R'' and orig_article_id not in (';
1230:
1231: k := 0;
1232:
1233: /*IF (l_debug = 'Y') THEN

Line 1265: l_query := 'Select kart.id ,kart.object_version_number from okc_k_articles_b kart where document_type=:l_doc_type and document_id=:l_doc_id and source_flag=''R'' ';

1261:
1262: END LOOP;
1263: l_query := l_query1||')';
1264: ELSE
1265: l_query := 'Select kart.id ,kart.object_version_number from okc_k_articles_b kart where document_type=:l_doc_type and document_id=:l_doc_id and source_flag=''R'' ';
1266:
1267: END IF;
1268:
1269: /*IF (l_debug = 'Y') THEN

Line 2126: SELECT nvl(max(display_SEQUENCE),0) FROM OKC_K_ARTICLES_B

2122: );
2123:
2124:
2125: CURSOR l_get_max_art_seq_csr(b_scn_id NUMBER) is
2126: SELECT nvl(max(display_SEQUENCE),0) FROM OKC_K_ARTICLES_B
2127: WHERE document_type=p_doc_type
2128: AND document_id=p_doc_id
2129: and b_scn_id is not null
2130: and scn_id=b_scn_id;

Line 2133: SELECT SCN_ID FROM OKC_K_ARTICLES_B WHERE Id=b_cat_id;

2129: and b_scn_id is not null
2130: and scn_id=b_scn_id;
2131:
2132: CURSOR l_get_scn_csr(b_cat_id NUMBER) IS
2133: SELECT SCN_ID FROM OKC_K_ARTICLES_B WHERE Id=b_cat_id;
2134:
2135: CURSOR l_get_parent_scn_csr(b_scn_id NUMBER) IS
2136: SELECT SCN_ID FROM OKC_SECTIONS_B WHERE Id=b_scn_id;
2137:

Line 2158: FROM OKC_K_ARTICLES_B

2154: (b_scn_id is Not Null and scn_id=b_scn_id)
2155: )
2156: UNION ALL
2157: SELECT ID,DISPLAY_SEQUENCE DISPLAY_SEQ,'ARTICLE' obj_type
2158: FROM OKC_K_ARTICLES_B
2159: WHERE document_type = p_doc_type
2160: AND document_id = p_doc_id
2161: AND scn_id=b_scn_id
2162: ORDER BY 2;

Line 2785: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb

2781: CURSOR article_properties(b_review_upld_terms_id NUMBER) is
2782: SELECT av.insert_by_reference,
2783: akb.mandatory_yn,
2784: av.lock_text
2785: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb
2786: WHERE av.article_version_id = ar.article_version_id
2787: AND akb.id = ar.object_id
2788: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2789: