DBA Data[Home] [Help]

APPS.IGI_IGI_ITR_LINES_PKG dependencies on IGI_ITR_CHARGE_LINES

Line 34: CURSOR C IS SELECT rowid FROM IGI_itr_charge_lines

30: X_Last_Update_Login NUMBER,
31: X_Last_Update_Date DATE,
32: X_Last_Updated_By NUMBER
33: ) IS
34: CURSOR C IS SELECT rowid FROM IGI_itr_charge_lines
35: WHERE it_header_id = X_It_Header_Id
36: AND it_line_num = X_It_Line_Num;
37:
38: BEGIN

Line 41: INSERT INTO IGI_itr_charge_lines(

37:
38: BEGIN
39:
40:
41: INSERT INTO IGI_itr_charge_lines(
42: it_header_id,
43: it_line_num,
44: set_of_books_id,
45: code_combination_id,

Line 112: FROM IGI_itr_charge_lines

108: ) IS
109:
110: CURSOR C IS
111: SELECT *
112: FROM IGI_itr_charge_lines
113: WHERE rowid = X_Rowid
114: FOR UPDATE of It_Header_Id NOWAIT;
115: Recinfo C%ROWTYPE;
116:

Line 199: UPDATE IGI_itr_charge_lines

195: X_Last_Update_Date DATE,
196: X_Last_Updated_By NUMBER
197: ) IS
198: BEGIN
199: UPDATE IGI_itr_charge_lines
200: SET
201: it_header_id = X_It_Header_Id,
202: it_line_num = X_It_Line_Num,
203: set_of_books_id = X_Set_Of_Books_Id,

Line 227: DELETE FROM IGI_itr_charge_lines

223: END Update_Row;
224:
225: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
226: BEGIN
227: DELETE FROM IGI_itr_charge_lines
228: WHERE rowid = X_Rowid;
229:
230: if (SQL%NOTFOUND) then
231: Raise NO_DATA_FOUND;