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_PVT dependencies on PSB_WORKSHEET

Line 1: PACKAGE BODY PSB_WORKSHEET_PVT AS

1: PACKAGE BODY PSB_WORKSHEET_PVT AS
2: /* $Header: PSBPWCMB.pls 120.10 2005/11/14 11:51:55 viraghun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WORKSHEET_PVT';
5:

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

1: PACKAGE BODY PSB_WORKSHEET_PVT AS
2: /* $Header: PSBPWCMB.pls 120.10 2005/11/14 11:51:55 viraghun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WORKSHEET_PVT';
5:
6: /* ----------------------------------------------------------------------- */
7:
8: PROCEDURE Create_WS_Line_Items

Line 49: PSB_WORKSHEET.Create_WS_Line_Items

45:
46:
47: -- Call Private Function
48:
49: PSB_WORKSHEET.Create_WS_Line_Items
50: (p_api_version => 1.0,
51: p_return_status => p_return_status,
52: p_worksheet_id => p_worksheet_id);
53:

Line 141: PSB_WORKSHEET.Delete_WS_Line_Items

137:
138:
139: -- Call Private Function
140:
141: PSB_WORKSHEET.Delete_WS_Line_Items
142: (p_api_version => 1.0,
143: p_return_status => p_return_status,
144: p_worksheet_id => p_worksheet_id,
145: p_global_worksheet => p_global_worksheet);

Line 291: PSB_WORKSHEET.Create_Worksheet

