APPS.OKC_CLM_PKG dependencies on OKC_SECTIONS_B

Line 815: x_default_scn_code OUT NOCOPY OKC_SECTIONS_B.SCN_CODE%TYPE,

811: p_article_id IN NUMBER,
812: p_article_version_id IN NUMBER,
813: p_doc_id IN NUMBER,
814: p_doc_type IN VARCHAR2,
815: x_default_scn_code OUT NOCOPY OKC_SECTIONS_B.SCN_CODE%TYPE,
816: x_return_status OUT NOCOPY VARCHAR2
817: )
818: IS
819: l_api_name VARCHAR2(30) := 'get_default_scn_id';

Line 1111: TYPE DupScnIdList IS TABLE OF OKC_SECTIONS_B.ID%TYPE INDEX BY BINARY_INTEGER;

1107: x_msg_data OUT NOCOPY VARCHAR2,
1108: x_msg_count OUT NOCOPY NUMBER)
1109: IS
1110:
1111: TYPE DupScnIdList IS TABLE OF OKC_SECTIONS_B.ID%TYPE INDEX BY BINARY_INTEGER;
1112: --TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;
1113:
1114: l_api_name CONSTANT VARCHAR2(30) := 'clm_remove_dup_scn_art';
1115: --l_dup_scn_code_tbl ScnCodeList;

Line 1112: --TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;

1108: x_msg_count OUT NOCOPY NUMBER)
1109: IS
1110:
1111: TYPE DupScnIdList IS TABLE OF OKC_SECTIONS_B.ID%TYPE INDEX BY BINARY_INTEGER;
1112: --TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;
1113:
1114: l_api_name CONSTANT VARCHAR2(30) := 'clm_remove_dup_scn_art';
1115: --l_dup_scn_code_tbl ScnCodeList;
1116: l_dup_scn_id_tbl DupScnIdList;

Line 1122: FROM okc_sections_b

1118: l_del_stmt VARCHAR2(4000);
1119:
1120: CURSOR l_get_dup_sec_csr IS
1121: SELECT scn_code, Count(scn_code)
1122: FROM okc_sections_b
1123: WHERE document_type = p_document_type
1124: AND document_id = p_document_id
1125: GROUP BY scn_code
1126: HAVING (Count(scn_code) >1 );

Line 1130: FROM okc_sections_b

1126: HAVING (Count(scn_code) >1 );
1127:
1128: CURSOR l_get_dup_sec_ids_csr(p_scn_code VARCHAR2) IS
1129: SELECT id
1130: FROM okc_sections_b
1131: WHERE document_type = p_document_type
1132: AND document_id = p_document_id
1133: AND scn_code = p_scn_code
1134: ORDER BY id;

Line 1184: /*When all the articles are updated with the first section_id, delete the remaining sections from okc_sections_b table*/

1180: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Update done on okc_k_articles_b table ');
1182: END IF;
1183:
1184: /*When all the articles are updated with the first section_id, delete the remaining sections from okc_sections_b table*/
1185:
1186: l_del_stmt := 'DELETE FROM okc_sections_b WHERE id IN (' || l_remaining_scn_ids || ')';
1187: EXECUTE IMMEDIATE l_del_stmt;
1188:

Line 1186: l_del_stmt := 'DELETE FROM okc_sections_b WHERE id IN (' || l_remaining_scn_ids || ')';

1182: END IF;
1183:
1184: /*When all the articles are updated with the first section_id, delete the remaining sections from okc_sections_b table*/
1185:
1186: l_del_stmt := 'DELETE FROM okc_sections_b WHERE id IN (' || l_remaining_scn_ids || ')';
1187: EXECUTE IMMEDIATE l_del_stmt;
1188:
1189: END IF;
1190:

Line 1192: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Delete done on okc_sections_b table ');

1188:
1189: END IF;
1190:
1191: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Delete done on okc_sections_b table ');
1193: END IF;
1194: END LOOP; -- FOR rec IN l_get_dup_sec_csr LOOP
1195:
1196: x_return_status := 'S';