APPS.JTF_ACTIVITY_SQLAPI dependencies on JTF_ACT_ACTIVITY_CATS

Line 109: insert into jtf_act_activity_cats

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,
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);

Line 134: delete from jtf_act_activity_cats

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
136: jtf_act_types_b_id = v_act_types_b_id;
137: end unsubscribeActivityType;
138:

Line 154: update jtf_act_activity_cats set priority = Priority

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
156: jtf_act_types_b_id = v_act_types_b_id;
157: end setActivityPriority;
158:

Line 175: update jtf_act_activity_cats set status_code = Status

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
177: jtf_act_types_b_id = v_act_types_b_id;
178:
179: end setActivityStatus;