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.IGI_BUD dependencies on IGI_BUD

Line 1: PACKAGE BODY IGI_BUD AS

1: PACKAGE BODY IGI_BUD AS
2: -- $Header: igibudab.pls 120.5.12000000.2 2007/08/01 08:49:58 pshivara ship $
3:
4: /* ===============================================================
5: This function checks is a column is numeric or not

Line 56: FROM igi_bud_profile_periods

52: ( p_first_period NUMBER
53: , p_last_period NUMBER
54: ) IS
55: SELECT period_ratio
56: FROM igi_bud_profile_periods
57: WHERE profile_code = p_profile_code
58: AND set_of_books_id = p_Set_Of_Books_Id
59: AND period_number BETWEEN
60: p_first_period AND p_last_period

Line 77: FROM igi_bud_profile_periods

73: SELECT max(period_number)
74: , sum(period_ratio)
75: INTO l_Max_Period_Number
76: , l_Total_Ratio
77: FROM igi_bud_profile_periods
78: WHERE profile_code = p_Profile_Code
79: AND set_of_books_id = p_Set_Of_Books_Id
80: AND period_number BETWEEN p_Start_Period
81: AND decode(p_Max_Period_Number

Line 140: FROM igi_bud_profile_codes pc

136: x NUMBER;
137: BEGIN
138: SELECT 1
139: INTO x
140: FROM igi_bud_profile_codes pc
141: WHERE pc.set_of_books_id = p_set_of_books_id
142: AND pc.profile_code = p_profile_code
143: AND nvl(pc.start_date_active, sysdate-1) <= sysdate
144: AND nvl(pc.end_date_active, sysdate+1) > sysdate;

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 155: GL_INTERFACE for each balanced entry into IGI_BUD_JOURNAL_LINES.

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.
159: SOB_ID The Set Of Books ID

Line 194: FROM IGI_BUD_PROFILE_PERIODS jupp

190: p_period_type VARCHAR2(30);
191:
192: CURSOR periods IS
193: SELECT period_number,period_ratio
194: FROM IGI_BUD_PROFILE_PERIODS jupp
195: WHERE jupp.PROFILE_CODE = p_profile_code
196: AND jupp.SET_OF_BOOKS_ID = p_sob_id;
197:
198: CURSOR totals_nyb IS

Line 201: FROM IGI_BUD_PROFILE_PERIODS jupp

197:
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

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 213: FROM IGI_BUD_PROFILE_PERIODS jupp

209:
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

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 263: p_period_amount := IGI_BUD.bud_period_amount

259: AND gp.PERIOD_YEAR = p_period_year
260: AND gp.PERIOD_TYPE = p_period_type
261: AND gp.PERIOD_NUM = period.period_number;
262:
263: p_period_amount := IGI_BUD.bud_period_amount
264: ( NVL(p_entered_dr,0) - NVL(p_entered_cr,0)
265: , period.period_number
266: , p_start_period_number
267: , p_profile_code

Line 272: p_period_nyb := IGI_BUD.bud_period_amount

268: , p_sob_id
269: , 0
270: );
271: /*
272: p_period_nyb := IGI_BUD.bud_period_amount
273: ( nvl(p_next_year_budget,0)
274: , period.period_number
275: , p_start_period_number
276: , p_profile_code

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 403: , 'IGIGBUDPR'

399: , jubjh.NAME
400: , jubjh.DESCRIPTION
401: , 'N'
402: , p_description
403: , 'IGIGBUDPR'
404: , jubjb.BE_BATCH_ID
405: , p_profile_code
406: , p_reason_code
407: , p_start_period

Line 413: FROM IGI_BUD_JOURNAL_BATCHES jubjb

409: , p_effect
410: , jubjp.NEXT_YEAR_BUDGET
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

Line 414: , IGI_BUD_JOURNAL_HEADERS jubjh

410: , jubjp.NEXT_YEAR_BUDGET
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

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

Line 582: This proceedure updates or inserts into igi_bud_profile_defaults

578: RETURN (r_where_list);
579: END; -- Of flexsql_range
580:
581: /* ==================================================================
582: This proceedure updates or inserts into igi_bud_profile_defaults
583: Parameters: Valid Code Combination ID
584: Valid Set of Books ID
585: Valid Profile Code */
586:

Line 596: UPDATE igi_bud_profile_defaults

