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_RFC_PVT dependencies on OKL_REMARKTNG_COSTS_B

Line 774: -- FUNCTION get_rec for: OKL_REMARKTNG_COSTS_B

770:
771: END add_language;
772:
773: ---------------------------------------------------------------------------
774: -- FUNCTION get_rec for: OKL_REMARKTNG_COSTS_B
775: ---------------------------------------------------------------------------
776: -- Start of comments
777: --
778: -- Function Name : get_rec

Line 779: -- Description : for: OKL_REMARKTNG_COSTS_B

775: ---------------------------------------------------------------------------
776: -- Start of comments
777: --
778: -- Function Name : get_rec
779: -- Description : for: OKL_REMARKTNG_COSTS_B
780: -- Business Rules :
781: -- Parameters :
782: -- Version : 1.0
783: -- History : RABHUPAT 17-DEC-2002 2667636

Line 830: FROM Okl_Remarktng_Costs_B

826: CURRENCY_CONVERSION_TYPE,
827: CURRENCY_CONVERSION_RATE,
828: CURRENCY_CONVERSION_DATE
829: -- RABHUPAT - 2667636 - End
830: FROM Okl_Remarktng_Costs_B
831: WHERE okl_remarktng_costs_b.id = p_id;
832: l_rfc_pk rfc_pk_csr%ROWTYPE;
833: l_rfc_rec rfc_rec_type;
834: BEGIN

Line 831: WHERE okl_remarktng_costs_b.id = p_id;

827: CURRENCY_CONVERSION_RATE,
828: CURRENCY_CONVERSION_DATE
829: -- RABHUPAT - 2667636 - End
830: FROM Okl_Remarktng_Costs_B
831: WHERE okl_remarktng_costs_b.id = p_id;
832: l_rfc_pk rfc_pk_csr%ROWTYPE;
833: l_rfc_rec rfc_rec_type;
834: BEGIN
835: x_no_data_found := TRUE;

Line 1671: -- insert_row for:OKL_REMARKTNG_COSTS_B --

1667: ---------------------------------------------------------------------------
1668: -- PROCEDURE insert_row
1669: ---------------------------------------------------------------------------
1670: ------------------------------------------
1671: -- insert_row for:OKL_REMARKTNG_COSTS_B --
1672: ------------------------------------------
1673: -- Start of comments
1674: --
1675: -- Procedure Name : insert_row

Line 1676: -- Description : for OKL_REMARKTNG_COSTS_B

1672: ------------------------------------------
1673: -- Start of comments
1674: --
1675: -- Procedure Name : insert_row
1676: -- Description : for OKL_REMARKTNG_COSTS_B
1677: -- Business Rules :
1678: -- Parameters :
1679: -- Version : 1.0
1680: -- History : RABHUPAT 17-DEC-2002 2667636

Line 1697: -- Set_Attributes for:OKL_REMARKTNG_COSTS_B --

