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.

[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 65: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

61: END get_item_cost;
62:
63:
64: FUNCTION asset_description(
65: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
66: x_error_msg OUT NOCOPY VARCHAR2,
67: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
68: IS
69: x_description VARCHAR2(80);

Line 125: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

121: -- default logic OR
122: -- the asset category ID derived by client extension.
123: --------------------------------------------------------------------------
124: FUNCTION asset_category(
125: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
126: x_error_msg OUT NOCOPY VARCHAR2,
127: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
128: IS
129: l_category_segs VARCHAr2(2000);

Line 209: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

205: -- Fan Li August 27, 2007 Support for Multiple FA Book Type
206: -- against Projects Flow
207: --------------------------------------------------------------------------
208: FUNCTION book_type(
209: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
210: x_error_msg OUT NOCOPY VARCHAR2,
211: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
212: IS
213: x_hook_used PLS_INTEGER;

Line 326: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

322: -- Description : Returns DPIS based on either the default logic
323: -- OR the DPIS derived by client extension.
324: --------------------------------------------------------------------------
325: FUNCTION date_place_in_service(
326: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
327: x_error_msg OUT NOCOPY VARCHAR2,
328: x_return_status OUT NOCOPY VARCHAR2) RETURN DATE
329: IS
330: l_date_place_in_service DATE;

Line 439: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

435: END date_place_in_service ;
436:
437:
438: FUNCTION asset_key(
439: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
440: x_error_msg OUT NOCOPY VARCHAR2,
441: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
442: IS
443: l_asset_key_ccid NUMBER;

Line 472: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

468: ---------------------------------------------------------------------------+
469: -- Description : returns the total wip cost of an asssemebly - comp cost
470: --------------------------------------------------------------------------
471: PROCEDURE get_wip_assembly_cost(
472: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
473: x_wip_assembly_cost OUT NOCOPY NUMBER,
474: x_return_status OUT NOCOPY VARCHAR2,
475: x_error_msg OUT NOCOPY VARCHAR2)
476: IS

Line 540: p_asset_attrib_rec IN OUT NOCOPY cse_datastructures_pub.asset_attrib_rec,

536: x_error_msg := fnd_message.get;
537: END get_wip_assembly_cost;
538:
539: FUNCTION deprn_expense_ccid(
540: p_asset_attrib_rec IN OUT NOCOPY cse_datastructures_pub.asset_attrib_rec,
541: x_error_msg OUT NOCOPY varchar2,
542: x_return_status OUT NOCOPY varchar2) RETURN number
543: IS
544:

Line 722: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

718: -- default logic OR
719: -- the LIFO or FIFO derived by client extension.
720: --------------------------------------------------------------------------
721: FUNCTION search_method(
722: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
723: x_error_msg OUT NOCOPY VARCHAR2,
724: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
725: IS
726:

Line 810: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

806: -- the Payables CCID derived by client extension.
807: --------------------------------------------------------------------------
808:
809: FUNCTION payables_ccid(
810: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
811: x_error_msg OUT NOCOPY VARCHAR2,
812: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
813: IS
814:

Line 1073: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1069: -- default logic OR
1070: -- the Tag Number derived by client extension.
1071: --------------------------------------------------------------------------
1072: FUNCTION tag_number(
1073: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1074: x_error_msg OUT NOCOPY VARCHAR2,
1075: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1076: IS
1077: x_tag_number VARCHAR2(15);

Line 1113: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1109: -- default logic OR
1110: -- the Model Number derived by client extension.
1111: --------------------------------------------------------------------------
1112: FUNCTION model_number(
1113: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1114: x_error_msg OUT NOCOPY VARCHAR2,
1115: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1116: IS
1117: x_model_number VARCHAR2(40);

Line 1152: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1148: -- default logic OR
1149: -- the Manufacturer Name derived by client extension.
1150: --------------------------------------------------------------------------
1151: FUNCTION manufacturer(
1152: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1153: x_error_msg OUT NOCOPY VARCHAR2,
1154: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1155: IS
1156: x_manufacturer_name VARCHAR2(30);

Line 1190: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1186: -- default logic OR
1187: -- the Employee Id derived by client extension.
1188: --------------------------------------------------------------------------
1189: FUNCTION employee(
1190: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1191: x_error_msg OUT NOCOPY VARCHAR2,
1192: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
1193: IS
1194: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.employee';

Line 1222: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec)

1218: RETURN NULL;
1219: END employee;
1220:
1221: FUNCTION inventory_item(
1222: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec)
1223: RETURN NUMBER IS
1224: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.inventory_item';
1225: l_inventory_item_id NUMBER;
1226: x_hook_used PLS_INTEGER;

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

1239: RETURN NULL;
1240: END inventory_item;
1241:
1242: PROCEDURE get_pending_retirements
1243: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
1244: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,
1245: x_return_status OUT NOCOPY VARCHAR2,
1246: x_error_msg OUT NOCOPY VARCHAR2)
1247: IS

Line 1244: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,

1240: END inventory_item;
1241:
1242: PROCEDURE get_pending_retirements
1243: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
1244: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,
1245: x_return_status OUT NOCOPY VARCHAR2,
1246: x_error_msg OUT NOCOPY VARCHAR2)
1247: IS
1248: l_cost NUMBER;

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

1319:
1320: ---------------------------------------------------------------------------
1321:
1322: PROCEDURE get_pending_adjustments
1323: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
1324: x_return_status OUT NOCOPY VARCHAR2,
1325: x_error_msg OUT NOCOPY VARCHAR2)
1326: IS
1327: l_cost NUMBER := 0;

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

1401: END get_pending_adjustments ;
1402:
1403: -------------------------------------------------------------------------------
1404:
1405: PROCEDURE get_catchup_dep_flag (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1406: p_asset_number IN VARCHAR2,
1407: p_instance_asset_id IN NUMBER,
1408: x_catchup_flag OUT NOCOPY VARCHAR2,
1409: x_return_status OUT NOCOPY VARCHAR2,

Line 1468: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

1464: --------------------------------------------------------------------------------
1465:
1466:
1467: PROCEDURE get_txn_class (
1468: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1469: x_transaction_class OUT NOCOPY VARCHAR2,
1470: x_return_status OUT NOCOPY VARCHAR2,
1471: x_error_msg OUT NOCOPY VARCHAR2)
1472: IS

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

1666: -- Description : validates if the instance is already associated with the Fixed Asset
1667: -------------------------------------------------------------------------
1668:
1669: /* bnarayan added for R12 */
1670: PROCEDURE validate_inst_asset (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
1671: X_valid OUT NOCOPY VARCHAR2,
1672: X_return_status OUT NOCOPY VARCHAR2,
1673: x_error_msg OUT NOCOPY VARCHAR2)
1674: IS

Line 2014: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

2010: END insert_mass_add;
2011:
2012:
2013: FUNCTION retire_non_mtl(
2014: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
2015: p_asset_id IN NUMBER,
2016: x_error_msg OUT NOCOPY VARCHAR2,
2017: x_return_status OUT NOCOPY VARCHAR2
2018: ) RETURN VARCHAR2

Line 2052: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

2048: --- current transaction.
2049: -------------------------------------------------------------------------------
2050:
2051: PROCEDURE is_valid_to_process(
2052: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
2053: x_valid_to_process OUT NOCOPY VARCHAR2,
2054: x_return_status OUT NOCOPY VARCHAR2,
2055: x_error_msg OUT NOCOPY VARCHAR2)
2056: IS