APPS.AS_INTEREST_CATEGORY_SETS_PKG dependencies on AS_INTEREST_CATEGORY_SETS

Line 1: PACKAGE BODY AS_INTEREST_CATEGORY_SETS_PKG as

1: PACKAGE BODY AS_INTEREST_CATEGORY_SETS_PKG as
2: /* $Header: asxldcsb.pls 115.5 2002/11/06 00:43:11 appldev ship $ */
3: --
4: --
5: -- HISTORY

Line 21: CURSOR C IS SELECT rowid FROM as_interest_category_sets

17: X_Created_By NUMBER,
18: X_Last_Update_Login NUMBER,
19: X_Enabled_Flag VARCHAR2 DEFAULT NULL
20: ) IS
21: CURSOR C IS SELECT rowid FROM as_interest_category_sets
22: WHERE category_set_id = X_Category_Set_Id
23: AND interest_type_id = X_Interest_Type_Id;
24: BEGIN
25: INSERT INTO as_interest_category_sets(

Line 25: INSERT INTO as_interest_category_sets(

21: CURSOR C IS SELECT rowid FROM as_interest_category_sets
22: WHERE category_set_id = X_Category_Set_Id
23: AND interest_type_id = X_Interest_Type_Id;
24: BEGIN
25: INSERT INTO as_interest_category_sets(
26: category_set_id,
27: interest_type_id,
28: last_update_date,
29: last_updated_by,

Line 61: FROM as_interest_category_sets

57: X_Enabled_Flag VARCHAR2 DEFAULT NULL
58: ) IS
59: CURSOR C IS
60: SELECT *
61: FROM as_interest_category_sets
62: WHERE rowid = X_Rowid
63: FOR UPDATE of Category_Set_Id NOWAIT;
64: Recinfo C%ROWTYPE;
65: BEGIN

Line 102: UPDATE as_interest_category_sets

98: X_Last_Update_Login NUMBER,
99: X_Enabled_Flag VARCHAR2 DEFAULT NULL
100: ) IS
101: BEGIN
102: UPDATE as_interest_category_sets
103: SET
104: category_set_id = X_Category_Set_Id,
105: interest_type_id = X_Interest_Type_Id,
106: last_update_date = X_Last_Update_Date,

Line 121: DELETE FROM as_interest_category_sets

117:
118:
119: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
120: BEGIN
121: DELETE FROM as_interest_category_sets
122: WHERE rowid = X_Rowid;
123:
124: if (SQL%NOTFOUND) then
125: RAISE NO_DATA_FOUND;

Line 129: END AS_INTEREST_CATEGORY_SETS_PKG;

125: RAISE NO_DATA_FOUND;
126: end if;
127: END Delete_Row;
128:
129: END AS_INTEREST_CATEGORY_SETS_PKG;