DBA Data[Home] [Help]

APPS.FA_CUA_HR_REINSTATEMENTS_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_REINSTATEMENTS_PKG as
2: /* $Header: FACHRINMB.pls 120.4 2009/04/16 14:43:04 bridgway ship $ \ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE reinstate ( x_batch_num IN NUMBER
7: , x_conc_request_id IN NUMBER
8: , x_book_type_code IN VARCHAR2

Line 44: , TH_attribute15 IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

40: , TH_attribute11 IN VARCHAR2
41: , TH_attribute12 IN VARCHAR2
42: , TH_attribute13 IN VARCHAR2
43: , TH_attribute14 IN VARCHAR2
44: , TH_attribute15 IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
45:
46: /* Local Variables holding Mass Retirements Information */
47:
48: LV_Retirement_Rowid rowid;

Line 96: l_trans_rec FA_API_TYPES.trans_rec_type;

92: l_validation_level number := FND_API.G_VALID_LEVEL_FULL;
93: l_return_status varchar2(1) := FND_API.G_FALSE;
94: l_msg_count number := 0;
95: l_msg_data varchar2(512);
96: l_trans_rec FA_API_TYPES.trans_rec_type;
97: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
98: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
99: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
100: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 97: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

93: l_return_status varchar2(1) := FND_API.G_FALSE;
94: l_msg_count number := 0;
95: l_msg_data varchar2(512);
96: l_trans_rec FA_API_TYPES.trans_rec_type;
97: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
98: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
99: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
100: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
101: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 98: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

94: l_msg_count number := 0;
95: l_msg_data varchar2(512);
96: l_trans_rec FA_API_TYPES.trans_rec_type;
97: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
98: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
99: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
100: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
101: l_inv_tbl FA_API_TYPES.inv_tbl_type;
102:

Line 99: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

95: l_msg_data varchar2(512);
96: l_trans_rec FA_API_TYPES.trans_rec_type;
97: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
98: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
99: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
100: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
101: l_inv_tbl FA_API_TYPES.inv_tbl_type;
102:
103: CURSOR qualified_assets IS

Line 100: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

96: l_trans_rec FA_API_TYPES.trans_rec_type;
97: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
98: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
99: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
100: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
101: l_inv_tbl FA_API_TYPES.inv_tbl_type;
102:
103: CURSOR qualified_assets IS
104: SELECT ret.asset_id,

Line 101: l_inv_tbl FA_API_TYPES.inv_tbl_type;

97: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
98: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
99: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
100: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
101: l_inv_tbl FA_API_TYPES.inv_tbl_type;
102:
103: CURSOR qualified_assets IS
104: SELECT ret.asset_id,
105: ret.rowid,