APPS.IGI_BUD_JOURNAL_LINES_PKG dependencies on IGI_BUD_JOURNAL_LINES

Line 1: PACKAGE BODY IGI_BUD_JOURNAL_LINES_PKG as

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

Line 39: CURSOR C IS SELECT rowid FROM IGI_BUD_JOURNAL_LINES

35: X_Last_Update_Date DATE,
36: X_Last_Updated_By NUMBER,
37: X_Last_Update_Login NUMBER
38: ) IS
39: CURSOR C IS SELECT rowid FROM IGI_BUD_JOURNAL_LINES
40: WHERE be_header_id = X_Be_Header_Id
41: AND be_line_num = X_Be_Line_Num;
42:
43: BEGIN

Line 46: INSERT INTO IGI_BUD_JOURNAL_LINES(

42:
43: BEGIN
44:
45:
46: INSERT INTO IGI_BUD_JOURNAL_LINES(
47: be_batch_id,
48: be_header_id,
49: be_line_num,
50: set_of_books_id,

Line 120: FROM IGI_BUD_JOURNAL_LINES

116: X_Recurring_Entry VARCHAR2
117: ) IS
118: CURSOR C IS
119: SELECT *
120: FROM IGI_BUD_JOURNAL_LINES
121: WHERE rowid = X_Rowid
122: FOR UPDATE of Be_Header_Id NOWAIT;
123: Recinfo C%ROWTYPE;
124:

Line 134: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journal_lines_pkg.lock_row.Msg1',FALSE);

130: CLOSE C;
131: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
132: --Bug 3199481 (start)
133: If (l_unexp_level >= l_debug_level) then
134: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journal_lines_pkg.lock_row.Msg1',FALSE);
135: End if;
136: --Bug 3199481 (End)
137: APP_EXCEPTION.Raise_Exception;
138: end if;

Line 211: UPDATE IGI_BUD_JOURNAL_LINES

207: X_Last_Update_Login NUMBER
208:
209: ) IS
210: BEGIN
211: UPDATE IGI_BUD_JOURNAL_LINES
212: SET
213: be_batch_id = X_Be_Batch_Id,
214: be_header_id = X_Be_Header_Id,
215: be_line_num = X_Be_Line_Num,

Line 249: DELETE FROM IGI_BUD_JOURNAL_LINES

245: where p.be_header_id = X_Be_Header_Id
246: and p.be_line_num = X_Be_Line_Num;
247:
248: BEGIN
249: DELETE FROM IGI_BUD_JOURNAL_LINES
250: WHERE rowid = X_Rowid;
251:
252: for periods in related_periods loop
253: igi_bud_journal_periods_pkg.delete_row(periods.row_id);

Line 262: END IGI_BUD_JOURNAL_LINES_PKG;

258: end if;
259: END Delete_Row;
260:
261:
262: END IGI_BUD_JOURNAL_LINES_PKG;