APPS.JTF_TASK_ASSIGNMENT_AUDIT_PKG dependencies on JTF_TASK_ASSIGNMENTS_AUDIT_B

Line 137: FROM jtf_task_assignments_audit_b

133:
134: CURSOR c1 (l_asg_audit_id IN NUMBER)
135: IS
136: SELECT 1
137: FROM jtf_task_assignments_audit_b
138: WHERE Assignment_audit_id = l_asg_audit_id;
139:
140: audit_rec cur_asg_audit%ROWTYPE;
141: l_new_category_id NUMBER := p_new_category_id ;

Line 578: cursor C IS select ROWID from JTF_TASK_ASSIGNMENTS_AUDIT_B

574: ) IS
575: l_rowid ROWID;
576: l_enable_audit varchar2(5);
577:
578: cursor C IS select ROWID from JTF_TASK_ASSIGNMENTS_AUDIT_B
579: where ASSIGNMENT_AUDIT_ID = X_ASSIGNMENT_AUDIT_ID;
580: BEGIN
581: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
582: IF(l_enable_audit = 'N') THEN

Line 586: INSERT INTO JTF_TASK_ASSIGNMENTS_AUDIT_B (

582: IF(l_enable_audit = 'N') THEN
583: RETURN;
584: END IF;
585:
586: INSERT INTO JTF_TASK_ASSIGNMENTS_AUDIT_B (
587: ASSIGNMENT_AUDIT_ID ,
588: ASSIGNMENT_ID ,
589: OBJECT_VERSION_NUMBER,
590: TASK_ID ,

Line 719: DELETE FROM jtf_task_assignments_audit_b WHERE assignment_id = x_assignment_id;

715: END IF;
716: OPEN c;
717: FETCH c into l_rowid;
718: IF(c%notfound) THEN
719: DELETE FROM jtf_task_assignments_audit_b WHERE assignment_id = x_assignment_id;
720: ELSE
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF;
723: CLOSE c;