APPS.JTF_ACTIVITY_SQLAPI dependencies on JTF_ACT_TYPES_TL

Line 6: ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE)

2: /* $Header: jtfactsb.pls 120.2 2005/10/25 05:12:40 psanyal ship $ */
3:
4:
5: FUNCTION getActivityNameID(
6: ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE)
7: RETURN NUMBER IS
8:
9: v_Result NUMBER;
10:

Line 15: FROM JTF_ACT_TYPES_TL

11: BEGIN
12:
13: SELECT activity_name_id
14: INTO v_Result
15: FROM JTF_ACT_TYPES_TL
16: WHERE activity_name = ActivityName AND
17: language = userenv('LANG');
18: RETURN v_Result;
19:

Line 29: ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

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

Line 56: ActivityName IN jtf_act_types_tl.activity_name%TYPE)

52:
53: END getActivityAttributeNameID;
54:
55: FUNCTION isActivityDefined(
56: ActivityName IN jtf_act_types_tl.activity_name%TYPE)
57: RETURN NUMBER IS
58:
59: v_row NUMBER;
60: BEGIN

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

74: name_id NUMBER;
75: i binary_integer;
76:
77: Cursor C is
78: select t.activity_name_id from jtf_act_types_tl t where t.language=userenv('LANG') and t.activity_name =activityname;
79: begin
80:
81: open C;
82:

Line 86: delete from jtf_act_types_tl where activity_name_id = name_id;

82:
83: loop
84: fetch C into name_id;
85: Exit when C%NOTFOUND;
86: delete from jtf_act_types_tl where activity_name_id = name_id;
87: delete from jtf_act_types_b where activity_name_id = name_id;
88: end loop;
89:
90: close c;

Line 185: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

181:
182: -- These APIs help insert rows in _B and _T tables
183:
184: PROCEDURE addActivityType (
185: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
186: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
187: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
188: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
189: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 186: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,

182: -- These APIs help insert rows in _B and _T tables
183:
184: PROCEDURE addActivityType (
185: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
186: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
187: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
188: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
189: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
190: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE)

Line 188: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,

184: PROCEDURE addActivityType (
185: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,
186: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,
187: p_tableName IN JTF_ACT_TYPES_B.table_name%TYPE,
188: p_Desc IN JTF_ACT_TYPES_TL.description%TYPE,
189: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
190: p_NameID OUT NOCOPY /* file.sql.39 change */ JTF_ACT_TYPES_B.activity_name_id%TYPE)
191: AS
192: v_FKey NUMBER;

Line 207: INSERT INTO JTF_ACT_TYPES_TL

203:
204: select jtf_act_types_b_s.currval into p_PK from dual;
205:
206: -- Finally insert the translatable columns into JTF_ProfileProperties_TL
207: INSERT INTO JTF_ACT_TYPES_TL
208: ( activity_name_id, activity_name, act_description, language,
209: created_by, creation_date, last_updated_by, last_update_date)
210: VALUES (p_PK, p_ActivityName, p_Desc, userenv('LANG'),
211: p_appID, SYSDATE, p_appID, SYSDATE);

Line 218: p_ActivityName IN JTF_ACT_TYPES_TL.activity_name%TYPE,

214:
215: END addActivityType;
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

Line 219: p_appID IN JTF_ACT_TYPES_TL.last_updated_by%TYPE,

215: END addActivityType;
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;