APPS.PSB_WORKSHEET dependencies on PSB_WORKSHEETS

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 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 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.