APPS.JTF_TASK_AUDITS_PVT dependencies on JTF_TASK_AUDITS_B

Line 337: FROM jtf_task_audits_b

333:
334: CURSOR ta_cur1 (l_rowid IN ROWID)
335: IS
336: SELECT 1
337: FROM jtf_task_audits_b
338: WHERE ROWID = l_rowid;
339:
340: CURSOR c_audit
341: IS

Line 1398: FROM jtf_task_audits_b

1394:
1395: CURSOR ta_cur1 (l_rowid IN ROWID)
1396: IS
1397: SELECT 1
1398: FROM jtf_task_audits_b
1399: WHERE ROWID = l_rowid;
1400:
1401: CURSOR tsk_aud (p_task_id IN NUMBER)
1402: IS

Line 1917: cursor C is select ROWID from JTF_TASK_AUDITS_B

1913: X_NEW_DATE_SELECTED in VARCHAR2,
1914: X_OLD_LOCATION_ID in NUMBER,
1915: X_NEW_LOCATION_ID in NUMBER
1916: ) is
1917: cursor C is select ROWID from JTF_TASK_AUDITS_B
1918: where TASK_AUDIT_ID = X_TASK_AUDIT_ID
1919: ;
1920: l_enable_audit varchar2(5);
1921: begin

Line 1927: insert into JTF_TASK_AUDITS_B (

1923: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
1924: IF(l_enable_audit = 'N') THEN
1925: RETURN;
1926: END IF;
1927: insert into JTF_TASK_AUDITS_B (
1928: NEW_NOTIFICATION_PERIOD,
1929: OLD_NOTIFICATION_PERIOD_UOM,
1930: NEW_NOTIFICATION_PERIOD_UOM,
1931: OLD_PARENT_TASK_ID,

Line 2185: from JTF_TASK_AUDITS_B B

2181:
2182: delete from JTF_TASK_AUDITS_TL T
2183: where not exists
2184: (select NULL
2185: from JTF_TASK_AUDITS_B B
2186: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
2187: );
2188:
2189: update JTF_TASK_AUDITS_TL T set (