APPS.JTF_ACTIVITY_SQLAPI SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

SELECT activity_name_id
INTO v_Result
FROM JTF_ACT_TYPES_TL
WHERE activity_name = ActivityName AND
      language = userenv('LANG');

Line: 39

SELECT b.attribute_name_id INTO v_Result
FROM JTF_ACT_TYPES_ATTRS_B b, JTF_ACT_TYPES_ATTRS_TL t
WHERE b.activity_name_id = v_activity_name_id
AND b.attribute_name_id = t.attribute_name_id
AND t.attribute_name = AttributeName
AND t.language = userenv('LANG');

Line: 73

procedure deleteActivityType(activityname IN varchar2) AS
name_id  NUMBER;

Line: 78

   select t.activity_name_id from jtf_act_types_tl t where t.language=userenv('LANG') and t.activity_name =activityname;

Line: 86

   delete from jtf_act_types_tl where activity_name_id = name_id;

Line: 87

   delete from jtf_act_types_b where activity_name_id = name_id;

Line: 91

end deleteActivityType;

Line: 100

  select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
  	where application_id = AppID and category_name_code=CategoryName;

Line: 106

  select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
	where activity_name_id = v_activityname_id;

Line: 109

  insert into jtf_act_activity_cats
	(jtf_act_types_b_id, jtf_act_app_cats_id, priority, status_code,
	 created_by, creation_date, last_updated_by, last_update_date)
   values (v_act_types_b_id, v_act_app_cats_id, 1, 'ON',
	        AppID, sysdate, AppID, sysdate);

Line: 125

  select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
	where application_id = AppID and category_name_code=CategoryName;

Line: 131

  select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
	where activity_name_id = v_activityname_id;

Line: 134

  delete from jtf_act_activity_cats
	where jtf_act_app_cats_id = v_act_app_cats_id and
              jtf_act_types_b_id = v_act_types_b_id;

Line: 147

  select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
	 where application_id = AppID and category_name_code=CategoryName;

Line: 151

  select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
	  where activity_name_id = v_activityname_id;

Line: 154

  update jtf_act_activity_cats set priority = Priority
	  where jtf_act_app_cats_id = v_act_app_cats_id and
              jtf_act_types_b_id = v_act_types_b_id;

Line: 167

 select jtf_act_app_cats_id into v_act_app_cats_id from jtf_act_app_cats
	where application_id = AppID and category_name_code=CategoryName;

Line: 172

 select jtf_act_types_b_id into v_act_types_b_id from jtf_act_types_b
	where activity_name_id = v_activityname_id;

Line: 175

 update jtf_act_activity_cats set status_code = Status
  	where jtf_act_app_cats_id = v_act_app_cats_id and
              jtf_act_types_b_id = v_act_types_b_id;

Line: 186

  p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
  p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
  p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
  p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
  p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE)
AS
v_FKey NUMBER;

Line: 200

INSERT INTO JTF_ACT_TYPES_B
 ( table_name, created_by, creation_date, last_updated_by, last_update_date)
  VALUES (p_tableName, p_appID, SYSDATE, p_appID, SYSDATE);

Line: 204

select jtf_act_types_b_s.currval into p_PK from dual;

Line: 207

INSERT INTO JTF_ACT_TYPES_TL
( activity_name_id, activity_name, act_description,  language,
  created_by, creation_date, last_updated_by, last_update_date)
VALUES (p_PK, p_ActivityName, p_Desc, userenv('LANG'),
        p_appID, SYSDATE, p_appID, SYSDATE);

Line: 219

  p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
  p_AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE,
  p_ColumnName IN JTF_ACT_TYPES_ATTRS_B.column_name%TYPE)
AS
v_activity_name_id NUMBER;

Line: 233

INSERT INTO JTF_ACT_TYPES_ATTRS_B
 ( activity_name_id, column_name, created_by, creation_date, last_updated_by, last_update_date)
  VALUES (v_activity_name_id, p_ColumnName, p_appID, SYSDATE, p_appID, SYSDATE);

Line: 237

SELECT  attribute_name_id INTO  v_attribute_name_id
FROM jtf_act_types_attrs_b
WHERE activity_name_id = v_activity_name_id
     and column_name = p_ColumnName;

Line: 243

INSERT INTO JTF_ACT_TYPES_ATTRS_TL
( attribute_name_id, attribute_name, language,
  created_by, creation_date, last_updated_by, last_update_date)
VALUES (v_attribute_name_id, p_AttributeName, userenv('LANG'),
        p_appID, SYSDATE, p_appID, SYSDATE);