APPS.JTF_ACTIVITY_SQLAPI dependencies on JTF_ACT_TYPES_TL

Line 19: activityname IN JTF_ACT_TYPES_TL.activity_name%TYPE)

15: -- Return the primary key for the newly inserted object.
16:
17: -- HELPER FUNCTIONS
18: FUNCTION getActivityNameID(
19: activityname IN JTF_ACT_TYPES_TL.activity_name%TYPE)
20: RETURN NUMBER;
21:
22: FUNCTION getActivityAttributeNameID(
23: ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

Line 23: ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

19: activityname IN JTF_ACT_TYPES_TL.activity_name%TYPE)
20: RETURN NUMBER;
21:
22: FUNCTION getActivityAttributeNameID(
23: ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
24: AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE)
25: RETURN NUMBER;
26:
27: FUNCTION isActivityDefined(

Line 28: ActivityName IN jtf_act_types_tl.activity_name%TYPE)

24: AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE)
25: RETURN NUMBER;
26:
27: FUNCTION isActivityDefined(
28: ActivityName IN jtf_act_types_tl.activity_name%TYPE)
29: RETURN NUMBER;
30:
31: PROCEDURE addActivityType (
32: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

Line 32: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

28: ActivityName IN jtf_act_types_tl.activity_name%TYPE)
29: RETURN NUMBER;
30:
31: PROCEDURE addActivityType (
32: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
33: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
34: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
35: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
36: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 33: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,

29: RETURN NUMBER;
30:
31: PROCEDURE addActivityType (
32: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
33: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
34: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
35: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
36: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE);

Line 35: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,

31: PROCEDURE addActivityType (
32: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
33: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
34: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
35: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
36: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE);
38:
39: PROCEDURE addActivityAttribute (

Line 40: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

36: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE);
38:
39: PROCEDURE addActivityAttribute (
40: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
41: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
42: p_AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE,
43: p_ColumnName IN JTF_ACT_TYPES_ATTRS_B.column_name%TYPE);
44:

Line 41: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,

37: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE);
38:
39: PROCEDURE addActivityAttribute (
40: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
41: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
42: p_AttributeName IN JTF_ACT_TYPES_ATTRS_TL.attribute_name%TYPE,
43: p_ColumnName IN JTF_ACT_TYPES_ATTRS_B.column_name%TYPE);
44:
45: -- Test debug procedure