APPS.ARP_IER_PKG dependencies on RA_ITEM_EXCEPTION_RATES

Line 30: From RA_item_exception_rates

26:
27: -- Get Exception with overlapping date
28: CURSOR Sel_Date_Overlap IS
29: Select 1
30: From RA_item_exception_rates
31: Where item_id = p_item_id
32: And nvl(location_id_segment_1,0) =
33: nvl(p_location_id_segment_1,0)
34: And nvl(location_id_segment_2,0) =

Line 145: CURSOR C IS SELECT rowid FROM RA_ITEM_EXCEPTION_RATES

141: p_Location_Id_Segment_9 NUMBER,
142: p_Location_Id_Segment_10 NUMBER,
143: p_org_id NUMBER DEFAULT -1 -- Bug 3098063
144: ) IS
145: CURSOR C IS SELECT rowid FROM RA_ITEM_EXCEPTION_RATES
146: WHERE item_exception_rate_id = p_Item_Exception_Rate_Id;
147: CURSOR C2 IS SELECT ra_item_exception_rates_s.nextval FROM dual;
148: BEGIN
149:

Line 147: CURSOR C2 IS SELECT ra_item_exception_rates_s.nextval FROM dual;

143: p_org_id NUMBER DEFAULT -1 -- Bug 3098063
144: ) IS
145: CURSOR C IS SELECT rowid FROM RA_ITEM_EXCEPTION_RATES
146: WHERE item_exception_rate_id = p_Item_Exception_Rate_Id;
147: CURSOR C2 IS SELECT ra_item_exception_rates_s.nextval FROM dual;
148: BEGIN
149:
150: -- Check if Effective Dates overlap.
151: --

Line 166: INSERT INTO RA_ITEM_EXCEPTION_RATES(

162: FETCH C2 INTO p_Item_Exception_Rate_Id;
163: CLOSE C2;
164: end if;
165:
166: INSERT INTO RA_ITEM_EXCEPTION_RATES(
167:
168: item_exception_rate_id,
169: creation_date,
170: created_by,

Line 383: FROM RA_ITEM_EXCEPTION_RATES

379: p_Location_Id_Segment_10 NUMBER
380: ) IS
381: CURSOR C IS
382: SELECT *
383: FROM RA_ITEM_EXCEPTION_RATES
384: WHERE rowid = p_Rowid
385: FOR UPDATE of Item_Exception_Rate_Id NOWAIT;
386: Recinfo C%ROWTYPE;
387:

Line 594: UPDATE RA_ITEM_EXCEPTION_RATES

590: arp_util.debug('Update_Row: ' || '-- Updating Row');
591: arp_util.debug('Update_Row: ' || '-- p_Rowid = '||p_Rowid);
592: END IF;
593:
594: UPDATE RA_ITEM_EXCEPTION_RATES
595: SET
596: item_exception_rate_id = p_Item_Exception_Rate_Id,
597: last_update_login = p_Last_Update_Login,
598: last_updated_by = p_Last_Updated_By,

Line 710: DELETE FROM RA_ITEM_EXCEPTION_RATES

706:
707:
708: PROCEDURE Delete_Row(p_Rowid VARCHAR2) IS
709: BEGIN
710: DELETE FROM RA_ITEM_EXCEPTION_RATES
711: WHERE rowid = p_Rowid;
712:
713: if (SQL%NOTFOUND) then
714: Raise NO_DATA_FOUND;