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_DRA_PVT dependencies on OKL_DISB_RULES_B

Line 205: FROM OKL_DISB_RULES_B B

201: WHERE NOT EXISTS (
202:
203: SELECT NULL
204:
205: FROM OKL_DISB_RULES_B B
206:
207: WHERE B.DISB_RULE_ID =T.DISB_RULE_ID
208:
209: );

Line 680: -- FUNCTION get_rec for: OKL_DISB_RULES_B

676: END get_rec;
677:
678: ---------------------------------------------------------------------------
679:
680: -- FUNCTION get_rec for: OKL_DISB_RULES_B
681:
682: ---------------------------------------------------------------------------
683:
684: FUNCTION get_rec (

Line 768: FROM Okl_Disb_Rules_B

764: LAST_UPDATE_DATE,
765:
766: LAST_UPDATE_LOGIN
767:
768: FROM Okl_Disb_Rules_B
769:
770: WHERE okl_disb_rules_b.disb_rule_id = p_disb_rule_id;
771:
772: l_okl_dra_pk okl_dra_pk_csr%ROWTYPE;

Line 770: WHERE okl_disb_rules_b.disb_rule_id = p_disb_rule_id;

766: LAST_UPDATE_LOGIN
767:
768: FROM Okl_Disb_Rules_B
769:
770: WHERE okl_disb_rules_b.disb_rule_id = p_disb_rule_id;
771:
772: l_okl_dra_pk okl_dra_pk_csr%ROWTYPE;
773:
774: l_dra_rec dra_rec_type;

Line 2408: -- insert_row for:OKL_DISB_RULES_B --

2404: ---------------------------------------------------------------------------
2405:
2406: -------------------------------------
2407:
2408: -- insert_row for:OKL_DISB_RULES_B --
2409:
2410: -------------------------------------
2411:
2412: PROCEDURE insert_row(

Line 2431: -- Set_Attributes for:OKL_DISB_RULES_B --

2427: l_def_dra_rec dra_rec_type;
2428:
2429: -----------------------------------------
2430:
2431: -- Set_Attributes for:OKL_DISB_RULES_B --
2432:
2433: -----------------------------------------
2434:
2435: FUNCTION Set_Attributes (

Line 2475: INSERT INTO OKL_DISB_RULES_B(

2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474:
2475: INSERT INTO OKL_DISB_RULES_B(
2476: disb_rule_id,
2477: object_version_number,
2478: rule_name,
2479: org_id,

Line 2923: -- insert_row for :OKL_DISB_RULES_B --

2919: END insert_row;
2920:
2921: --------------------------------------
2922:
2923: -- insert_row for :OKL_DISB_RULES_B --
2924:
2925: --------------------------------------
2926:
2927: PROCEDURE insert_row(

Line 2995: -- Set_Attributes for:OKL_DISB_RULES_B --

2991: END fill_who_columns;
2992:
2993: -----------------------------------------
2994:
2995: -- Set_Attributes for:OKL_DISB_RULES_B --
2996:
2997: -----------------------------------------
2998:
2999: FUNCTION Set_Attributes (

Line 3584: -- lock_row for:OKL_DISB_RULES_B --

3580: ---------------------------------------------------------------------------
3581:
3582: -----------------------------------
3583:
3584: -- lock_row for:OKL_DISB_RULES_B --
3585:
3586: -----------------------------------
3587:
3588: PROCEDURE lock_row(

Line 3610: FROM OKL_DISB_RULES_B

3606: CURSOR lock_csr (p_dra_rec IN dra_rec_type) IS
3607:
3608: SELECT OBJECT_VERSION_NUMBER
3609:
3610: FROM OKL_DISB_RULES_B
3611:
3612: WHERE DISB_RULE_ID = p_dra_rec.disb_rule_id
3613:
3614: AND OBJECT_VERSION_NUMBER = p_dra_rec.object_version_number

Line 3624: FROM OKL_DISB_RULES_B

3620: CURSOR lchk_csr (p_dra_rec IN dra_rec_type) IS
3621:
3622: SELECT OBJECT_VERSION_NUMBER
3623:
3624: FROM OKL_DISB_RULES_B
3625:
3626: WHERE DISB_RULE_ID = p_dra_rec.disb_rule_id;
3627:
3628: l_api_version CONSTANT NUMBER := 1;

Line 3634: l_object_version_number OKL_DISB_RULES_B.OBJECT_VERSION_NUMBER%TYPE;

3630: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3631:
3632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3633:
3634: l_object_version_number OKL_DISB_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3635:
3636: lc_object_version_number OKL_DISB_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3637:
3638: l_row_notfound BOOLEAN := FALSE;

Line 3636: lc_object_version_number OKL_DISB_RULES_B.OBJECT_VERSION_NUMBER%TYPE;

3632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3633:
3634: l_object_version_number OKL_DISB_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3635:
3636: lc_object_version_number OKL_DISB_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3637:
3638: l_row_notfound BOOLEAN := FALSE;
3639:
3640: lc_row_notfound BOOLEAN := FALSE;

Line 4478: -- update_row for:OKL_DISB_RULES_B --

4474: ---------------------------------------------------------------------------
4475:
4476: -------------------------------------
4477:
4478: -- update_row for:OKL_DISB_RULES_B --
4479:
4480: -------------------------------------
4481:
4482: PROCEDURE update_row(

Line 4754: -- Set_Attributes for:OKL_DISB_RULES_B --

4750: END populate_new_record;
4751:
4752: -----------------------------------------
4753:
4754: -- Set_Attributes for:OKL_DISB_RULES_B --
4755:
4756: -----------------------------------------
4757:
4758: FUNCTION Set_Attributes (

Line 4836: UPDATE OKL_DISB_RULES_B

4832:
4833: --g_debug_proc('In DRA l_def_dra_rec.day_of_month ' || l_def_dra_rec.day_of_month);
4834: --g_debug_proc('In DRA l_def_dra_rec.scheduled_month ' || l_def_dra_rec.scheduled_month);
4835:
4836: UPDATE OKL_DISB_RULES_B
4837:
4838: SET OBJECT_VERSION_NUMBER = l_def_dra_rec.object_version_number,
4839:
4840: RULE_NAME = l_def_dra_rec.rule_name,

Line 6187: -- delete_row for:OKL_DISB_RULES_B --

6183: ---------------------------------------------------------------------------
6184:
6185: -------------------------------------
6186:
6187: -- delete_row for:OKL_DISB_RULES_B --
6188:
6189: -------------------------------------
6190:
6191: PROCEDURE delete_row(

Line 6237: DELETE FROM OKL_DISB_RULES_B

6233: END IF;
6234:
6235:
6236:
6237: DELETE FROM OKL_DISB_RULES_B
6238:
6239: WHERE DISB_RULE_ID = p_dra_rec.disb_rule_id;
6240:
6241: