eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WORKSHEET dependencies on PSB_WORKSHEET

Line 1: PACKAGE BODY PSB_WORKSHEET AS

1: PACKAGE BODY PSB_WORKSHEET AS
2: /* $Header: PSBVWCMB.pls 120.15 2005/11/16 11:20:28 viraghun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WORKSHEET';
5:

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

1: PACKAGE BODY PSB_WORKSHEET AS
2: /* $Header: PSBVWCMB.pls 120.15 2005/11/16 11:20:28 viraghun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WORKSHEET';
5:
6: -- TokNameArray contains names of all tokens
7:
8: TYPE TokNameArray IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

Line 712: PSB_WORKSHEET.Update_Worksheet

708: then
709: raise FND_API.G_EXC_UNEXPECTED_ERROR;
710: end if;
711:
712: PSB_WORKSHEET.Update_Worksheet
713: (p_api_version => 1.0,
714: p_return_status => l_return_status,
715: p_worksheet_id => p_worksheet_id,
716: p_ws_creation_complete => 'N');

Line 952: PSB_WORKSHEET.Update_Worksheet

948:
949: end;
950: end if;
951:
952: PSB_WORKSHEET.Update_Worksheet
953: (p_api_version => 1.0,
954: p_return_status => l_return_status,
955: p_worksheet_id => p_worksheet_id,
956: p_ws_creation_complete => 'Y');

Line 1083: from PSB_WORKSHEETS_V

1079: nvl(constraint_set_id, global_constraint_set_id) constraint_set_id,
1080: budget_calendar_id,
1081: nvl(data_extract_id, global_data_extract_id) data_extract_id,
1082: budget_by_position
1083: from PSB_WORKSHEETS_V
1084: where worksheet_id = p_worksheet_id;
1085:
1086: cursor c_BG is
1087: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,

Line 1476: PSB_WORKSHEET.Update_Worksheet

1472: delete from PSB_ERROR_MESSAGES
1473: where source_process = 'WORKSHEET_CREATION'
1474: and process_id = p_worksheet_id;
1475:
1476: PSB_WORKSHEET.Update_Worksheet
1477: (p_api_version => 1.0,
1478: p_return_status => l_return_status,
1479: p_worksheet_id => p_worksheet_id,
1480: p_ws_creation_complete => 'N');

Line 1968: from PSB_WORKSHEETS_V

1964: nvl(constraint_set_id, global_constraint_set_id) constraint_set_id,
1965: budget_calendar_id,
1966: nvl(data_extract_id, global_data_extract_id) data_extract_id,
1967: budget_by_position
1968: from PSB_WORKSHEETS_V
1969: where worksheet_id = p_worksheet_id;
1970:
1971: cursor c_BG is
1972: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,

Line 2181: from PSB_WORKSHEETS_V

2177: nvl(constraint_set_id, global_constraint_set_id) constraint_set_id,
2178: budget_calendar_id,
2179: nvl(data_extract_id, global_data_extract_id) data_extract_id,
2180: budget_by_position
2181: from PSB_WORKSHEETS_V
2182: where worksheet_id = p_worksheet_id;
2183:
2184: cursor c_BG is
2185: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,

Line 2395: from PSB_WORKSHEETS_V

2391: nvl(constraint_set_id, global_constraint_set_id) constraint_set_id,
2392: budget_calendar_id,
2393: nvl(data_extract_id, global_data_extract_id) data_extract_id,
2394: budget_by_position
2395: from PSB_WORKSHEETS_V
2396: where worksheet_id = p_worksheet_id;
2397:
2398: cursor c_BG is
2399: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) chart_of_accounts_id,

Line 2591: PSB_WORKSHEET.Update_Worksheet

2587: then
2588: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2589: end if;
2590:
2591: PSB_WORKSHEET.Update_Worksheet
2592: (p_api_version => 1.0,
2593: p_return_status => l_return_status,
2594: p_worksheet_id => p_worksheet_id,
2595: p_ws_creation_complete => 'Y');

Line 2816: select psb_worksheets_s.nextval worksheet_id

2812: from psb_budget_stages
2813: where budget_stage_set_id = p_stage_set_id;
2814:
2815: cursor c_Seq is
2816: select psb_worksheets_s.nextval worksheet_id
2817: from dual;
2818:
2819: cursor c_Budget_Group is
2820: select short_name

Line 2853: insert into PSB_WORKSHEETS

2849: for c_Budget_Group_Rec in C_Budget_Group loop
2850: l_worksheet_name := c_Budget_Group_Rec.short_name || ' - '|| to_char(l_worksheet_id);
2851: end loop;
2852:
2853: insert into PSB_WORKSHEETS
2854: (worksheet_id,
2855: budget_group_id,
2856: budget_calendar_id,
2857: worksheet_type,

Line 3098: from psb_worksheets

3094:
3095: /* BUG 3239307 Start */
3096: select gl_cutoff_period
3097: into l_gl_cutoff_period
3098: from psb_worksheets
3099: where worksheet_id = p_worksheet_id;
3100: /* BUG 3239307 End */
3101:
3102: update PSB_WORKSHEETS

