APPS.JTF_ACTIVITY_SQLAPI dependencies on JTF_ACT_TYPES_ATTRS_B

Line 40: FROM JTF_ACT_TYPES_ATTRS_B b, JTF_ACT_TYPES_ATTRS_TL t

36:
37: v_activity_name_id := getActivityNameID(ActivityName);
38:
39: SELECT b.attribute_name_id INTO v_Result
40: FROM JTF_ACT_TYPES_ATTRS_B b, JTF_ACT_TYPES_ATTRS_TL t
41: WHERE b.activity_name_id = v_activity_name_id
42: AND b.attribute_name_id = t.attribute_name_id
43: AND t.attribute_name = AttributeName
44: AND t.language = userenv('LANG');

Line 221: p_ColumnName IN JTF_ACT_TYPES_ATTRS_B.column_name%TYPE)

217: PROCEDURE addActivityAttribute (
218: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
219: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
220: p_AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE,
221: p_ColumnName IN JTF_ACT_TYPES_ATTRS_B.column_name%TYPE)
222: AS
223: v_activity_name_id NUMBER;
224: v_attribute_name_id NUMBER;
225: begin

Line 231: -- First do an insert into JTF_ACT_TYPES_ATTRS_B table

227: -- first check whether the activity name is already defined
228: IF (isActivityDefined(p_ActivityName) > 0 ) THEN
229:
230: v_activity_name_id := getActivityNameID(p_ActivityName);
231: -- First do an insert into JTF_ACT_TYPES_ATTRS_B table
232: -- activity_name_id is the same as primary key
233: INSERT INTO JTF_ACT_TYPES_ATTRS_B
234: ( activity_name_id, column_name, created_by, creation_date, last_updated_by, last_update_date)
235: VALUES (v_activity_name_id, p_ColumnName, p_appID, SYSDATE, p_appID, SYSDATE);

Line 233: INSERT INTO JTF_ACT_TYPES_ATTRS_B

229:
230: v_activity_name_id := getActivityNameID(p_ActivityName);
231: -- First do an insert into JTF_ACT_TYPES_ATTRS_B table
232: -- activity_name_id is the same as primary key
233: INSERT INTO JTF_ACT_TYPES_ATTRS_B
234: ( activity_name_id, column_name, created_by, creation_date, last_updated_by, last_update_date)
235: VALUES (v_activity_name_id, p_ColumnName, p_appID, SYSDATE, p_appID, SYSDATE);
236:
237: SELECT attribute_name_id INTO v_attribute_name_id

Line 238: FROM jtf_act_types_attrs_b

234: ( activity_name_id, column_name, created_by, creation_date, last_updated_by, last_update_date)
235: VALUES (v_activity_name_id, p_ColumnName, p_appID, SYSDATE, p_appID, SYSDATE);
236:
237: SELECT attribute_name_id INTO v_attribute_name_id
238: FROM jtf_act_types_attrs_b
239: WHERE activity_name_id = v_activity_name_id
240: and column_name = p_ColumnName;
241:
242: -- Finally insert the translatable columns into JTF_ProfileProperties_TL