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 455: FROM OKC_K_ARTICLES_B

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

Line 460: FROM OKC_K_ARTICLES_B

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

Line 709: FROM OKC_K_ARTICLES_B

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

Line 980: l_art_id OKC_K_ARTICLES_B.ID%TYPE;

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

Line 987: OKC_K_ARTICLES_B KART

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

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

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

Line 1143: FROM okc_k_articles_b,okc_articles_all

1139: l_max_local_article_rec l_get_max_local_article_csr%ROWTYPE;
1140:
1141: CURSOR get_articles_order_art_num is
1142: SELECT id,scn_id
1143: FROM okc_k_articles_b,okc_articles_all
1144: WHERE document_type=p_doc_type AND
1145: document_id=p_doc_id AND
1146: sav_sae_id=article_id
1147: ORDER BY scn_id,article_number;

Line 1252: 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 (';

1248: FND_LOG.STRING(G_PROC_LEVEL,
1249: G_PKG_NAME, '100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag );
1250: END IF;
1251:
1252: 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 (';
1253:
1254: k := 0;
1255:
1256: /*IF (l_debug = 'Y') THEN

Line 1288: 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'' ';

1284:
1285: END LOOP;
1286: l_query := l_query1||')';
1287: ELSE
1288: 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'' ';
1289:
1290: END IF;
1291:
1292: /*IF (l_debug = 'Y') THEN

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

2235: );
2236:
2237:
2238: CURSOR l_get_max_art_seq_csr(b_scn_id NUMBER) is
2239: SELECT nvl(max(display_SEQUENCE),0) FROM OKC_K_ARTICLES_B
2240: WHERE document_type=p_doc_type
2241: AND document_id=p_doc_id
2242: and b_scn_id is not null
2243: and scn_id=b_scn_id;

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

2242: and b_scn_id is not null
2243: and scn_id=b_scn_id;
2244:
2245: CURSOR l_get_scn_csr(b_cat_id NUMBER) IS
2246: SELECT SCN_ID FROM OKC_K_ARTICLES_B WHERE Id=b_cat_id;
2247:
2248: CURSOR l_get_parent_scn_csr(b_scn_id NUMBER) IS
2249: SELECT SCN_ID FROM OKC_SECTIONS_B WHERE Id=b_scn_id;
2250:

Line 2271: FROM OKC_K_ARTICLES_B

2267: (b_scn_id is Not Null and scn_id=b_scn_id)
2268: )
2269: UNION ALL
2270: SELECT ID,DISPLAY_SEQUENCE DISPLAY_SEQ,'ARTICLE' obj_type
2271: FROM OKC_K_ARTICLES_B
2272: WHERE document_type = p_doc_type
2273: AND document_id = p_doc_id
2274: AND scn_id=b_scn_id
2275: ORDER BY 2;

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

2894: CURSOR article_properties(b_review_upld_terms_id NUMBER) is
2895: SELECT av.insert_by_reference,
2896: akb.mandatory_yn,
2897: av.lock_text
2898: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb
2899: WHERE av.article_version_id = ar.article_version_id
2900: AND akb.id = ar.object_id
2901: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2902: