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_WS_OPS_PVT dependencies on PSB_WS_ACCT1

Line 722: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id

718: --
719: -- Get budget calendar related info to find all the budget groups down in the
720: -- current hierarchy to get all the CCIDs for the current budget group.
721: --
722: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id
723: THEN
724: --
725: PSB_WS_Acct1.Cache_Budget_Calendar
726: (

Line 725: PSB_WS_Acct1.Cache_Budget_Calendar

721: --
722: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id
723: THEN
724: --
725: PSB_WS_Acct1.Cache_Budget_Calendar
726: (
727: p_return_status => l_return_status ,
728: p_budget_calendar_id => l_main_budget_calendar_id
729: );

Line 1217: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id

1213: --
1214: -- Get budget calendar related info to find all the budget groups down in the
1215: -- current hierarchy to get all the CCIDs for the current budget group.
1216: --
1217: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id
1218: THEN
1219: --
1220: PSB_WS_Acct1.Cache_Budget_Calendar
1221: (

Line 1220: PSB_WS_Acct1.Cache_Budget_Calendar

1216: --
1217: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id
1218: THEN
1219: --
1220: PSB_WS_Acct1.Cache_Budget_Calendar
1221: (
1222: p_return_status => l_return_status ,
1223: p_budget_calendar_id => l_main_budget_calendar_id
1224: );

Line 1251: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

1247: AND accts.budget_group_id IN
1248: ( SELECT budget_group_id
1249: FROM psb_budget_groups
1250: WHERE budget_group_type = 'R'
1251: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1252: AND ((effective_end_date IS NULL)
1253: OR
1254: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
1255: START WITH budget_group_id = p_budget_group_id

Line 1254: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

1250: WHERE budget_group_type = 'R'
1251: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1252: AND ((effective_end_date IS NULL)
1253: OR
1254: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
1255: START WITH budget_group_id = p_budget_group_id
1256: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
1257: )
1258: */

Line 1264: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

1260: ( SELECT 1
1261: FROM psb_budget_groups
1262: WHERE budget_group_type = 'R'
1263: AND budget_group_id = accts.budget_group_id
1264: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1265: AND ((effective_end_date IS NULL)
1266: OR
1267: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
1268: START WITH budget_group_id = p_budget_group_id

Line 1267: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

1263: AND budget_group_id = accts.budget_group_id
1264: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1265: AND ((effective_end_date IS NULL)
1266: OR
1267: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
1268: START WITH budget_group_id = p_budget_group_id
1269: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
1270: )
1271: /*For Bug No : 2236283 End*/

Line 1329: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

1325: (
1326: SELECT bg.budget_group_id
1327: FROM psb_budget_groups bg
1328: WHERE bg.budget_group_type = 'R'
1329: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1330: AND ((effective_end_date IS NULL)
1331: OR
1332: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy )
1333: )

Line 1332: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy )

1328: WHERE bg.budget_group_type = 'R'
1329: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1330: AND ((effective_end_date IS NULL)
1331: OR
1332: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy )
1333: )
1334: START WITH bg.budget_group_id = p_budget_group_id
1335: CONNECT BY PRIOR bg.budget_group_id =
1336: bg.parent_budget_group_id

Line 1351: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

1347: SELECT bg.budget_group_id
1348: FROM psb_budget_groups bg
1349: WHERE bg.budget_group_type = 'R'
1350: AND budget_group_id = acct_lines.budget_group_id
1351: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1352: AND ((effective_end_date IS NULL)
1353: OR
1354: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy )
1355: )

Line 1354: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy )

1350: AND budget_group_id = acct_lines.budget_group_id
1351: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1352: AND ((effective_end_date IS NULL)
1353: OR
1354: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy )
1355: )
1356: START WITH bg.budget_group_id = p_budget_group_id
1357: CONNECT BY PRIOR bg.budget_group_id =
1358: bg.parent_budget_group_id

Line 1481: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;

1477: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;
1478: l_new_position_assignment_id
1479: psb_position_assignments.position_assignment_id%TYPE ;
1480: l_rowid VARCHAR2(2000);
1481: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
1482: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
1483: l_segment_values_tbl FND_FLEX_EXT.SegmentArray ;
1484: --
1485: l_dummy_account_line_id psb_ws_account_lines.account_line_id%TYPE ;

Line 1482: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;

1478: l_new_position_assignment_id
1479: psb_position_assignments.position_assignment_id%TYPE ;
1480: l_rowid VARCHAR2(2000);
1481: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
1482: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
1483: l_segment_values_tbl FND_FLEX_EXT.SegmentArray ;
1484: --
1485: l_dummy_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
1486: --

Line 1770: -- Populate the l_period_fte_tbl ( used by PSB_WS_Acct1 API )

1766: )
1767: LOOP
1768:
1769: --
1770: -- Populate the l_period_fte_tbl ( used by PSB_WS_Acct1 API )
1771: --
1772: l_period_fte_tbl(1) := l_fte_rec.period1_fte ;
1773: l_period_fte_tbl(2) := l_fte_rec.period2_fte ;
1774: l_period_fte_tbl(3) := l_fte_rec.period3_fte ;

Line 2082: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;

2078: --
2079: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2080: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2081: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
2082: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2083: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2084: l_segment_values_tbl FND_FLEX_EXT.SegmentArray ;
2085: --
2086: CURSOR l_ws_account_lines_csr

Line 2083: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;

2079: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2080: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2081: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
2082: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2083: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2084: l_segment_values_tbl FND_FLEX_EXT.SegmentArray ;
2085: --
2086: CURSOR l_ws_account_lines_csr
2087: (

Line 2223: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )

2219:
2220: FETCH l_ws_account_lines_csr INTO l_target_account_line_id;
2221:
2222: --
2223: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )
2224: --
2225: l_period_amount_tbl(1) := l_lines_accts_rec.period1_amount ;
2226: l_period_amount_tbl(2) := l_lines_accts_rec.period2_amount ;
2227: l_period_amount_tbl(3) := l_lines_accts_rec.period3_amount ;

Line 2554: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )

2550: )
2551: LOOP
2552:
2553: --
2554: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )
2555: --
2556: l_period_fte_tbl(1) := l_fte_rec.period1_fte ;
2557: l_period_fte_tbl(2) := l_fte_rec.period2_fte ;
2558: l_period_fte_tbl(3) := l_fte_rec.period3_fte ;

Line 2808: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )

2804:
2805: FETCH l_ws_account_lines_csr INTO l_target_account_line_id;
2806:
2807: --
2808: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )
2809: --
2810: l_period_amount_tbl(1) := l_lines_accts_rec.period1_amount ;
2811: l_period_amount_tbl(2) := l_lines_accts_rec.period2_amount ;
2812: l_period_amount_tbl(3) := l_lines_accts_rec.period3_amount ;

Line 3016: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )

3012: )
3013: LOOP
3014:
3015: --
3016: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )
3017: --
3018: l_period_fte_tbl(1) := l_fte_rec.period1_fte ;
3019: l_period_fte_tbl(2) := l_fte_rec.period2_fte ;
3020: l_period_fte_tbl(3) := l_fte_rec.period3_fte ;

Line 5505: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id

5501: --
5502: -- Use budget calendar related info to find all the budget groups down
5503: -- in the current hierarchy .
5504: --
5505: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
5506: THEN
5507: --
5508: PSB_WS_Acct1.Cache_Budget_Calendar
5509: (

Line 5508: PSB_WS_Acct1.Cache_Budget_Calendar

5504: --
5505: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
5506: THEN
5507: --
5508: PSB_WS_Acct1.Cache_Budget_Calendar
5509: (
5510: p_return_status => l_return_status ,
5511: p_budget_calendar_id => l_budget_calendar_id
5512: );

Line 5532: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

5528: (
5529: SELECT budget_group_id
5530: FROM psb_budget_groups
5531: WHERE budget_group_type = 'R'
5532: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5533: AND ((effective_end_date IS NULL)
5534: OR
5535: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5536: START WITH budget_group_id = l_budget_group_id

Line 5535: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

5531: WHERE budget_group_type = 'R'
5532: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5533: AND ((effective_end_date IS NULL)
5534: OR
5535: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5536: START WITH budget_group_id = l_budget_group_id
5537: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
5538: )
5539: LOOP

Line 5805: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id

5801: --
5802: -- Get budget calendar related info to find all the budget groups down in
5803: -- the current hierarchy to get all the CCIDs for the current budget group.
5804: --
5805: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
5806: THEN
5807: --
5808: PSB_WS_Acct1.Cache_Budget_Calendar
5809: (

Line 5808: PSB_WS_Acct1.Cache_Budget_Calendar

5804: --
5805: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
5806: THEN
5807: --
5808: PSB_WS_Acct1.Cache_Budget_Calendar
5809: (
5810: p_return_status => l_return_status ,
5811: p_budget_calendar_id => l_budget_calendar_id
5812: );

Line 5840: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

5836: AND accts.budget_group_id IN
5837: ( SELECT budget_group_id
5838: FROM psb_budget_groups
5839: WHERE budget_group_type = 'R'
5840: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5841: AND ((effective_end_date IS NULL)
5842: OR
5843: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5844: START WITH budget_group_id = l_target_budget_group_id

Line 5843: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

5839: WHERE budget_group_type = 'R'
5840: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5841: AND ((effective_end_date IS NULL)
5842: OR
5843: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5844: START WITH budget_group_id = l_target_budget_group_id
5845: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
5846: )
5847: */

Line 5853: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

5849: ( SELECT 1
5850: FROM psb_budget_groups
5851: WHERE budget_group_type = 'R'
5852: AND budget_group_id = accts.budget_group_id
5853: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5854: AND ((effective_end_date IS NULL)
5855: OR
5856: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5857: START WITH budget_group_id = l_target_budget_group_id

Line 5856: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

5852: AND budget_group_id = accts.budget_group_id
5853: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5854: AND ((effective_end_date IS NULL)
5855: OR
5856: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5857: START WITH budget_group_id = l_target_budget_group_id
5858: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
5859: )
5860: /*For Bug No : 2236283 End*/

Line 5924: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

5920: (
5921: SELECT bg.budget_group_id
5922: FROM psb_budget_groups bg
5923: WHERE bg.budget_group_type = 'R'
5924: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5925: AND ((effective_end_date IS NULL)
5926: OR
5927: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5928: START WITH bg.budget_group_id = l_target_budget_group_id

Line 5927: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

5923: WHERE bg.budget_group_type = 'R'
5924: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5925: AND ((effective_end_date IS NULL)
5926: OR
5927: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5928: START WITH bg.budget_group_id = l_target_budget_group_id
5929: CONNECT BY PRIOR bg.budget_group_id = bg.parent_budget_group_id
5930: )
5931: )

Line 5944: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

5940: SELECT 1
5941: FROM psb_budget_groups bg
5942: WHERE bg.budget_group_type = 'R'
5943: AND bg.budget_group_id = acct_lines.budget_group_id
5944: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5945: AND ((effective_end_date IS NULL)
5946: OR
5947: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5948: START WITH bg.budget_group_id = l_target_budget_group_id

Line 5947: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

5943: AND bg.budget_group_id = acct_lines.budget_group_id
5944: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5945: AND ((effective_end_date IS NULL)
5946: OR
5947: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
5948: START WITH bg.budget_group_id = l_target_budget_group_id
5949: CONNECT BY PRIOR bg.budget_group_id = bg.parent_budget_group_id
5950: )
5951: )

Line 6059: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;

6055: l_msg_count NUMBER ;
6056: l_msg_data VARCHAR2(2000) ;
6057: --
6058: l_dummy_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
6059: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
6060: --
6061: BEGIN
6062:
6063: SAVEPOINT Create_Local_Dist_Pvt ;

Line 6075: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )

6071: WHERE account_line_id = p_account_line_id
6072: )
6073: LOOP
6074: --
6075: -- Populate the l_period_amount_tbl ( used by PSB_WS_Acct1 API )
6076: --
6077: l_period_amount_tbl(1) := l_accts_rec.period1_amount ;
6078: l_period_amount_tbl(2) := l_accts_rec.period2_amount ;
6079: l_period_amount_tbl(3) := l_accts_rec.period3_amount ;

Line 6358: IF l_record_ctr = PSB_WS_ACCT1.g_checkpoint_save THEN

6354: WHERE account_line_id = l_account_line_id;
6355: --
6356: /*For Bug No : 2266309 Start*/
6357: l_record_ctr := l_record_ctr + 1;
6358: IF l_record_ctr = PSB_WS_ACCT1.g_checkpoint_save THEN
6359: COMMIT WORK;
6360: l_record_ctr := 0;
6361: SAVEPOINT Delete_Worksheet_Pvt;
6362: END IF;

Line 6399: IF l_record_ctr >= PSB_WS_ACCT1.g_checkpoint_save THEN

6395: WHERE position_line_id = l_position_line_id;
6396:
6397: /*For Bug No : 2266309 Start*/
6398: l_record_ctr := l_record_ctr + 3;
6399: IF l_record_ctr >= PSB_WS_ACCT1.g_checkpoint_save THEN
6400: COMMIT WORK;
6401: l_record_ctr := 0;
6402: SAVEPOINT Delete_Worksheet_Pvt;
6403: END IF;

Line 6794: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id

6790: --
6791: -- Get budget calendar related info to find all the budget groups down in the
6792: -- current hierarchy to get all the CCIDs for the current budget group.
6793: --
6794: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id
6795: THEN
6796: --
6797: PSB_WS_Acct1.Cache_Budget_Calendar
6798: (

Line 6797: PSB_WS_Acct1.Cache_Budget_Calendar

6793: --
6794: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_main_budget_calendar_id
6795: THEN
6796: --
6797: PSB_WS_Acct1.Cache_Budget_Calendar
6798: (
6799: p_return_status => l_return_status ,
6800: p_budget_calendar_id => l_main_budget_calendar_id
6801: );