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_CLG_PVT dependencies on OKL_CNTR_LVLNG_GRPS_B

Line 716: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_B

712:
713: END add_language;
714:
715: ---------------------------------------------------------------------------
716: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_B
717: ---------------------------------------------------------------------------
718: FUNCTION get_rec (
719: p_clg_rec IN clg_rec_type,
720: x_no_data_found OUT NOCOPY BOOLEAN

Line 758: FROM Okl_Cntr_Lvlng_Grps_B

754: EFFECTIVE_DATE_FROM,
755: EFFECTIVE_DATE_TO,
756: IPL_ID,
757: LEGAL_ENTITY_ID -- for LE Uptake project 08-11-2006
758: FROM Okl_Cntr_Lvlng_Grps_B
759: WHERE okl_cntr_lvlng_grps_b.id = p_id;
760: l_clg_pk clg_pk_csr%ROWTYPE;
761: l_clg_rec clg_rec_type;
762: BEGIN

Line 759: WHERE okl_cntr_lvlng_grps_b.id = p_id;

755: EFFECTIVE_DATE_TO,
756: IPL_ID,
757: LEGAL_ENTITY_ID -- for LE Uptake project 08-11-2006
758: FROM Okl_Cntr_Lvlng_Grps_B
759: WHERE okl_cntr_lvlng_grps_b.id = p_id;
760: l_clg_pk clg_pk_csr%ROWTYPE;
761: l_clg_rec clg_rec_type;
762: BEGIN
763: x_no_data_found := TRUE;

Line 1503: -- insert_row for:OKL_CNTR_LVLNG_GRPS_B --

1499: ---------------------------------------------------------------------------
1500: -- PROCEDURE insert_row
1501: ---------------------------------------------------------------------------
1502: ------------------------------------------
1503: -- insert_row for:OKL_CNTR_LVLNG_GRPS_B --
1504: ------------------------------------------
1505: PROCEDURE insert_row(
1506: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1507: x_return_status OUT NOCOPY VARCHAR2,

Line 1519: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_B --

1515: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1516: l_clg_rec clg_rec_type := p_clg_rec;
1517: l_def_clg_rec clg_rec_type;
1518: ----------------------------------------------
1519: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_B --
1520: ----------------------------------------------
1521: FUNCTION Set_Attributes (
1522: p_clg_rec IN clg_rec_type,
1523: x_clg_rec OUT NOCOPY clg_rec_type

Line 1550: INSERT INTO OKL_CNTR_LVLNG_GRPS_B(

1546: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1547: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1548: RAISE Okc_Api.G_EXCEPTION_ERROR;
1549: END IF;
1550: INSERT INTO OKL_CNTR_LVLNG_GRPS_B(
1551: id,
1552: org_id,
1553: currency_code,
1554: inf_id,

Line 2007: -- lock_row for:OKL_CNTR_LVLNG_GRPS_B --

2003: ---------------------------------------------------------------------------
2004: -- PROCEDURE lock_row
2005: ---------------------------------------------------------------------------
2006: ----------------------------------------
2007: -- lock_row for:OKL_CNTR_LVLNG_GRPS_B --
2008: ----------------------------------------
2009: PROCEDURE lock_row(
2010: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2011: x_return_status OUT NOCOPY VARCHAR2,

Line 2020: FROM OKL_CNTR_LVLNG_GRPS_B

2016: E_Resource_Busy EXCEPTION;
2017: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2018: CURSOR lock_csr (p_clg_rec IN clg_rec_type) IS
2019: SELECT OBJECT_VERSION_NUMBER
2020: FROM OKL_CNTR_LVLNG_GRPS_B
2021: WHERE ID = p_clg_rec.id
2022: AND OBJECT_VERSION_NUMBER = p_clg_rec.object_version_number
2023: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2024:

Line 2027: FROM OKL_CNTR_LVLNG_GRPS_B

2023: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2024:
2025: CURSOR lchk_csr (p_clg_rec IN clg_rec_type) IS
2026: SELECT OBJECT_VERSION_NUMBER
2027: FROM OKL_CNTR_LVLNG_GRPS_B
2028: WHERE ID = p_clg_rec.id;
2029: l_api_version CONSTANT NUMBER := 1;
2030: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2031: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2032: l_object_version_number OKL_CNTR_LVLNG_GRPS_B.OBJECT_VERSION_NUMBER%TYPE;

2028: WHERE ID = p_clg_rec.id;
2029: l_api_version CONSTANT NUMBER := 1;
2030: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2031: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2032: l_object_version_number OKL_CNTR_LVLNG_GRPS_B.OBJECT_VERSION_NUMBER%TYPE;
2033: lc_object_version_number OKL_CNTR_LVLNG_GRPS_B.OBJECT_VERSION_NUMBER%TYPE;
2034: l_row_notfound BOOLEAN := FALSE;
2035: lc_row_notfound BOOLEAN := FALSE;
2036: BEGIN

Line 2033: lc_object_version_number OKL_CNTR_LVLNG_GRPS_B.OBJECT_VERSION_NUMBER%TYPE;

2029: l_api_version CONSTANT NUMBER := 1;
2030: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2031: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2032: l_object_version_number OKL_CNTR_LVLNG_GRPS_B.OBJECT_VERSION_NUMBER%TYPE;
2033: lc_object_version_number OKL_CNTR_LVLNG_GRPS_B.OBJECT_VERSION_NUMBER%TYPE;
2034: l_row_notfound BOOLEAN := FALSE;
2035: lc_row_notfound BOOLEAN := FALSE;
2036: BEGIN
2037: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2360: -- update_row for:OKL_CNTR_LVLNG_GRPS_B --

2356: ---------------------------------------------------------------------------
2357: -- PROCEDURE update_row
2358: ---------------------------------------------------------------------------
2359: ------------------------------------------
2360: -- update_row for:OKL_CNTR_LVLNG_GRPS_B --
2361: ------------------------------------------
2362: PROCEDURE update_row(
2363: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2364: x_return_status OUT NOCOPY VARCHAR2,

Line 2534: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_B --

2530: -- for LE Uptake project 08-11-2006
2531: RETURN(l_return_status);
2532: END populate_new_record;
2533: ----------------------------------------------
2534: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_B --
2535: ----------------------------------------------
2536: FUNCTION Set_Attributes (
2537: p_clg_rec IN clg_rec_type,
2538: x_clg_rec OUT NOCOPY clg_rec_type

Line 2571: UPDATE OKL_CNTR_LVLNG_GRPS_B

2567: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2568: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2569: RAISE Okc_Api.G_EXCEPTION_ERROR;
2570: END IF;
2571: UPDATE OKL_CNTR_LVLNG_GRPS_B
2572: SET ORG_ID = l_def_clg_rec.org_id,
2573: CURRENCY_CODE = l_def_clg_rec.currency_code,
2574: INF_ID = l_def_clg_rec.inf_id,
2575: ICA_ID = l_def_clg_rec.ica_id,

Line 3223: -- delete_row for:OKL_CNTR_LVLNG_GRPS_B --

3219: ---------------------------------------------------------------------------
3220: -- PROCEDURE delete_row
3221: ---------------------------------------------------------------------------
3222: ------------------------------------------
3223: -- delete_row for:OKL_CNTR_LVLNG_GRPS_B --
3224: ------------------------------------------
3225: PROCEDURE delete_row(
3226: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3227: x_return_status OUT NOCOPY VARCHAR2,

Line 3247: DELETE FROM OKL_CNTR_LVLNG_GRPS_B

3243: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3244: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3245: RAISE Okc_Api.G_EXCEPTION_ERROR;
3246: END IF;
3247: DELETE FROM OKL_CNTR_LVLNG_GRPS_B
3248: WHERE ID = l_clg_rec.id;
3249:
3250: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3251: EXCEPTION