APPS.JTF_ACTIVITY_SQLAPI dependencies on JTF_ACT_TYPES_ATTRS_TL

Line 30: AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE)

26: END getActivityNameID;
27:
28: FUNCTION getActivityAttributeNameID(
29: ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
30: AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE)
31: RETURN NUMBER IS
32:
33: v_Result NUMBER;
34: v_activity_name_id NUMBER;

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 220: p_AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE,

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

Line 243: INSERT INTO JTF_ACT_TYPES_ATTRS_TL

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
243: INSERT INTO JTF_ACT_TYPES_ATTRS_TL
244: ( attribute_name_id, attribute_name, language,
245: created_by, creation_date, last_updated_by, last_update_date)
246: VALUES (v_attribute_name_id, p_AttributeName, userenv('LANG'),
247: p_appID, SYSDATE, p_appID, SYSDATE);