DBA Data[Home] [Help]

APPS.FA_ASSET_DESC_PUB dependencies on FA_API_TYPES

Line 8: g_log_level_rec fa_api_types.log_level_rec_type;

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_ASSET_DESC_PUB';
5: G_API_NAME CONSTANT VARCHAR2(30) := 'Update Asset Description API';
6: G_API_VERSION CONSTANT NUMBER := 1.0;
7:
8: g_log_level_rec fa_api_types.log_level_rec_type;
9:
10: --*********************** Private functions ******************************--
11:
12: FUNCTION update_row(

Line 13: p_trans_rec IN fa_api_types.trans_rec_type,

9:
10: --*********************** Private functions ******************************--
11:
12: FUNCTION update_row(
13: p_trans_rec IN fa_api_types.trans_rec_type,
14: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
15: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
16: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
17: p_old_warranty_id IN number,

Line 14: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

10: --*********************** Private functions ******************************--
11:
12: FUNCTION update_row(
13: p_trans_rec IN fa_api_types.trans_rec_type,
14: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
15: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
16: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
17: p_old_warranty_id IN number,
18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;

Line 15: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,

11:
12: FUNCTION update_row(
13: p_trans_rec IN fa_api_types.trans_rec_type,
14: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
15: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
16: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
17: p_old_warranty_id IN number,
18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
19:

Line 16: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,

12: FUNCTION update_row(
13: p_trans_rec IN fa_api_types.trans_rec_type,
14: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
15: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
16: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
17: p_old_warranty_id IN number,
18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
19:
20: FUNCTION initialize_category_df (

Line 18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;

14: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
15: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
16: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
17: p_old_warranty_id IN number,
18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
19:
20: FUNCTION initialize_category_df (
21: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;

Line 21: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

17: p_old_warranty_id IN number,
18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
19:
20: FUNCTION initialize_category_df (
21: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
23:
24:
25: --*********************** Public procedures ******************************--

Line 22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;

18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
19:
20: FUNCTION initialize_category_df (
21: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
23:
24:
25: --*********************** Public procedures ******************************--
26: PROCEDURE update_desc(

Line 37: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_calling_fn IN VARCHAR2,
36: -- Transaction Object --
37: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
38: -- Asset Object --
39: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
40: px_asset_desc_rec_new IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS

Line 39: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

35: p_calling_fn IN VARCHAR2,
36: -- Transaction Object --
37: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
38: -- Asset Object --
39: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
40: px_asset_desc_rec_new IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS
42:
43: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 40: px_asset_desc_rec_new IN OUT NOCOPY fa_api_types.asset_desc_rec_type,

36: -- Transaction Object --
37: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
38: -- Asset Object --
39: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
40: px_asset_desc_rec_new IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS
42:
43: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS

37: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
38: -- Asset Object --
39: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
40: px_asset_desc_rec_new IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS
42:
43: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
45: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 43: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

39: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
40: px_asset_desc_rec_new IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS
42:
43: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
45: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
46: l_calling_fn varchar2(50);
47: pub_error exception;

Line 44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

40: px_asset_desc_rec_new IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS
42:
43: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
45: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
46: l_calling_fn varchar2(50);
47: pub_error exception;
48:

Line 45: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

41: px_asset_cat_rec_new IN OUT NOCOPY fa_api_types.asset_cat_rec_type) IS
42:
43: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
45: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
46: l_calling_fn varchar2(50);
47: pub_error exception;
48:
49: l_err_stage varchar2(640);

Line 1150: p_trans_rec IN fa_api_types.trans_rec_type,

1146: END update_desc;
1147:
1148:
1149: FUNCTION update_row(
1150: p_trans_rec IN fa_api_types.trans_rec_type,
1151: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1152: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1153: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1154: p_old_warranty_id IN number,

Line 1151: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

1147:
1148:
1149: FUNCTION update_row(
1150: p_trans_rec IN fa_api_types.trans_rec_type,
1151: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1152: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1153: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1154: p_old_warranty_id IN number,
1155: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

Line 1152: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,

1148:
1149: FUNCTION update_row(
1150: p_trans_rec IN fa_api_types.trans_rec_type,
1151: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1152: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1153: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1154: p_old_warranty_id IN number,
1155: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
1156:

Line 1153: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,

1149: FUNCTION update_row(
1150: p_trans_rec IN fa_api_types.trans_rec_type,
1151: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1152: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1153: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1154: p_old_warranty_id IN number,
1155: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
1156:
1157: l_return_status boolean:= FALSE;

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

1151: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1152: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1153: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1154: p_old_warranty_id IN number,
1155: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
1156:
1157: l_return_status boolean:= FALSE;
1158: l_calling_fn varchar2(30);
1159: update_error EXCEPTION;

Line 1415: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

1411: x_msg_count OUT NOCOPY NUMBER,
1412: x_msg_data OUT NOCOPY VARCHAR2,
1413: p_calling_fn IN VARCHAR2,
1414: -- Transaction Object --
1415: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1416: -- Asset Object --
1417: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1418: px_inv_tbl_new IN OUT NOCOPY fa_api_types.inv_tbl_type) IS
1419:

Line 1417: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

1413: p_calling_fn IN VARCHAR2,
1414: -- Transaction Object --
1415: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1416: -- Asset Object --
1417: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1418: px_inv_tbl_new IN OUT NOCOPY fa_api_types.inv_tbl_type) IS
1419:
1420: inv_err exception;
1421:

Line 1418: px_inv_tbl_new IN OUT NOCOPY fa_api_types.inv_tbl_type) IS

1414: -- Transaction Object --
1415: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1416: -- Asset Object --
1417: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1418: px_inv_tbl_new IN OUT NOCOPY fa_api_types.inv_tbl_type) IS
1419:
1420: inv_err exception;
1421:
1422: l_rowid ROWID;

Line 1423: l_period_rec fa_api_types.period_rec_type;

1419:
1420: inv_err exception;
1421:
1422: l_rowid ROWID;
1423: l_period_rec fa_api_types.period_rec_type;
1424: l_inv_rec fa_api_types.inv_rec_type;
1425:
1426: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_invoice_desc';
1427:

Line 1424: l_inv_rec fa_api_types.inv_rec_type;

1420: inv_err exception;
1421:
1422: l_rowid ROWID;
1423: l_period_rec fa_api_types.period_rec_type;
1424: l_inv_rec fa_api_types.inv_rec_type;
1425:
1426: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_invoice_desc';
1427:
1428: -- Bug 5475276 Cursor to get the book_type_code

Line 1442: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

1438:
1439: -- For primary and reporting books
1440: l_reporting_flag varchar2(1) := 'P';
1441: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
1442: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1443:
1444: BEGIN
1445:
1446: SAVEPOINT do_invoice_desc_update;

Line 2051: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

2047: x_msg_count OUT NOCOPY NUMBER,
2048: x_msg_data OUT NOCOPY VARCHAR2,
2049: p_calling_fn IN VARCHAR2,
2050: -- Transaction Object --
2051: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
2052: -- Asset Object --
2053: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2054: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) AS
2055:

Line 2053: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

2049: p_calling_fn IN VARCHAR2,
2050: -- Transaction Object --
2051: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
2052: -- Asset Object --
2053: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2054: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) AS
2055:
2056: ret_err exception;
2057:

Line 2054: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) AS

2050: -- Transaction Object --
2051: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
2052: -- Asset Object --
2053: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2054: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) AS
2055:
2056: ret_err exception;
2057:
2058: l_rowid ROWID;

Line 2059: l_period_rec fa_api_types.period_rec_type;

2055:
2056: ret_err exception;
2057:
2058: l_rowid ROWID;
2059: l_period_rec fa_api_types.period_rec_type;
2060: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2061:
2062: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_retirement_desc';
2063:

Line 2060: l_asset_retire_rec fa_api_types.asset_retire_rec_type;

2056: ret_err exception;
2057:
2058: l_rowid ROWID;
2059: l_period_rec fa_api_types.period_rec_type;
2060: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2061:
2062: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_retirement_desc';
2063:
2064: -- For primary and reporting books

Line 2067: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2063:
2064: -- For primary and reporting books
2065: l_reporting_flag varchar2(1) := 'P';
2066: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
2067: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2068:
2069: l_old_primary_proceeds_of_sale number;
2070: l_old_primary_cost_of_removal number;
2071: l_old_rep_proceeds_of_sale number;

Line 2770: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

2766:
2767:
2768: --
2769: FUNCTION initialize_category_df (
2770: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
2771: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
2772:
2773: l_return_status BOOLEAN;
2774: l_category_chart_id number;

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

2767:
2768: --
2769: FUNCTION initialize_category_df (
2770: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
2771: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
2772:
2773: l_return_status BOOLEAN;
2774: l_category_chart_id number;
2775: l_num_segs number;