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 117: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;

113: x_msg_count NUMBER;
114:
115: l_task_audit_id NUMBER;
116:
117: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
118: l_source_object_id jtf_tasks_b.source_object_id%type ;
119: l_source_object_name jtf_tasks_b.source_object_name%type ;
120:
121: BEGIN

Line 118: l_source_object_id jtf_tasks_b.source_object_id%type ;

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

Line 119: l_source_object_name jtf_tasks_b.source_object_name%type ;

115: l_task_audit_id NUMBER;
116:
117: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;
118: l_source_object_id jtf_tasks_b.source_object_id%type ;
119: l_source_object_name jtf_tasks_b.source_object_name%type ;
120:
121: BEGIN
122:
123:

Line 125: INSERT INTO jtf_tasks_b (

121: BEGIN
122:
123:
124:
125: INSERT INTO jtf_tasks_b (
126: attribute4,
127: attribute5,
128: attribute6,
129: attribute7,

Line 752: l_source_object_type_code jtf_tasks_b.source_object_type_code%type ;

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

Line 753: l_source_object_id jtf_tasks_b.source_object_id%type ;

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

Line 754: l_source_object_name jtf_tasks_b.source_object_name%type ;

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

Line 840: UPDATE jtf_tasks_b

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

Line 981: FROM jtf_tasks_b b

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