592: IS
593: err_msg VARCHAR2(240);
594: BEGIN
595: IF p_new_profile_code is NOT NULL THEN
596: UPDATE igi_bud_profile_defaults
597: SET latest_profile_code = p_new_profile_code
598: WHERE code_combination_id = p_code_combination_id
599: AND set_of_books_id = p_set_of_books_id;
600:

Line 602: INSERT INTO igi_bud_profile_defaults

598: WHERE code_combination_id = p_code_combination_id
599: AND set_of_books_id = p_set_of_books_id;
600:
601: IF SQL%NOTFOUND THEN -- No row to update so
602: INSERT INTO igi_bud_profile_defaults
603: ( code_combination_id
604: , set_of_books_id
605: , primary_profile_code
606: , latest_profile_code

Line 635: FND_LOG.MESSAGE(fnd_log.level_unexpected,'igi.plsql.igi_bud.bud_profile_default.Msg1',TRUE);

631: If (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
632: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
633: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
634: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
635: FND_LOG.MESSAGE(fnd_log.level_unexpected,'igi.plsql.igi_bud.bud_profile_default.Msg1',TRUE);
636: End if;
637: --Bug 3199481 (end)
638: raise_application_error (-20000, err_msg);
639:

Line 642: This proceedure updates or inserts igi_bud_ny_balances

638: raise_application_error (-20000, err_msg);
639:
640: END; -- Of bud_profile_default
641: /* =============================================================
642: This proceedure updates or inserts igi_bud_ny_balances
643: Parameters: JE_HEADER_ID of Posted Budget Journal */
644:
645: PROCEDURE bud_next_year_budget
646: ( p_je_header_id NUMBER

Line 666: INSERT INTO IGI_BUD_NY_BALANCES

662: l_line_reference_3 gl_je_lines.reference_3%type;
663: BEGIN
664: FOR line IN lines LOOP
665: BEGIN
666: INSERT INTO IGI_BUD_NY_BALANCES
667: ( SET_OF_BOOKS_ID
668: , CODE_COMBINATION_ID
669: , BUDGET_VERSION_ID
670: , PERIOD_NAME

Line 703: UPDATE IGI_BUD_NY_BALANCES nyb

699: FROM GL_JE_LINES
700: WHERE JE_HEADER_ID = p_je_header_id
701: AND JE_LINE_NUM = line.JE_LINE_NUM;
702:
703: UPDATE IGI_BUD_NY_BALANCES nyb
704: SET NEXT_YEAR_BUDGET =
705: (SELECT nyb.NEXT_YEAR_BUDGET +
706: NVL(gjl.REFERENCE_8,0)
707: FROM GL_JE_LINES gjl

Line 731: FND_LOG.MESSAGE(fnd_log.level_unexpected,'igi.plsql.igi_bud.bud_next_year_budget.Msg1',TRUE);

727: If (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
728: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
729: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
730: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
731: FND_LOG.MESSAGE(fnd_log.level_unexpected,'igi.plsql.igi_bud.bud_next_year_budget.Msg1',TRUE);
732: End if;
733: --Bug 3199481 (End)
734: raise_application_error(-20002,'Value Error Occurred');
735: WHEN others THEN

Line 741: FND_LOG.MESSAGE(fnd_log.level_unexpected,'igi.plsql.igi_bud.bud_next_year_budget.Msg2',TRUE);

737: If (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
738: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
739: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
740: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
741: FND_LOG.MESSAGE(fnd_log.level_unexpected,'igi.plsql.igi_bud.bud_next_year_budget.Msg2',TRUE);
742: End if;
743: --Bug 3199481 (End)
744: raise_application_error(-20003,SQLERRM);
745: END;

Line 755: FROM igi_bud_profile_codes

751: WHERE line.reference_3 <> 'MANUAL'
752: AND line.reference_3 is not null
753: AND line.reference_3 not in (
754: SELECT profile_code
755: FROM igi_bud_profile_codes
756: WHERE set_of_books_id = p_set_of_books_id
757: AND sysdate >= nvl(start_date_Active,sysdate-1)
758: AND sysdate <= nvl(end_date_active,sysdate+1));
759:

Line 766: IGI_BUD.bud_profile_default

762: END;
763:
764: IF l_line_reference_3 <> 'MANUAL'
765: AND l_line_reference_3 IS NOT NULL THEN
766: IGI_BUD.bud_profile_default
767: ( line.CODE_COMBINATION_ID
768: , p_set_of_books_id
769: , line.REFERENCE_3);
770: END IF;