APPS.IGI_BUD_JOURNAL_HEADERS_PKG dependencies on IGI_BUD_JOURNAL_HEADERS

Line 1: PACKAGE BODY IGI_BUD_JOURNAL_HEADERS_PKG as

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

Line 38: CURSOR C IS SELECT rowid FROM IGI_BUD_JOURNAL_HEADERS

34: X_Last_Update_Date DATE,
35: X_Last_Updated_By NUMBER,
36: X_Last_Update_Login NUMBER
37: ) IS
38: CURSOR C IS SELECT rowid FROM IGI_BUD_JOURNAL_HEADERS
39: WHERE be_header_id = X_Be_Header_Id;
40: CURSOR C2 IS SELECT igi_bud_journal_headers_s.nextval FROM sys.dual;
41: BEGIN
42: if (X_Be_Header_Id is NULL) then

Line 40: CURSOR C2 IS SELECT igi_bud_journal_headers_s.nextval FROM sys.dual;

36: X_Last_Update_Login NUMBER
37: ) IS
38: CURSOR C IS SELECT rowid FROM IGI_BUD_JOURNAL_HEADERS
39: WHERE be_header_id = X_Be_Header_Id;
40: CURSOR C2 IS SELECT igi_bud_journal_headers_s.nextval FROM sys.dual;
41: BEGIN
42: if (X_Be_Header_Id is NULL) then
43: OPEN C2;
44: FETCH C2 INTO X_Be_Header_Id;

Line 48: INSERT INTO IGI_BUD_JOURNAL_HEADERS(

44: FETCH C2 INTO X_Be_Header_Id;
45: CLOSE C2;
46: end if;
47:
48: INSERT INTO IGI_BUD_JOURNAL_HEADERS(
49: be_batch_id,
50: be_header_id,
51: budget_entity_id,
52: budget_version_id,

Line 118: FROM IGI_BUD_JOURNAL_HEADERS

114: X_Description VARCHAR2
115: ) IS
116: CURSOR C IS
117: SELECT *
118: FROM IGI_BUD_JOURNAL_HEADERS
119: WHERE rowid = X_Rowid
120: FOR UPDATE of Be_Header_Id NOWAIT;
121: Recinfo C%ROWTYPE;
122:

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

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

Line 165: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journal_headers_pkg.lock_row.Msg2',FALSE);

161: else
162: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
163: --Bug 3199481 (start)
164: If (l_unexp_level >= l_debug_level) then
165: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journal_headers_pkg.lock_row.Msg2',FALSE);
166: End if;
167: --Bug 3199481 (End)
168: APP_EXCEPTION.Raise_Exception;
169: end if;

Line 195: UPDATE IGI_BUD_JOURNAL_HEADERS

191: X_Last_Update_Login NUMBER
192:
193: ) IS
194: BEGIN
195: UPDATE IGI_BUD_JOURNAL_HEADERS
196: SET
197: be_batch_id = X_Be_Batch_Id,
198: be_header_id = X_Be_Header_Id,
199: budget_entity_id = X_Budget_Entity_Id,

Line 230: DELETE FROM IGI_BUD_JOURNAL_HEADERS

226: from igi_bud_journal_lines l
227: where l.be_header_id = X_Be_Header_Id;
228:
229: BEGIN
230: DELETE FROM IGI_BUD_JOURNAL_HEADERS
231: WHERE rowid = X_Rowid;
232:
233: for lines in related_lines loop
234: igi_bud_journal_lines_pkg.delete_row(lines.row_id,

Line 245: END IGI_BUD_JOURNAL_HEADERS_PKG;

241: end if;
242: END Delete_Row;
243:
244:
245: END IGI_BUD_JOURNAL_HEADERS_PKG;