PACKAGE: APPS.JTF_ACTIVITY_SQLAPI

Source

1 PACKAGE JTF_ACTIVITY_SQLAPI AS
2 /* $Header: jtfactss.pls 120.2 2005/10/25 05:13:09 psanyal ship $ */
3 
4 procedure deleteActivityType(activityname IN varchar2);
5 
6 procedure subscribeActivityType(AppID IN number, CategoryName IN varchar2, ActivityName IN varchar2);
7 
8 procedure unsubscribeActivityType(AppID IN number, CategoryName IN varchar2, ActivityName IN varchar2);
9 
10 procedure setActivityPriority(appID IN number, categoryname IN varchar2, activityname IN varchar2, Priority IN number);
11 
12 procedure setActivityStatus(appID IN NUMBER, categoryname IN varchar2, activityname IN varchar2, Status IN varchar2);
13 
14 -- Insert a new Profile Owner object into JTF_ProfileProperties_B/TL
15 -- Return the primary key for the newly inserted object.
16 
17 -- HELPER FUNCTIONS
18 FUNCTION getActivityNameID(
19   activityname IN JTF_ACT_TYPES_TL.activity_name%TYPE)
20  RETURN NUMBER;
21 
22 FUNCTION getActivityAttributeNameID(
23  ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
24  AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE)
25 RETURN NUMBER;
26 
27 FUNCTION isActivityDefined(
28   ActivityName IN jtf_act_types_tl.activity_name%TYPE)
29 RETURN NUMBER;
30 
31 PROCEDURE addActivityType (
32   p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
33   p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
34   p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
35   p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
36   p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
37   p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE);
38 
39 PROCEDURE addActivityAttribute (
40   p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
41   p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
42   p_AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE,
43   p_ColumnName IN JTF_ACT_TYPES_ATTRS_B.column_name%TYPE);
44 
45 -- Test debug procedure
46 PROCEDURE run;
47 
48 end jtf_activity_sqlapi;