eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_ACTIVITY_SQLAPI dependencies on JTF_ACT_TYPES_B

Line 87: delete from jtf_act_types_b where activity_name_id = name_id;

83: loop
84: fetch C into name_id;
85: Exit when C%NOTFOUND;
86: delete from jtf_act_types_tl where activity_name_id = name_id;
87: delete from jtf_act_types_b where activity_name_id = name_id;
88: end loop;
89:
90: close c;
91: end deleteActivityType;

Line 106: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b

102:
103: -- get the activity name id
104: v_activityname_id := getActivityNameID(ActivityName);
105:
106: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
107: where activity_name_id = v_activityname_id;
108:
109: insert into jtf_act_activity_cats
110: (jtf_act_types_b_id, jtf_act_app_cats_id, priority, status_code,

Line 110: (jtf_act_types_b_id, jtf_act_app_cats_id, priority, status_code,

106: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
107: where activity_name_id = v_activityname_id;
108:
109: insert into jtf_act_activity_cats
110: (jtf_act_types_b_id, jtf_act_app_cats_id, priority, status_code,
111: created_by, creation_date, last_updated_by, last_update_date)
112: values (v_act_types_b_id, v_act_app_cats_id, 1, 'ON',
113: AppID, sysdate, AppID, sysdate);
114:

Line 131: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b

127:
128: -- get the activity name id
129: v_activityname_id := getActivityNameID(ActivityName);
130:
131: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
132: where activity_name_id = v_activityname_id;
133:
134: delete from jtf_act_activity_cats
135: where jtf_act_app_cats_id = v_act_app_cats_id and

Line 136: jtf_act_types_b_id = v_act_types_b_id;

132: where activity_name_id = v_activityname_id;
133:
134: delete from jtf_act_activity_cats
135: where jtf_act_app_cats_id = v_act_app_cats_id and
136: jtf_act_types_b_id = v_act_types_b_id;
137: end unsubscribeActivityType;
138:
139: procedure setActivityPriority(appID IN NUMBER, categoryname IN varchar2, activityname IN varchar2, Priority IN NUMBER)
140: AS

Line 151: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b

147: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
148: where application_id = AppID and category_name_code=CategoryName;
149: -- get the activity name id
150: v_activityname_id := getActivityNameID(ActivityName);
151: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
152: where activity_name_id = v_activityname_id;
153:
154: update jtf_act_activity_cats set priority = Priority
155: where jtf_act_app_cats_id = v_act_app_cats_id and

Line 156: jtf_act_types_b_id = v_act_types_b_id;

152: where activity_name_id = v_activityname_id;
153:
154: update jtf_act_activity_cats set priority = Priority
155: where jtf_act_app_cats_id = v_act_app_cats_id and
156: jtf_act_types_b_id = v_act_types_b_id;
157: end setActivityPriority;
158:
159: procedure setActivityStatus(appID IN NUMBER, categoryname IN varchar2, activityname IN varchar2, Status IN varchar2)
160: AS

Line 172: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b

168: where application_id = AppID and category_name_code=CategoryName;
169:
170: -- get the activity name id
171: v_activityname_id := getActivityNameID(ActivityName);
172: select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
173: where activity_name_id = v_activityname_id;
174:
175: update jtf_act_activity_cats set status_code = Status
176: where jtf_act_app_cats_id = v_act_app_cats_id and

Line 177: jtf_act_types_b_id = v_act_types_b_id;

173: where activity_name_id = v_activityname_id;
174:
175: update jtf_act_activity_cats set status_code = Status
176: where jtf_act_app_cats_id = v_act_app_cats_id and
177: jtf_act_types_b_id = v_act_types_b_id;
178:
179: end setActivityStatus;
180:
181:

Line 187: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,

183:
184: PROCEDURE addActivityType (
185: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
186: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
187: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
188: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
189: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
190: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE)
191: AS

Line 190: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE)

186: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
187: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
188: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
189: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
190: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE)
191: AS
192: v_FKey NUMBER;
193: v_row NUMBER;
194: begin

Line 198: -- First do an insert into JTF_ACT_TYPES_B table

194: begin
195: -- first check whether the activity name is already defined
196: IF (isActivityDefined(p_ActivityName) = 0 ) THEN
197:
198: -- First do an insert into JTF_ACT_TYPES_B table
199: -- activity_name_id is the same as primary key
200: INSERT INTO JTF_ACT_TYPES_B
201: ( table_name, created_by, creation_date, last_updated_by, last_update_date)
202: VALUES (p_tableName, p_appID, SYSDATE, p_appID, SYSDATE);

Line 200: INSERT INTO JTF_ACT_TYPES_B

196: IF (isActivityDefined(p_ActivityName) = 0 ) THEN
197:
198: -- First do an insert into JTF_ACT_TYPES_B table
199: -- activity_name_id is the same as primary key
200: INSERT INTO JTF_ACT_TYPES_B
201: ( table_name, created_by, creation_date, last_updated_by, last_update_date)
202: VALUES (p_tableName, p_appID, SYSDATE, p_appID, SYSDATE);
203:
204: select jtf_act_types_b_s.currval into p_PK from dual;

Line 204: select jtf_act_types_b_s.currval into p_PK from dual;

200: INSERT INTO JTF_ACT_TYPES_B
201: ( table_name, created_by, creation_date, last_updated_by, last_update_date)
202: VALUES (p_tableName, p_appID, SYSDATE, p_appID, SYSDATE);
203:
204: select jtf_act_types_b_s.currval into p_PK from dual;
205:
206: -- Finally insert the translatable columns into JTF_ProfileProperties_TL
207: INSERT INTO JTF_ACT_TYPES_TL
208: ( activity_name_id, activity_name, act_description, language,