DBA Data[Home] [Help]

APPS.PSB_EXCEL_PVT dependencies on PSB_WS_LINE_BALANCES_I

Line 1186: insert into psb_ws_line_balances_i(

1182: ELSE
1183: l_position_account_flag := 'N';
1184: END IF;
1185:
1186: insert into psb_ws_line_balances_i(
1187: EXPORT_ID,
1188: EXPORT_WORKSHEET_TYPE,
1189: CODE_COMBINATION_ID,
1190: CONCATENATED_ACCOUNT,

Line 2096: INSERT INTO psb_ws_line_balances_i(

2092: -- (12 years * 12 periods ) + 12 years * 2 misc columns = 168
2093: -- 4 misc columns (Year Total, Percentage, Start stage seq, End stage seq)
2094: -- Later include amount169..amount220 when supporting
2095: -- more than 12 periods for an year
2096: INSERT INTO psb_ws_line_balances_i(
2097: EXPORT_ID,
2098: EXPORT_WORKSHEET_TYPE,
2099: CODE_COMBINATION_ID,
2100: BUDGET_GROUP_ID,

Line 2545: INSERT INTO psb_ws_line_balances_i(

2541:
2542: END LOOP; -- for each budget year and balance;
2543:
2544: -- Insert Statement
2545: INSERT INTO psb_ws_line_balances_i(
2546: EXPORT_ID,
2547: EXPORT_WORKSHEET_TYPE,
2548: CODE_COMBINATION_ID,
2549: BUDGET_GROUP_ID,

Line 3370: DELETE FROM psb_ws_line_balances_i

3366: END IF;
3367: --
3368: p_return_status := FND_API.G_RET_STS_SUCCESS ;
3369:
3370: DELETE FROM psb_ws_line_balances_i
3371: WHERE export_id = p_export_id;
3372:
3373: DELETE FROM psb_ws_columns_i
3374: WHERE export_id = p_export_id;