APPS.OKC_NUMBER_SCHEME_GRP dependencies on OKC_REVIEW_UPLD_TERMS

Line 1374: from okc_review_upld_terms

1370: SELECT review_upld_terms_id,
1371: object_type TYPE,
1372: display_seq,
1373: object_id
1374: from okc_review_upld_terms
1375: where new_parent_id=p_review_upld_terms_id
1376: and document_type=p_doc_type
1377: and document_id = p_doc_id
1378: and (object_type = 'SECTION'

Line 1383: SELECT review_upld_terms_id,'ARTICLE' TYPE,display_seq, object_id from okc_review_upld_terms

1379: OR (object_type = 'ARTICLE'
1380: and l_number_article_yn = 'Y'))
1381: /***********
1382: UNION
1383: SELECT review_upld_terms_id,'ARTICLE' TYPE,display_seq, object_id from okc_review_upld_terms
1384: where new_parent_id=p_review_upld_terms_id
1385: and document_type=p_doc_type
1386: and document_id = p_doc_id
1387: and object_type = 'ARTICLE'

Line 1523: from okc_review_upld_terms

1519: l_api_name VARCHAR2(30) := 'apply_num_scheme_4_Review';
1520:
1521: cursor l_get_child_csr IS
1522: SELECT review_upld_terms_id,display_seq, object_id
1523: from okc_review_upld_terms
1524: where document_type = p_doc_type
1525: AND document_id = p_doc_id
1526: AND object_type = 'SECTION'
1527: --and (action <> 'DELETED' OR action is null)

Line 1529: from okc_review_upld_terms rt

1525: AND document_id = p_doc_id
1526: AND object_type = 'SECTION'
1527: --and (action <> 'DELETED' OR action is null)
1528: AND new_parent_id = (select review_upld_terms_id
1529: from okc_review_upld_terms rt
1530: where rt.document_type = p_doc_type
1531: and rt.document_id = p_doc_id
1532: and rt.object_type = p_doc_type
1533: and rt.object_id = p_doc_id)

Line 1548: FROM okc_review_upld_terms

1544:
1545:
1546: CURSOR l_get_art_csr IS
1547: SELECT review_upld_terms_id,object_version_number, object_id
1548: FROM okc_review_upld_terms
1549: WHERE document_type=p_doc_type
1550: AND document_id=p_doc_id
1551: AND object_type = 'ARTICLE'
1552: and action <> 'DELETED';

Line 1641: UPDATE okc_review_upld_terms

1637: FND_LOG.STRING(G_PROC_LEVEL,
1638: G_PKG_NAME, '110: Numbering Scheme Detail Count : '||l_dtl_count );
1639: END IF;
1640:
1641: UPDATE okc_review_upld_terms
1642: SET label = NULL
1643: WHERE document_type = p_doc_type
1644: AND document_id = p_doc_id ;
1645:

Line 1783: G_PKG_NAME, '170: Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row');

1779: For k in l_review_tbl.FIRST..l_review_tbl.LAST LOOP
1780:
1781: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1782: FND_LOG.STRING(G_PROC_LEVEL,
1783: G_PKG_NAME, '170: Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row');
1784: FND_LOG.STRING(G_PROC_LEVEL,
1785: G_PKG_NAME, '170: l_review_tbl(k).id : '||l_review_tbl(k).review_upld_terms_id);
1786: FND_LOG.STRING(G_PROC_LEVEL,
1787: G_PKG_NAME, '170: l_review_tbl(k).label : '||l_review_tbl(k).label);

Line 1790: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

1786: FND_LOG.STRING(G_PROC_LEVEL,
1787: G_PKG_NAME, '170: l_review_tbl(k).label : '||l_review_tbl(k).label);
1788: END IF;
1789:
1790: OKC_REVIEW_UPLD_TERMS_PVT.update_row(
1791: x_return_status => x_return_status,
1792: p_review_upld_terms_id => l_review_tbl(k).review_upld_terms_id,
1793: p_label => l_review_tbl(k).label,
1794: p_object_version_number => NULL);

Line 1798: G_PKG_NAME, '170: After Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row x_return_status : '||x_return_status );

1794: p_object_version_number => NULL);
1795:
1796: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1797: FND_LOG.STRING(G_PROC_LEVEL,
1798: G_PKG_NAME, '170: After Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row x_return_status : '||x_return_status );
1799: END IF;
1800:
1801: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;