APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_WORKSHEET

Line 1: PACKAGE BODY PSB_WORKSHEET_CONSOLIDATE AS

1: PACKAGE BODY PSB_WORKSHEET_CONSOLIDATE AS
2: /* $Header: PSBVWCDB.pls 120.4 2005/08/09 09:29:56 masethur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WORKSHEET_CONSOLIDATE';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WORKSHEET_CONSOLIDATE';

1: PACKAGE BODY PSB_WORKSHEET_CONSOLIDATE AS
2: /* $Header: PSBVWCDB.pls 120.4 2005/08/09 09:29:56 masethur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WORKSHEET_CONSOLIDATE';
5:
6: g_userid NUMBER;
7: g_loginid NUMBER;
8:

Line 2335: PSB_WORKSHEETS b

2331: cursor c_Global_WS is
2332: select b.data_extract_id,
2333: a.business_group_id
2334: from PSB_DATA_EXTRACTS a,
2335: PSB_WORKSHEETS b
2336: where a.data_extract_id = b.data_extract_id
2337: and b.worksheet_id = p_global_worksheet_id;
2338:
2339: cursor c_Local_WS_Pos is

Line 2344: PSB_WORKSHEETS b,

2340: select c.local_worksheet_id,
2341: b.data_extract_id,
2342: a.business_group_id
2343: from PSB_DATA_EXTRACTS a,
2344: PSB_WORKSHEETS b,
2345: PSB_WS_CONSOLIDATION_DETAILS c
2346: where a.data_extract_id = b.data_extract_id
2347: and b.worksheet_id = c.local_worksheet_id
2348: and c.global_worksheet_id = p_global_worksheet_id;

Line 2367: PSB_WORKSHEET.Update_Worksheet

2363: then
2364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2365: end if;
2366:
2367: PSB_WORKSHEET.Update_Worksheet
2368: (p_api_version => 1.0,
2369: p_return_status => l_return_status,
2370: p_worksheet_id => p_global_worksheet_id,
2371: p_ws_creation_complete => 'N');

Line 2534: PSB_WORKSHEET.Update_Worksheet

2530: commit work;
2531:
2532: end loop;
2533:
2534: PSB_WORKSHEET.Update_Worksheet
2535: (p_api_version => 1.0,
2536: p_return_status => l_return_status,
2537: p_worksheet_id => p_global_worksheet_id,
2538: p_ws_creation_complete => 'Y');

Line 2602: PSB_WORKSHEETS b

2598: b.budget_by_position,
2599: b.budget_group_id,
2600: nvl(a.set_of_books_id, a.root_set_of_books_id) set_of_books_id
2601: from PSB_BUDGET_GROUPS_V a,
2602: PSB_WORKSHEETS b
2603: where a.budget_group_id = b.budget_group_id
2604: and b.worksheet_id = p_global_worksheet_id;
2605:
2606: cursor c_Local_WS is

Line 2616: PSB_WORKSHEETS b,

2612: b.budget_by_position,
2613: b.budget_group_id,
2614: nvl(a.set_of_books_id, a.root_set_of_books_id) set_of_books_id
2615: from PSB_BUDGET_GROUPS_V a,
2616: PSB_WORKSHEETS b,
2617: PSB_WS_CONSOLIDATION_DETAILS c
2618: where a.budget_group_id = b.budget_group_id
2619: and b.worksheet_id = c.local_worksheet_id
2620: and c.global_worksheet_id = p_global_worksheet_id;

Line 2832: END PSB_WORKSHEET_CONSOLIDATE;

2828: END add_message;
2829:
2830: /* ----------------------------------------------------------------------- */
2831:
2832: END PSB_WORKSHEET_CONSOLIDATE;