287:
288:
289: -- Call Private Function
290:
291: PSB_WORKSHEET.Create_Worksheet
292: (p_api_version => 1.0,
293: p_validation_level => p_validation_level,
294: p_return_status => p_return_status,
295: p_budget_group_id => p_budget_group_id,

Line 486: PSB_WORKSHEET.Update_Worksheet

482:
483:
484: -- Call Private Function
485:
486: PSB_WORKSHEET.Update_Worksheet
487: (p_api_version => 1.0,
488: p_validation_level => p_validation_level,
489: p_return_status => p_return_status,
490: p_worksheet_id => p_worksheet_id,

Line 623: PSB_WORKSHEET.Delete_Worksheet

619:
620:
621: -- Call Private Function
622:
623: PSB_WORKSHEET.Delete_Worksheet
624: (p_api_version => 1.0,
625: p_return_status => p_return_status,
626: p_worksheet_id => p_worksheet_id);
627:

Line 730: PSB_WORKSHEET.Apply_Constraints

726:
727:
728: -- Call Private Function
729:
730: PSB_WORKSHEET.Apply_Constraints
731: (p_api_version => 1.0,
732: p_validation_level => p_validation_level,
733: p_return_status => p_return_status,
734: p_validation_status => p_validation_status,

Line 834: PSB_WORKSHEET.Validate_Entity_Set

830:
831:
832: -- Call Private Function
833:
834: PSB_WORKSHEET.Validate_Entity_Set
835: (p_api_version => 1.0,
836: p_validation_level => p_validation_level,
837: p_return_status => p_return_status,
838: p_data_extract_id => p_data_extract_id,

Line 921: PSB_WORKSHEET.Delete_WPL

917:
918:
919: -- Call Private Function
920:
921: PSB_WORKSHEET.Delete_WPL
922: (p_api_version => 1.0,
923: p_validation_level => p_validation_level,
924: p_return_status => p_return_status,
925: p_worksheet_id => p_worksheet_id,

Line 1008: PSB_WORKSHEETS_V b

1004: cursor c_BG is
1005: select nvl(b.data_extract_id, b.global_data_extract_id) data_extract_id,
1006: nvl(a.root_budget_group_id, a.budget_group_id) root_budget_group_id
1007: from PSB_BUDGET_GROUPS_V a,
1008: PSB_WORKSHEETS_V b
1009: where a.budget_group_id = b.budget_group_id
1010: and b.worksheet_id = p_worksheet_id;
1011: */
1012:

Line 1020: FROM psb_worksheets

1016: SELECT nvl(global_worksheet_id, worksheet_id) global_worksheet_id,
1017: data_extract_id
1018: INTO l_global_worksheet_id,
1019: l_data_extract_id
1020: FROM psb_worksheets
1021: WHERE worksheet_id = p_worksheet_id;
1022:
1023: -- Do not need to query if it's a global worksheet
1024: IF p_worksheet_id <> l_global_worksheet_id THEN

Line 1026: FROM psb_worksheets

1022:
1023: -- Do not need to query if it's a global worksheet
1024: IF p_worksheet_id <> l_global_worksheet_id THEN
1025: SELECT data_extract_id INTO l_data_extract_id
1026: FROM psb_worksheets
1027: WHERE worksheet_id = l_global_worksheet_id ;
1028: END IF;
1029: /* Bug 3458191 end */
1030:

Line 1119: PSB_WORKSHEET_PVT.Create_WS_Line_Items

1115: end if;
1116:
1117: end if;
1118:
1119: PSB_WORKSHEET_PVT.Create_WS_Line_Items
1120: (p_api_version => 1.0,
1121: p_return_status => l_return_status,
1122: p_msg_count => l_msg_count,
1123: p_msg_data => l_msg_data,

Line 1202: FROM psb_worksheets ws, psb_budget_groups bg1

1198: l_set_of_books_id
1199: FROM psb_budget_groups bg
1200: WHERE bg.budget_group_id =
1201: (SELECT nvl(bg1.root_budget_group_id, bg1.budget_group_id) root_budget_group_id
1202: FROM psb_worksheets ws, psb_budget_groups bg1
1203: WHERE bg1.budget_group_id = ws.budget_group_id
1204: and ws.worksheet_id = p_worksheet_id);
1205:
1206: PSB_Budget_Account_PVT.Populate_Budget_Accounts

Line 1299: PSB_WORKSHEET.Pre_Create_Line_Items

1295: l_return_status VARCHAR2(1) ;
1296:
1297: BEGIN
1298:
1299: PSB_WORKSHEET.Pre_Create_Line_Items
1300: (p_api_version => 1.0,
1301: p_return_status => l_return_status,
1302: p_worksheet_id => p_worksheet_id);
1303:

Line 1378: PSB_WORKSHEET.g_ws_creation_flag := TRUE;

1374: --If the Flag is 'N' then do not process at all
1375: IF p_create_non_pos_line_items = 'Y' then
1376:
1377: -- Bug 3458191: Make g_worksheet_creation_flag to TRUE for ws caching
1378: PSB_WORKSHEET.g_ws_creation_flag := TRUE;
1379:
1380: PSB_WORKSHEET.Create_Acct_Line_Items
1381: (p_api_version => 1.0,
1382: p_return_status => l_return_status,

Line 1380: PSB_WORKSHEET.Create_Acct_Line_Items

1376:
1377: -- Bug 3458191: Make g_worksheet_creation_flag to TRUE for ws caching
1378: PSB_WORKSHEET.g_ws_creation_flag := TRUE;
1379:
1380: PSB_WORKSHEET.Create_Acct_Line_Items
1381: (p_api_version => 1.0,
1382: p_return_status => l_return_status,
1383: p_worksheet_id => p_worksheet_id);
1384:

Line 1386: PSB_WORKSHEET.g_ws_creation_flag := FALSE;

1382: p_return_status => l_return_status,
1383: p_worksheet_id => p_worksheet_id);
1384:
1385: -- Bug 3458191: Reset g_worksheet_creation_flag to FALSE
1386: PSB_WORKSHEET.g_ws_creation_flag := FALSE;
1387:
1388: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1389: raise FND_API.G_EXC_ERROR;
1390: end if;

Line 1480: PSB_WORKSHEET.Create_Pos_Line_Items

1476: BEGIN
1477:
1478: IF p_create_positions = 'Y' THEN
1479:
1480: PSB_WORKSHEET.Create_Pos_Line_Items
1481: (p_api_version => 1.0,
1482: p_return_status => l_return_status,
1483: p_worksheet_id => p_worksheet_id);
1484:

Line 1560: PSB_WORKSHEET.Apply_Acct_Constraints

1556: BEGIN
1557:
1558: IF p_apply_constraints = 'Y' THEN
1559:
1560: PSB_WORKSHEET.Apply_Acct_Constraints
1561: (p_api_version => 1.0,
1562: p_return_status => l_return_status,
1563: p_worksheet_id => p_worksheet_id);
1564:

Line 1640: PSB_WORKSHEET.Apply_Pos_Constraints

1636:
1637: BEGIN
1638: IF p_apply_constraints = 'Y' THEN
1639:
1640: PSB_WORKSHEET.Apply_Pos_Constraints
1641: (p_api_version => 1.0,
1642: p_return_status => l_return_status,
1643: p_worksheet_id => p_worksheet_id);
1644:

Line 1721: PSB_WORKSHEET.Apply_Elem_Constraints

1717: BEGIN
1718:
1719: IF p_apply_constraints = 'Y' THEN
1720:
1721: PSB_WORKSHEET.Apply_Elem_Constraints
1722: (p_api_version => 1.0,
1723: p_return_status => l_return_status,
1724: p_worksheet_id => p_worksheet_id);
1725:

Line 1796: PSB_WORKSHEET.Post_Create_Line_Items

1792: l_return_status VARCHAR2(1) ;
1793:
1794: BEGIN
1795:
1796: PSB_WORKSHEET.Post_Create_Line_Items
1797: (p_api_version => 1.0,
1798: p_return_status => l_return_status,
1799: p_worksheet_id => p_worksheet_id);
1800:

Line 1845: END PSB_WORKSHEET_PVT;

1841: END Post_Create_WS_Lines_CP;
1842:
1843: /* ----------------------------------------------------------------------- */
1844:
1845: END PSB_WORKSHEET_PVT;