APPS.PSB_EXCEL_PVT dependencies on PSB_WORKSHEETS

Line 147: l_export_name psb_worksheets_i.export_name%TYPE;

143: l_account_export_status VARCHAR2(10);
144: l_position_export_status VARCHAR2(10);
145:
146: l_export_seq NUMBER;
147: l_export_name psb_worksheets_i.export_name%TYPE;
148:
149: l_api_name CONSTANT VARCHAR2(30) := 'Move_To_Interface' ;
150: l_api_version CONSTANT NUMBER := 1.0 ;
151: --

Line 266: -- The psb_worksheets_i.export_name is VARCHAR2(80). If necessary, truncate

262: l_export_seq := Get_Next_Export_Seq;
263: g_export_id := l_export_seq;
264: g_msg_export_id := l_export_seq;
265:
266: -- The psb_worksheets_i.export_name is VARCHAR2(80). If necessary, truncate
267: -- export_name to accomodate the export_id at the end.
268: l_export_name := substr( p_export_name,
269: 1,
270: 80 - length(to_char(l_export_seq)) - 1)

Line 295: Insert into PSB_WORKSHEETS_I

291: END IF;
292:
293: Setup_Year_View(p_worksheet_id, g_user_id);
294:
295: Insert into PSB_WORKSHEETS_I
296: (EXPORT_ID,
297: EXPORT_NAME,
298: WORKSHEET_ID,
299: STAGE_ID,

Line 348: update psb_worksheets_i

344:
345: END IF;
346:
347: -- Populate Position WS Lines sets the global variable g_allow_position_import
348: update psb_worksheets_i
349: set allow_position_import = g_allow_position_import
350: where export_id = g_export_id;
351:
352: IF FND_API.to_Boolean (p_commit) then

Line 526: FROM psb_worksheets

522: IS
523: l_current_stage_seq NUMBER := 0;
524: CURSOR ws_cur IS
525: SELECT current_stage_seq
526: FROM psb_worksheets
527: WHERE worksheet_id = g_worksheet_id;
528: Recinfo ws_cur%ROWTYPE;
529: BEGIN
530: OPEN ws_cur;

Line 3376: DELETE FROM psb_worksheets_i

3372:
3373: DELETE FROM psb_ws_columns_i
3374: WHERE export_id = p_export_id;
3375:
3376: DELETE FROM psb_worksheets_i
3377: WHERE export_id = p_export_id;
3378:
3379: IF FND_API.to_Boolean (p_commit) then
3380: commit work;