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_SCC_PVT dependencies on OKC_SECTION_CONTENTS

Line 360: FROM okc_section_contents

356: -- for case K2 should not overwrite already existing K1
357: -- ------------------------------------------------------
358: CURSOR cur_vcs IS
359: SELECT 'x'
360: FROM okc_section_contents
361: WHERE scn_id = p_sccv_rec.SCN_ID
362: AND content_sequence = p_sccv_rec.CONTENT_SEQUENCE
363: AND id <> NVL(p_sccv_rec.ID,-9999);
364:

Line 457: -- FUNCTION get_rec for: OKC_SECTION_CONTENTS

453:
454: END get_seq_id;
455:
456: ---------------------------------------------------------------------------
457: -- FUNCTION get_rec for: OKC_SECTION_CONTENTS
458: ---------------------------------------------------------------------------
459: FUNCTION get_rec (
460: p_scc_rec IN scc_rec_type,
461: x_no_data_found OUT NOCOPY BOOLEAN

Line 463: CURSOR okc_section_contents_pk_csr (p_id IN NUMBER) IS

459: FUNCTION get_rec (
460: p_scc_rec IN scc_rec_type,
461: x_no_data_found OUT NOCOPY BOOLEAN
462: ) RETURN scc_rec_type IS
463: CURSOR okc_section_contents_pk_csr (p_id IN NUMBER) IS
464: SELECT
465: ID,
466: SCN_ID,
467: CONTENT_SEQUENCE,

Line 494: FROM Okc_Section_Contents

490: ATTRIBUTE12,
491: ATTRIBUTE13,
492: ATTRIBUTE14,
493: ATTRIBUTE15
494: FROM Okc_Section_Contents
495: WHERE okc_section_contents.id = p_id;
496: l_okc_section_contents_pk okc_section_contents_pk_csr%ROWTYPE;
497: l_scc_rec scc_rec_type;
498: BEGIN

Line 495: WHERE okc_section_contents.id = p_id;

491: ATTRIBUTE13,
492: ATTRIBUTE14,
493: ATTRIBUTE15
494: FROM Okc_Section_Contents
495: WHERE okc_section_contents.id = p_id;
496: l_okc_section_contents_pk okc_section_contents_pk_csr%ROWTYPE;
497: l_scc_rec scc_rec_type;
498: BEGIN
499:

Line 496: l_okc_section_contents_pk okc_section_contents_pk_csr%ROWTYPE;

492: ATTRIBUTE14,
493: ATTRIBUTE15
494: FROM Okc_Section_Contents
495: WHERE okc_section_contents.id = p_id;
496: l_okc_section_contents_pk okc_section_contents_pk_csr%ROWTYPE;
497: l_scc_rec scc_rec_type;
498: BEGIN
499:
500: IF (l_debug = 'Y') THEN

Line 507: OPEN okc_section_contents_pk_csr (p_scc_rec.id);

503: END IF;
504:
505: x_no_data_found := TRUE;
506: -- Get current database values
507: OPEN okc_section_contents_pk_csr (p_scc_rec.id);
508: FETCH okc_section_contents_pk_csr INTO
509: l_scc_rec.ID,
510: l_scc_rec.SCN_ID,
511: l_scc_rec.CONTENT_SEQUENCE,

Line 508: FETCH okc_section_contents_pk_csr INTO

504:
505: x_no_data_found := TRUE;
506: -- Get current database values
507: OPEN okc_section_contents_pk_csr (p_scc_rec.id);
508: FETCH okc_section_contents_pk_csr INTO
509: l_scc_rec.ID,
510: l_scc_rec.SCN_ID,
511: l_scc_rec.CONTENT_SEQUENCE,
512: l_scc_rec.OBJECT_VERSION_NUMBER,

Line 538: x_no_data_found := okc_section_contents_pk_csr%NOTFOUND;

534: l_scc_rec.ATTRIBUTE12,
535: l_scc_rec.ATTRIBUTE13,
536: l_scc_rec.ATTRIBUTE14,
537: l_scc_rec.ATTRIBUTE15;
538: x_no_data_found := okc_section_contents_pk_csr%NOTFOUND;
539: CLOSE okc_section_contents_pk_csr;
540:
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('900: Leaving Fn Get_Rec ', 2);

Line 539: CLOSE okc_section_contents_pk_csr;

535: l_scc_rec.ATTRIBUTE13,
536: l_scc_rec.ATTRIBUTE14,
537: l_scc_rec.ATTRIBUTE15;
538: x_no_data_found := okc_section_contents_pk_csr%NOTFOUND;
539: CLOSE okc_section_contents_pk_csr;
540:
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
543: okc_debug.Reset_Indentation;

Line 560: -- FUNCTION get_rec for: OKC_SECTION_CONTENTS_V

556: RETURN(get_rec(p_scc_rec, l_row_notfound));
557:
558: END get_rec;
559: ---------------------------------------------------------------------------
560: -- FUNCTION get_rec for: OKC_SECTION_CONTENTS_V
561: ---------------------------------------------------------------------------
562: FUNCTION get_rec (
563: p_sccv_rec IN sccv_rec_type,
564: x_no_data_found OUT NOCOPY BOOLEAN

Line 599: FROM okc_section_contents_v

595: ATTRIBUTE12,
596: ATTRIBUTE13,
597: ATTRIBUTE14,
598: ATTRIBUTE15
599: FROM okc_section_contents_v
600: WHERE okc_section_contents_v.id = p_id;
601:
602: l_okc_sccv_pk okc_sccv_pk_csr%ROWTYPE;
603:

Line 600: WHERE okc_section_contents_v.id = p_id;

596: ATTRIBUTE13,
597: ATTRIBUTE14,
598: ATTRIBUTE15
599: FROM okc_section_contents_v
600: WHERE okc_section_contents_v.id = p_id;
601:
602: l_okc_sccv_pk okc_sccv_pk_csr%ROWTYPE;
603:
604: -- UPTO THIS (JOHN)

Line 676: -- FUNCTION null_out_defaults for: OKC_SECTION_CONTENTS_V --

672:
673: END get_rec;
674:
675: ------------------------------------------------------------
676: -- FUNCTION null_out_defaults for: OKC_SECTION_CONTENTS_V --
677: ------------------------------------------------------------
678: FUNCTION null_out_defaults (
679: p_sccv_rec IN sccv_rec_type
680: ) RETURN sccv_rec_type IS

Line 789: -- Validate_Attributes for:OKC_SECTION_CONTENTS_V --

785: ---------------------------------------------------------------------------
786: -- PROCEDURE Validate_Attributes
787: ---------------------------------------------------------------------------
788: ----------------------------------------------------
789: -- Validate_Attributes for:OKC_SECTION_CONTENTS_V --
790: ----------------------------------------------------
791: FUNCTION Validate_Attributes (
792: p_sccv_rec IN sccv_rec_type
793: ) RETURN VARCHAR2 IS

Line 895: -- Validate_Record for:OKC_SECTION_CONTENTS_V --

891: ---------------------------------------------------------------------------
892: -- PROCEDURE Validate_Record
893: ---------------------------------------------------------------------------
894: ------------------------------------------------
895: -- Validate_Record for:OKC_SECTION_CONTENTS_V --
896: ------------------------------------------------
897: FUNCTION Validate_Record (
898: p_sccv_rec IN sccv_rec_type
899: ) RETURN VARCHAR2 IS

Line 906: FROM okc_section_contents_v

902: l_counter NUMBER := 0;
903:
904: Cursor l_sccv_csr Is
905: SELECT count(*)
906: FROM okc_section_contents_v
907: WHERE cat_id = p_sccv_rec.CAT_ID
908: AND scn_id IN (SELECT id
909: FROM okc_sections_b
910: WHERE chr_id = (SELECT chr_id

Line 1026: -- validate_row for:OKC_SECTION_CONTENTS_V --

1022: ---------------------------------------------------------------------------
1023: -- PROCEDURE validate_row
1024: ---------------------------------------------------------------------------
1025: ---------------------------------------------
1026: -- validate_row for:OKC_SECTION_CONTENTS_V --
1027: ---------------------------------------------
1028: PROCEDURE validate_row(
1029: p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2,

Line 1232: -- insert_row for:OKC_SECTION_CONTENTS --

1228: ---------------------------------------------------------------------------
1229: -- PROCEDURE insert_row
1230: ---------------------------------------------------------------------------
1231: -----------------------------------------
1232: -- insert_row for:OKC_SECTION_CONTENTS --
1233: -----------------------------------------
1234: PROCEDURE insert_row(
1235: p_init_msg_list IN VARCHAR2,
1236: x_return_status OUT NOCOPY VARCHAR2,

Line 1248: -- Set_Attributes for:OKC_SECTION_CONTENTS --

1244: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1245: l_scc_rec scc_rec_type := p_scc_rec;
1246: l_def_scc_rec scc_rec_type;
1247: ---------------------------------------------
1248: -- Set_Attributes for:OKC_SECTION_CONTENTS --
1249: ---------------------------------------------
1250: FUNCTION Set_Attributes (
1251: p_scc_rec IN scc_rec_type,
1252: x_scc_rec OUT NOCOPY scc_rec_type

Line 1287: INSERT INTO OKC_SECTION_CONTENTS(

1283: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1284: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1285: RAISE OKC_API.G_EXCEPTION_ERROR;
1286: END IF;
1287: INSERT INTO OKC_SECTION_CONTENTS(
1288: id,
1289: scn_id,
1290: content_sequence,
1291: object_version_number,

Line 1408: -- insert_row for:OKC_SECTION_CONTENTS_V --

1404: );
1405:
1406: END insert_row;
1407: -------------------------------------------
1408: -- insert_row for:OKC_SECTION_CONTENTS_V --
1409: -------------------------------------------
1410: PROCEDURE insert_row(
1411: p_api_version IN NUMBER,
1412: p_init_msg_list IN VARCHAR2,

Line 1444: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --

1440: RETURN(l_sccv_rec);
1441:
1442: END fill_who_columns;
1443: -----------------------------------------------
1444: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --
1445: -----------------------------------------------
1446: FUNCTION Set_Attributes (
1447: p_sccv_rec IN sccv_rec_type,
1448: x_sccv_rec OUT NOCOPY sccv_rec_type

Line 1688: -- lock_row for:OKC_SECTION_CONTENTS --

1684: ---------------------------------------------------------------------------
1685: -- PROCEDURE lock_row
1686: ---------------------------------------------------------------------------
1687: ---------------------------------------
1688: -- lock_row for:OKC_SECTION_CONTENTS --
1689: ---------------------------------------
1690: PROCEDURE lock_row(
1691: p_init_msg_list IN VARCHAR2,
1692: x_return_status OUT NOCOPY VARCHAR2,

Line 1701: FROM OKC_SECTION_CONTENTS

1697: E_Resource_Busy EXCEPTION;
1698: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1699: CURSOR lock_csr (p_scc_rec IN scc_rec_type) IS
1700: SELECT OBJECT_VERSION_NUMBER
1701: FROM OKC_SECTION_CONTENTS
1702: WHERE ID = p_scc_rec.id
1703: AND OBJECT_VERSION_NUMBER = p_scc_rec.object_version_number
1704: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1705:

Line 1708: FROM OKC_SECTION_CONTENTS

1704: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1705:
1706: CURSOR lchk_csr (p_scc_rec IN scc_rec_type) IS
1707: SELECT OBJECT_VERSION_NUMBER
1708: FROM OKC_SECTION_CONTENTS
1709: WHERE ID = p_scc_rec.id;
1710: l_api_version CONSTANT NUMBER := 1;
1711: l_api_name CONSTANT VARCHAR2(30) := 'CONTENTS_lock_row';
1712: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1713: l_object_version_number OKC_SECTION_CONTENTS.OBJECT_VERSION_NUMBER%TYPE;

1709: WHERE ID = p_scc_rec.id;
1710: l_api_version CONSTANT NUMBER := 1;
1711: l_api_name CONSTANT VARCHAR2(30) := 'CONTENTS_lock_row';
1712: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1713: l_object_version_number OKC_SECTION_CONTENTS.OBJECT_VERSION_NUMBER%TYPE;
1714: lc_object_version_number OKC_SECTION_CONTENTS.OBJECT_VERSION_NUMBER%TYPE;
1715: l_row_notfound BOOLEAN := FALSE;
1716: lc_row_notfound BOOLEAN := FALSE;
1717: BEGIN

Line 1714: lc_object_version_number OKC_SECTION_CONTENTS.OBJECT_VERSION_NUMBER%TYPE;

1710: l_api_version CONSTANT NUMBER := 1;
1711: l_api_name CONSTANT VARCHAR2(30) := 'CONTENTS_lock_row';
1712: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1713: l_object_version_number OKC_SECTION_CONTENTS.OBJECT_VERSION_NUMBER%TYPE;
1714: lc_object_version_number OKC_SECTION_CONTENTS.OBJECT_VERSION_NUMBER%TYPE;
1715: l_row_notfound BOOLEAN := FALSE;
1716: lc_row_notfound BOOLEAN := FALSE;
1717: BEGIN
1718:

Line 1847: -- lock_row for:OKC_SECTION_CONTENTS_V --

1843: );
1844:
1845: END lock_row;
1846: -----------------------------------------
1847: -- lock_row for:OKC_SECTION_CONTENTS_V --
1848: -----------------------------------------
1849: PROCEDURE lock_row(
1850: p_api_version IN NUMBER,
1851: p_init_msg_list IN VARCHAR2,

Line 2057: -- update_row for:OKC_SECTION_CONTENTS --

2053: ---------------------------------------------------------------------------
2054: -- PROCEDURE update_row
2055: ---------------------------------------------------------------------------
2056: -----------------------------------------
2057: -- update_row for:OKC_SECTION_CONTENTS --
2058: -----------------------------------------
2059: PROCEDURE update_row(
2060: p_init_msg_list IN VARCHAR2,
2061: x_return_status OUT NOCOPY VARCHAR2,

Line 2222: -- Set_Attributes for:OKC_SECTION_CONTENTS --

2218: RETURN(l_return_status);
2219:
2220: END populate_new_record;
2221: ---------------------------------------------
2222: -- Set_Attributes for:OKC_SECTION_CONTENTS --
2223: ---------------------------------------------
2224: FUNCTION Set_Attributes (
2225: p_scc_rec IN scc_rec_type,
2226: x_scc_rec OUT NOCOPY scc_rec_type

Line 2267: UPDATE OKC_SECTION_CONTENTS

2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;
2267: UPDATE OKC_SECTION_CONTENTS
2268: SET SCN_ID = l_def_scc_rec.scn_id,
2269: CONTENT_SEQUENCE = l_def_scc_rec.content_sequence,
2270: OBJECT_VERSION_NUMBER = l_def_scc_rec.object_version_number,
2271: CREATED_BY = l_def_scc_rec.created_by,

Line 2358: -- update_row for:OKC_SECTION_CONTENTS_V --

2354: );
2355:
2356: END update_row;
2357: -------------------------------------------
2358: -- update_row for:OKC_SECTION_CONTENTS_V --
2359: -------------------------------------------
2360: PROCEDURE update_row(
2361: p_api_version IN NUMBER,
2362: p_init_msg_list IN VARCHAR2,

Line 2540: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --

2536: RETURN(l_return_status);
2537:
2538: END populate_new_record;
2539: -----------------------------------------------
2540: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --
2541: -----------------------------------------------
2542: FUNCTION Set_Attributes (
2543: p_sccv_rec IN sccv_rec_type,
2544: x_sccv_rec OUT NOCOPY sccv_rec_type

Line 2788: -- delete_row for:OKC_SECTION_CONTENTS --

2784: ---------------------------------------------------------------------------
2785: -- PROCEDURE delete_row
2786: ---------------------------------------------------------------------------
2787: -----------------------------------------
2788: -- delete_row for:OKC_SECTION_CONTENTS --
2789: -----------------------------------------
2790: PROCEDURE delete_row(
2791: p_init_msg_list IN VARCHAR2,
2792: x_return_status OUT NOCOPY VARCHAR2,

Line 2818: DELETE FROM OKC_SECTION_CONTENTS

2814: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2815: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2816: RAISE OKC_API.G_EXCEPTION_ERROR;
2817: END IF;
2818: DELETE FROM OKC_SECTION_CONTENTS
2819: WHERE ID = l_scc_rec.id;
2820:
2821: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2822:

Line 2880: -- delete_row for:OKC_SECTION_CONTENTS_V --

2876: );
2877:
2878: END delete_row;
2879: -------------------------------------------
2880: -- delete_row for:OKC_SECTION_CONTENTS_V --
2881: -------------------------------------------
2882: PROCEDURE delete_row(
2883: p_api_version IN NUMBER,
2884: p_init_msg_list IN VARCHAR2,

Line 3105: INSERT INTO okc_section_contents_h

3101: okc_debug.Set_Indentation('OKC_SCC_PVT');
3102: okc_debug.log('10900: Entered create_version', 2);
3103: END IF;
3104:
3105: INSERT INTO okc_section_contents_h
3106: (
3107: major_version,
3108: id,
3109: scn_id,

Line 3169: FROM okc_section_contents

3165: attribute12,
3166: attribute13,
3167: attribute14,
3168: attribute15
3169: FROM okc_section_contents
3170: WHERE scn_id in (SELECT id
3171: FROM okc_sections_b
3172: WHERE CHR_ID=p_chr_id);
3173:

Line 3231: INSERT INTO okc_section_contents

3227: okc_debug.Set_Indentation('OKC_SCC_PVT');
3228: okc_debug.log('11200: Entered restore_version', 2);
3229: END IF;
3230:
3231: INSERT INTO okc_section_contents
3232: (
3233: id,
3234: scn_id,
3235: content_sequence,

Line 3293: FROM okc_section_contents_h

3289: attribute12,
3290: attribute13,
3291: attribute14,
3292: attribute15
3293: FROM okc_section_contents_h
3294: WHERE scn_id in (SELECT id
3295: FROM okc_sections_bh
3296: WHERE chr_id = p_chr_id)
3297: AND major_version = p_major_version;