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(
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,
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;
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:
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 (
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;
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 ******************************--
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(
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
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;
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;
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;
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;
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:
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);
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,
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
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:
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;
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;
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:
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:
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;
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:
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
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;
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:
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:
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;
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:
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
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;
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;
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;