APPS.IGI_DUN_CUST_LET_SET_CUR_PKG dependencies on IGI_DUN_CUST_LETTER_SET_CUR

Line 23: CURSOR C IS SELECT rowid FROM igi_dun_cust_letter_set_cur

19: X_Last_Update_Date DATE,
20: X_Last_Update_Login NUMBER
21:
22: ) IS
23: CURSOR C IS SELECT rowid FROM igi_dun_cust_letter_set_cur
24: WHERE customer_profile_id = X_Customer_Profile_Id
25: AND currency_code = X_Currency_Code;
26:
27: BEGIN

Line 29: INSERT INTO igi_dun_cust_letter_set_cur(

25: AND currency_code = X_Currency_Code;
26:
27: BEGIN
28:
29: INSERT INTO igi_dun_cust_letter_set_cur(
30: customer_profile_id,
31: currency_code,
32: created_by,
33: creation_date,

Line 62: FROM igi_dun_cust_letter_set_cur

58:
59: ) IS
60: CURSOR C IS
61: SELECT *
62: FROM igi_dun_cust_letter_set_cur
63: WHERE rowid = X_Rowid
64: FOR UPDATE of Customer_Profile_Id NOWAIT;
65: Recinfo C%ROWTYPE;
66:

Line 107: UPDATE igi_dun_cust_letter_set_cur

103: X_Last_Update_Login NUMBER
104:
105: ) IS
106: BEGIN
107: UPDATE igi_dun_cust_letter_set_cur
108: SET
109: customer_profile_id = X_Customer_Profile_Id,
110: currency_code = X_Currency_Code,
111: last_updated_by = X_Last_Updated_By,

Line 123: DELETE FROM igi_dun_cust_letter_set_cur

119: END Update_Row;
120:
121: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
122: BEGIN
123: DELETE FROM igi_dun_cust_letter_set_cur
124: WHERE rowid = X_Rowid;
125:
126: if (SQL%NOTFOUND) then
127: Raise NO_DATA_FOUND;