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_TEMPLATES_PVT dependencies on OKC_TERMS_TEMPLATES_ALL_S

Line 59: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL FROM DUAL;

55: x_template_id OUT NOCOPY NUMBER
56: ) RETURN VARCHAR2 IS
57: l_api_name CONSTANT VARCHAR2(30) := 'Get_Seq_Id';
58: CURSOR l_seq_csr IS
59: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL FROM DUAL;
60: BEGIN
61: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
62: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered get_seq_id');
63: END IF;

Line 795: l_tmpl_status okc_terms_templates_all.status_code%TYPE := 'ZZZ';

791: l_apps_user VARCHAR2(150);
792: l_layout_start_date DATE;
793: l_layout_end_date DATE;
794: l_eff_date DATE;
795: l_tmpl_status okc_terms_templates_all.status_code%TYPE := 'ZZZ';
796: l_validate_layout VARCHAR2(1) := 'Y';
797:
798: CURSOR l_apps_user_csr IS
799: SELECT oracle_username

Line 1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;

1479: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1480: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;

Line 1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;

1480: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;

Line 2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;

2500: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2501: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;

Line 2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;

2501: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;