DBA Data[Home] [Help]

APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FA_API_TYPES

Line 113: g_log_level_rec fa_api_types.log_level_rec_type;

109: G_test_num_of_distributions NUMBER;
110: G_test_ident_distributions NUMBER;
111: G_single_dist_array VARCHAR2(10);
112:
113: g_log_level_rec fa_api_types.log_level_rec_type;
114:
115: PROCEDURE Mass_Ext_Retire (P_BOOK_TYPE_CODE IN VARCHAR2,
116: PX_BATCH_NAME IN OUT NOCOPY VARCHAR2,
117: P_PARENT_REQUEST_ID IN NUMBER,

Line 235: l_trans_rec fa_api_types.trans_rec_type;

231: l_return_status VARCHAR2(10);
232: l_msg_count NUMBER;
233: -- l_msg_data VARCHAR2(4000);
234: l_calling_fn VARCHAR2(100) := 'fa_cua_mass_ext_ret_pkg';
235: l_trans_rec fa_api_types.trans_rec_type;
236: l_dist_trans_rec fa_api_types.trans_rec_type;
237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;

Line 236: l_dist_trans_rec fa_api_types.trans_rec_type;

232: l_msg_count NUMBER;
233: -- l_msg_data VARCHAR2(4000);
234: l_calling_fn VARCHAR2(100) := 'fa_cua_mass_ext_ret_pkg';
235: l_trans_rec fa_api_types.trans_rec_type;
236: l_dist_trans_rec fa_api_types.trans_rec_type;
237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

Line 237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

233: -- l_msg_data VARCHAR2(4000);
234: l_calling_fn VARCHAR2(100) := 'fa_cua_mass_ext_ret_pkg';
235: l_trans_rec fa_api_types.trans_rec_type;
236: l_dist_trans_rec fa_api_types.trans_rec_type;
237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;

Line 238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;

234: l_calling_fn VARCHAR2(100) := 'fa_cua_mass_ext_ret_pkg';
235: l_trans_rec fa_api_types.trans_rec_type;
236: l_dist_trans_rec fa_api_types.trans_rec_type;
237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;
242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;

Line 239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;

235: l_trans_rec fa_api_types.trans_rec_type;
236: l_dist_trans_rec fa_api_types.trans_rec_type;
237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;
242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
243: l_inv_rec fa_api_types.inv_rec_type;

Line 240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

236: l_dist_trans_rec fa_api_types.trans_rec_type;
237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;
242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
243: l_inv_rec fa_api_types.inv_rec_type;
244: l_inv_tbl fa_api_types.inv_tbl_type;

Line 241: l_subcomp_rec fa_api_types.subcomp_rec_type;

237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;
242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
243: l_inv_rec fa_api_types.inv_rec_type;
244: l_inv_tbl fa_api_types.inv_tbl_type;
245: -- end api declaration

Line 242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;

238: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;
242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
243: l_inv_rec fa_api_types.inv_rec_type;
244: l_inv_tbl fa_api_types.inv_tbl_type;
245: -- end api declaration
246:

Line 243: l_inv_rec fa_api_types.inv_rec_type;

239: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;
242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
243: l_inv_rec fa_api_types.inv_rec_type;
244: l_inv_tbl fa_api_types.inv_tbl_type;
245: -- end api declaration
246:
247: l_Mass_External_Retire_Id num_tbl_type;

Line 244: l_inv_tbl fa_api_types.inv_tbl_type;

240: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
241: l_subcomp_rec fa_api_types.subcomp_rec_type;
242: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
243: l_inv_rec fa_api_types.inv_rec_type;
244: l_inv_tbl fa_api_types.inv_tbl_type;
245: -- end api declaration
246:
247: l_Mass_External_Retire_Id num_tbl_type;
248: L_Book_Type_Code char_tbl_type;

Line 1576: RETCODE OUT NOCOPY VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1572: END Mass_Ext_Retire;
1573:
1574: ------------------------------------------------------------------------------
1575: PROCEDURE Purge(ERRBUF OUT NOCOPY VARCHAR2,
1576: RETCODE OUT NOCOPY VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1577:
1578: Cursor Assets_C is
1579: select Mass_External_Retire_ID
1580: from fa_mass_ext_retirements