DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_API_TYPES

Line 5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

1: PACKAGE BODY FA_UTIL_PVT as
2: /* $Header: FAVUTILB.pls 120.20.12010000.2 2008/12/19 08:34:14 rjayaraj ship $ */
3:
4: FUNCTION get_asset_fin_rec
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8: p_mrc_sob_type_code IN VARCHAR2,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

Line 6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

2: /* $Header: FAVUTILB.pls 120.20.12010000.2 2008/12/19 08:34:14 rjayaraj ship $ */
3:
4: FUNCTION get_asset_fin_rec
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8: p_mrc_sob_type_code IN VARCHAR2,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
10:

Line 9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8: p_mrc_sob_type_code IN VARCHAR2,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
10:
11: error_found EXCEPTION;
12:
13: BEGIN

Line 910: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

906: END get_asset_fin_rec;
907:
908:
909: FUNCTION get_asset_deprn_rec
910: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
911: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
912: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
913: p_mrc_sob_type_code IN VARCHAR2,
914: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

Line 911: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

907:
908:
909: FUNCTION get_asset_deprn_rec
910: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
911: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
912: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
913: p_mrc_sob_type_code IN VARCHAR2,
914: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
915:

Line 914: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

910: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
911: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
912: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
913: p_mrc_sob_type_code IN VARCHAR2,
914: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
915:
916: l_dpr FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
917: l_status BOOLEAN;
918: error_found EXCEPTION;

Line 976: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

972:
973:
974:
975: FUNCTION get_asset_cat_rec
976: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
977: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
978: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
979: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
980:

Line 977: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

973:
974:
975: FUNCTION get_asset_cat_rec
976: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
977: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
978: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
979: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
980:
981: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;

Line 979: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

975: FUNCTION get_asset_cat_rec
976: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
977: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
978: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
979: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
980:
981: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;
982:
983: BEGIN

Line 1084: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

1080:
1081:
1082:
1083: FUNCTION get_asset_type_rec
1084: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1085: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
1086: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
1087: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1088:

Line 1085: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

1081:
1082:
1083: FUNCTION get_asset_type_rec
1084: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1085: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
1086: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
1087: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1088:
1089: BEGIN

Line 1087: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

1083: FUNCTION get_asset_type_rec
1084: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1085: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
1086: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
1087: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1088:
1089: BEGIN
1090:
1091: select ah.asset_type

Line 1113: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

1109: END get_asset_type_rec;
1110:
1111:
1112: FUNCTION get_asset_desc_rec
1113: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1114: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
1115: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1116:
1117: BEGIN

Line 1114: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

1110:
1111:
1112: FUNCTION get_asset_desc_rec
1113: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1114: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
1115: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1116:
1117: BEGIN
1118:

Line 1115: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

1111:
1112: FUNCTION get_asset_desc_rec
1113: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1114: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
1115: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1116:
1117: BEGIN
1118:
1119: select asset_number ,

Line 1316: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,

1312: END get_asset_desc_rec;
1313:
1314:
1315: FUNCTION get_inv_rec
1316: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1317: p_mrc_sob_type_code IN VARCHAR2,
1318: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL,
1319: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1320:

Line 1318: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL,

1314:
1315: FUNCTION get_inv_rec
1316: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1317: p_mrc_sob_type_code IN VARCHAR2,
1318: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL,
1319: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1320:
1321: l_dummy number;
1322: error_found EXCEPTION;

Line 1319: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

1315: FUNCTION get_inv_rec
1316: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1317: p_mrc_sob_type_code IN VARCHAR2,
1318: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL,
1319: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1320:
1321: l_dummy number;
1322: error_found EXCEPTION;
1323:

Line 1779: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

1775: FUNCTION check_asset_key_req
1776: (p_asset_key_chart_id IN NUMBER,
1777: p_asset_key_required OUT NOCOPY BOOLEAN,
1778: p_calling_fn IN VARCHAR2,
1779: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1780:
1781: cursor asset_key_req is
1782: select 1
1783: from fnd_id_flex_segments

Line 1827: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS

1823: FUNCTION get_current_units
1824: (p_calling_fn in VARCHAR2
1825: ,p_asset_id in NUMBER
1826: ,x_current_units out NOCOPY NUMBER
1827: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
1828:
1829: BEGIN
1830:
1831: select units

Line 1861: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS

1857: (p_calling_fn in VARCHAR2
1858: ,p_asset_id in NUMBER
1859: ,p_book in VARCHAR2
1860: ,x_latest_trans_date out NOCOPY DATE
1861: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
1862:
1863: BEGIN
1864:
1865: /* commenting for bug 3768867

Line 1904: ,x_period_rec out NOCOPY FA_API_TYPES.period_rec_type

1900: FUNCTION get_period_rec
1901: (p_book in varchar2
1902: ,p_period_counter in number default null
1903: ,p_effective_date in date default null
1904: ,x_period_rec out NOCOPY FA_API_TYPES.period_rec_type
1905: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
1906:
1907: error_found EXCEPTION;
1908:

Line 1905: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS

1901: (p_book in varchar2
1902: ,p_period_counter in number default null
1903: ,p_effective_date in date default null
1904: ,x_period_rec out NOCOPY FA_API_TYPES.period_rec_type
1905: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
1906:
1907: error_found EXCEPTION;
1908:
1909: BEGIN

Line 1964: (px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type,

1960: END get_period_rec;
1961:
1962:
1963: FUNCTION get_asset_retire_rec
1964: (px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type,
1965: p_mrc_sob_type_code IN VARCHAR2
1966: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1967:
1968: error_found EXCEPTION;

Line 1966: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

1962:
1963: FUNCTION get_asset_retire_rec
1964: (px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type,
1965: p_mrc_sob_type_code IN VARCHAR2
1966: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1967:
1968: error_found EXCEPTION;
1969:
1970: BEGIN

Line 2212: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

2208: END get_asset_retire_rec;
2209:
2210: FUNCTION get_corp_book( p_asset_id IN NUMBER,
2211: p_corp_book IN OUT NOCOPY VARCHAR2,
2212: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
2213:
2214: BEGIN
2215:
2216: SELECT bc.book_type_code

Line 2253: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

2249: PROCEDURE load_char_value
2250: (p_char_old IN VARCHAR2,
2251: p_char_adj IN VARCHAR2,
2252: x_char_new IN OUT NOCOPY VARCHAR2,
2253: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
2254:
2255: BEGIN
2256:
2257: if (p_char_adj is null) then

Line 2271: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

2267: PROCEDURE load_date_value
2268: (p_date_old IN VARCHAR2,
2269: p_date_adj IN VARCHAR2,
2270: x_date_new IN OUT NOCOPY VARCHAR2,
2271: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
2272:
2273: BEGIN
2274:
2275: if (p_date_adj is null) then

Line 2289: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

2285: PROCEDURE load_num_value
2286: (p_num_old IN VARCHAR2,
2287: p_num_adj IN VARCHAR2,
2288: x_num_new IN OUT NOCOPY VARCHAR2,
2289: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
2290:
2291: BEGIN
2292:
2293: if (p_num_adj is null) then

Line 2309: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS

2305: FUNCTION check_deprn_run
2306: (X_book IN VARCHAR2,
2307: X_asset_id IN NUMBER DEFAULT 0,
2308: X_deprn_amount OUT NOCOPY NUMBER,
2309: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
2310:
2311: deprn_run VARCHAR2(1);
2312: h_count NUMBER;
2313: h_mc_source_flag VARCHAR2(3);