APPS.AS_INTERESTS_PKG dependencies on AS_INTERESTS

Line 1: PACKAGE BODY AS_INTERESTS_PKG as

1: PACKAGE BODY AS_INTERESTS_PKG as
2: /* $Header: asxininb.pls 115.10 2004/01/16 07:02:40 gbatra ship $ */
3:
4: --
5: -- ??-???-94 J Sondergaard Created

Line 55: CURSOR C IS SELECT rowid FROM as_interests

51: X_Product_Category_Id NUMBER,
52: X_Product_Cat_Set_Id NUMBER
53:
54: ) IS
55: CURSOR C IS SELECT rowid FROM as_interests
56: WHERE interest_id = X_Interest_Id;
57: CURSOR C2 IS SELECT as_interests_s.nextval FROM sys.dual;
58:
59: X_User_Id NUMBER;

Line 57: CURSOR C2 IS SELECT as_interests_s.nextval FROM sys.dual;

53:
54: ) IS
55: CURSOR C IS SELECT rowid FROM as_interests
56: WHERE interest_id = X_Interest_Id;
57: CURSOR C2 IS SELECT as_interests_s.nextval FROM sys.dual;
58:
59: X_User_Id NUMBER;
60: X_Login_Id NUMBER;
61: X_Date DATE;

Line 78: INSERT INTO as_interests(

74: X_Login_Id := X_Last_Update_Login;
75: X_Date := X_Creation_Date;
76: end if;
77:
78: INSERT INTO as_interests(
79: interest_id,
80: last_update_date,
81: last_updated_by,
82: creation_date,

Line 201: FROM as_interests

197:
198: ) IS
199: CURSOR C IS
200: SELECT *
201: FROM as_interests
202: WHERE rowid = X_Rowid
203: FOR UPDATE of Interest_Id NOWAIT;
204: Recinfo C%ROWTYPE;
205: BEGIN

Line 349: UPDATE as_interests_all

345:
346: ) IS
347: l_description varchar2(30);
348: BEGIN
349: UPDATE as_interests_all
350: SET
351: object_version_number = nvl(object_version_number,0) + 1,
352: interest_id = decode(X_Interest_Id,FND_API.G_MISS_NUM, interest_id, X_Interest_Id),
353: last_update_date = X_Last_Update_Date,

Line 400: DELETE FROM as_interests

396: END Update_Row;
397:
398: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
399: BEGIN
400: DELETE FROM as_interests
401: WHERE rowid = X_Rowid;
402:
403: if (SQL%NOTFOUND) then
404: RAISE NO_DATA_FOUND;

Line 408: END AS_INTERESTS_PKG;

404: RAISE NO_DATA_FOUND;
405: end if;
406: END Delete_Row;
407:
408: END AS_INTERESTS_PKG;