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) 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) 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) return boolean;
19:
20: FUNCTION initialize_category_df (

Line 18: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) 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) 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) 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) 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) return boolean;
23:
24:
25: --*********************** Public procedures ******************************--

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

18: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) 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) 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)

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)
42: IS
43:

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)
42: IS
43:
44: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 41: px_asset_cat_rec_new IN OUT NOCOPY 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)
42: IS
43:
44: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
45: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 44: l_asset_desc_rec FA_API_TYPES.asset_desc_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)
42: IS
43:
44: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
45: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
46: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
47: l_calling_fn varchar2(50) := 'FA_ASSET_DESC_PUB.update_desc';
48: pub_error exception;

Line 45: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

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

Line 46: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

42: IS
43:
44: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
45: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
46: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
47: l_calling_fn varchar2(50) := 'FA_ASSET_DESC_PUB.update_desc';
48: pub_error exception;
49:
50: l_err_stage varchar2(640);

Line 1114: p_trans_rec IN fa_api_types.trans_rec_type,

1110: END update_desc;
1111:
1112:
1113: FUNCTION update_row(
1114: p_trans_rec IN fa_api_types.trans_rec_type,
1115: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1116: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1117: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1118: p_old_warranty_id IN number

Line 1115: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

1111:
1112:
1113: FUNCTION update_row(
1114: p_trans_rec IN fa_api_types.trans_rec_type,
1115: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1116: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1117: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1118: p_old_warranty_id IN number
1119: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

Line 1116: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,

1112:
1113: FUNCTION update_row(
1114: p_trans_rec IN fa_api_types.trans_rec_type,
1115: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1116: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1117: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1118: p_old_warranty_id IN number
1119: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1120:

Line 1117: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,

1113: FUNCTION update_row(
1114: p_trans_rec IN fa_api_types.trans_rec_type,
1115: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1116: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1117: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1118: p_old_warranty_id IN number
1119: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1120:
1121: l_return_status boolean:= FALSE;

Line 1119: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

1115: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1116: p_asset_desc_rec_new IN fa_api_types.asset_desc_rec_type,
1117: p_asset_cat_rec_new IN fa_api_types.asset_cat_rec_type,
1118: p_old_warranty_id IN number
1119: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1120:
1121: l_return_status boolean:= FALSE;
1122: l_calling_fn varchar2(30);
1123: update_error EXCEPTION;

Line 1376: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

1372: x_msg_count OUT NOCOPY NUMBER,
1373: x_msg_data OUT NOCOPY VARCHAR2,
1374: p_calling_fn IN VARCHAR2,
1375: -- Transaction Object --
1376: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1377: -- Asset Object --
1378: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1379: px_inv_tbl_new IN OUT NOCOPY fa_api_types.inv_tbl_type) IS
1380:

Line 1378: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

1374: p_calling_fn IN VARCHAR2,
1375: -- Transaction Object --
1376: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1377: -- Asset Object --
1378: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1379: px_inv_tbl_new IN OUT NOCOPY fa_api_types.inv_tbl_type) IS
1380:
1381: inv_err exception;
1382:

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

1375: -- Transaction Object --
1376: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1377: -- Asset Object --
1378: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1379: px_inv_tbl_new IN OUT NOCOPY fa_api_types.inv_tbl_type) IS
1380:
1381: inv_err exception;
1382:
1383: l_rowid ROWID;

Line 1384: l_period_rec fa_api_types.period_rec_type;

1380:
1381: inv_err exception;
1382:
1383: l_rowid ROWID;
1384: l_period_rec fa_api_types.period_rec_type;
1385: l_inv_rec fa_api_types.inv_rec_type;
1386:
1387: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_invoice_desc';
1388:

Line 1385: l_inv_rec fa_api_types.inv_rec_type;

1381: inv_err exception;
1382:
1383: l_rowid ROWID;
1384: l_period_rec fa_api_types.period_rec_type;
1385: l_inv_rec fa_api_types.inv_rec_type;
1386:
1387: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_invoice_desc';
1388:
1389: -- Bug 8252607/5475276 Cursor to get the book_type_code

Line 1403: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

1399:
1400: -- For primary and reporting books
1401: l_reporting_flag varchar2(1) := 'P';
1402: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
1403: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1404:
1405: BEGIN
1406:
1407: SAVEPOINT do_invoice_desc_update;

Line 1990: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

1986: x_msg_count OUT NOCOPY NUMBER,
1987: x_msg_data OUT NOCOPY VARCHAR2,
1988: p_calling_fn IN VARCHAR2,
1989: -- Transaction Object --
1990: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1991: -- Asset Object --
1992: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1993: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) IS
1994:

Line 1992: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

1988: p_calling_fn IN VARCHAR2,
1989: -- Transaction Object --
1990: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1991: -- Asset Object --
1992: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1993: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) IS
1994:
1995: ret_err exception;
1996:

Line 1993: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) IS

1989: -- Transaction Object --
1990: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1991: -- Asset Object --
1992: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1993: px_asset_retire_rec_new IN OUT NOCOPY fa_api_types.asset_retire_rec_type) IS
1994:
1995: ret_err exception;
1996:
1997: l_rowid ROWID;

Line 1998: l_period_rec fa_api_types.period_rec_type;

1994:
1995: ret_err exception;
1996:
1997: l_rowid ROWID;
1998: l_period_rec fa_api_types.period_rec_type;
1999: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2000:
2001: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_retirement_desc';
2002:

Line 1999: l_asset_retire_rec fa_api_types.asset_retire_rec_type;

1995: ret_err exception;
1996:
1997: l_rowid ROWID;
1998: l_period_rec fa_api_types.period_rec_type;
1999: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2000:
2001: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_retirement_desc';
2002:
2003: -- For primary and reporting books

Line 2006: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2002:
2003: -- For primary and reporting books
2004: l_reporting_flag varchar2(1) := 'P';
2005: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
2006: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2007:
2008: l_old_primary_proceeds_of_sale number;
2009: l_old_primary_cost_of_removal number;
2010: l_old_rep_proceeds_of_sale number;

Line 2684: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type

2680:
2681:
2682: --
2683: FUNCTION initialize_category_df (
2684: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type
2685: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2686:
2687: l_return_status BOOLEAN;
2688: l_category_chart_id number;

Line 2685: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

2681:
2682: --
2683: FUNCTION initialize_category_df (
2684: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type
2685: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2686:
2687: l_return_status BOOLEAN;
2688: l_category_chart_id number;
2689: l_num_segs number;