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

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 121: -- FUNCTION get_rec for: OKC_SECTIONS_B

117:
118: END Get_Seq_Id;
119:
120: ---------------------------------------------------------------------------
121: -- FUNCTION get_rec for: OKC_SECTIONS_B
122: ---------------------------------------------------------------------------
123: FUNCTION Get_Rec (
124: p_id IN NUMBER,
125:

Line 167: CURSOR OKC_SECTIONS_B_pk_csr (cp_id IN NUMBER) IS

163: x_last_amended_by OUT NOCOPY NUMBER,
164: x_last_amendment_date OUT NOCOPY DATE
165:
166: ) RETURN VARCHAR2 IS
167: CURSOR OKC_SECTIONS_B_pk_csr (cp_id IN NUMBER) IS
168: SELECT
169: SECTION_SEQUENCE,
170: LABEL,
171: SCN_ID,

Line 208: FROM OKC_SECTIONS_B t

204: LAST_UPDATE_LOGIN,
205: LAST_UPDATE_DATE,
206: LAST_AMENDED_BY,
207: LAST_AMENDMENT_DATE
208: FROM OKC_SECTIONS_B t
209: WHERE t.ID = cp_id;
210: BEGIN
211:
212: /*IF (l_debug = 'Y') THEN

Line 222: OPEN OKC_SECTIONS_B_pk_csr (p_id);

218: G_PKG_NAME, '400: Entered get_rec' );
219: END IF;
220:
221: -- Get current database values
222: OPEN OKC_SECTIONS_B_pk_csr (p_id);
223: FETCH OKC_SECTIONS_B_pk_csr INTO
224: x_section_sequence,
225: x_label,
226: x_scn_id,

Line 223: FETCH OKC_SECTIONS_B_pk_csr INTO

219: END IF;
220:
221: -- Get current database values
222: OPEN OKC_SECTIONS_B_pk_csr (p_id);
223: FETCH OKC_SECTIONS_B_pk_csr INTO
224: x_section_sequence,
225: x_label,
226: x_scn_id,
227: x_heading,

Line 263: IF OKC_SECTIONS_B_pk_csr%NOTFOUND THEN

259: x_last_update_login,
260: x_last_update_date,
261: x_last_amended_by,
262: x_last_amendment_date;
263: IF OKC_SECTIONS_B_pk_csr%NOTFOUND THEN
264: RAISE NO_DATA_FOUND;
265: END IF;
266: CLOSE OKC_SECTIONS_B_pk_csr;
267:

Line 266: CLOSE OKC_SECTIONS_B_pk_csr;

262: x_last_amendment_date;
263: IF OKC_SECTIONS_B_pk_csr%NOTFOUND THEN
264: RAISE NO_DATA_FOUND;
265: END IF;
266: CLOSE OKC_SECTIONS_B_pk_csr;
267:
268: /*IF (l_debug = 'Y') THEN
269: Okc_Debug.Log('500: Leaving get_rec ', 2);
270: END IF;*/

Line 298: IF OKC_SECTIONS_B_pk_csr%ISOPEN THEN

294: p_token1_value => sqlcode,
295: p_token2 => G_SQLERRM_TOKEN,
296: p_token2_value => sqlerrm);
297:
298: IF OKC_SECTIONS_B_pk_csr%ISOPEN THEN
299: CLOSE OKC_SECTIONS_B_pk_csr;
300: END IF;
301:
302: RETURN G_RET_STS_UNEXP_ERROR ;

Line 299: CLOSE OKC_SECTIONS_B_pk_csr;

295: p_token2 => G_SQLERRM_TOKEN,
296: p_token2_value => sqlerrm);
297:
298: IF OKC_SECTIONS_B_pk_csr%ISOPEN THEN
299: CLOSE OKC_SECTIONS_B_pk_csr;
300: END IF;
301:
302: RETURN G_RET_STS_UNEXP_ERROR ;
303:

Line 307: -- Set_Attributes for:OKC_SECTIONS_B --

303:
304: END Get_Rec;
305:
306: -----------------------------------------
307: -- Set_Attributes for:OKC_SECTIONS_B --
308: -----------------------------------------
309: FUNCTION Set_Attributes(
310: p_id IN NUMBER,
311: p_section_sequence IN NUMBER,

Line 381: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;

377: x_last_amended_by OUT NOCOPY NUMBER,
378: x_last_amendment_date OUT NOCOPY DATE
379: ) RETURN VARCHAR2 IS
380: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
381: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
382: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
383: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
384: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
385: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;

