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_SECTIONS_PVT dependencies on OKC_SECTIONS_B_S

Line 64: SELECT OKC_SECTIONS_B_S.NEXTVAL FROM DUAL;

60: p_id IN NUMBER,
61: x_id OUT NOCOPY NUMBER
62: ) RETURN VARCHAR2 IS
63: CURSOR l_seq_csr IS
64: SELECT OKC_SECTIONS_B_S.NEXTVAL FROM DUAL;
65: BEGIN
66: /*IF (l_debug = 'Y') THEN
67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;*/

Line 1249: l_section_sequence OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE;

1245: p_attribute15 IN VARCHAR2,
1246: p_summary_amend_operation_code IN VARCHAR2,
1247: p_object_version_number IN NUMBER
1248: ) IS
1249: l_section_sequence OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE;
1250: l_label OKC_SECTIONS_B.LABEL%TYPE;
1251: l_scn_id OKC_SECTIONS_B.SCN_ID%TYPE;
1252: l_heading OKC_SECTIONS_B.HEADING%TYPE;
1253: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;

Line 1251: l_scn_id OKC_SECTIONS_B.SCN_ID%TYPE;

1247: p_object_version_number IN NUMBER
1248: ) IS
1249: l_section_sequence OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE;
1250: l_label OKC_SECTIONS_B.LABEL%TYPE;
1251: l_scn_id OKC_SECTIONS_B.SCN_ID%TYPE;
1252: l_heading OKC_SECTIONS_B.HEADING%TYPE;
1253: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;
1254: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%TYPE;
1255: l_document_id OKC_SECTIONS_B.DOCUMENT_ID%TYPE;

Line 1256: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

1252: l_heading OKC_SECTIONS_B.HEADING%TYPE;
1253: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;
1254: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%TYPE;
1255: l_document_id OKC_SECTIONS_B.DOCUMENT_ID%TYPE;
1256: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
1257: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
1258: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;
1259: l_orig_system_reference_code OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1260: l_orig_system_reference_id1 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 1279: l_summary_amend_operation_code OKC_SECTIONS_B.summary_amend_operation_code%TYPE;

1275: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;
1276: l_attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE;
1277: l_attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE;
1278: l_attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE;
1279: l_summary_amend_operation_code OKC_SECTIONS_B.summary_amend_operation_code%TYPE;
1280: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1281: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
1282: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1283: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;

Line 2301: l_section_sequence OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE;

2297: p_object_version_number IN NUMBER
2298:
2299: ) IS
2300:
2301: l_section_sequence OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE;
2302: l_label OKC_SECTIONS_B.LABEL%TYPE;
2303: l_scn_id OKC_SECTIONS_B.SCN_ID%TYPE;
2304: l_heading OKC_SECTIONS_B.HEADING%TYPE;
2305: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;

Line 2303: l_scn_id OKC_SECTIONS_B.SCN_ID%TYPE;

2299: ) IS
2300:
2301: l_section_sequence OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE;
2302: l_label OKC_SECTIONS_B.LABEL%TYPE;
2303: l_scn_id OKC_SECTIONS_B.SCN_ID%TYPE;
2304: l_heading OKC_SECTIONS_B.HEADING%TYPE;
2305: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;
2306: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%TYPE;
2307: l_document_id OKC_SECTIONS_B.DOCUMENT_ID%TYPE;

Line 2308: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

2304: l_heading OKC_SECTIONS_B.HEADING%TYPE;
2305: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;
2306: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%TYPE;
2307: l_document_id OKC_SECTIONS_B.DOCUMENT_ID%TYPE;
2308: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
2309: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
2310: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;
2311: l_orig_system_reference_code OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2312: l_orig_system_reference_id1 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;

Line 2331: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

2327: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;
2328: l_attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE;
2329: l_attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE;
2330: l_attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE;
2331: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
2332: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
2333: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
2334: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;