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.CSE_ASSET_UTIL_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 109: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

105: END get_item_cost;
106:
107:
108: FUNCTION asset_description(
109: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
110: x_error_msg OUT NOCOPY VARCHAR2,
111: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
112: IS
113: x_description VARCHAR2(80);

Line 169: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

165: -- default logic OR
166: -- the asset category ID derived by client extension.
167: --------------------------------------------------------------------------
168: FUNCTION asset_category(
169: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
170: x_error_msg OUT NOCOPY VARCHAR2,
171: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
172: IS
173: l_category_segs VARCHAr2(2000);

Line 253: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

249: -- Fan Li August 27, 2007 Support for Multiple FA Book Type
250: -- against Projects Flow
251: --------------------------------------------------------------------------
252: FUNCTION book_type(
253: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
254: x_error_msg OUT NOCOPY VARCHAR2,
255: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
256: IS
257: x_hook_used PLS_INTEGER;

Line 370: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

366: -- Description : Returns DPIS based on either the default logic
367: -- OR the DPIS derived by client extension.
368: --------------------------------------------------------------------------
369: FUNCTION date_place_in_service(
370: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
371: x_error_msg OUT NOCOPY VARCHAR2,
372: x_return_status OUT NOCOPY VARCHAR2) RETURN DATE
373: IS
374: l_date_place_in_service DATE;

Line 483: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

479: END date_place_in_service ;
480:
481:
482: FUNCTION asset_key(
483: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
484: x_error_msg OUT NOCOPY VARCHAR2,
485: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
486: IS
487: l_asset_key_ccid NUMBER;

Line 516: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

512: ---------------------------------------------------------------------------+
513: -- Description : returns the total wip cost of an asssemebly - comp cost
514: --------------------------------------------------------------------------
515: PROCEDURE get_wip_assembly_cost(
516: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
517: x_wip_assembly_cost OUT NOCOPY NUMBER,
518: x_return_status OUT NOCOPY VARCHAR2,
519: x_error_msg OUT NOCOPY VARCHAR2)
520: IS

Line 584: p_asset_attrib_rec IN OUT NOCOPY cse_datastructures_pub.asset_attrib_rec,

580: x_error_msg := fnd_message.get;
581: END get_wip_assembly_cost;
582:
583: FUNCTION deprn_expense_ccid(
584: p_asset_attrib_rec IN OUT NOCOPY cse_datastructures_pub.asset_attrib_rec,
585: x_error_msg OUT NOCOPY varchar2,
586: x_return_status OUT NOCOPY varchar2) RETURN number
587: IS
588:

Line 766: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

762: -- default logic OR
763: -- the LIFO or FIFO derived by client extension.
764: --------------------------------------------------------------------------
765: FUNCTION search_method(
766: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
767: x_error_msg OUT NOCOPY VARCHAR2,
768: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
769: IS
770:

Line 854: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

850: -- the Payables CCID derived by client extension.
851: --------------------------------------------------------------------------
852:
853: FUNCTION payables_ccid(
854: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
855: x_error_msg OUT NOCOPY VARCHAR2,
856: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
857: IS
858:

Line 1198: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1194: -- default logic OR
1195: -- the Tag Number derived by client extension.
1196: --------------------------------------------------------------------------
1197: FUNCTION tag_number(
1198: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1199: x_error_msg OUT NOCOPY VARCHAR2,
1200: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1201: IS
1202: x_tag_number VARCHAR2(15);

Line 1238: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1234: -- default logic OR
1235: -- the Model Number derived by client extension.
1236: --------------------------------------------------------------------------
1237: FUNCTION model_number(
1238: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1239: x_error_msg OUT NOCOPY VARCHAR2,
1240: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1241: IS
1242: x_model_number VARCHAR2(40);

Line 1277: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1273: -- default logic OR
1274: -- the Manufacturer Name derived by client extension.
1275: --------------------------------------------------------------------------
1276: FUNCTION manufacturer(
1277: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1278: x_error_msg OUT NOCOPY VARCHAR2,
1279: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1280: IS
1281: x_manufacturer_name VARCHAR2(30);

Line 1315: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1311: -- default logic OR
1312: -- the Employee Id derived by client extension.
1313: --------------------------------------------------------------------------
1314: FUNCTION employee(
1315: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1316: x_error_msg OUT NOCOPY VARCHAR2,
1317: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
1318: IS
1319: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.employee';

Line 1347: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec)

1343: RETURN NULL;
1344: END employee;
1345:
1346: FUNCTION inventory_item(
1347: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec)
1348: RETURN NUMBER IS
1349: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.inventory_item';
1350: l_inventory_item_id NUMBER;
1351: x_hook_used PLS_INTEGER;

Line 1368: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

1364: RETURN NULL;
1365: END inventory_item;
1366:
1367: PROCEDURE get_pending_retirements
1368: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
1369: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,
1370: x_return_status OUT NOCOPY VARCHAR2,
1371: x_error_msg OUT NOCOPY VARCHAR2)
1372: IS

Line 1369: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,

1365: END inventory_item;
1366:
1367: PROCEDURE get_pending_retirements
1368: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
1369: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,
1370: x_return_status OUT NOCOPY VARCHAR2,
1371: x_error_msg OUT NOCOPY VARCHAR2)
1372: IS
1373: l_cost NUMBER;

Line 1448: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

1444:
1445: ---------------------------------------------------------------------------
1446:
1447: PROCEDURE get_pending_adjustments
1448: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
1449: x_return_status OUT NOCOPY VARCHAR2,
1450: x_error_msg OUT NOCOPY VARCHAR2)
1451: IS
1452: l_cost NUMBER := 0;

Line 1530: PROCEDURE get_catchup_dep_flag (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1526: END get_pending_adjustments ;
1527:
1528: -------------------------------------------------------------------------------
1529:
1530: PROCEDURE get_catchup_dep_flag (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1531: p_asset_number IN VARCHAR2,
1532: p_instance_asset_id IN NUMBER,
1533: x_catchup_flag OUT NOCOPY VARCHAR2,
1534: x_return_status OUT NOCOPY VARCHAR2,

Line 1593: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1589: --------------------------------------------------------------------------------
1590:
1591:
1592: PROCEDURE get_txn_class (
1593: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1594: x_transaction_class OUT NOCOPY VARCHAR2,
1595: x_return_status OUT NOCOPY VARCHAR2,
1596: x_error_msg OUT NOCOPY VARCHAR2)
1597: IS

Line 1856: PROCEDURE validate_inst_asset (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1852: -- Description : validates if the instance is already associated with the Fixed Asset
1853: -------------------------------------------------------------------------
1854:
1855: /* bnarayan added for R12 */
1856: PROCEDURE validate_inst_asset (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1857: X_valid OUT NOCOPY VARCHAR2,
1858: X_return_status OUT NOCOPY VARCHAR2,
1859: x_error_msg OUT NOCOPY VARCHAR2)
1860: IS

Line 2278: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

2274: END insert_mass_add;
2275:
2276:
2277: FUNCTION retire_non_mtl(
2278: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
2279: p_asset_id IN NUMBER,
2280: x_error_msg OUT NOCOPY VARCHAR2,
2281: x_return_status OUT NOCOPY VARCHAR2
2282: ) RETURN VARCHAR2

Line 2316: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

2312: --- current transaction.
2313: -------------------------------------------------------------------------------
2314:
2315: PROCEDURE is_valid_to_process(
2316: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
2317: x_valid_to_process OUT NOCOPY VARCHAR2,
2318: x_return_status OUT NOCOPY VARCHAR2,
2319: x_error_msg OUT NOCOPY VARCHAR2)
2320: IS