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_REVIEW_UPLD_TERMS_PVT dependencies on OKC_SECTIONS_B

Line 2028: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;

2024: l_scn_id NUMBER;
2025: l_user_access VARCHAR2(30);
2026: l_parent_id NUMBER;
2027: l_doc_num_scheme NUMBER;
2028: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
2029: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
2030: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2031: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
2032: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

Line 2032: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

2028: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
2029: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
2030: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2031: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
2032: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
2033: -- 2 way word sync with clause edit
2034: l_prof_value VARCHAR2(1);
2035: l_wml_i NUMBER;
2036:

Line 2517: UPDATE okc_sections_b scn

2513: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2514: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2515: END IF;
2516:
2517: UPDATE okc_sections_b scn
2518: SET scn.last_updated_by = fnd_global.user_id,
2519: scn.last_update_date = sysdate,
2520: scn.amendment_operation_code = 'DELETED',
2521: scn.summary_amend_operation_code =

Line 2535: DELETE FROM okc_sections_b

2531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2533: END IF;
2534:
2535: DELETE FROM okc_sections_b
2536: WHERE id = obj_ids(i);
2537: END IF; --IF p_mode = 'AMEND' THEN
2538:
2539: ELSIF obj_types(i) = 'ARTICLE' THEN

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

2594: END LOOP;
2595: END IF; --IF rut_ids.COUNT > 0 THEN
2596:
2597: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2599: END IF;
2600:
2601: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2602: UPDATE okc_sections_b

Line 2602: UPDATE okc_sections_b

2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2599: END IF;
2600:
2601: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2602: UPDATE okc_sections_b
2603: SET scn_id = pobj_ids(i),
2604: section_sequence = disp_seqs(i)
2605: WHERE id = obj_ids(i)
2606: AND obj_types(i) = 'SECTION';

Line 2941: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE;

2937: l_api_name CONSTANT VARCHAR2(30) := 'Sync_Review_Tables';
2938: l_api_version CONSTANT NUMBER := 1;
2939: l_doc_exists VARCHAR2(1);
2940: l_rev_id_for_doc OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2941: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE;
2942: l_clauses_no_parent_exist VARCHAR2(1);
2943: l_clause_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2944: l_section_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2945: l_clause_counter NUMBER;

Line 3472: FROM OKC_SECTIONS_B S

3468: AND NVL(A1.AMENDMENT_OPERATION_CODE,'ZZZ') = 'DELETED') )
3469: ) OR
3470: (OBJECT_TYPE = 'SECTION'
3471: AND (NOT EXISTS (SELECT 1
3472: FROM OKC_SECTIONS_B S
3473: WHERE S.ID = UT.OBJECT_ID
3474: AND S.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3475: AND S.DOCUMENT_ID = UT.DOCUMENT_ID )
3476: OR

Line 3478: FROM OKC_SECTIONS_B S1

3474: AND S.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3475: AND S.DOCUMENT_ID = UT.DOCUMENT_ID )
3476: OR
3477: EXISTS (SELECT 1
3478: FROM OKC_SECTIONS_B S1
3479: WHERE S1.ID = UT.OBJECT_ID
3480: AND S1.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3481: AND S1.DOCUMENT_ID = UT.DOCUMENT_ID
3482: AND NVL(S1.AMENDMENT_OPERATION_CODE,'ZZZ') = 'DELETED' ))

Line 3612: FROM OKC_SECTIONS_B SCN

3608: FND_GLOBAL.USER_ID,
3609: SYSDATE,
3610: FND_GLOBAL.USER_ID,
3611: SYSDATE
3612: FROM OKC_SECTIONS_B SCN
3613: WHERE SCN.DOCUMENT_ID = P_DOCUMENT_ID
3614: AND SCN.DOCUMENT_TYPE = P_DOCUMENT_TYPE
3615: AND NOT EXISTS (SELECT 1
3616: FROM OKC_REVIEW_UPLD_TERMS UT

Line 3731: DISPLAY_SEQ = (SELECT SECTION_SEQUENCE FROM OKC_SECTIONS_B SCN

3727: -- 2 way word sync with clause edit ends
3728:
3729: UPDATE OKC_REVIEW_UPLD_TERMS UT
3730: SET ACTION='UPDATED',
3731: DISPLAY_SEQ = (SELECT SECTION_SEQUENCE FROM OKC_SECTIONS_B SCN
3732: WHERE SCN.ID = UT.OBJECT_ID
3733: AND to_char(UT.OBJECT_TITLE) <> SCN.HEADING)
3734: WHERE ACTION IS NULL
3735: AND DOCUMENT_ID = P_DOCUMENT_ID

Line 3739: FROM OKC_SECTIONS_B SCN

3735: AND DOCUMENT_ID = P_DOCUMENT_ID
3736: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3737: AND OBJECT_TYPE = 'SECTION'
3738: AND EXISTS (SELECT 1
3739: FROM OKC_SECTIONS_B SCN
3740: WHERE SCN.ID = UT.OBJECT_ID
3741: AND SCN.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3742: AND SCN.DOCUMENT_ID = UT.DOCUMENT_ID
3743:

Line 4308: -- Call Simple API of okc_sections_b with following input

4304: -- Initialize API return status to success
4305: x_return_status := G_RET_STS_SUCCESS;
4306:
4307: --------------------------------------------
4308: -- Call Simple API of okc_sections_b with following input
4309: -- doc_type=p_doc_type, doc_id=p_doc_id, scn_code=G_UNASSIGNED_SECTION_CODE,
4310: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
4311: -- Set x_scn_id to id returned by simpel API.
4312: --------------------------------------------