APPS.IGI_BUD_JOURNAL_PERIODS_PKG dependencies on IGI_BUD_JOURNAL_PERIODS

Line 1: PACKAGE BODY IGI_BUD_JOURNAL_PERIODS_PKG as

1: PACKAGE BODY IGI_BUD_JOURNAL_PERIODS_PKG as
2: -- $Header: igibuddb.pls 120.4 2005/10/30 05:51:39 appldev ship $
3:
4: --Bug 3199481
5:

Line 34: CURSOR C IS SELECT rowid FROM igi_bud_journal_periods

30: X_Last_Update_Date DATE,
31: X_Last_Updated_By NUMBER,
32: X_Last_Update_Login NUMBER
33: ) IS
34: CURSOR C IS SELECT rowid FROM igi_bud_journal_periods
35: WHERE be_header_id = X_Be_Header_Id
36: AND be_line_num = X_Be_Line_Num
37: AND period_name = X_Period_Name;
38:

Line 42: INSERT INTO igi_bud_journal_periods(

38:
39: BEGIN
40:
41:
42: INSERT INTO igi_bud_journal_periods(
43: be_batch_id,
44: be_header_id,
45: be_line_num,
46: period_name,

Line 100: FROM igi_bud_journal_periods

96: X_Next_Year_Budget NUMBER
97: ) IS
98: CURSOR C IS
99: SELECT *
100: FROM igi_bud_journal_periods
101: WHERE rowid = X_Rowid
102: FOR UPDATE of Be_Header_Id NOWAIT;
103: Recinfo C%ROWTYPE;
104:

Line 170: UPDATE igi_bud_journal_periods

166: X_Last_Update_Login NUMBER
167:
168: ) IS
169: BEGIN
170: UPDATE igi_bud_journal_periods
171: SET
172: be_batch_id = X_Be_Batch_Id,
173: be_header_id = X_Be_Header_Id,
174: be_line_num = X_Be_Line_Num,

Line 193: DELETE FROM igi_bud_journal_periods

189: end if;
190: END Update_Row;
191: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
192: BEGIN
193: DELETE FROM igi_bud_journal_periods
194: WHERE rowid = X_Rowid;
195:
196: if (SQL%NOTFOUND) then
197: Raise NO_DATA_FOUND;

Line 202: END IGI_BUD_JOURNAL_PERIODS_PKG;

198: end if;
199: END Delete_Row;
200:
201:
202: END IGI_BUD_JOURNAL_PERIODS_PKG;