Line 382: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;

378: x_last_amendment_date OUT NOCOPY DATE
379: ) RETURN VARCHAR2 IS
380: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
381: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
382: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
383: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
384: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
385: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
386: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;

Line 383: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;

379: ) RETURN VARCHAR2 IS
380: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
381: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
382: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
383: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
384: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
385: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
386: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
387: BEGIN

Line 384: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;

380: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
381: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
382: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
383: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
384: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
385: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
386: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
387: BEGIN
388: /*IF (l_debug = 'Y') THEN

Line 385: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;

381: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
382: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
383: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
384: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
385: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
386: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
387: BEGIN
388: /*IF (l_debug = 'Y') THEN
389: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 386: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;

382: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
383: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
384: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
385: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
386: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
387: BEGIN
388: /*IF (l_debug = 'Y') THEN
389: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
390: END IF;*/

Line 706: -- Validate_Attributes for: OKC_SECTIONS_B --

702:
703: END Set_Attributes ;
704:
705: ----------------------------------------------
706: -- Validate_Attributes for: OKC_SECTIONS_B --
707: ----------------------------------------------
708: FUNCTION Validate_Attributes (
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710:

Line 749: FROM OKC_SECTIONS_B

745: l_dummy_var VARCHAR2(1) := '?';
746:
747: CURSOR l_scn_id_csr is
748: SELECT '!'
749: FROM OKC_SECTIONS_B
750: WHERE ID = p_scn_id;
751:
752: CURSOR l_doc_type_csr is
753: SELECT '!'

Line 1062: -- Validate_Record for:OKC_SECTIONS_B --

1058: -- PROCEDURE Validate_Record
1059: -- It calls Item Level Validations and then makes Record Level Validations
1060: ---------------------------------------------------------------------------
1061: ------------------------------------------
1062: -- Validate_Record for:OKC_SECTIONS_B --
1063: ------------------------------------------
1064: FUNCTION Validate_Record (
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: p_id IN NUMBER,

Line 1210: -- validate_row for:OKC_SECTIONS_B --

1206: ---------------------------------------------------------------------------
1207: -- PROCEDURE validate_row
1208: ---------------------------------------------------------------------------
1209: ---------------------------------------
1210: -- validate_row for:OKC_SECTIONS_B --
1211: ---------------------------------------
1212: PROCEDURE validate_row(
1213: p_validation_level IN NUMBER,
1214: x_return_status OUT NOCOPY VARCHAR2,

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 1250: l_label OKC_SECTIONS_B.LABEL%TYPE;

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;
1254: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%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 1252: l_heading OKC_SECTIONS_B.HEADING%TYPE;

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;
1256: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

Line 1253: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;

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;
1256: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
1257: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;

Line 1254: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%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;
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;

Line 1255: l_document_id OKC_SECTIONS_B.DOCUMENT_ID%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;
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;

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 1257: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%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;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 1258: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%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;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;

Line 1259: l_orig_system_reference_code OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_CODE%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;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;

Line 1260: l_orig_system_reference_id1 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%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;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;

Line 1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%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;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;

Line 1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%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;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;

Line 1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%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;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;

Line 1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;

1260: l_orig_system_reference_id1 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;

Line 1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;

1261: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;

Line 1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;

1262: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;

Line 1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;

1263: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;

Line 1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;

1264: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;

Line 1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;

1265: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;

Line 1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;

1266: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;

Line 1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;

1267: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;
1275: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;

Line 1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;

1268: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;
1275: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;
1276: l_attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE;

Line 1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;

1269: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;

1270: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 1275: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;

1271: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 1276: l_attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE;

1272: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 1277: l_attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE;

1273: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 1278: l_attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE;

1274: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

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 1280: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%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;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;

Line 1281: l_created_by OKC_SECTIONS_B.CREATED_BY%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;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;

Line 1282: l_creation_date OKC_SECTIONS_B.CREATION_DATE%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;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1286: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;

Line 1283: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%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;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1286: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1287: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;

Line 1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%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;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1286: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1287: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1288: BEGIN

Line 1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%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;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1286: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1287: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1288: BEGIN
1289:

Line 1286: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;

1282: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1283: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1286: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1287: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1288: BEGIN
1289:
1290: /*IF (l_debug = 'Y') THEN

Line 1287: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;

1283: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1284: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1285: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1286: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1287: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1288: BEGIN
1289:
1290: /*IF (l_debug = 'Y') THEN
1291: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 1469: -- Insert_Row for:OKC_SECTIONS_B --

1465: ---------------------------------------------------------------------------
1466: -- PROCEDURE Insert_Row
1467: ---------------------------------------------------------------------------
1468: -------------------------------------
1469: -- Insert_Row for:OKC_SECTIONS_B --
1470: -------------------------------------
1471: FUNCTION Insert_Row(
1472: p_id IN NUMBER,
1473: p_section_sequence IN NUMBER,

Line 1531: INSERT INTO OKC_SECTIONS_B(

1527: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
1528: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
1529: END IF;
1530:
1531: INSERT INTO OKC_SECTIONS_B(
1532: ID,
1533: SECTION_SEQUENCE,
1534: SCN_TYPE,
1535: CHR_ID,

Line 1655: -- Insert_Row for:OKC_SECTIONS_B --

1651: END Insert_Row;
1652:
1653:
1654: -------------------------------------
1655: -- Insert_Row for:OKC_SECTIONS_B --
1656: -------------------------------------
1657: PROCEDURE Insert_Row(
1658: p_validation_level IN NUMBER,
1659: x_return_status OUT NOCOPY VARCHAR2,

Line 1696: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;

1692: x_id OUT NOCOPY NUMBER
1693:
1694: ) IS
1695:
1696: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1697: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;

Line 1697: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;

1693:
1694: ) IS
1695:
1696: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1697: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;

Line 1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;

1694: ) IS
1695:
1696: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1697: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1702: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;

Line 1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;

1695:
1696: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1697: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1702: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1703: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;

Line 1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;

1696: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1697: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1702: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1703: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1704: BEGIN

Line 1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;

1697: l_created_by OKC_SECTIONS_B.CREATED_BY%TYPE;
1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1702: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1703: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1704: BEGIN
1705:

Line 1702: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;

1698: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1702: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1703: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1704: BEGIN
1705:
1706: x_return_status := G_RET_STS_SUCCESS;

Line 1703: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;

1699: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
1700: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
1701: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
1702: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
1703: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
1704: BEGIN
1705:
1706: x_return_status := G_RET_STS_SUCCESS;
1707:

Line 1905: -- Lock_Row for:OKC_SECTIONS_B --

1901: ---------------------------------------------------------------------------
1902: -- PROCEDURE Lock_Row
1903: ---------------------------------------------------------------------------
1904: -----------------------------------
1905: -- Lock_Row for:OKC_SECTIONS_B --
1906: -----------------------------------
1907: FUNCTION Lock_Row(
1908: p_id IN NUMBER,
1909: p_object_version_number IN NUMBER

Line 1915: FROM OKC_SECTIONS_B

1911:
1912:
1913: CURSOR lock_csr (cp_id NUMBER, cp_object_version_number NUMBER) IS
1914: SELECT object_version_number
1915: FROM OKC_SECTIONS_B
1916: WHERE ID = cp_id
1917: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1918: FOR UPDATE OF object_version_number NOWAIT;
1919:

Line 1922: FROM OKC_SECTIONS_B

1918: FOR UPDATE OF object_version_number NOWAIT;
1919:
1920: CURSOR lchk_csr (cp_id NUMBER) IS
1921: SELECT object_version_number
1922: FROM OKC_SECTIONS_B
1923: WHERE ID = cp_id;
1924:
1925: l_return_status VARCHAR2(1);
1926:

Line 1927: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;

1923: WHERE ID = cp_id;
1924:
1925: l_return_status VARCHAR2(1);
1926:
1927: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1928:
1929: l_row_notfound BOOLEAN := FALSE;
1930: BEGIN
1931:

Line 1977: 'ENTITYNAME','OKC_SECTIONS_B',

1973: CLOSE lchk_csr;
1974:
1975: IF (l_row_notfound) THEN
1976: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
1977: 'ENTITYNAME','OKC_SECTIONS_B',
1978: 'PKEY',p_id,
1979: 'OVN',p_object_version_number
1980: );
1981: ELSIF l_object_version_number > p_object_version_number THEN

Line 2033: -- Lock_Row for:OKC_SECTIONS_B --

2029: RETURN( G_RET_STS_UNEXP_ERROR );
2030: END Lock_Row;
2031:
2032: -----------------------------------
2033: -- Lock_Row for:OKC_SECTIONS_B --
2034: -----------------------------------
2035: PROCEDURE Lock_Row(
2036: x_return_status OUT NOCOPY VARCHAR2,
2037: p_id IN NUMBER,

Line 2121: -- Update_Row for:OKC_SECTIONS_B --

2117: ---------------------------------------------------------------------------
2118: -- PROCEDURE Update_Row
2119: ---------------------------------------------------------------------------
2120: -------------------------------------
2121: -- Update_Row for:OKC_SECTIONS_B --
2122: -------------------------------------
2123: FUNCTION Update_Row(
2124: p_id IN NUMBER,
2125: p_section_sequence IN NUMBER,

Line 2182: UPDATE OKC_SECTIONS_B

2178: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
2179: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
2180: END IF;
2181:
2182: UPDATE OKC_SECTIONS_B
2183: SET SECTION_SEQUENCE = p_section_sequence,
2184: LABEL = p_label,
2185: SCN_ID = p_scn_id,
2186: HEADING = p_heading,

Line 2258: -- Update_Row for:OKC_SECTIONS_B --

2254:
2255: END Update_Row;
2256:
2257: -------------------------------------
2258: -- Update_Row for:OKC_SECTIONS_B --
2259: -------------------------------------
2260: PROCEDURE Update_Row(
2261: p_validation_level IN NUMBER,
2262: x_return_status OUT NOCOPY VARCHAR2,

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 2302: l_label OKC_SECTIONS_B.LABEL%TYPE;

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;
2306: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%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 2304: l_heading OKC_SECTIONS_B.HEADING%TYPE;

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;
2308: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;

Line 2305: l_description OKC_SECTIONS_B.DESCRIPTION%TYPE;

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;
2308: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
2309: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;

Line 2306: l_document_type OKC_SECTIONS_B.DOCUMENT_TYPE%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;
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;

Line 2307: l_document_id OKC_SECTIONS_B.DOCUMENT_ID%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;
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;

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 2309: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%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;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;

Line 2310: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%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;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;

Line 2311: l_orig_system_reference_code OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_CODE%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;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;

Line 2312: l_orig_system_reference_id1 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%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;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;

Line 2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%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;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;

Line 2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%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;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;

Line 2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%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;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;

Line 2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;

2312: l_orig_system_reference_id1 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;

Line 2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;

2313: l_orig_system_reference_id2 OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;

Line 2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;

2314: l_print_yn OKC_SECTIONS_B.PRINT_YN%TYPE;
2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;

Line 2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;

2315: l_attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE;
2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;

Line 2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;

2316: l_attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE;
2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;

Line 2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;

2317: l_attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE;
2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;

Line 2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;

2318: l_attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE;
2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;

Line 2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;

2319: l_attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE;
2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;
2327: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;

Line 2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;

2320: l_attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE;
2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;
2327: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;
2328: l_attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE;

Line 2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;

2321: l_attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE;
2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE;

2322: l_attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE;
2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 2327: l_attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE;

2323: l_attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE;
2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 2328: l_attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE;

2324: l_attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE;
2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 2329: l_attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE;

2325: l_attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE;
2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

Line 2330: l_attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE;

2326: l_attribute11 OKC_SECTIONS_B.ATTRIBUTE11%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;

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;

Line 2332: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%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;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;

Line 2333: l_created_by OKC_SECTIONS_B.CREATED_BY%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;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;

Line 2334: l_creation_date OKC_SECTIONS_B.CREATION_DATE%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;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
2338: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;

Line 2335: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%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;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
2338: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
2339: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;

Line 2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%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;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
2338: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
2339: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
2340:

Line 2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%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;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
2338: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
2339: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
2340:
2341: BEGIN

Line 2338: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;

2334: l_creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE;
2335: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
2338: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
2339: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
2340:
2341: BEGIN
2342:

Line 2339: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;

2335: l_last_updated_by OKC_SECTIONS_B.LAST_UPDATED_BY%TYPE;
2336: l_last_update_login OKC_SECTIONS_B.LAST_UPDATE_LOGIN%TYPE;
2337: l_last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE;
2338: l_last_amended_by OKC_SECTIONS_B.LAST_AMENDED_BY%TYPE;
2339: l_last_amendment_date OKC_SECTIONS_B.LAST_AMENDMENT_DATE%TYPE;
2340:
2341: BEGIN
2342:
2343: /*IF (l_debug = 'Y') THEN

Line 2639: -- Delete_Row for:OKC_SECTIONS_B --

2635: ---------------------------------------------------------------------------
2636: -- PROCEDURE Delete_Row
2637: ---------------------------------------------------------------------------
2638: -------------------------------------
2639: -- Delete_Row for:OKC_SECTIONS_B --
2640: -------------------------------------
2641: FUNCTION Delete_Row(
2642: p_id IN NUMBER
2643: ) RETURN VARCHAR2 IS

Line 2656: DELETE FROM OKC_SECTIONS_B WHERE ID = p_ID;

2652: FND_LOG.STRING(G_PROC_LEVEL,
2653: G_PKG_NAME, '8200: Entered Delete_Row');
2654: END IF;
2655:
2656: DELETE FROM OKC_SECTIONS_B WHERE ID = p_ID;
2657:
2658: /*IF (l_debug = 'Y') THEN
2659: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
2660: END IF;*/

Line 2693: -- Delete_Row for:OKC_SECTIONS_B --

2689:
2690: END Delete_Row;
2691:
2692: -------------------------------------
2693: -- Delete_Row for:OKC_SECTIONS_B --
2694: -------------------------------------
2695: PROCEDURE Delete_Row(
2696: x_return_status OUT NOCOPY VARCHAR2,
2697: p_id IN NUMBER,

Line 2797: SELECT rowid FROM OKC_SECTIONS_B

2793: p_doc_type IN VARCHAR2,
2794: p_doc_id IN NUMBER
2795: ) IS
2796: CURSOR lock_csr IS
2797: SELECT rowid FROM OKC_SECTIONS_B
2798: WHERE document_type = p_doc_type and
2799: document_id = p_doc_id
2800: FOR UPDATE NOWAIT;
2801: BEGIN

Line 2815: DELETE FROM OKC_SECTIONS_B

2811: -- making OPEN/CLOSE cursor to lock records
2812: OPEN lock_csr;
2813: CLOSE lock_csr;
2814:
2815: DELETE FROM OKC_SECTIONS_B
2816: WHERE document_type = p_doc_type and
2817: document_id = p_doc_id ;
2818:
2819: /*IF (l_debug = 'Y') THEN

Line 2922: INSERT INTO OKC_SECTIONS_BH (

2918:
2919: -----------------------------------------
2920: -- Saving Base Table
2921: -----------------------------------------
2922: INSERT INTO OKC_SECTIONS_BH (
2923: major_version,
2924: ID,
2925: SECTION_SEQUENCE,
2926: SCN_TYPE,

Line 3012: FROM OKC_SECTIONS_B

3008: LAST_UPDATE_LOGIN,
3009: LAST_UPDATE_DATE,
3010: LAST_AMENDED_BY,
3011: LAST_AMENDMENT_DATE
3012: FROM OKC_SECTIONS_B
3013: WHERE document_type = p_doc_type
3014: AND document_id = p_doc_id;
3015:
3016: /*IF (l_debug = 'Y') THEN

Line 3075: INSERT INTO OKC_SECTIONS_B (

3071:
3072: -----------------------------------------
3073: -- Restoring Base Table
3074: -----------------------------------------
3075: INSERT INTO OKC_SECTIONS_B (
3076: ID,
3077: SECTION_SEQUENCE,
3078: SCN_TYPE,
3079: CHR_ID,

Line 3163: FROM OKC_SECTIONS_BH

3159: LAST_UPDATE_LOGIN,
3160: LAST_UPDATE_DATE,
3161: LAST_AMENDED_BY,
3162: LAST_AMENDMENT_DATE
3163: FROM OKC_SECTIONS_BH
3164: WHERE document_type = p_doc_type and document_id = p_doc_id AND major_version = p_major_version;
3165:
3166: /*IF (l_debug = 'Y') THEN
3167: Okc_Debug.Log('10500: Leaving restore_version', 2);

Line 3224: FROM OKC_SECTIONS_BH

3220: -----------------------------------------
3221: -- Restoring Base Table
3222: -----------------------------------------
3223: DELETE
3224: FROM OKC_SECTIONS_BH
3225: WHERE document_type = p_doc_type and document_id = p_doc_id AND major_version = p_major_version;
3226:
3227: /*IF (l_debug = 'Y') THEN
3228: Okc_Debug.Log('7300: Leaving Delete_Version', 2);