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_SIP_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 102: FROM OKL_SUBSIDY_POOLS_B B

98: BEGIN
99: DELETE FROM OKL_SUBSIDY_POOLS_TL T
100: WHERE NOT EXISTS (
101: SELECT NULL
102: FROM OKL_SUBSIDY_POOLS_B B
103: WHERE B.ID =T.ID
104: );
105:
106: UPDATE OKL_SUBSIDY_POOLS_TL T SET(

Line 368: -- FUNCTION get_rec for: OKL_SUBSIDY_POOLS_B

364: BEGIN
365: RETURN(get_rec(p_okl_subsidy_pools_tl_rec, l_row_not_found));
366: END get_rec;
367: ---------------------------------------------------------------------------
368: -- FUNCTION get_rec for: OKL_SUBSIDY_POOLS_B
369: ---------------------------------------------------------------------------
370: FUNCTION get_rec (
371: p_sip_rec IN sip_rec_type,
372: x_no_data_found OUT NOCOPY BOOLEAN

Line 374: CURSOR okl_subsidy_pools_b_pk_csr (p_id IN NUMBER) IS

370: FUNCTION get_rec (
371: p_sip_rec IN sip_rec_type,
372: x_no_data_found OUT NOCOPY BOOLEAN
373: ) RETURN sip_rec_type IS
374: CURSOR okl_subsidy_pools_b_pk_csr (p_id IN NUMBER) IS
375: SELECT
376: ID,
377: OBJECT_VERSION_NUMBER,
378: POOL_TYPE_CODE,

Line 411: FROM Okl_Subsidy_Pools_B

407: CREATION_DATE,
408: LAST_UPDATED_BY,
409: LAST_UPDATE_DATE,
410: LAST_UPDATE_LOGIN
411: FROM Okl_Subsidy_Pools_B
412: WHERE okl_subsidy_pools_b.id = p_id;
413: l_okl_subsidy_pools_b_pk okl_subsidy_pools_b_pk_csr%ROWTYPE;
414: l_sip_rec sip_rec_type;
415: BEGIN

Line 412: WHERE okl_subsidy_pools_b.id = p_id;

408: LAST_UPDATED_BY,
409: LAST_UPDATE_DATE,
410: LAST_UPDATE_LOGIN
411: FROM Okl_Subsidy_Pools_B
412: WHERE okl_subsidy_pools_b.id = p_id;
413: l_okl_subsidy_pools_b_pk okl_subsidy_pools_b_pk_csr%ROWTYPE;
414: l_sip_rec sip_rec_type;
415: BEGIN
416: x_no_data_found := TRUE;

Line 413: l_okl_subsidy_pools_b_pk okl_subsidy_pools_b_pk_csr%ROWTYPE;

409: LAST_UPDATE_DATE,
410: LAST_UPDATE_LOGIN
411: FROM Okl_Subsidy_Pools_B
412: WHERE okl_subsidy_pools_b.id = p_id;
413: l_okl_subsidy_pools_b_pk okl_subsidy_pools_b_pk_csr%ROWTYPE;
414: l_sip_rec sip_rec_type;
415: BEGIN
416: x_no_data_found := TRUE;
417: -- Get current database values

Line 418: OPEN okl_subsidy_pools_b_pk_csr (p_sip_rec.id);

414: l_sip_rec sip_rec_type;
415: BEGIN
416: x_no_data_found := TRUE;
417: -- Get current database values
418: OPEN okl_subsidy_pools_b_pk_csr (p_sip_rec.id);
419: FETCH okl_subsidy_pools_b_pk_csr INTO
420: l_sip_rec.id,
421: l_sip_rec.object_version_number,
422: l_sip_rec.pool_type_code,

Line 419: FETCH okl_subsidy_pools_b_pk_csr INTO

415: BEGIN
416: x_no_data_found := TRUE;
417: -- Get current database values
418: OPEN okl_subsidy_pools_b_pk_csr (p_sip_rec.id);
419: FETCH okl_subsidy_pools_b_pk_csr INTO
420: l_sip_rec.id,
421: l_sip_rec.object_version_number,
422: l_sip_rec.pool_type_code,
423: l_sip_rec.subsidy_pool_name,

Line 455: x_no_data_found := okl_subsidy_pools_b_pk_csr%NOTFOUND;

451: l_sip_rec.creation_date,
452: l_sip_rec.last_updated_by,
453: l_sip_rec.last_update_date,
454: l_sip_rec.last_update_login;
455: x_no_data_found := okl_subsidy_pools_b_pk_csr%NOTFOUND;
456: CLOSE okl_subsidy_pools_b_pk_csr;
457: RETURN(l_sip_rec);
458: END get_rec;
459:

Line 456: CLOSE okl_subsidy_pools_b_pk_csr;

452: l_sip_rec.last_updated_by,
453: l_sip_rec.last_update_date,
454: l_sip_rec.last_update_login;
455: x_no_data_found := okl_subsidy_pools_b_pk_csr%NOTFOUND;
456: CLOSE okl_subsidy_pools_b_pk_csr;
457: RETURN(l_sip_rec);
458: END get_rec;
459:
460: ------------------------------------------------------------------

Line 760: from okl_subsidy_pools_b sub

756: p_id IN NUMBER) IS
757:
758: cursor c_record_exists is
759: select 1
760: from okl_subsidy_pools_b sub
761: where sub.id = p_id
762: ;
763:
764: cursor c_unique_insert is

Line 766: from okl_subsidy_pools_b sub

762: ;
763:
764: cursor c_unique_insert is
765: select 1
766: from okl_subsidy_pools_b sub
767: where sub.subsidy_pool_name = p_name
768: ;
769:
770: cursor c_unique_update is

Line 772: from okl_subsidy_pools_b sub

768: ;
769:
770: cursor c_unique_update is
771: select 1
772: from okl_subsidy_pools_b sub
773: where sub.id <> p_id
774: and sub.subsidy_pool_name = p_name
775: ;
776:

Line 871: lv_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;

867: SELECT '1'
868: FROM fnd_lookups
869: WHERE lookup_type = 'OKL_SUBSIDY_POOL_STATUS'
870: AND lookup_code = p_decision_status_code ;
871: lv_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
872: BEGIN
873: x_return_status := OKL_API.G_RET_STS_SUCCESS;
874: IF(p_decision_status_code IS NOT NULL)THEN
875: OPEN c_get_pool_stat_csr; FETCH c_get_pool_stat_csr INTO lv_pool_status;

Line 932: CURSOR c_record_exists (cp_pool_id IN okl_subsidy_pools_b.subsidy_pool_id%type) IS

928: PROCEDURE validate_reporting_pool_id(
929: x_return_status OUT NOCOPY VARCHAR2,
930: p_sipv_rec IN sipv_rec_type) IS
931:
932: CURSOR c_record_exists (cp_pool_id IN okl_subsidy_pools_b.subsidy_pool_id%type) IS
933: SELECT subsidy_pool_id
934: FROM okl_subsidy_pools_v
935: WHERE id = cp_pool_id ;
936:

Line 937: CURSOR c_pool_name(cp_pool_id IN okl_subsidy_pools_b.subsidy_pool_id%type) IS

933: SELECT subsidy_pool_id
934: FROM okl_subsidy_pools_v
935: WHERE id = cp_pool_id ;
936:
937: CURSOR c_pool_name(cp_pool_id IN okl_subsidy_pools_b.subsidy_pool_id%type) IS
938: SELECT subsidy_pool_name
939: FROM okl_subsidy_pools_v
940: WHERE id = cp_pool_id;
941:

Line 1060: FROM okl_subsidy_pools_b

1056: -- cursor to fetch the pool type code of the pool which is
1057: -- defined as a parent pool of the current pool.
1058: CURSOR c_get_pool_type_csr IS
1059: SELECT pool_type_code
1060: FROM okl_subsidy_pools_b
1061: WHERE id = p_subsidy_pool_id;
1062: lv_pool_type okl_subsidy_pools_b.pool_type_code%TYPE;
1063: BEGIN
1064: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1062: lv_pool_type okl_subsidy_pools_b.pool_type_code%TYPE;

1058: CURSOR c_get_pool_type_csr IS
1059: SELECT pool_type_code
1060: FROM okl_subsidy_pools_b
1061: WHERE id = p_subsidy_pool_id;
1062: lv_pool_type okl_subsidy_pools_b.pool_type_code%TYPE;
1063: BEGIN
1064: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1065: IF(p_subsidy_pool_id IS NOT NULL)THEN
1066: OPEN c_get_pool_type_csr; FETCH c_get_pool_type_csr INTO lv_pool_type;

Line 1637: -- insert_row for:OKL_SUBSIDY_POOLS_B --

1633: ---------------------------------------------------------------------------
1634: -- PROCEDURE insert_row
1635: ---------------------------------------------------------------------------
1636: ----------------------------------------
1637: -- insert_row for:OKL_SUBSIDY_POOLS_B --
1638: ----------------------------------------
1639: PROCEDURE insert_row(
1640: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1641: x_return_status OUT NOCOPY VARCHAR2,

Line 1653: -- Set_Attributes for:OKL_SUBSIDY_POOLS_B --

1649: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1650: l_sip_rec sip_rec_type := p_sip_rec;
1651: l_def_sip_rec sip_rec_type;
1652: --------------------------------------------
1653: -- Set_Attributes for:OKL_SUBSIDY_POOLS_B --
1654: --------------------------------------------
1655: FUNCTION Set_Attributes (
1656: p_sip_rec IN sip_rec_type,
1657: x_sip_rec OUT NOCOPY sip_rec_type

Line 1684: INSERT INTO OKL_SUBSIDY_POOLS_B(

1680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1681: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1682: RAISE OKL_API.G_EXCEPTION_ERROR;
1683: END IF;
1684: INSERT INTO OKL_SUBSIDY_POOLS_B(
1685: id,
1686: object_version_number,
1687: pool_type_code,
1688: subsidy_pool_name,

Line 2238: -- lock_row for:OKL_SUBSIDY_POOLS_B --

2234: ---------------------------------------------------------------------------
2235: -- PROCEDURE lock_row
2236: ---------------------------------------------------------------------------
2237: --------------------------------------
2238: -- lock_row for:OKL_SUBSIDY_POOLS_B --
2239: --------------------------------------
2240: PROCEDURE lock_row(
2241: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2242: x_return_status OUT NOCOPY VARCHAR2,

Line 2251: FROM OKL_SUBSIDY_POOLS_B

2247: E_Resource_Busy EXCEPTION;
2248: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2249: CURSOR lock_csr (p_sip_rec IN sip_rec_type) IS
2250: SELECT OBJECT_VERSION_NUMBER
2251: FROM OKL_SUBSIDY_POOLS_B
2252: WHERE ID = p_sip_rec.id
2253: AND OBJECT_VERSION_NUMBER = p_sip_rec.object_version_number
2254: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2255:

Line 2258: FROM OKL_SUBSIDY_POOLS_B

2254: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2255:
2256: CURSOR lchk_csr (p_sip_rec IN sip_rec_type) IS
2257: SELECT OBJECT_VERSION_NUMBER
2258: FROM OKL_SUBSIDY_POOLS_B
2259: WHERE ID = p_sip_rec.id;
2260: l_api_version CONSTANT NUMBER := 1;
2261: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2262: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2263: l_object_version_number OKL_SUBSIDY_POOLS_B.OBJECT_VERSION_NUMBER%TYPE;

2259: WHERE ID = p_sip_rec.id;
2260: l_api_version CONSTANT NUMBER := 1;
2261: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2262: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2263: l_object_version_number OKL_SUBSIDY_POOLS_B.OBJECT_VERSION_NUMBER%TYPE;
2264: lc_object_version_number OKL_SUBSIDY_POOLS_B.OBJECT_VERSION_NUMBER%TYPE;
2265: l_row_notfound BOOLEAN := FALSE;
2266: lc_row_notfound BOOLEAN := FALSE;
2267: BEGIN

Line 2264: lc_object_version_number OKL_SUBSIDY_POOLS_B.OBJECT_VERSION_NUMBER%TYPE;

2260: l_api_version CONSTANT NUMBER := 1;
2261: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2262: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2263: l_object_version_number OKL_SUBSIDY_POOLS_B.OBJECT_VERSION_NUMBER%TYPE;
2264: lc_object_version_number OKL_SUBSIDY_POOLS_B.OBJECT_VERSION_NUMBER%TYPE;
2265: l_row_notfound BOOLEAN := FALSE;
2266: lc_row_notfound BOOLEAN := FALSE;
2267: BEGIN
2268: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2685: -- update_row for:OKL_SUBSIDY_POOLS_B --

2681: ---------------------------------------------------------------------------
2682: -- PROCEDURE update_row
2683: ---------------------------------------------------------------------------
2684: ----------------------------------------
2685: -- update_row for:OKL_SUBSIDY_POOLS_B --
2686: ----------------------------------------
2687: PROCEDURE update_row(
2688: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2689: x_return_status OUT NOCOPY VARCHAR2,

Line 2860: -- Set_Attributes for:OKL_SUBSIDY_POOLS_B --

2856: END IF;
2857: RETURN(l_return_status);
2858: END populate_new_record;
2859: --------------------------------------------
2860: -- Set_Attributes for:OKL_SUBSIDY_POOLS_B --
2861: --------------------------------------------
2862: FUNCTION Set_Attributes (
2863: p_sip_rec IN sip_rec_type,
2864: x_sip_rec OUT NOCOPY sip_rec_type

Line 2898: UPDATE OKL_SUBSIDY_POOLS_B

2894: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2895: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2896: RAISE OKL_API.G_EXCEPTION_ERROR;
2897: END IF;
2898: UPDATE OKL_SUBSIDY_POOLS_B
2899: SET OBJECT_VERSION_NUMBER = l_def_sip_rec.object_version_number,
2900: POOL_TYPE_CODE = l_def_sip_rec.pool_type_code,
2901: SUBSIDY_POOL_NAME = l_def_sip_rec.subsidy_pool_name,
2902: EFFECTIVE_FROM_DATE = l_def_sip_rec.effective_from_date,

Line 3655: -- delete_row for:OKL_SUBSIDY_POOLS_B --

3651: ---------------------------------------------------------------------------
3652: -- PROCEDURE delete_row
3653: ---------------------------------------------------------------------------
3654: ----------------------------------------
3655: -- delete_row for:OKL_SUBSIDY_POOLS_B --
3656: ----------------------------------------
3657: PROCEDURE delete_row(
3658: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3659: x_return_status OUT NOCOPY VARCHAR2,

Line 3680: DELETE FROM OKL_SUBSIDY_POOLS_B

3676: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3677: RAISE OKL_API.G_EXCEPTION_ERROR;
3678: END IF;
3679:
3680: DELETE FROM OKL_SUBSIDY_POOLS_B
3681: WHERE ID = p_sip_rec.id;
3682:
3683: x_return_status := l_return_status;
3684: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);