DBA Data[Home] [Help]

APPS.PSB_DISTRIBUTE_WORKSHEET_PVT dependencies on PSB_WORKSHEETS

Line 51: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

47: --
48: l_ItemType VARCHAR2(100) := 'PSBWS' ;
49: l_ItemKey VARCHAR2(100) := p_item_key ;
50: --
51: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
52: l_user_name VARCHAR2(100);
53: BEGIN
54: --
55: SAVEPOINT Start_Process_Pvt ;

Line 202: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

198: result OUT NOCOPY VARCHAR2
199: )
200: IS
201: --
202: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
203: l_worksheet_name psb_worksheets.name%TYPE ;
204: l_budget_group_name psb_budget_groups.name%TYPE ;
205: l_recipient_name VARCHAR2(2000);
206: --

Line 203: l_worksheet_name psb_worksheets.name%TYPE ;

199: )
200: IS
201: --
202: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
203: l_worksheet_name psb_worksheets.name%TYPE ;
204: l_budget_group_name psb_budget_groups.name%TYPE ;
205: l_recipient_name VARCHAR2(2000);
206: --
207: BEGIN

Line 228: FROM psb_worksheets_v

224: budget_group_name
225: INTO
226: l_worksheet_name ,
227: l_budget_group_name
228: FROM psb_worksheets_v
229: WHERE worksheet_id = l_worksheet_id;
230:
231: --
232: WF_Engine.SetItemAttrText