APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_SECTIONS_B

Line 1992: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;

1988: l_scn_id NUMBER;
1989: l_user_access VARCHAR2(30);
1990: l_parent_id NUMBER;
1991: l_doc_num_scheme NUMBER;
1992: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
1993: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1994: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1995: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1996: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

Line 1996: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

1992: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
1993: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1994: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1995: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1996: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
1997:
1998:
1999: BEGIN
2000:

Line 2415: UPDATE okc_sections_b scn

2411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2413: END IF;
2414:
2415: UPDATE okc_sections_b scn
2416: SET scn.last_updated_by = fnd_global.user_id,
2417: scn.last_update_date = sysdate,
2418: scn.amendment_operation_code = 'DELETED',
2419: scn.summary_amend_operation_code =

Line 2433: DELETE FROM okc_sections_b

2429: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2430: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2431: END IF;
2432:
2433: DELETE FROM okc_sections_b
2434: WHERE id = obj_ids(i);
2435: END IF; --IF p_mode = 'AMEND' THEN
2436:
2437: ELSIF obj_types(i) = 'ARTICLE' THEN

Line 2496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');

2492: END LOOP;
2493: END IF; --IF rut_ids.COUNT > 0 THEN
2494:
2495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2497: END IF;
2498:
2499: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2500: UPDATE okc_sections_b

Line 2500: UPDATE okc_sections_b

2496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2497: END IF;
2498:
2499: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2500: UPDATE okc_sections_b
2501: SET scn_id = pobj_ids(i),
2502: section_sequence = disp_seqs(i)
2503: WHERE id = obj_ids(i)
2504: AND obj_types(i) = 'SECTION';

Line 2832: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE;

2828: l_api_name CONSTANT VARCHAR2(30) := 'Sync_Review_Tables';
2829: l_api_version CONSTANT NUMBER := 1;
2830: l_doc_exists VARCHAR2(1);
2831: l_rev_id_for_doc OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2832: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE;
2833: l_clauses_no_parent_exist VARCHAR2(1);
2834: l_clause_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2835: l_section_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2836: l_clause_counter NUMBER;

Line 3361: FROM OKC_SECTIONS_B S

3357: AND NVL(A1.AMENDMENT_OPERATION_CODE,'ZZZ') = 'DELETED') )
3358: ) OR
3359: (OBJECT_TYPE = 'SECTION'
3360: AND (NOT EXISTS (SELECT 1
3361: FROM OKC_SECTIONS_B S
3362: WHERE S.ID = UT.OBJECT_ID
3363: AND S.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3364: AND S.DOCUMENT_ID = UT.DOCUMENT_ID )
3365: OR

Line 3367: FROM OKC_SECTIONS_B S1

3363: AND S.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3364: AND S.DOCUMENT_ID = UT.DOCUMENT_ID )
3365: OR
3366: EXISTS (SELECT 1
3367: FROM OKC_SECTIONS_B S1
3368: WHERE S1.ID = UT.OBJECT_ID
3369: AND S1.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3370: AND S1.DOCUMENT_ID = UT.DOCUMENT_ID
3371: AND NVL(S1.AMENDMENT_OPERATION_CODE,'ZZZ') = 'DELETED' ))

Line 3500: FROM OKC_SECTIONS_B SCN

3496: FND_GLOBAL.USER_ID,
3497: SYSDATE,
3498: FND_GLOBAL.USER_ID,
3499: SYSDATE
3500: FROM OKC_SECTIONS_B SCN
3501: WHERE SCN.DOCUMENT_ID = P_DOCUMENT_ID
3502: AND SCN.DOCUMENT_TYPE = P_DOCUMENT_TYPE
3503: AND NOT EXISTS (SELECT 1
3504: FROM OKC_REVIEW_UPLD_TERMS UT

Line 3578: DISPLAY_SEQ = (SELECT SECTION_SEQUENCE FROM OKC_SECTIONS_B SCN

3574: |