DBA Data[Home] [Help]

APPS.JTF_ACTIVITY_MANAGER dependencies on JTF_ACT_ACTIVITY_LOGS

Line 8: v_userid jtf_act_activity_logs.jtf_act_activity_logs_user_id%TYPE ;

4: procedure write(
5: appid IN number, activityname IN varchar2, attrnames IN t_valuetable, valuen IN t_valuetable ) is
6:
7: v_attrname jtf_act_types_attrs_tl.attribute_name%TYPE;
8: v_userid jtf_act_activity_logs.jtf_act_activity_logs_user_id%TYPE ;
9: v_component jtf_act_activity_logs.component%TYPE ;
10: v_numvalue number;
11: v_tablename jtf_act_types_b.table_name%TYPE;
12: v_columns t_valuetable;

Line 9: v_component jtf_act_activity_logs.component%TYPE ;

5: appid IN number, activityname IN varchar2, attrnames IN t_valuetable, valuen IN t_valuetable ) is
6:
7: v_attrname jtf_act_types_attrs_tl.attribute_name%TYPE;
8: v_userid jtf_act_activity_logs.jtf_act_activity_logs_user_id%TYPE ;
9: v_component jtf_act_activity_logs.component%TYPE ;
10: v_numvalue number;
11: v_tablename jtf_act_types_b.table_name%TYPE;
12: v_columns t_valuetable;
13: j binary_integer;

Line 84: jtf_act_activity_logs_user_id, created_by, creation_date, last_updated_by,

80:
81: cid := DBMS_SQL.OPEN_CURSOR;
82:
83: DBMS_SQL.PARSE(cid, 'insert into '|| v_tablename || '(activity_name_id, application_id ,
84: jtf_act_activity_logs_user_id, created_by, creation_date, last_updated_by,
85: last_update_date, component, column1, column2, column3, column4,column5,
86: column6, column7,column8,column9, column10, column11, column12, column13,
87: column14,column15, column16, column17,column18,column19, column20, column21,
88: column22, column23, column24,column25, column26, column27,column28, column29,