DBA Data[Home] [Help]

APPS.PSB_WS_MATRIX dependencies on PSB_WORKSHEET_CONTEXT

Line 60: Update psb_worksheet_context

56: /*For Bug No : 1756051 End*/
57:
58: /* Added the following If condition for bug 3206280 */
59: If nvl(p_modify_ws,'N') = 'Y' then
60: Update psb_worksheet_context
61: Set
62: stage = p_stage,
63: account_flag = l_account_flag,
64: year1_id = p1_year_id,

Line 94: Insert Into psb_worksheet_context

90: and session_id = p_session_id;
91:
92: If SQL%NOTFOUND Then
93:
94: Insert Into psb_worksheet_context
95: (
96: session_id ,
97: worksheet_id ,
98: stage ,

Line 444: worksheet from PSB_WORKSHEET_CONTEXT */

440: /*For Bug No : 1756051 End*/
441:
442: /* Added the following procedure for bug 3206280
443: This procedure deletes session information for a
444: worksheet from PSB_WORKSHEET_CONTEXT */
445:
446: PROCEDURE Delete_Session_Information
447: (
448: p_worksheet_id IN NUMBER,

Line 455: delete from psb_worksheet_context

451: IS
452: BEGIN
453: SAVEPOINT DELETE_SESSION;
454:
455: delete from psb_worksheet_context
456: where session_id = p_session_id;
457:
458: COMMIT work;
459: