DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_API_TYPES

Line 4: g_log_level_rec fa_api_types.log_level_rec_type;

1: PACKAGE BODY FA_CUA_HR_RETIREMENTS_PKG AS
2: /* $Header: FACHRMRMB.pls 120.7 2009/08/20 14:18:31 bridgway ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: -- ----------------------------------------------------------------
7: -- This function will return TRUE if the asset belongs to any batch
8: -- in mass_update_batches or retirement_batches with a pending

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

38: x_category_id IN NUMBER DEFAULT NULL,
39: x_attribute IN VARCHAR2 DEFAULT NULL,
40: x_conc_request_id IN NUMBER DEFAULT NULL,
41: x_status IN OUT NOCOPY VARCHAR2
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
43:
44: v_dummy NUMBER:=0;
45: v_node_id NUMBER;
46: pending_batch varchar2(17):= 'CUA_PENDING_BATCH';

Line 182: x_status in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

178: nvl(concurrent_request_id,0) <> x_conc_request_id ) );
179:
180: -- TRUE if txn allowed - FALSE otherwise
181: FUNCTION check_book_stats ( x_book in varchar2 ,
182: x_status in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
183:
184: l_txn_status boolean:= FALSE;
185: l_api_version number := 1;
186: l_init_msg_list varchar2(1) := FND_API.G_FALSE;

Line 192: l_trans_rec FA_API_TYPES.trans_rec_type;

188: l_validation_level number := FND_API.G_VALID_LEVEL_FULL;
189: l_return_status varchar2(1) := FND_API.G_FALSE;
190: l_msg_count number := 0;
191: l_msg_data varchar2(512);
192: l_trans_rec FA_API_TYPES.trans_rec_type;
193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
194: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
195: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
196: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

189: l_return_status varchar2(1) := FND_API.G_FALSE;
190: l_msg_count number := 0;
191: l_msg_data varchar2(512);
192: l_trans_rec FA_API_TYPES.trans_rec_type;
193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
194: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
195: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
196: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
197: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 194: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

190: l_msg_count number := 0;
191: l_msg_data varchar2(512);
192: l_trans_rec FA_API_TYPES.trans_rec_type;
193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
194: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
195: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
196: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
197: l_inv_tbl FA_API_TYPES.inv_tbl_type;
198: BEGIN

Line 195: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

191: l_msg_data varchar2(512);
192: l_trans_rec FA_API_TYPES.trans_rec_type;
193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
194: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
195: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
196: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
197: l_inv_tbl FA_API_TYPES.inv_tbl_type;
198: BEGIN
199:

Line 196: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

192: l_trans_rec FA_API_TYPES.trans_rec_type;
193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
194: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
195: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
196: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
197: l_inv_tbl FA_API_TYPES.inv_tbl_type;
198: BEGIN
199:
200: -- bugfix2250373

Line 197: l_inv_tbl FA_API_TYPES.inv_tbl_type;

193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
194: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
195: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
196: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
197: l_inv_tbl FA_API_TYPES.inv_tbl_type;
198: BEGIN
199:
200: -- bugfix2250373
201: if NOT FA_CHK_BOOKSTS_PKG.faxcbs(

Line 524: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

520: , TH_attribute14 IN VARCHAR2
521: , TH_attribute15 IN VARCHAR2
522: , x_err_code IN OUT NOCOPY VARCHAR2
523: , x_err_stage IN OUT NOCOPY VARCHAR2
524: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
525:
526: CURSOR C1 IS
527: select fa_hr_retirement_hdrs_s.nextval
528: from dual;

Line 692: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

688: , x_last_update_login IN NUMBER
689: , x_concurrent_request_id IN NUMBER
690: , x_err_code IN OUT NOCOPY VARCHAR2
691: , x_err_stage IN OUT NOCOPY VARCHAR2
692: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
693:
694: v_old_err_stack VARCHAr2(640);
695: BEGIN
696: x_err_code := '0';

Line 805: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

801: , TH_attribute14 IN VARCHAR2 DEFAULT NULL
802: , TH_attribute15 IN VARCHAR2 DEFAULT NULL
803: , x_err_code IN OUT NOCOPY VARCHAR2
804: , x_err_stage IN OUT NOCOPY VARCHAR2
805: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
806:
807: v_old_err_stack VARCHAR2(630);
808: v_sysdate DATE;
809: v_created_by NUMBER;

Line 1527: , x_conc_request_id IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1523: , TH_attribute12 IN VARCHAR2
1524: , TH_attribute13 IN VARCHAR2
1525: , TH_attribute14 IN VARCHAR2
1526: , TH_attribute15 IN VARCHAR2
1527: , x_conc_request_id IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1528:
1529: CURSOR c_hrd IS
1530: select batch_id,
1531: asset_id,

Line 1618: l_trans_rec FA_API_TYPES.trans_rec_type;

1614: v_no_of_dist_lines number:= 0;
1615: v_transaction_units number:= NULL;
1616: v_running_units number:=0;
1617:
1618: l_trans_rec FA_API_TYPES.trans_rec_type;
1619: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 1619: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

1615: v_transaction_units number:= NULL;
1616: v_running_units number:=0;
1617:
1618: l_trans_rec FA_API_TYPES.trans_rec_type;
1619: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1623: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1616: v_running_units number:=0;
1617:
1618: l_trans_rec FA_API_TYPES.trans_rec_type;
1619: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1623: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1624: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

1617:
1618: l_trans_rec FA_API_TYPES.trans_rec_type;
1619: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1623: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1624: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1625:

Line 1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

1618: l_trans_rec FA_API_TYPES.trans_rec_type;
1619: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1623: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1624: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1625:
1626: /* misc info */

Line 1623: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

1619: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1623: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1624: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1625:
1626: /* misc info */
1627: l_api_version number := 1;

Line 1624: l_inv_tbl FA_API_TYPES.inv_tbl_type;

1620: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1621: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1622: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1623: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1624: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1625:
1626: /* misc info */
1627: l_api_version number := 1;
1628: l_init_msg_list varchar2(1) := FND_API.G_FALSE;