APPS.IGI_BUD_PROFILE_PERIODS_PKG dependencies on IGI_BUD_PROFILE_PERIODS

Line 1: PACKAGE BODY IGI_BUD_PROFILE_PERIODS_PKG as

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

Line 28: CURSOR C IS SELECT rowid FROM igi_bud_profile_periods

24: X_Last_Update_Date DATE,
25: X_Last_Updated_By NUMBER,
26: X_Last_Update_Login NUMBER
27: ) IS
28: CURSOR C IS SELECT rowid FROM igi_bud_profile_periods
29: WHERE period_number = X_Period_Number;
30:
31: BEGIN
32:

Line 33: INSERT INTO igi_bud_profile_periods(

29: WHERE period_number = X_Period_Number;
30:
31: BEGIN
32:
33: INSERT INTO igi_bud_profile_periods(
34: profile_code,
35: set_of_books_id,
36: period_number,
37: period_ratio,

Line 73: FROM igi_bud_profile_periods

69: X_Period_Ratio NUMBER
70: ) IS
71: CURSOR C IS
72: SELECT *
73: FROM igi_bud_profile_periods
74: WHERE rowid = X_Rowid
75: FOR UPDATE of Period_Number NOWAIT;
76: Recinfo C%ROWTYPE;
77:

Line 125: UPDATE igi_bud_profile_periods

121: X_Last_Update_Login NUMBER
122:
123: ) IS
124: BEGIN
125: UPDATE igi_bud_profile_periods
126: SET
127: profile_code = X_Profile_Code,
128: set_of_books_id = X_Set_Of_Books_Id,
129: period_number = X_Period_Number,

Line 142: DELETE FROM igi_bud_profile_periods

138: end if;
139: END Update_Row;
140: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
141: BEGIN
142: DELETE FROM igi_bud_profile_periods
143: WHERE rowid = X_Rowid;
144:
145: if (SQL%NOTFOUND) then
146: Raise NO_DATA_FOUND;

Line 151: END IGI_BUD_PROFILE_PERIODS_PKG;

147: end if;
148: END Delete_Row;
149:
150:
151: END IGI_BUD_PROFILE_PERIODS_PKG;