APPS.IGI_BUD dependencies on IGI_BUD_JOURNAL_PERIODS

Line 154: This Procedure creates entries in IGI_BUD_JOURNAL_PERIODS and

150: RETURN false;
151: END;
152:
153: /* ========================================================================
154: This Procedure creates entries in IGI_BUD_JOURNAL_PERIODS and
155: GL_INTERFACE for each balanced entry into IGI_BUD_JOURNAL_LINES.
156: Inputs: Batch_ID The Batch ID of the line.
157: Header_ID The Header ID of the line.
158: Line_Number The Line Number of the line.

Line 202: , IGI_BUD_JOURNAL_PERIODS jubjl

198: CURSOR totals_nyb IS
199: SELECT sum(nvl(jupp.period_ratio,0)) total
200: , max(nvl(jubjl.period_number,0))
201: FROM IGI_BUD_PROFILE_PERIODS jupp
202: , IGI_BUD_JOURNAL_PERIODS jubjl
203: WHERE jupp.PROFILE_CODE = p_profile_code
204: AND jupp.SET_OF_BOOKS_ID = p_sob_id
205: AND jubjl.BE_BATCH_ID = p_batch_id
206: AND jubjl.BE_HEADER_ID = p_header_id

Line 214: , IGI_BUD_JOURNAL_PERIODS jubjl

210: CURSOR periods_nyb IS
211: SELECT jubjl.period_number
212: , period_ratio
213: FROM IGI_BUD_PROFILE_PERIODS jupp
214: , IGI_BUD_JOURNAL_PERIODS jubjl
215: WHERE jupp.PROFILE_CODE = p_profile_code
216: AND jupp.SET_OF_BOOKS_ID = p_sob_id
217: AND jupp.PERIOD_NUMBER = jubjl.PERIOD_NUMBER
218: AND jubjl.BE_BATCH_ID = p_batch_id

Line 283: INSERT INTO IGI_BUD_JOURNAL_PERIODS

279: );
280: */
281:
282: IF p_period_amount <> 0 THEN
283: INSERT INTO IGI_BUD_JOURNAL_PERIODS
284: ( BE_BATCH_ID
285: , BE_HEADER_ID
286: , BE_LINE_NUM
287: , PERIOD_NUMBER

Line 324: UPDATE IGI_BUD_JOURNAL_PERIODS

320: * nyb.period_ratio)
321: * sign(p_next_year_budget);
322: l_amount := l_amount + l_nyb_amt;
323:
324: UPDATE IGI_BUD_JOURNAL_PERIODS
325: SET NEXT_YEAR_BUDGET = l_nyb_amt
326: WHERE PERIOD_NUMBER = nyb.period_number
327: AND BE_BATCH_ID = p_batch_id
328: AND BE_HEADER_ID = p_header_id

Line 331: UPDATE IGI_BUD_JOURNAL_PERIODS

327: AND BE_BATCH_ID = p_batch_id
328: AND BE_HEADER_ID = p_header_id
329: AND BE_LINE_NUM = p_line_number;
330: ELSE
331: UPDATE IGI_BUD_JOURNAL_PERIODS
332: SET NEXT_YEAR_BUDGET =
333: p_next_year_budget - l_amount
334: WHERE PERIOD_NUMBER = nyb.period_number
335: AND BE_BATCH_ID = p_batch_id

Line 415: , IGI_BUD_JOURNAL_PERIODS jubjp

411: , jubjh.BE_HEADER_ID
412: , p_line_number
413: FROM IGI_BUD_JOURNAL_BATCHES jubjb
414: , IGI_BUD_JOURNAL_HEADERS jubjh
415: , IGI_BUD_JOURNAL_PERIODS jubjp
416: , GL_JE_CATEGORIES gjc
417: WHERE jubjb.BE_BATCH_ID = p_batch_id
418: AND jubjh.BE_HEADER_ID = p_header_id
419: AND jubjp.BE_HEADER_ID = p_header_id