APPS.AD_CONC_SESSION_LOCKS dependencies on AD_SESSION_TASKS

Line 1619: UPDATE AD_SESSION_TASKS

1615: STAGE_CODE <> p_end_stage_cd AND
1616: STAGE_CODE <> p_begin_stage_cd;
1617: --
1618: --
1619: UPDATE AD_SESSION_TASKS
1620: SET COMPLETION_STATUS = p_completion_status,
1621: END_DATE = sysdate ,
1622: LAST_UPDATE_DATE = sysdate
1623: where session_id = p_session_id and

Line 1676: INSERT INTO AD_SESSION_TASKS_HISTORY

1672: DELETE FROM AD_SESSIONS
1673: WHERE session_id = p_sess_id;
1674: --
1675: --
1676: INSERT INTO AD_SESSION_TASKS_HISTORY
1677: (SESSION_ID,TASK_NUMBER,COMPLETION_STATUS,
1678: CONTEXT ,START_DATE ,END_DATE,CREATION_DATE,
1679: LAST_UPDATE_DATE)
1680: SELECT

Line 1685: AD_SESSION_TASKS

1681: SESSION_ID,TASK_NUMBER,COMPLETION_STATUS,
1682: CONTEXT ,START_DATE , nvl(END_DATE,SYSDATE),SYSDATE,
1683: SYSDATE
1684: from
1685: AD_SESSION_TASKS
1686: where
1687: SESSION_ID=p_sess_id;
1688: --
1689: --

Line 1690: DELETE FROM AD_SESSION_TASKS

1686: where
1687: SESSION_ID=p_sess_id;
1688: --
1689: --
1690: DELETE FROM AD_SESSION_TASKS
1691: WHERE session_id = p_sess_id;
1692: --
1693: --
1694: commit;