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.OKL_RAS_PVT dependencies on OKL_RELOCATE_ASSETS_B

Line 860: -- FUNCTION get_rec for: OKL_RELOCATE_ASSETS_B

856:
857: END add_language;
858:
859: ---------------------------------------------------------------------------
860: -- FUNCTION get_rec for: OKL_RELOCATE_ASSETS_B
861: ---------------------------------------------------------------------------
862: -- Start of comments
863: --
864: -- Function Name : get_rec

Line 865: -- Description : for: OKL_RELOCATE_ASSETS_B

861: ---------------------------------------------------------------------------
862: -- Start of comments
863: --
864: -- Function Name : get_rec
865: -- Description : for: OKL_RELOCATE_ASSETS_B
866: -- Business Rules :
867: -- Parameters :
868: -- Version : 1.0
869: -- History : RABHUPAT 17-DEC-2002 2667636

Line 876: CURSOR okl_relocate_assets_b_pk_csr (p_id IN NUMBER) IS

872: FUNCTION get_rec (
873: p_ras_rec IN ras_rec_type,
874: x_no_data_found OUT NOCOPY BOOLEAN
875: ) RETURN ras_rec_type IS
876: CURSOR okl_relocate_assets_b_pk_csr (p_id IN NUMBER) IS
877: SELECT
878: ID,
879: IST_ID,
880: PAC_ID,

Line 919: FROM Okl_Relocate_Assets_B

915: CURRENCY_CONVERSION_TYPE,
916: CURRENCY_CONVERSION_RATE,
917: CURRENCY_CONVERSION_DATE
918: -- RABHUPAT - 2667636 - End
919: FROM Okl_Relocate_Assets_B
920: WHERE okl_relocate_assets_b.id = p_id;
921: l_okl_relocate_assets_b_pk okl_relocate_assets_b_pk_csr%ROWTYPE;
922: l_ras_rec ras_rec_type;
923: BEGIN

Line 920: WHERE okl_relocate_assets_b.id = p_id;

916: CURRENCY_CONVERSION_RATE,
917: CURRENCY_CONVERSION_DATE
918: -- RABHUPAT - 2667636 - End
919: FROM Okl_Relocate_Assets_B
920: WHERE okl_relocate_assets_b.id = p_id;
921: l_okl_relocate_assets_b_pk okl_relocate_assets_b_pk_csr%ROWTYPE;
922: l_ras_rec ras_rec_type;
923: BEGIN
924: x_no_data_found := TRUE;

Line 921: l_okl_relocate_assets_b_pk okl_relocate_assets_b_pk_csr%ROWTYPE;

917: CURRENCY_CONVERSION_DATE
918: -- RABHUPAT - 2667636 - End
919: FROM Okl_Relocate_Assets_B
920: WHERE okl_relocate_assets_b.id = p_id;
921: l_okl_relocate_assets_b_pk okl_relocate_assets_b_pk_csr%ROWTYPE;
922: l_ras_rec ras_rec_type;
923: BEGIN
924: x_no_data_found := TRUE;
925: -- Get current database values

Line 926: OPEN okl_relocate_assets_b_pk_csr (p_ras_rec.id);

922: l_ras_rec ras_rec_type;
923: BEGIN
924: x_no_data_found := TRUE;
925: -- Get current database values
926: OPEN okl_relocate_assets_b_pk_csr (p_ras_rec.id);
927: FETCH okl_relocate_assets_b_pk_csr INTO
928: l_ras_rec.ID,
929: l_ras_rec.IST_ID,
930: l_ras_rec.PAC_ID,

Line 927: FETCH okl_relocate_assets_b_pk_csr INTO

923: BEGIN
924: x_no_data_found := TRUE;
925: -- Get current database values
926: OPEN okl_relocate_assets_b_pk_csr (p_ras_rec.id);
927: FETCH okl_relocate_assets_b_pk_csr INTO
928: l_ras_rec.ID,
929: l_ras_rec.IST_ID,
930: l_ras_rec.PAC_ID,
931: l_ras_rec.ART_ID,