1693: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1694: l_rfc_rec rfc_rec_type := p_rfc_rec;
1695: l_def_rfc_rec rfc_rec_type;
1696: ----------------------------------------------
1697: -- Set_Attributes for:OKL_REMARKTNG_COSTS_B --
1698: ----------------------------------------------
1699: FUNCTION Set_Attributes (
1700: p_rfc_rec IN rfc_rec_type,
1701: x_rfc_rec OUT NOCOPY rfc_rec_type

Line 1730: INSERT INTO OKL_REMARKTNG_COSTS_B(

1726: RAISE OKC_API.G_EXCEPTION_ERROR;
1727: END IF;
1728:
1729:
1730: INSERT INTO OKL_REMARKTNG_COSTS_B(
1731: id,
1732: cos_code,
1733: art_id,
1734: object_version_number,

Line 2266: -- lock_row for:OKL_REMARKTNG_COSTS_B --

2262: ---------------------------------------------------------------------------
2263: -- PROCEDURE lock_row
2264: ---------------------------------------------------------------------------
2265: ----------------------------------------
2266: -- lock_row for:OKL_REMARKTNG_COSTS_B --
2267: ----------------------------------------
2268: PROCEDURE lock_row(
2269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2270: x_return_status OUT NOCOPY VARCHAR2,

Line 2279: FROM OKL_REMARKTNG_COSTS_B

2275: E_Resource_Busy EXCEPTION;
2276: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2277: CURSOR lock_csr (p_rfc_rec IN rfc_rec_type) IS
2278: SELECT OBJECT_VERSION_NUMBER
2279: FROM OKL_REMARKTNG_COSTS_B
2280: WHERE ID = p_rfc_rec.id
2281: AND OBJECT_VERSION_NUMBER = p_rfc_rec.object_version_number
2282: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2283:

Line 2286: FROM OKL_REMARKTNG_COSTS_B

2282: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2283:
2284: CURSOR lchk_csr (p_rfc_rec IN rfc_rec_type) IS
2285: SELECT OBJECT_VERSION_NUMBER
2286: FROM OKL_REMARKTNG_COSTS_B
2287: WHERE ID = p_rfc_rec.id;
2288: l_api_version CONSTANT NUMBER := 1;
2289: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2290: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2291: l_object_version_number OKL_REMARKTNG_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;

2287: WHERE ID = p_rfc_rec.id;
2288: l_api_version CONSTANT NUMBER := 1;
2289: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2290: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2291: l_object_version_number OKL_REMARKTNG_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2292: lc_object_version_number OKL_REMARKTNG_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2293: l_row_notfound BOOLEAN := FALSE;
2294: lc_row_notfound BOOLEAN := FALSE;
2295: BEGIN

Line 2292: lc_object_version_number OKL_REMARKTNG_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;

2288: l_api_version CONSTANT NUMBER := 1;
2289: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2290: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2291: l_object_version_number OKL_REMARKTNG_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2292: lc_object_version_number OKL_REMARKTNG_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2293: l_row_notfound BOOLEAN := FALSE;
2294: lc_row_notfound BOOLEAN := FALSE;
2295: BEGIN
2296: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2635: -- update_row for:OKL_REMARKTNG_COSTS_B --

2631: ---------------------------------------------------------------------------
2632: -- PROCEDURE update_row
2633: ---------------------------------------------------------------------------
2634: ------------------------------------------
2635: -- update_row for:OKL_REMARKTNG_COSTS_B --
2636: ------------------------------------------
2637: -- Start of comments
2638: --
2639: -- Procedure Name : update_row

Line 2640: -- Description : for OKL_REMARKTNG_COSTS_B

2636: ------------------------------------------
2637: -- Start of comments
2638: --
2639: -- Procedure Name : update_row
2640: -- Description : for OKL_REMARKTNG_COSTS_B
2641: -- Business Rules :
2642: -- Parameters :
2643: -- Version : 1.0
2644: -- History : RABHUPAT 17-DEC-2002 2667636

Line 2827: -- Set_Attributes for:OKL_REMARKTNG_COSTS_B --

2823: -- RABHUPAT - 2667636 - End
2824: RETURN(l_return_status);
2825: END populate_new_record;
2826: ----------------------------------------------
2827: -- Set_Attributes for:OKL_REMARKTNG_COSTS_B --
2828: ----------------------------------------------
2829: FUNCTION Set_Attributes (
2830: p_rfc_rec IN rfc_rec_type,
2831: x_rfc_rec OUT NOCOPY rfc_rec_type

Line 2879: UPDATE OKL_REMARKTNG_COSTS_B

2875: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2876: RAISE OKC_API.G_EXCEPTION_ERROR;
2877: END IF;
2878:
2879: UPDATE OKL_REMARKTNG_COSTS_B
2880: SET COS_CODE = l_def_rfc_rec.cos_code,
2881: ART_ID = l_def_rfc_rec.art_id,
2882: OBJECT_VERSION_NUMBER = l_def_rfc_rec.object_version_number,
2883: AMOUNT = l_def_rfc_rec.amount,

Line 3570: -- delete_row for:OKL_REMARKTNG_COSTS_B --

3566: ---------------------------------------------------------------------------
3567: -- PROCEDURE delete_row
3568: ---------------------------------------------------------------------------
3569: ------------------------------------------
3570: -- delete_row for:OKL_REMARKTNG_COSTS_B --
3571: ------------------------------------------
3572: PROCEDURE delete_row(
3573: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3574: x_return_status OUT NOCOPY VARCHAR2,

Line 3594: DELETE FROM OKL_REMARKTNG_COSTS_B

3590: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3592: RAISE OKC_API.G_EXCEPTION_ERROR;
3593: END IF;
3594: DELETE FROM OKL_REMARKTNG_COSTS_B
3595: WHERE ID = l_rfc_rec.id;
3596:
3597: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3598: EXCEPTION