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.FA_JP_TAX_EXTN_PVT dependencies on FA_BOOKS

Line 34: , p_book_type_code IN fa_books.book_type_code%TYPE

30: x_errbuf OUT NOCOPY VARCHAR2
31: , x_retcode OUT NOCOPY NUMBER
32: , p_request_id IN NUMBER
33: , p_checkbox_check IN VARCHAR2
34: , p_book_type_code IN fa_books.book_type_code%TYPE
35: , p_number_of_periods IN NUMBER
36: , p_asset_id IN fa_books.asset_id%TYPE
37: , p_period_name IN fa_deprn_periods.period_name%TYPE
38: , p_first_begin_prd IN fa_deprn_periods.period_name%TYPE

Line 36: , p_asset_id IN fa_books.asset_id%TYPE

32: , p_request_id IN NUMBER
33: , p_checkbox_check IN VARCHAR2
34: , p_book_type_code IN fa_books.book_type_code%TYPE
35: , p_number_of_periods IN NUMBER
36: , p_asset_id IN fa_books.asset_id%TYPE
37: , p_period_name IN fa_deprn_periods.period_name%TYPE
38: , p_first_begin_prd IN fa_deprn_periods.period_name%TYPE
39: , p_dep_amt IN NUMBER
40: , p_dep_amt_annual IN NUMBER

Line 41: , p_date_placed_in_service IN fa_books.date_placed_in_service%TYPE

37: , p_period_name IN fa_deprn_periods.period_name%TYPE
38: , p_first_begin_prd IN fa_deprn_periods.period_name%TYPE
39: , p_dep_amt IN NUMBER
40: , p_dep_amt_annual IN NUMBER
41: , p_date_placed_in_service IN fa_books.date_placed_in_service%TYPE
42: , p_life_in_months IN fa_books.life_in_months%TYPE
43: , p_original_cost IN fa_books.original_cost%TYPE
44: , p_asset_number IN fa_additions_b.asset_number%TYPE
45: , p_description IN fa_additions.description%TYPE

Line 42: , p_life_in_months IN fa_books.life_in_months%TYPE

38: , p_first_begin_prd IN fa_deprn_periods.period_name%TYPE
39: , p_dep_amt IN NUMBER
40: , p_dep_amt_annual IN NUMBER
41: , p_date_placed_in_service IN fa_books.date_placed_in_service%TYPE
42: , p_life_in_months IN fa_books.life_in_months%TYPE
43: , p_original_cost IN fa_books.original_cost%TYPE
44: , p_asset_number IN fa_additions_b.asset_number%TYPE
45: , p_description IN fa_additions.description%TYPE
46: , p_tag_number IN fa_additions_b.tag_number%TYPE

Line 43: , p_original_cost IN fa_books.original_cost%TYPE

39: , p_dep_amt IN NUMBER
40: , p_dep_amt_annual IN NUMBER
41: , p_date_placed_in_service IN fa_books.date_placed_in_service%TYPE
42: , p_life_in_months IN fa_books.life_in_months%TYPE
43: , p_original_cost IN fa_books.original_cost%TYPE
44: , p_asset_number IN fa_additions_b.asset_number%TYPE
45: , p_description IN fa_additions.description%TYPE
46: , p_tag_number IN fa_additions_b.tag_number%TYPE
47: , p_serial_number IN fa_additions_b.serial_number%TYPE

Line 56: p_book_type_code IN fa_books.book_type_code%TYPE

52: , p_flag IN VARCHAR2
53: )
54: IS
55: CURSOR lcr_deprn_periods (
56: p_book_type_code IN fa_books.book_type_code%TYPE
57: , p_period_name IN fa_deprn_periods.period_name%TYPE
58: )
59: /***********************************************************************
60: *

Line 95: p_book_type_code IN fa_books.book_type_code%TYPE

91: AND fcp.calendar_type = fbc.deprn_calendar
92: AND fcp.period_name = p_period_name;
93:
94: CURSOR lcr_end_date (
95: p_book_type_code IN fa_books.book_type_code%TYPE
96: , p_period_name IN fa_deprn_periods.period_name%TYPE
97: , p_counter IN NUMBER
98: )
99: /***********************************************************************

Line 136: p_book_type_code IN fa_books.book_type_code%TYPE

132: AND fcp.calendar_type = fbc.deprn_calendar
133: AND fcp.period_name = p_period_name;
134:
135: CURSOR lcr_distribution (
136: p_book_type_code IN fa_books.book_type_code%TYPE
137: , p_asset_id IN fa_books.asset_id%TYPE
138: )
139: /***********************************************************************
140: *

Line 137: , p_asset_id IN fa_books.asset_id%TYPE

133: AND fcp.period_name = p_period_name;
134:
135: CURSOR lcr_distribution (
136: p_book_type_code IN fa_books.book_type_code%TYPE
137: , p_asset_id IN fa_books.asset_id%TYPE
138: )
139: /***********************************************************************
140: *
141: * CURSOR

Line 178: p_book_type IN fa_books.book_type_code%TYPE

174: AND fdh.asset_id = p_asset_id
175: AND fdh.assigned_to = papf.person_id(+);
176:
177: CURSOR lcr_first_periods (
178: p_book_type IN fa_books.book_type_code%TYPE
179: , p_start_period IN fa_deprn_periods.period_name%TYPE
180: , p_number_of_periods IN NUMBER
181: )
182: /***********************************************************************

Line 229: p_book_type_code IN fa_books.book_type_code%TYPE

225: AND cp1.start_date >= cp.start_date
226: AND ROWNUM = 1;
227:
228: CURSOR lcr_periods (
229: p_book_type_code IN fa_books.book_type_code%TYPE
230: , p_end_date IN DATE
231: )
232: /***********************************************************************
233: *

Line 780: , p_book_type_code IN fa_books.book_type_code%TYPE

776: PROCEDURE whatif_main (
777: x_errbuf OUT NOCOPY VARCHAR2
778: , x_retcode OUT NOCOPY NUMBER
779: , p_request_id IN NUMBER
780: , p_book_type_code IN fa_books.book_type_code%TYPE
781: , p_first_begin_period IN VARCHAR2
782: , p_number_of_periods IN NUMBER
783: , p_start_period IN VARCHAR2
784: , p_checkbox_check IN VARCHAR2

Line 823: p_book_type_code IN fa_books.book_type_code%TYPE

819: FROM fnd_profile_options_vl
820: WHERE profile_option_name = p_option_name;
821:
822: CURSOR lcr_books (
823: p_book_type_code IN fa_books.book_type_code%TYPE
824: , p_asset_id IN fa_books.asset_id%TYPE
825: )
826: /***********************************************************************
827: *

Line 824: , p_asset_id IN fa_books.asset_id%TYPE

820: WHERE profile_option_name = p_option_name;
821:
822: CURSOR lcr_books (
823: p_book_type_code IN fa_books.book_type_code%TYPE
824: , p_asset_id IN fa_books.asset_id%TYPE
825: )
826: /***********************************************************************
827: *
828: * CURSOR

Line 877: FROM fa_books fb

873: - FLOOR ((fb.allowed_deprn_limit_amount - 1) / 5) round_value
874: -- , CEIL(((FB.cost - FB.salvage_value)*FB.basic_rate)/12) Deprn_Value
875: , ROUND ((fb.allowed_deprn_limit_amount - 1) / 60) deprn_value
876: , (fb.allowed_deprn_limit_amount - 1) / 5 annual_deprn_value
877: FROM fa_books fb
878: , fa_book_controls fbc
879: ,fa_calendar_periods cp
880: , fa_fiscal_year fy
881: , fa_calendar_types fct

Line 912: p_book_type_code IN fa_books.book_type_code%TYPE

908: AND fb.deprn_method_code <> 'JP-STL-EXTND'
909: AND fb.allowed_deprn_limit_amount > 1;
910:
911: CURSOR lcr_deprn_periods (
912: p_book_type_code IN fa_books.book_type_code%TYPE
913: , p_period_name IN fa_deprn_periods.period_name%TYPE
914: )
915: /***********************************************************************
916: *

Line 948: p_book_type IN fa_books.book_type_code%TYPE

944: WHERE fdp.book_type_code = p_book_type_code
945: AND fdp.period_name = p_period_name;
946:
947: CURSOR lcr_first_periods (
948: p_book_type IN fa_books.book_type_code%TYPE
949: , p_start_period IN fa_deprn_periods.period_name%TYPE
950: , p_number_of_periods IN NUMBER
951: )
952: /***********************************************************************

Line 1001: p_book_type_code IN fa_books.book_type_code%TYPE

997: AND cp1.start_date > cp.start_date
998: AND ROWNUM = 1;
999:
1000: CURSOR lcr_deprn_amount (
1001: p_book_type_code IN fa_books.book_type_code%TYPE
1002: , p_asset_id IN fa_books.asset_id%TYPE
1003: , p_period_counter IN NUMBER
1004: )
1005: /***********************************************************************

Line 1002: , p_asset_id IN fa_books.asset_id%TYPE

998: AND ROWNUM = 1;
999:
1000: CURSOR lcr_deprn_amount (
1001: p_book_type_code IN fa_books.book_type_code%TYPE
1002: , p_asset_id IN fa_books.asset_id%TYPE
1003: , p_period_counter IN NUMBER
1004: )
1005: /***********************************************************************
1006: *

Line 1033: FROM fa_books fb

1029: *
1030: ***********************************************************************/
1031: IS
1032: SELECT CEIL ((fb.COST - fds.deprn_reserve) / 60)
1033: FROM fa_books fb
1034: , fa_deprn_summary fds
1035: WHERE fds.book_type_code = fb.book_type_code
1036: AND fb.asset_id = fds.asset_id
1037: AND fds.period_counter = p_period_counter

Line 1044: p_book_type_code IN fa_books.book_type_code%TYPE

1040: AND fb.transaction_header_id_out IS NULL;
1041:
1042: -- condition modified from date_ineffective
1043: CURSOR lcr_end_date (
1044: p_book_type_code IN fa_books.book_type_code%TYPE
1045: , p_period_name IN fa_deprn_periods.period_name%TYPE
1046: , p_counter IN NUMBER
1047: )
1048: /***********************************************************************

Line 1085: p_book_type_code IN fa_books.book_type_code%TYPE

1081: AND fcp.calendar_type = fbc.deprn_calendar
1082: AND fcp.period_name = p_period_name;
1083:
1084: CURSOR lcr_periods (
1085: p_book_type_code IN fa_books.book_type_code%TYPE
1086: , p_end_date IN DATE
1087: )
1088: /***********************************************************************
1089: *

Line 1385: , p_book_type_code IN fa_books.book_type_code%TYPE

1381: PROCEDURE extd_deprn_main (
1382: x_errbuf OUT NOCOPY VARCHAR2
1383: , x_retcode OUT NOCOPY NUMBER
1384: , p_request_id IN NUMBER
1385: , p_book_type_code IN fa_books.book_type_code%TYPE
1386: , p_first_begin_period IN VARCHAR2
1387: , p_number_of_periods IN NUMBER
1388: , p_start_period IN VARCHAR2
1389: , p_checkbox_check IN VARCHAR2

Line 1428: p_book_type_code IN fa_books.book_type_code%TYPE

1424: FROM fnd_profile_options_vl
1425: WHERE profile_option_name = p_option_name;
1426:
1427: CURSOR lcr_books (
1428: p_book_type_code IN fa_books.book_type_code%TYPE
1429: , p_asset_id IN fa_books.asset_id%TYPE
1430: )
1431: /***********************************************************************
1432: *

Line 1429: , p_asset_id IN fa_books.asset_id%TYPE

1425: WHERE profile_option_name = p_option_name;
1426:
1427: CURSOR lcr_books (
1428: p_book_type_code IN fa_books.book_type_code%TYPE
1429: , p_asset_id IN fa_books.asset_id%TYPE
1430: )
1431: /***********************************************************************
1432: *
1433: * CURSOR

Line 1483: FROM fa_books fb

1479: , ROUND ((fb.allowed_deprn_limit_amount - 1) / 60) deprn_value
1480: , (fb.allowed_deprn_limit_amount - 1) / 5 annual_deprn_value
1481: , fb.adjusted_cost
1482: , fb.allowed_deprn_limit_amount
1483: FROM fa_books fb
1484: , fa_book_controls fbc -- As per Bug No .7183390 (For Tax Books)
1485: , fa_additions fa
1486: , fa_distribution_history fdh
1487: , fa_locations_kfv flk

Line 1509: p_book_type_code IN fa_books.book_type_code%TYPE

1505: AND fb.deprn_method_code <> 'JP-STL-EXTND'
1506: AND fb.allowed_deprn_limit_amount > 1;
1507:
1508: CURSOR lcr_deprn_periods (
1509: p_book_type_code IN fa_books.book_type_code%TYPE
1510: , p_period_name IN fa_deprn_periods.period_name%TYPE
1511: )
1512: /***********************************************************************
1513: *

Line 1545: p_book_type IN fa_books.book_type_code%TYPE

1541: WHERE fdp.book_type_code = p_book_type_code
1542: AND fdp.period_name = p_period_name;
1543:
1544: CURSOR lcr_first_periods (
1545: p_book_type IN fa_books.book_type_code%TYPE
1546: , p_start_period IN fa_deprn_periods.period_name%TYPE
1547: , p_number_of_periods IN NUMBER
1548: )
1549: /***********************************************************************

Line 1596: p_book_type_code IN fa_books.book_type_code%TYPE

1592: AND cp1.start_date >= cp.start_date -- BUG# 7264516: Added = condition
1593: AND ROWNUM = 1;
1594:
1595: CURSOR lcr_deprn_amount (
1596: p_book_type_code IN fa_books.book_type_code%TYPE
1597: , p_asset_id IN fa_books.asset_id%TYPE
1598: , p_period_counter IN NUMBER
1599: )
1600: /***********************************************************************

Line 1597: , p_asset_id IN fa_books.asset_id%TYPE

1593: AND ROWNUM = 1;
1594:
1595: CURSOR lcr_deprn_amount (
1596: p_book_type_code IN fa_books.book_type_code%TYPE
1597: , p_asset_id IN fa_books.asset_id%TYPE
1598: , p_period_counter IN NUMBER
1599: )
1600: /***********************************************************************
1601: *

Line 1629: FROM fa_books fb

1625: ***********************************************************************/
1626: IS
1627: SELECT CEIL ((fb.COST - fds.deprn_reserve) / 60)
1628: -- need to change for variable
1629: FROM fa_books fb
1630: , fa_deprn_summary fds
1631: WHERE fds.book_type_code = fb.book_type_code
1632: AND fb.asset_id = fds.asset_id
1633: AND fds.period_counter = p_period_counter

Line 1640: p_book_type_code IN fa_books.book_type_code%TYPE

1636: AND fb.transaction_header_id_out IS NULL;
1637:
1638: -- condition modified from date_ineffective
1639: CURSOR lcr_end_date_check (
1640: p_book_type_code IN fa_books.book_type_code%TYPE
1641: , p_period_name IN fa_deprn_periods.period_name%TYPE
1642: , p_counter IN NUMBER
1643: )
1644: /***********************************************************************

Line 1682: p_book_type_code IN fa_books.book_type_code%TYPE

1678: AND fcp.calendar_type = fbc.deprn_calendar
1679: AND fcp.period_name = p_period_name;
1680:
1681: CURSOR lcr_end_date_validate (
1682: p_book_type_code IN fa_books.book_type_code%TYPE
1683: , p_end_date IN fa_calendar_periods.end_date%TYPE
1684: , p_counter IN NUMBER
1685: )
1686: /***********************************************************************

Line 1724: p_book_type_code IN fa_books.book_type_code%TYPE

1720: AND fcp.calendar_type = fbc.deprn_calendar
1721: AND p_end_date BETWEEN fcp.start_date AND fcp.end_date;
1722:
1723: CURSOR lcr_periods (
1724: p_book_type_code IN fa_books.book_type_code%TYPE
1725: , p_end_date IN DATE
1726: )
1727: /***********************************************************************
1728: *

Line 1764: p_book_type_code IN fa_books.book_type_code%TYPE

1760: AND fcp.calendar_type = fbc.deprn_calendar
1761: AND fcp.end_date = p_end_date;
1762:
1763: CURSOR lcr_extd_deprns (
1764: p_book_type_code IN fa_books.book_type_code%TYPE
1765: , p_period_name IN fa_deprn_periods.period_name%TYPE
1766: )
1767: /***********************************************************************
1768: *

Line 1803: p_book_type_code IN fa_books.book_type_code%TYPE

1799: AND fcp.calendar_type = fbc.deprn_calendar
1800: AND fcp.period_name = p_period_name;
1801:
1802: CURSOR lcr_dern_method (
1803: p_book_type_code IN fa_books.book_type_code%TYPE
1804: , p_asset_id IN fa_books.asset_id%TYPE
1805: )
1806: /***********************************************************************
1807: *

Line 1804: , p_asset_id IN fa_books.asset_id%TYPE

1800: AND fcp.period_name = p_period_name;
1801:
1802: CURSOR lcr_dern_method (
1803: p_book_type_code IN fa_books.book_type_code%TYPE
1804: , p_asset_id IN fa_books.asset_id%TYPE
1805: )
1806: /***********************************************************************
1807: *
1808: * CURSOR

Line 1834: FROM fa_books fb

1830: *
1831: ***********************************************************************/
1832: IS
1833: SELECT fb.deprn_method_code
1834: FROM fa_books fb
1835: WHERE fb.book_type_code = p_book_type_code
1836: AND fb.asset_id = p_asset_id
1837: AND fb.date_ineffective IS NULL
1838: AND fb.transaction_header_id_out IS NULL

