APPS.PSB_BUDGET_ACCOUNT_PVT dependencies on PSB_ACCOUNT_POSITION_SETS

Line 25: g_set_of_books_id psb_account_position_sets.set_of_books_id%TYPE;

21: TYPE Active_Segments_tbl_type IS TABLE OF VARCHAR2(10)
22: INDEX BY BINARY_INTEGER;
23:
24: -- To store set of books id for the current set.
25: g_set_of_books_id psb_account_position_sets.set_of_books_id%TYPE;
26:
27: -- To store chart of accounts id for the current set.
28: g_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
29:

Line 39: psb_account_position_sets.max_code_combination_id%TYPE;

35: g_active_segments_tbl Active_Segments_tbl_type;
36:
37: -- To store maximum code combination id for a chart of accounts.
38: g_max_code_combination_id
39: psb_account_position_sets.max_code_combination_id%TYPE;
40:
41: -- To store current account set id.
42: g_account_set_id
43: psb_account_position_sets.account_position_set_id%TYPE;

Line 43: psb_account_position_sets.account_position_set_id%TYPE;

39: psb_account_position_sets.max_code_combination_id%TYPE;
40:
41: -- To store current account set id.
42: g_account_set_id
43: psb_account_position_sets.account_position_set_id%TYPE;
44:
45: --
46: -- WHO columns variables
47: --

Line 118: l_set_of_books_id psb_account_position_sets.set_of_books_id%TYPE ;

114: --
115: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Budget_Accounts' ;
116: l_api_version CONSTANT NUMBER := 1.0;
117: --
118: l_set_of_books_id psb_account_position_sets.set_of_books_id%TYPE ;
119: l_number NUMBER;
120: --
121: BEGIN
122: --

Line 155: -- sets in psb_account_position_sets table.

151: IF ( p_account_set_id = FND_API.G_MISS_NUM ) OR ( p_account_set_id IS NULL)
152: THEN
153: --
154: -- As no parameter is supplied, we have to populate all the account
155: -- sets in psb_account_position_sets table.
156: --
157: FOR l_set_rec IN
158: (
159: SELECT account_position_set_id

Line 160: FROM psb_account_position_sets

156: --
157: FOR l_set_rec IN
158: (
159: SELECT account_position_set_id
160: FROM psb_account_position_sets
161: WHERE account_or_position_type = 'A'
162: AND set_of_books_id = NVL( l_set_of_books_id, set_of_books_id )
163: -- Bug 3458191: Add order by to taking advantage of caching
164: ORDER BY set_of_books_id

Line 310: FROM psb_account_position_sets

306: INTO g_set_of_books_id,
307: g_max_code_combination_id,
308: l_last_maintained_date,
309: l_last_update_date
310: FROM psb_account_position_sets
311: WHERE account_position_set_id = p_account_set_id ;
312:
313: -- Get the chart of accounts for the set_of_books_id.
314: SELECT chart_of_accounts_id INTO g_chart_of_accounts_id

Line 328: -- Lock psb_account_position_sets table to prevent modifications.

324: END IF;
325: END IF;
326:
327: --
328: -- Lock psb_account_position_sets table to prevent modifications.
329: -- Set maintain_status to 'P' (meaning Processing).
330: --
331: UPDATE psb_account_position_sets
332: SET maintain_status = 'C'

Line 331: UPDATE psb_account_position_sets

327: --
328: -- Lock psb_account_position_sets table to prevent modifications.
329: -- Set maintain_status to 'P' (meaning Processing).
330: --
331: UPDATE psb_account_position_sets
332: SET maintain_status = 'C'
333: WHERE account_position_set_id = p_account_set_id;
334:
335: --

Line 383: -- Update max_code_combination_id info in psb_account_position_sets.

379: END IF;
380: END LOOP;
381:
382: --
383: -- Update max_code_combination_id info in psb_account_position_sets.
384: -- Set maintain_status to 'C' (meaning updated from PSBVMBAB module).
385: --
386: UPDATE psb_account_position_sets
387: SET maintain_status = 'C' ,

Line 386: UPDATE psb_account_position_sets

382: --
383: -- Update max_code_combination_id info in psb_account_position_sets.
384: -- Set maintain_status to 'C' (meaning updated from PSBVMBAB module).
385: --
386: UPDATE psb_account_position_sets
387: SET maintain_status = 'C' ,
388: last_maintained_date = g_current_date ,
389: max_code_combination_id =
390: ( SELECT max(code_combination_id)

Line 715: l_account_set_name psb_account_position_sets.name%TYPE;

711: l_msg_data VARCHAR2(2000) ;
712: l_msg_index_out NUMBER;
713: --
714: l_set_of_books_name gl_sets_of_books.name%TYPE;
715: l_account_set_name psb_account_position_sets.name%TYPE;
716: --
717: BEGIN
718: --
719: -- SAVEPOINT Populate_Budget_Acct_CP_Pvt ;

Line 744: FROM psb_account_position_sets

740: FND_FILE.Put_Line( FND_FILE.OUTPUT, 'Account set name : ALL');
741: ELSE
742: --
743: SELECT name INTO l_account_set_name
744: FROM psb_account_position_sets
745: WHERE account_position_set_id = p_account_set_id ;
746: --
747: FND_FILE.Put_Line( FND_FILE.OUTPUT,
748: 'Account set name : ' || l_account_set_name );