APPS.JTF_TASK_AUDITS_PKG dependencies on JTF_TASK_AUDITS_B

Line 109: cursor C is select ROWID from JTF_TASK_AUDITS_B

105: X_NEW_OWNER_TERRITORY_ID in NUMBER,
106: X_NEW_ESCALATION_LEVEL in VARCHAR2,
107: X_OLD_ESCALATION_LEVEL in VARCHAR2
108: ) is
109: cursor C is select ROWID from JTF_TASK_AUDITS_B
110: where TASK_AUDIT_ID = X_TASK_AUDIT_ID
111: ;
112: begin
113: insert into JTF_TASK_AUDITS_B (

Line 113: insert into JTF_TASK_AUDITS_B (

109: cursor C is select ROWID from JTF_TASK_AUDITS_B
110: where TASK_AUDIT_ID = X_TASK_AUDIT_ID
111: ;
112: begin
113: insert into JTF_TASK_AUDITS_B (
114: NEW_NOTIFICATION_PERIOD,
115: OLD_NOTIFICATION_PERIOD_UOM,
116: NEW_NOTIFICATION_PERIOD_UOM,
117: OLD_PARENT_TASK_ID,

Line 545: from JTF_TASK_AUDITS_B

541: OLD_WORKFLOW_PROCESS_ID,
542: NEW_WORKFLOW_PROCESS_ID,
543: NOTIFICATION_CHANGED_FLAG,
544: OLD_NOTIFICATION_PERIOD
545: from JTF_TASK_AUDITS_B
546: where TASK_AUDIT_ID = X_TASK_AUDIT_ID
547: for update of TASK_AUDIT_ID nowait;
548: recinfo c%rowtype;
549:

Line 871: update JTF_TASK_AUDITS_B set

867: X_NEW_ESCALATION_LEVEL in VARCHAR2,
868: X_OLD_ESCALATION_LEVEL in VARCHAR2
869: ) is
870: begin
871: update JTF_TASK_AUDITS_B set
872: NEW_NOTIFICATION_PERIOD = X_NEW_NOTIFICATION_PERIOD,
873: OLD_NOTIFICATION_PERIOD_UOM = X_OLD_NOTIFICATION_PERIOD_UOM,
874: NEW_NOTIFICATION_PERIOD_UOM = X_NEW_NOTIFICATION_PERIOD_UOM,
875: OLD_PARENT_TASK_ID = X_OLD_PARENT_TASK_ID,

Line 999: delete from JTF_TASK_AUDITS_B

995: if (sql%notfound) then
996: raise no_data_found;
997: end if;
998:
999: delete from JTF_TASK_AUDITS_B
1000: where TASK_AUDIT_ID = X_TASK_AUDIT_ID;
1001:
1002: if (sql%notfound) then
1003: raise no_data_found;

Line 1013: from JTF_TASK_AUDITS_B B

1009: begin
1010: delete from JTF_TASK_AUDITS_TL T
1011: where not exists
1012: (select NULL
1013: from JTF_TASK_AUDITS_B B
1014: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
1015: );
1016:
1017: update JTF_TASK_AUDITS_TL T set (