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_APP_CATS

Line 99: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table

95: v_activityname_id NUMBER;
96: v_act_app_cats_id NUMBER;
97: v_act_types_b_id NUMBER;
98: begin
99: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
100: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
101: where application_id = AppID and category_name_code=CategoryName;
102:
103: -- get the activity name id

Line 100: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats

96: v_act_app_cats_id NUMBER;
97: v_act_types_b_id NUMBER;
98: begin
99: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
100: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
101: where application_id = AppID and category_name_code=CategoryName;
102:
103: -- get the activity name id
104: v_activityname_id := getActivityNameID(ActivityName);

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 124: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table

120: v_act_app_cats_id NUMBER;
121: v_act_types_b_id NUMBER;
122: begin
123:
124: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
125: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
126: where application_id = AppID and category_name_code=CategoryName;
127:
128: -- get the activity name id

Line 125: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats

121: v_act_types_b_id NUMBER;
122: begin
123:
124: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
125: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
126: where application_id = AppID and category_name_code=CategoryName;
127:
128: -- get the activity name id
129: v_activityname_id := getActivityNameID(ActivityName);

Line 135: where jtf_act_app_cats_id = v_act_app_cats_id and

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:
139: procedure setActivityPriority(appID IN NUMBER, categoryname IN varchar2, activityname IN varchar2, Priority IN NUMBER)

Line 146: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table

142: v_activityname_id NUMBER;
143: v_act_app_cats_id NUMBER;
144: v_act_types_b_id NUMBER;
145: begin
146: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
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);

Line 147: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats

143: v_act_app_cats_id NUMBER;
144: v_act_types_b_id NUMBER;
145: begin
146: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
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

Line 155: where jtf_act_app_cats_id = v_act_app_cats_id and

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:
159: procedure setActivityStatus(appID IN NUMBER, categoryname IN varchar2, activityname IN varchar2, Status IN varchar2)

Line 166: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table

162: v_activityname_id NUMBER;
163: v_act_app_cats_id NUMBER;
164: v_act_types_b_id NUMBER;
165: begin
166: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
167: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
168: where application_id = AppID and category_name_code=CategoryName;
169:
170: -- get the activity name id

Line 167: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats

163: v_act_app_cats_id NUMBER;
164: v_act_types_b_id NUMBER;
165: begin
166: -- get the jtf_act_app_cats_id from jtf_act_app_cats_id table
167: select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
168: where application_id = AppID and category_name_code=CategoryName;
169:
170: -- get the activity name id
171: v_activityname_id := getActivityNameID(ActivityName);

Line 176: where jtf_act_app_cats_id = v_act_app_cats_id and

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;
180: