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_ACCOUNT_LINES

Line 755: psb_ws_account_lines accts

751: SELECT lines.* ,
752: accts.code_combination_id ,
753: accts.budget_group_id
754: FROM psb_ws_lines lines ,
755: psb_ws_account_lines accts
756: WHERE lines.worksheet_id = p_worksheet_id
757: AND lines.account_line_id = accts.account_line_id
758: AND ( l_service_package_count = 0
759: OR

Line 854: FROM psb_ws_account_lines accts

850: OR
851: pos_lines.position_line_id IN
852: (
853: SELECT accts.position_line_id
854: FROM psb_ws_account_lines accts
855: WHERE accts.position_line_id = pos_lines.position_line_id
856: AND accts.service_package_id IN
857: (
858: SELECT sp.service_package_id

Line 925: psb_ws_account_lines accts

921: FOR l_lines_rec IN
922: (
923: SELECT lines.*
924: FROM psb_ws_lines lines,
925: psb_ws_account_lines accts
926: WHERE accts.position_line_id = l_lines_pos_rec.position_line_id
927: AND lines.worksheet_id = p_worksheet_id
928: AND lines.account_line_id = accts.account_line_id
929: )

Line 1242: psb_ws_account_lines accts

1238: FOR l_lines_rec IN
1239: (
1240: SELECT lines.*
1241: FROM psb_ws_lines lines ,
1242: psb_ws_account_lines accts
1243: WHERE lines.worksheet_id = p_worksheet_id
1244: AND lines.account_line_id = accts.account_line_id
1245: /*For Bug No : 2236283 Start*/
1246: /*

Line 1323: FROM psb_ws_account_lines acct_lines

1319: /*
1320: AND lines.position_line_id IN
1321: (
1322: SELECT acct_lines.position_line_id
1323: FROM psb_ws_account_lines acct_lines
1324: WHERE acct_lines.budget_group_id IN
1325: (
1326: SELECT bg.budget_group_id
1327: FROM psb_budget_groups bg

Line 1343: FROM psb_ws_account_lines acct_lines

1339: */
1340: AND EXISTS
1341: (
1342: SELECT 1
1343: FROM psb_ws_account_lines acct_lines
1344: WHERE acct_lines.position_line_id = lines.position_line_id
1345: AND EXISTS
1346: (
1347: SELECT bg.budget_group_id

Line 1485: l_dummy_account_line_id psb_ws_account_lines.account_line_id%TYPE ;

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: --
1487: CURSOR l_worksheets_csr IS
1488: SELECT *
1489: FROM psb_worksheets

Line 1625: -- psb_ws_lines and psb_ws_account_lines table for the target worksheet.

1621: END IF;
1622:
1623: --
1624: -- Get account_line related info for the current worksheet to be copied in
1625: -- psb_ws_lines and psb_ws_account_lines table for the target worksheet.
1626: -- The positon related account lines will be updated by position phase.
1627: --
1628: FOR l_lines_accts_rec IN
1629: (

Line 1632: psb_ws_account_lines accts

1628: FOR l_lines_accts_rec IN
1629: (
1630: SELECT accts.*
1631: FROM psb_ws_lines lines ,
1632: psb_ws_account_lines accts
1633: WHERE lines.worksheet_id = p_worksheet_id
1634: AND lines.account_line_id = accts.account_line_id
1635: AND accts.position_line_id IS NULL
1636: )

Line 1639: -- Create records in psb_ws_lines and psb_ws_account_lines for the

1635: AND accts.position_line_id IS NULL
1636: )
1637: LOOP
1638: --
1639: -- Create records in psb_ws_lines and psb_ws_account_lines for the
1640: -- new worksheet.
1641: --
1642: PSB_WS_Ops_Pvt.Create_Local_Dist_Pvt
1643: (

Line 1718: FROM psb_ws_account_lines

1714: --
1715: FOR l_accts_rec IN
1716: (
1717: SELECT account_line_id
1718: FROM psb_ws_account_lines
1719: WHERE position_line_id = l_lines_pos_rec.position_line_id
1720: )
1721: LOOP
1722: --

Line 1743: -- psb_ws_account_lines table.

1739:
1740: /*
1741: --
1742: -- Update the old position_line_id with new position_line_id in
1743: -- psb_ws_account_lines table.
1744: --
1745: UPDATE psb_ws_account_lines
1746: SET position_line_id = l_new_position_line_id
1747: WHERE position_line_id = l_lines_pos_rec.position_line_id

Line 1745: UPDATE psb_ws_account_lines

1741: --
1742: -- Update the old position_line_id with new position_line_id in
1743: -- psb_ws_account_lines table.
1744: --
1745: UPDATE psb_ws_account_lines
1746: SET position_line_id = l_new_position_line_id
1747: WHERE position_line_id = l_lines_pos_rec.position_line_id
1748: AND account_line_id IN
1749: (

Line 2068: l_target_account_line_id psb_ws_account_lines.account_line_id%TYPE ;

2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;
2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2067: l_target_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2068: l_target_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
2069: l_target_position_line_id psb_ws_lines_positions.position_line_id%TYPE;
2070: l_target_position_id psb_ws_position_lines.position_id%TYPE;
2071: --
2072: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE;

Line 2089: psb_ws_account_lines.copy_of_account_line_id%TYPE

2085: --
2086: CURSOR l_ws_account_lines_csr
2087: (
2088: c_copy_of_account_line_id
2089: psb_ws_account_lines.copy_of_account_line_id%TYPE
2090: )
2091: IS
2092: SELECT account_line_id
2093: FROM psb_ws_account_lines

Line 2093: FROM psb_ws_account_lines

2089: psb_ws_account_lines.copy_of_account_line_id%TYPE
2090: )
2091: IS
2092: SELECT account_line_id
2093: FROM psb_ws_account_lines
2094: WHERE account_line_id = NVL( c_copy_of_account_line_id , -99)
2095: AND ROWNUM < 2 ;
2096: --
2097: l_new_account_line_id psb_ws_account_lines.account_line_id%TYPE ;

Line 2097: l_new_account_line_id psb_ws_account_lines.account_line_id%TYPE ;

2093: FROM psb_ws_account_lines
2094: WHERE account_line_id = NVL( c_copy_of_account_line_id , -99)
2095: AND ROWNUM < 2 ;
2096: --
2097: l_new_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
2098: --
2099: CURSOR l_ws_position_lines_csr
2100: (
2101: c_copy_of_position_line_id

Line 2206: psb_ws_account_lines accts

2202: FOR l_lines_accts_rec IN
2203: (
2204: SELECT accts.*
2205: FROM psb_ws_lines lines ,
2206: psb_ws_account_lines accts
2207: WHERE lines.worksheet_id = p_source_worksheet_id
2208: AND lines.account_line_id = accts.account_line_id
2209: AND accts.position_line_id IS NULL
2210: AND accts.end_stage_seq IS NULL

Line 2216: -- Finding p_target_worksheet_id in psb_ws_account_lines.

2212: AND accts.balance_type = 'E'
2213: )
2214: LOOP
2215: --
2216: -- Finding p_target_worksheet_id in psb_ws_account_lines.
2217: --
2218: OPEN l_ws_account_lines_csr ( l_lines_accts_rec.copy_of_account_line_id ) ;
2219:
2220: FETCH l_ws_account_lines_csr INTO l_target_account_line_id;

Line 2477: FROM psb_ws_account_lines

2473: --
2474: FOR l_accts_rec IN
2475: (
2476: SELECT account_line_id
2477: FROM psb_ws_account_lines
2478: WHERE position_line_id = l_lines_pos_rec.position_line_id
2479: )
2480: LOOP
2481: --

Line 2501: -- psb_ws_account_lines table.

2497:
2498: /*
2499: --
2500: -- Update the old position_line_id with new position_line_id in
2501: -- psb_ws_account_lines table.
2502: --
2503: UPDATE psb_ws_account_lines
2504: SET position_line_id = l_new_position_line_id
2505: WHERE position_line_id = l_lines_pos_rec.position_line_id

Line 2503: UPDATE psb_ws_account_lines

2499: --
2500: -- Update the old position_line_id with new position_line_id in
2501: -- psb_ws_account_lines table.
2502: --
2503: UPDATE psb_ws_account_lines
2504: SET position_line_id = l_new_position_line_id
2505: WHERE position_line_id = l_lines_pos_rec.position_line_id
2506: AND account_line_id IN
2507: (

Line 2770: -- psb_ws_account_lines table.

2766: --
2767:
2768: --
2769: -- Update the old position_line_id with new position_line_id in
2770: -- psb_ws_account_lines table.
2771: --
2772: /*For Bug No : 2534088 Start*/
2773: --commented the following code as the complete code to be implemented
2774: --for inserting/updating the account lines for target worksheet

Line 2777: UPDATE psb_ws_account_lines

2773: --commented the following code as the complete code to be implemented
2774: --for inserting/updating the account lines for target worksheet
2775:
2776: /*
2777: UPDATE psb_ws_account_lines
2778: SET position_line_id = l_target_position_line_id
2779: WHERE position_line_id = l_lines_pos_rec.position_line_id
2780: AND account_line_id IN
2781: (

Line 2792: psb_ws_account_lines accts

2788: FOR l_lines_accts_rec IN
2789: (
2790: SELECT accts.*
2791: FROM psb_ws_lines lines ,
2792: psb_ws_account_lines accts
2793: WHERE lines.worksheet_id = p_source_worksheet_id
2794: AND lines.account_line_id = accts.account_line_id
2795: AND accts.position_line_id = l_lines_pos_rec.position_line_id
2796: AND accts.end_stage_seq IS NULL

Line 2801: -- Finding p_target_worksheet_id in psb_ws_account_lines.

2797: AND accts.template_id IS NULL
2798: )
2799: LOOP
2800: --
2801: -- Finding p_target_worksheet_id in psb_ws_account_lines.
2802: --
2803: OPEN l_ws_account_lines_csr ( l_lines_accts_rec.copy_of_account_line_id ) ;
2804:
2805: FETCH l_ws_account_lines_csr INTO l_target_account_line_id;

Line 3744: p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,

3740: p_msg_count OUT NOCOPY NUMBER ,
3741: p_msg_data OUT NOCOPY VARCHAR2 ,
3742: --
3743: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
3744: p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,
3745: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
3746: )
3747: IS
3748: --

Line 3971: psb_ws_account_lines b

3967: select b.account_line_id,
3968: a.view_line_flag,
3969: a.freeze_flag
3970: from psb_ws_lines a,
3971: psb_ws_account_lines b
3972: where a.account_line_id = b.account_line_id
3973: and a.worksheet_id = p_worksheet_id
3974: and b.position_line_id = p_position_line_id;
3975:

Line 4086: p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,

4082: p_return_status OUT NOCOPY VARCHAR2 ,
4083: p_msg_count OUT NOCOPY NUMBER ,
4084: p_msg_data OUT NOCOPY VARCHAR2 ,
4085: --
4086: p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,
4087: p_worksheet_tbl IN Worksheet_Tbl_Type
4088: )
4089: IS
4090: --

Line 4953: -- Update all the lines in psb_ws_account_lines as no service package

4949:
4950: IF l_service_package_count = 0 THEN
4951:
4952: --
4953: -- Update all the lines in psb_ws_account_lines as no service package
4954: -- selection exists.
4955: --
4956: UPDATE psb_ws_account_lines
4957: SET current_stage_seq = l_target_stage_seq

Line 4956: UPDATE psb_ws_account_lines

4952: --
4953: -- Update all the lines in psb_ws_account_lines as no service package
4954: -- selection exists.
4955: --
4956: UPDATE psb_ws_account_lines
4957: SET current_stage_seq = l_target_stage_seq
4958: WHERE l_target_stage_seq > current_stage_seq
4959: AND end_stage_seq is null
4960: AND account_line_id IN

Line 4997: -- Update psb_ws_account_lines as per the service package selection.

4993:
4994: ELSE
4995:
4996: --
4997: -- Update psb_ws_account_lines as per the service package selection.
4998: --
4999: UPDATE psb_ws_account_lines
5000: SET current_stage_seq = l_target_stage_seq
5001: WHERE l_target_stage_seq > current_stage_seq

Line 4999: UPDATE psb_ws_account_lines

4995:
4996: --
4997: -- Update psb_ws_account_lines as per the service package selection.
4998: --
4999: UPDATE psb_ws_account_lines
5000: SET current_stage_seq = l_target_stage_seq
5001: WHERE l_target_stage_seq > current_stage_seq
5002: AND end_stage_seq is null
5003: AND account_line_id IN

Line 5831: psb_ws_account_lines accts

5827: FOR l_account_line_id_rec IN
5828: (
5829: SELECT lines.account_line_id
5830: FROM psb_ws_lines lines ,
5831: psb_ws_account_lines accts
5832: WHERE lines.worksheet_id = p_source_worksheet_id
5833: AND lines.account_line_id = accts.account_line_id
5834: /*For Bug No : 2236283 Start*/
5835: /*

Line 5918: FROM psb_ws_account_lines acct_lines

5914: /*
5915: AND lines.position_line_id IN
5916: (
5917: SELECT acct_lines.position_line_id
5918: FROM psb_ws_account_lines acct_lines
5919: WHERE acct_lines.budget_group_id IN
5920: (
5921: SELECT bg.budget_group_id
5922: FROM psb_budget_groups bg

Line 5936: FROM psb_ws_account_lines acct_lines

5932: */
5933: AND EXISTS
5934: (
5935: SELECT 1
5936: FROM psb_ws_account_lines acct_lines
5937: WHERE acct_lines.position_line_id = lines.position_line_id
5938: AND EXISTS
5939: (
5940: SELECT 1

Line 6058: l_dummy_account_line_id psb_ws_account_lines.account_line_id%TYPE ;

6054: l_return_status VARCHAR2(1) ;
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:

Line 6070: FROM psb_ws_account_lines

6066:
6067: FOR l_accts_rec IN
6068: (
6069: SELECT *
6070: FROM psb_ws_account_lines
6071: WHERE account_line_id = p_account_line_id
6072: )
6073: LOOP
6074: --

Line 6139: -- Create records in psb_ws_lines and psb_ws_account_lines for the

6135: l_period_amount_tbl(59) := l_accts_rec.period59_amount ;
6136: l_period_amount_tbl(60) := l_accts_rec.period60_amount ;
6137:
6138: --
6139: -- Create records in psb_ws_lines and psb_ws_account_lines for the
6140: -- new worksheet.
6141: --
6142: PSB_WS_Acct_Pvt.Create_Account_Dist
6143: (

Line 6334: -- p_delete_lines_flag specifies whether psb_ws_account_lines and

6330: --
6331: p_return_status := FND_API.G_RET_STS_SUCCESS ;
6332:
6333: --
6334: -- p_delete_lines_flag specifies whether psb_ws_account_lines and
6335: -- psb_ws_position_lines related tables will be deleted or not.
6336: --
6337: IF p_delete_lines_flag = 'Y' THEN
6338:

Line 6352: --Deleting records from psb_ws_account_lines.

6348: IF (l_ws_account_lines_csr%NOTFOUND) THEN
6349: EXIT;
6350: END IF;
6351:
6352: --Deleting records from psb_ws_account_lines.
6353: DELETE psb_ws_account_lines
6354: WHERE account_line_id = l_account_line_id;
6355: --
6356: /*For Bug No : 2266309 Start*/

Line 6353: DELETE psb_ws_account_lines

6349: EXIT;
6350: END IF;
6351:
6352: --Deleting records from psb_ws_account_lines.
6353: DELETE psb_ws_account_lines
6354: WHERE account_line_id = l_account_line_id;
6355: --
6356: /*For Bug No : 2266309 Start*/
6357: l_record_ctr := l_record_ctr + 1;

Line 6848: FROM psb_ws_account_lines accts

6844: OR
6845: pos_lines.position_line_id IN
6846: (
6847: SELECT accts.position_line_id
6848: FROM psb_ws_account_lines accts
6849: WHERE accts.position_line_id = pos_lines.position_line_id
6850: AND accts.service_package_id IN
6851: (
6852: SELECT sp.service_package_id

Line 6898: psb_ws_account_lines accts

6894: FOR l_lines_rec IN
6895: (
6896: SELECT lines.*
6897: FROM psb_ws_lines lines,
6898: psb_ws_account_lines accts
6899: WHERE accts.position_line_id = l_lines_pos_rec.position_line_id
6900: AND lines.worksheet_id = p_worksheet_id
6901: AND lines.account_line_id = accts.account_line_id
6902: )