APPS.FV_BE_PKG4 dependencies on FV_BUDGET_LEVELS

Line 15: FROM FV_BUDGET_LEVELS

11: v_sequence number := 1;
12:
13: CURSOR C IS
14: SELECT BUDGET_LEVEL_NUM, POST_FLAG
15: FROM FV_BUDGET_LEVELS
16: WHERE FV_BUDGET_LEVELS.SET_OF_BOOKS_ID = x_set_of_books_id
17: ORDER BY BUDGET_LEVEL_NUM
18: FOR UPDATE OF BUDGET_LEVEL_ID;
19:

Line 16: WHERE FV_BUDGET_LEVELS.SET_OF_BOOKS_ID = x_set_of_books_id

12:
13: CURSOR C IS
14: SELECT BUDGET_LEVEL_NUM, POST_FLAG
15: FROM FV_BUDGET_LEVELS
16: WHERE FV_BUDGET_LEVELS.SET_OF_BOOKS_ID = x_set_of_books_id
17: ORDER BY BUDGET_LEVEL_NUM
18: FOR UPDATE OF BUDGET_LEVEL_ID;
19:
20: v_budget_level_num FV_BUDGET_LEVELS.BUDGET_LEVEL_NUM%TYPE;

Line 20: v_budget_level_num FV_BUDGET_LEVELS.BUDGET_LEVEL_NUM%TYPE;

16: WHERE FV_BUDGET_LEVELS.SET_OF_BOOKS_ID = x_set_of_books_id
17: ORDER BY BUDGET_LEVEL_NUM
18: FOR UPDATE OF BUDGET_LEVEL_ID;
19:
20: v_budget_level_num FV_BUDGET_LEVELS.BUDGET_LEVEL_NUM%TYPE;
21: v_post_flag FV_BUDGET_LEVELS.POST_FLAG%TYPE;
22: BEGIN
23:
24: OPEN C;

Line 21: v_post_flag FV_BUDGET_LEVELS.POST_FLAG%TYPE;

17: ORDER BY BUDGET_LEVEL_NUM
18: FOR UPDATE OF BUDGET_LEVEL_ID;
19:
20: v_budget_level_num FV_BUDGET_LEVELS.BUDGET_LEVEL_NUM%TYPE;
21: v_post_flag FV_BUDGET_LEVELS.POST_FLAG%TYPE;
22: BEGIN
23:
24: OPEN C;
25: LOOP

Line 32: UPDATE FV_BUDGET_LEVELS

28:
29: -- EXIT LOOP WHEN THERE ARE NO MORE ROWS TO FETCH
30: EXIT WHEN C%notfound;
31:
32: UPDATE FV_BUDGET_LEVELS
33: SET BUDGET_LEVEL_ID = v_sequence,
34: POST_FLAG = DECODE(v_sequence, 1, 'Y', 2, 'Y', v_post_flag)
35: WHERE CURRENT OF C;
36:

Line 65: from fv_budget_levels

61: begin
62:
63: select description
64: into x_description
65: from fv_budget_levels
66: where budget_level_id = x_budget_level_id
67: and set_of_books_id = x_set_of_bks_id ;
68:
69: exception

Line 163: from fv_budget_levels fvbl

159: l_errbuf VARCHAR2(1024);
160:
161: CURSOR je_category_cur IS
162: select fvbl.description
163: from fv_budget_levels fvbl
164: where fvbl.set_of_books_id = P_SET_OF_BKS_ID
165: and not exists (
166: select glc.je_category_name
167: from gl_je_categories glc