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

Line 430: from OKC_SECTIONS_B

426:
427: l_dummy_var VARCHAR2(1) := '?';
428: Cursor l_scnv_csr Is
429: select 'x'
430: from OKC_SECTIONS_B
431: where id = p_scnv_rec.scn_id;
432:
433: Begin
434:

Line 520: FROM OKC_SECTIONS_B B

516:
517: DELETE FROM OKC_SECTIONS_TL T
518: WHERE NOT EXISTS (
519: SELECT NULL
520: FROM OKC_SECTIONS_B B
521: WHERE B.ID = T.ID
522: );
523:
524: UPDATE OKC_SECTIONS_TL T SET (

Line 578: FROM OKC_SECTIONS_BH B

574: );
575: DELETE FROM OKC_SECTIONS_TLH T
576: WHERE NOT EXISTS (
577: SELECT NULL
578: FROM OKC_SECTIONS_BH B
579: WHERE B.ID = T.ID
580: AND B.MAJOR_VERSION = T.MAJOR_VERSION
581: );
582:

Line 651: -- FUNCTION get_rec for: OKC_SECTIONS_B

647: END IF;
648: END add_language;
649:
650: ---------------------------------------------------------------------------
651: -- FUNCTION get_rec for: OKC_SECTIONS_B
652: ---------------------------------------------------------------------------
653: FUNCTION get_rec (
654: p_scn_rec IN scn_rec_type,
655: x_no_data_found OUT NOCOPY BOOLEAN

Line 657: CURSOR okc_sections_b_pk_csr (p_id IN NUMBER) IS

653: FUNCTION get_rec (
654: p_scn_rec IN scn_rec_type,
655: x_no_data_found OUT NOCOPY BOOLEAN
656: ) RETURN scn_rec_type IS
657: CURSOR okc_sections_b_pk_csr (p_id IN NUMBER) IS
658: SELECT
659: ID,
660: SCN_TYPE,
661: CHR_ID,

Line 688: FROM Okc_Sections_B

684: ATTRIBUTE12,
685: ATTRIBUTE13,
686: ATTRIBUTE14,
687: ATTRIBUTE15
688: FROM Okc_Sections_B
689: WHERE okc_sections_b.id = p_id;
690: l_okc_sections_b_pk okc_sections_b_pk_csr%ROWTYPE;
691: l_scn_rec scn_rec_type;
692: BEGIN

Line 689: WHERE okc_sections_b.id = p_id;

685: ATTRIBUTE13,
686: ATTRIBUTE14,
687: ATTRIBUTE15
688: FROM Okc_Sections_B
689: WHERE okc_sections_b.id = p_id;
690: l_okc_sections_b_pk okc_sections_b_pk_csr%ROWTYPE;
691: l_scn_rec scn_rec_type;
692: BEGIN
693:

Line 690: l_okc_sections_b_pk okc_sections_b_pk_csr%ROWTYPE;

686: ATTRIBUTE14,
687: ATTRIBUTE15
688: FROM Okc_Sections_B
689: WHERE okc_sections_b.id = p_id;
690: l_okc_sections_b_pk okc_sections_b_pk_csr%ROWTYPE;
691: l_scn_rec scn_rec_type;
692: BEGIN
693:
694: IF (l_debug = 'Y') THEN

Line 701: OPEN okc_sections_b_pk_csr (p_scn_rec.id);

697: END IF;
698:
699: x_no_data_found := TRUE;
700: -- Get current database values
701: OPEN okc_sections_b_pk_csr (p_scn_rec.id);
702: FETCH okc_sections_b_pk_csr INTO
703: l_scn_rec.ID,
704: l_scn_rec.SCN_TYPE,
705: l_scn_rec.CHR_ID,

Line 702: FETCH okc_sections_b_pk_csr INTO

698:
699: x_no_data_found := TRUE;
700: -- Get current database values
701: OPEN okc_sections_b_pk_csr (p_scn_rec.id);
702: FETCH okc_sections_b_pk_csr INTO
703: l_scn_rec.ID,
704: l_scn_rec.SCN_TYPE,
705: l_scn_rec.CHR_ID,
706: l_scn_rec.SAT_CODE,

Line 732: x_no_data_found := okc_sections_b_pk_csr%NOTFOUND;

728: l_scn_rec.ATTRIBUTE12,
729: l_scn_rec.ATTRIBUTE13,
730: l_scn_rec.ATTRIBUTE14,
731: l_scn_rec.ATTRIBUTE15;
732: x_no_data_found := okc_sections_b_pk_csr%NOTFOUND;
733: CLOSE okc_sections_b_pk_csr;
734:
735: IF (l_debug = 'Y') THEN
736: okc_debug.log('900: Leaving Fn Get_Rec ', 2);

Line 733: CLOSE okc_sections_b_pk_csr;

729: l_scn_rec.ATTRIBUTE13,
730: l_scn_rec.ATTRIBUTE14,
731: l_scn_rec.ATTRIBUTE15;
732: x_no_data_found := okc_sections_b_pk_csr%NOTFOUND;
733: CLOSE okc_sections_b_pk_csr;
734:
735: IF (l_debug = 'Y') THEN
736: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
737: okc_debug.Reset_Indentation;

Line 1199: FROM okc_sections_b

1195: AND id <> NVL(p_scnv_rec.ID,-9999);
1196:
1197: CURSOR cur_scn_2 IS
1198: SELECT 'x'
1199: FROM okc_sections_b
1200: WHERE chr_id = p_scnv_rec.CHR_ID
1201: AND sat_code = p_scnv_rec.SAT_CODE
1202: AND section_sequence = p_scnv_rec.SECTION_SEQUENCE
1203: AND scn_id IS NULL

Line 1599: -- insert_row for:OKC_SECTIONS_B --

1595:
1596: END validate_row;
1597:
1598: -----------------------------------
1599: -- insert_row for:OKC_SECTIONS_B --
1600: -----------------------------------
1601: PROCEDURE insert_row(
1602: p_init_msg_list IN VARCHAR2,
1603: x_return_status OUT NOCOPY VARCHAR2,

Line 1615: -- Set_Attributes for:OKC_SECTIONS_B --

1611: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1612: l_scn_rec scn_rec_type := p_scn_rec;
1613: l_def_scn_rec scn_rec_type;
1614: ---------------------------------------
1615: -- Set_Attributes for:OKC_SECTIONS_B --
1616: ---------------------------------------
1617: FUNCTION Set_Attributes (
1618: p_scn_rec IN scn_rec_type,
1619: x_scn_rec OUT NOCOPY scn_rec_type

Line 1654: INSERT INTO OKC_SECTIONS_B(

1650: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1651: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1652: RAISE OKC_API.G_EXCEPTION_ERROR;
1653: END IF;
1654: INSERT INTO OKC_SECTIONS_B(
1655: id,
1656: scn_type,
1657: chr_id,
1658: sat_code,

Line 2231: -- lock_row for:OKC_SECTIONS_B --

2227: ---------------------------------------------------------------------------
2228: -- PROCEDURE lock_row
2229: ---------------------------------------------------------------------------
2230: ---------------------------------
2231: -- lock_row for:OKC_SECTIONS_B --
2232: ---------------------------------
2233: PROCEDURE lock_row(
2234: p_init_msg_list IN VARCHAR2,
2235: x_return_status OUT NOCOPY VARCHAR2,

Line 2244: FROM OKC_SECTIONS_B

2240: E_Resource_Busy EXCEPTION;
2241: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2242: CURSOR lock_csr (p_scn_rec IN scn_rec_type) IS
2243: SELECT OBJECT_VERSION_NUMBER
2244: FROM OKC_SECTIONS_B
2245: WHERE ID = p_scn_rec.id
2246: AND OBJECT_VERSION_NUMBER = p_scn_rec.object_version_number
2247: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2248:

Line 2251: FROM OKC_SECTIONS_B

2247: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2248:
2249: CURSOR lchk_csr (p_scn_rec IN scn_rec_type) IS
2250: SELECT OBJECT_VERSION_NUMBER
2251: FROM OKC_SECTIONS_B
2252: WHERE ID = p_scn_rec.id;
2253: l_api_version CONSTANT NUMBER := 1;
2254: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2255: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2256: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;

2252: WHERE ID = p_scn_rec.id;
2253: l_api_version CONSTANT NUMBER := 1;
2254: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2255: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2256: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
2257: lc_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
2258: l_row_notfound BOOLEAN := FALSE;
2259: lc_row_notfound BOOLEAN := FALSE;
2260: BEGIN

Line 2257: lc_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;

2253: l_api_version CONSTANT NUMBER := 1;
2254: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2255: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2256: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
2257: lc_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE;
2258: l_row_notfound BOOLEAN := FALSE;
2259: lc_row_notfound BOOLEAN := FALSE;
2260: BEGIN
2261:

Line 2729: -- update_row for:OKC_SECTIONS_B --

2725: ---------------------------------------------------------------------------
2726: -- PROCEDURE update_row
2727: ---------------------------------------------------------------------------
2728: -----------------------------------
2729: -- update_row for:OKC_SECTIONS_B --
2730: -----------------------------------
2731: PROCEDURE update_row(
2732: p_init_msg_list IN VARCHAR2,
2733: x_return_status OUT NOCOPY VARCHAR2,

Line 2893: -- Set_Attributes for:OKC_SECTIONS_B --

2889:
2890: RETURN(l_return_status);
2891: END populate_new_record;
2892: ---------------------------------------
2893: -- Set_Attributes for:OKC_SECTIONS_B --
2894: ---------------------------------------
2895: FUNCTION Set_Attributes (
2896: p_scn_rec IN scn_rec_type,
2897: x_scn_rec OUT NOCOPY scn_rec_type

Line 2938: UPDATE OKC_SECTIONS_B

2934: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2935: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2936: RAISE OKC_API.G_EXCEPTION_ERROR;
2937: END IF;
2938: UPDATE OKC_SECTIONS_B
2939: SET SCN_TYPE = l_def_scn_rec.scn_type,
2940: CHR_ID = l_def_scn_rec.chr_id,
2941: SAT_CODE = l_def_scn_rec.sat_code,
2942: SECTION_SEQUENCE = l_def_scn_rec.section_sequence,

Line 3695: -- delete_row for:OKC_SECTIONS_B --

3691: ---------------------------------------------------------------------------
3692: -- PROCEDURE delete_row
3693: ---------------------------------------------------------------------------
3694: -----------------------------------
3695: -- delete_row for:OKC_SECTIONS_B --
3696: -----------------------------------
3697: PROCEDURE delete_row(
3698: p_init_msg_list IN VARCHAR2,
3699: x_return_status OUT NOCOPY VARCHAR2,

Line 3725: DELETE FROM OKC_SECTIONS_B

3721: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3722: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3723: RAISE OKC_API.G_EXCEPTION_ERROR;
3724: END IF;
3725: DELETE FROM OKC_SECTIONS_B
3726: WHERE ID = l_scn_rec.id;
3727:
3728: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3729:

Line 4144: INSERT INTO okc_sections_bh

4140: okc_debug.Set_Indentation('OKC_SCN_PVT');
4141: okc_debug.log('14900: Entered create_version', 2);
4142: END IF;
4143:
4144: INSERT INTO okc_sections_bh
4145: (
4146: major_version,
4147: id,
4148: scn_type,

Line 4208: FROM okc_sections_b

4204: attribute12,
4205: attribute13,
4206: attribute14,
4207: attribute15
4208: FROM okc_sections_b
4209: WHERE chr_id = p_chr_id;
4210:
4211: --------------------------
4212: -- Versioning TL Table

Line 4243: FROM okc_sections_b

4239: last_update_date,
4240: last_update_login
4241: FROM okc_sections_tl
4242: WHERE id in (SELECT id
4243: FROM okc_sections_b
4244: WHERE chr_id= p_chr_id);
4245:
4246: IF (l_debug = 'Y') THEN
4247: okc_debug.log('15000: Leaving create_version', 2);

Line 4321: FROM okc_sections_bh

4317: last_update_date,
4318: last_update_login
4319: FROM okc_sections_tlh
4320: WHERE id in (SELECT id
4321: FROM okc_sections_bh
4322: WHERE chr_id = p_chr_id)
4323: AND major_version = p_major_version;
4324:
4325: -----------------------------

Line 4329: INSERT INTO okc_sections_b

4325: -----------------------------
4326: -- Restoring for Base Table
4327: -----------------------------
4328:
4329: INSERT INTO okc_sections_b
4330: (
4331: id,
4332: scn_type,
4333: chr_id,

Line 4391: FROM okc_sections_bh

4387: attribute12,
4388: attribute13,
4389: attribute14,
4390: attribute15
4391: FROM okc_sections_bh
4392: WHERE chr_id = p_chr_id
4393: AND major_version = p_major_version;
4394:
4395: IF (l_debug = 'Y') THEN