APPS.JTF_TASKS_PKG dependencies on JTF_TASKS_B

Line 108: FROM jtf_tasks_b

104: IS
105: CURSOR c
106: IS
107: SELECT ROWID
108: FROM jtf_tasks_b
109: WHERE task_id = x_task_id;
110:
111: x_return_status varchar2(1);
112: x_msg_data VARCHAR2(2000);

Line 118: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;

114:
115: l_task_audit_id NUMBER;
116: l_enable_audit varchar2(5);
117:
118: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
119: l_source_object_id jtf_tasks_b.source_object_id%type ;
120: l_source_object_name jtf_tasks_b.source_object_name%type ;
121:
122: BEGIN

Line 119: l_source_object_id jtf_tasks_b.source_object_id%type ;

115: l_task_audit_id NUMBER;
116: l_enable_audit varchar2(5);
117:
118: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
119: l_source_object_id jtf_tasks_b.source_object_id%type ;
120: l_source_object_name jtf_tasks_b.source_object_name%type ;
121:
122: BEGIN
123: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));

Line 120: l_source_object_name jtf_tasks_b.source_object_name%type ;

116: l_enable_audit varchar2(5);
117:
118: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
119: l_source_object_id jtf_tasks_b.source_object_id%type ;
120: l_source_object_name jtf_tasks_b.source_object_name%type ;
121:
122: BEGIN
123: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
124: IF(l_enable_audit = 'Y') THEN

Line 198: INSERT INTO jtf_tasks_b (

194: x_task_audit_id => l_task_audit_id
195: );
196: END IF;
197:
198: INSERT INTO jtf_tasks_b (
199: attribute4,
200: attribute5,
201: attribute6,
202: attribute7,

Line 751: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;

747: x_return_status VARCHAR2(1);
748: x_msg_data VARCHAR2(2000);
749: x_msg_count NUMBER;
750:
751: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
752: l_source_object_id jtf_tasks_b.source_object_id%type ;
753: l_source_object_name jtf_tasks_b.source_object_name%type ;
754:
755: l_task_audit_id number :=-1;

Line 752: l_source_object_id jtf_tasks_b.source_object_id%type ;

748: x_msg_data VARCHAR2(2000);
749: x_msg_count NUMBER;
750:
751: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
752: l_source_object_id jtf_tasks_b.source_object_id%type ;
753: l_source_object_name jtf_tasks_b.source_object_name%type ;
754:
755: l_task_audit_id number :=-1;
756: my_message VARCHAR2(2000);

Line 753: l_source_object_name jtf_tasks_b.source_object_name%type ;

749: x_msg_count NUMBER;
750:
751: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
752: l_source_object_id jtf_tasks_b.source_object_id%type ;
753: l_source_object_name jtf_tasks_b.source_object_name%type ;
754:
755: l_task_audit_id number :=-1;
756: my_message VARCHAR2(2000);
757: l_count NUMBER;

Line 841: UPDATE jtf_tasks_b

837: );
838: END IF;
839: p_task_audit_id := l_task_audit_id;
840:
841: UPDATE jtf_tasks_b
842: SET attribute4 = l_Task_Upd_Rec.attribute4,
843: object_version_number = l_Task_Upd_Rec.object_version_number,
844: attribute5 = l_Task_Upd_Rec.attribute5,
845: attribute6 = l_Task_Upd_Rec.attribute6,

Line 982: FROM jtf_tasks_b b

978:
979: /* DELETE
980: FROM jtf_tasks_tl t
981: WHERE NOT EXISTS (SELECT NULL
982: FROM jtf_tasks_b b
983: WHERE b.task_id = t.task_id);
984: UPDATE jtf_tasks_tl t
985: SET (task_name, description) = ( SELECT b.task_name, b.description
986: FROM jtf_tasks_tl b