Line 1873: l_deprn_method fa_books.deprn_method_code%TYPE;

1869: l_exit NUMBER := 0;
1870: ln_first_elg_period NUMBER;
1871: ln_first_beg_period NUMBER;
1872: ln_int_deprn fa_deprn_summary.deprn_reserve%TYPE;
1873: l_deprn_method fa_books.deprn_method_code%TYPE;
1874: l_amt NUMBER;
1875: l_temp NUMBER;
1876: lr_books lcr_books%ROWTYPE;
1877: ex_user_exception EXCEPTION;

Line 2350: , p_book_type_code IN fa_books.book_type_code%TYPE

2346: PROCEDURE deprn_main (
2347: x_errbuf OUT NOCOPY VARCHAR2
2348: , x_retcode OUT NOCOPY NUMBER
2349: , p_request_id IN NUMBER
2350: , p_book_type_code IN fa_books.book_type_code%TYPE
2351: , p_first_begin_period IN VARCHAR2
2352: , p_number_of_periods IN NUMBER
2353: , p_start_period IN VARCHAR2
2354: , p_checkbox_check IN VARCHAR2

Line 2360: p_book_type_code IN fa_books.book_type_code%TYPE

2356: , p_asset_id IN NUMBER
2357: )
2358: IS
2359: CURSOR lcr_books (
2360: p_book_type_code IN fa_books.book_type_code%TYPE
2361: , p_asset_id IN fa_books.asset_id%TYPE
2362: )
2363: /***********************************************************************
2364: *

Line 2361: , p_asset_id IN fa_books.asset_id%TYPE

2357: )
2358: IS
2359: CURSOR lcr_books (
2360: p_book_type_code IN fa_books.book_type_code%TYPE
2361: , p_asset_id IN fa_books.asset_id%TYPE
2362: )
2363: /***********************************************************************
2364: *
2365: * CURSOR

Line 2391: FROM fa_books fb

2387: ***********************************************************************/
2388: IS
2389: SELECT fb.period_counter_fully_reserved
2390: , fb.asset_id
2391: FROM fa_books fb
2392: WHERE fb.book_type_code = p_book_type_code
2393: AND fb.date_ineffective IS NULL
2394: AND fb.transaction_header_id_out IS NULL
2395: AND fb.asset_id = p_asset_id

Line 2820: FROM fa_books

2816: , COST, 1
2817: , 0
2818: )
2819: INTO l_tmp
2820: FROM fa_books
2821: WHERE book_type_code = x_book
2822: AND date_ineffective IS NULL
2823: AND period_counter_fully_reserved IS NULL
2824: AND asset_id = x_asset_id;

Line 3282: FROM fa_books

3278: , COST, 1
3279: , 0
3280: )
3281: INTO l_tmp
3282: FROM fa_books
3283: WHERE book_type_code = x_book
3284: AND date_ineffective IS NULL
3285: AND period_counter_fully_reserved IS NULL
3286: AND asset_id = x_asset_id;