Line 969: x_no_data_found := okl_relocate_assets_b_pk_csr%NOTFOUND;

965: l_ras_rec.CURRENCY_CONVERSION_TYPE,
966: l_ras_rec.CURRENCY_CONVERSION_RATE,
967: l_ras_rec.CURRENCY_CONVERSION_DATE;
968: -- RABHUPAT - 2667636 - End
969: x_no_data_found := okl_relocate_assets_b_pk_csr%NOTFOUND;
970: CLOSE okl_relocate_assets_b_pk_csr;
971: RETURN(l_ras_rec);
972: END get_rec;
973:

Line 970: CLOSE okl_relocate_assets_b_pk_csr;

966: l_ras_rec.CURRENCY_CONVERSION_RATE,
967: l_ras_rec.CURRENCY_CONVERSION_DATE;
968: -- RABHUPAT - 2667636 - End
969: x_no_data_found := okl_relocate_assets_b_pk_csr%NOTFOUND;
970: CLOSE okl_relocate_assets_b_pk_csr;
971: RETURN(l_ras_rec);
972: END get_rec;
973:
974: FUNCTION get_rec (

Line 1827: -- insert_row for:OKL_RELOCATE_ASSETS_B --

1823: ---------------------------------------------------------------------------
1824: -- PROCEDURE insert_row
1825: ---------------------------------------------------------------------------
1826: ------------------------------------------
1827: -- insert_row for:OKL_RELOCATE_ASSETS_B --
1828: ------------------------------------------
1829: -- Start of comments
1830: --
1831: -- Procedure Name : insert_row

Line 1832: -- Description : for OKL_RELOCATE_ASSETS_B

1828: ------------------------------------------
1829: -- Start of comments
1830: --
1831: -- Procedure Name : insert_row
1832: -- Description : for OKL_RELOCATE_ASSETS_B
1833: -- Business Rules :
1834: -- Parameters :
1835: -- Version : 1.0
1836: -- History : RABHUPAT 17-DEC-2002 2667636

Line 1853: -- Set_Attributes for:OKL_RELOCATE_ASSETS_B --

1849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1850: l_ras_rec ras_rec_type := p_ras_rec;
1851: l_def_ras_rec ras_rec_type;
1852: ----------------------------------------------
1853: -- Set_Attributes for:OKL_RELOCATE_ASSETS_B --
1854: ----------------------------------------------
1855: FUNCTION Set_Attributes (
1856: p_ras_rec IN ras_rec_type,
1857: x_ras_rec OUT NOCOPY ras_rec_type

Line 1884: INSERT INTO OKL_RELOCATE_ASSETS_B(

1880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1882: RAISE OKC_API.G_EXCEPTION_ERROR;
1883: END IF;
1884: INSERT INTO OKL_RELOCATE_ASSETS_B(
1885: id,
1886: ist_id,
1887: pac_id,
1888: art_id,

Line 2397: -- lock_row for:OKL_RELOCATE_ASSETS_B --

2393: ---------------------------------------------------------------------------
2394: -- PROCEDURE lock_row
2395: ---------------------------------------------------------------------------
2396: ----------------------------------------
2397: -- lock_row for:OKL_RELOCATE_ASSETS_B --
2398: ----------------------------------------
2399: PROCEDURE lock_row(
2400: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2401: x_return_status OUT NOCOPY VARCHAR2,

Line 2410: FROM OKL_RELOCATE_ASSETS_B

2406: E_Resource_Busy EXCEPTION;
2407: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2408: CURSOR lock_csr (p_ras_rec IN ras_rec_type) IS
2409: SELECT OBJECT_VERSION_NUMBER
2410: FROM OKL_RELOCATE_ASSETS_B
2411: WHERE ID = p_ras_rec.id
2412: AND OBJECT_VERSION_NUMBER = p_ras_rec.object_version_number
2413: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2414:

Line 2417: FROM OKL_RELOCATE_ASSETS_B

2413: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2414:
2415: CURSOR lchk_csr (p_ras_rec IN ras_rec_type) IS
2416: SELECT OBJECT_VERSION_NUMBER
2417: FROM OKL_RELOCATE_ASSETS_B
2418: WHERE ID = p_ras_rec.id;
2419: l_api_version CONSTANT NUMBER := 1;
2420: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2421: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2422: l_object_version_number OKL_RELOCATE_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

2418: WHERE ID = p_ras_rec.id;
2419: l_api_version CONSTANT NUMBER := 1;
2420: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2421: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2422: l_object_version_number OKL_RELOCATE_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2423: lc_object_version_number OKL_RELOCATE_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2424: l_row_notfound BOOLEAN := FALSE;
2425: lc_row_notfound BOOLEAN := FALSE;
2426: BEGIN

Line 2423: lc_object_version_number OKL_RELOCATE_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

2419: l_api_version CONSTANT NUMBER := 1;
2420: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2421: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2422: l_object_version_number OKL_RELOCATE_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2423: lc_object_version_number OKL_RELOCATE_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2424: l_row_notfound BOOLEAN := FALSE;
2425: lc_row_notfound BOOLEAN := FALSE;
2426: BEGIN
2427: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2766: -- update_row for:OKL_RELOCATE_ASSETS_B --

2762: ---------------------------------------------------------------------------
2763: -- PROCEDURE update_row
2764: ---------------------------------------------------------------------------
2765: ------------------------------------------
2766: -- update_row for:OKL_RELOCATE_ASSETS_B --
2767: ------------------------------------------
2768: -- Start of comments
2769: --
2770: -- Procedure Name : update_row

Line 2771: -- Description : for OKL_RELOCATE_ASSETS_B

2767: ------------------------------------------
2768: -- Start of comments
2769: --
2770: -- Procedure Name : update_row
2771: -- Description : for OKL_RELOCATE_ASSETS_B
2772: -- Business Rules :
2773: -- Parameters :
2774: -- Version : 1.0
2775: -- History : RABHUPAT 17-DEC-2002 2667636

Line 2970: -- Set_Attributes for:OKL_RELOCATE_ASSETS_B --

2966: -- RABHUPAT - 2667636 - End
2967: RETURN(l_return_status);
2968: END populate_new_record;
2969: ----------------------------------------------
2970: -- Set_Attributes for:OKL_RELOCATE_ASSETS_B --
2971: ----------------------------------------------
2972: FUNCTION Set_Attributes (
2973: p_ras_rec IN ras_rec_type,
2974: x_ras_rec OUT NOCOPY ras_rec_type

Line 3007: UPDATE OKL_RELOCATE_ASSETS_B

3003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3004: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3005: RAISE OKC_API.G_EXCEPTION_ERROR;
3006: END IF;
3007: UPDATE OKL_RELOCATE_ASSETS_B
3008: SET IST_ID = l_def_ras_rec.ist_id,
3009: PAC_ID = l_def_ras_rec.pac_id,
3010: ART_ID = l_def_ras_rec.art_id,
3011: OBJECT_VERSION_NUMBER = l_def_ras_rec.object_version_number,

Line 3695: -- delete_row for:OKL_RELOCATE_ASSETS_B --

3691: ---------------------------------------------------------------------------
3692: -- PROCEDURE delete_row
3693: ---------------------------------------------------------------------------
3694: ------------------------------------------
3695: -- delete_row for:OKL_RELOCATE_ASSETS_B --
3696: ------------------------------------------
3697: PROCEDURE delete_row(
3698: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3699: x_return_status OUT NOCOPY VARCHAR2,

Line 3719: DELETE FROM OKL_RELOCATE_ASSETS_B

3715: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3716: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3717: RAISE OKC_API.G_EXCEPTION_ERROR;
3718: END IF;
3719: DELETE FROM OKL_RELOCATE_ASSETS_B
3720: WHERE ID = l_ras_rec.id;
3721:
3722: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3723: EXCEPTION