Line 3102: update PSB_WORKSHEETS

3098: from psb_worksheets
3099: where worksheet_id = p_worksheet_id;
3100: /* BUG 3239307 End */
3101:
3102: update PSB_WORKSHEETS
3103: set worksheet_type = decode(p_worksheet_type, FND_API.G_MISS_CHAR, worksheet_type, p_worksheet_type),
3104: description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description),
3105: ws_creation_complete = decode(p_ws_creation_complete, FND_API.G_MISS_CHAR, ws_creation_complete, p_ws_creation_complete),
3106: global_worksheet_id = decode(p_global_worksheet_id, FND_API.G_MISS_NUM, global_worksheet_id, p_global_worksheet_id),

Line 3158: update psb_worksheets

3154: /* BUG 3239307 Start */
3155: if (NVL(p_gl_cutoff_period, to_date('31-12-4712', 'dd-mm-yyyy')) <>
3156: NVL(l_gl_cutoff_period, to_date('31-12-4712', 'dd-mm-yyyy')))
3157: then
3158: update psb_worksheets
3159: set gl_cutoff_period = p_gl_cutoff_period
3160: where global_worksheet_id = p_worksheet_id;
3161: end if;
3162: /* BUG 3239307 End */

Line 3214: delete from PSB_WORKSHEETS

3210: then
3211: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3212: end if;
3213:
3214: delete from PSB_WORKSHEETS
3215: where worksheet_id = p_worksheet_id;
3216:
3217:
3218: -- Initialize API return status to success

Line 3362: from PSB_WORKSHEETS

3358: from PSB_WS_POSITION_LINES
3359: where position_line_id = p_position_line_id)
3360: and worksheet_id =
3361: (select nvl(global_worksheet_id, worksheet_id)
3362: from PSB_WORKSHEETS
3363: where worksheet_id = p_worksheet_id);
3364:
3365: delete from PSB_WS_POSITION_LINES
3366: where position_line_id = p_position_line_id;

Line 3678: from PSB_WORKSHEETS_V

3674: include_cbc_oblig_balance,
3675: include_cbc_budget_balance,
3676: /* Bug No 4725091 */
3677: include_gl_forward_balance
3678: from PSB_WORKSHEETS_V
3679: where worksheet_id = p_worksheet_id;
3680:
3681: -- Bug 3543845: Add root_budget_greoup, ps_account_position_set_id, and
3682: -- nps_account_position_set_id for caching purposes.

Line 4098: END PSB_WORKSHEET;

4094: END Get_Debug;
4095:
4096: /* ----------------------------------------------------------------------- */
4097:
4098: END PSB_WORKSHEET;