DBA Data[Home] [Help]

APPS.FA_MASSPSLTFR_PKG dependencies on FA_API_TYPES

Line 4: g_log_level_rec fa_api_types.log_level_rec_type;

1: PACKAGE BODY FA_MASSPSLTFR_PKG AS
2: /* $Header: FAMPSLTFRB.pls 120.21 2006/07/21 07:17:52 tdewanga noship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: --************************* Private types ********************************--
7: -- Types for table variable
8: TYPE num_tbl_type is table of number index by binary_integer;

Line 39: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;

35: p_transfer_amount IN NUMBER,
36: p_source_line_id IN NUMBER,
37: p_post_batch_id IN NUMBER,
38: p_calling_fn IN VARCHAR2,
39: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
40:
41: PROCEDURE add_dependencies (
42: px_dep_group_asset_id IN OUT NOCOPY NUM_TBL_TYPE,
43: px_dep_asset_id IN OUT NOCOPY NUM_TBL_TYPE,

Line 48: p_log_level_rec IN fa_api_types.log_level_rec_type default null);

44: p_sub_group_asset_id IN NUM_TBL_TYPE,
45: p_sub_asset_id IN NUM_TBL_TYPE,
46: px_new_group_total IN OUT NOCOPY NUMBER,
47: px_new_asset_total IN OUT NOCOPY NUMBER,
48: p_log_level_rec IN fa_api_types.log_level_rec_type default null);
49:
50: --*********************** Public procedures ******************************--
51: PROCEDURE do_mass_sl_transfer (
52: p_book_type_code IN VARCHAR2,

Line 156: l_src_trans_rec fa_api_types.trans_rec_type;

152: l_last_update_login number(15) := fnd_global.login_id;
153: l_created_by number(15) := fnd_global.user_id;
154: l_creation_date date := sysdate;
155:
156: l_src_trans_rec fa_api_types.trans_rec_type;
157: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
158: l_dest_trans_rec fa_api_types.trans_rec_type;
159: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
160: l_inv_rec fa_api_types.inv_rec_type;

Line 157: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

153: l_created_by number(15) := fnd_global.user_id;
154: l_creation_date date := sysdate;
155:
156: l_src_trans_rec fa_api_types.trans_rec_type;
157: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
158: l_dest_trans_rec fa_api_types.trans_rec_type;
159: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
160: l_inv_rec fa_api_types.inv_rec_type;
161: l_inv_tbl fa_api_types.inv_tbl_type;

Line 158: l_dest_trans_rec fa_api_types.trans_rec_type;

154: l_creation_date date := sysdate;
155:
156: l_src_trans_rec fa_api_types.trans_rec_type;
157: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
158: l_dest_trans_rec fa_api_types.trans_rec_type;
159: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
160: l_inv_rec fa_api_types.inv_rec_type;
161: l_inv_tbl fa_api_types.inv_tbl_type;
162:

Line 159: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

155:
156: l_src_trans_rec fa_api_types.trans_rec_type;
157: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
158: l_dest_trans_rec fa_api_types.trans_rec_type;
159: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
160: l_inv_rec fa_api_types.inv_rec_type;
161: l_inv_tbl fa_api_types.inv_tbl_type;
162:
163: -- Column types for bulk fetch

Line 160: l_inv_rec fa_api_types.inv_rec_type;

156: l_src_trans_rec fa_api_types.trans_rec_type;
157: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
158: l_dest_trans_rec fa_api_types.trans_rec_type;
159: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
160: l_inv_rec fa_api_types.inv_rec_type;
161: l_inv_tbl fa_api_types.inv_tbl_type;
162:
163: -- Column types for bulk fetch
164: l_mass_external_transfer_id num_tbl_type;

Line 161: l_inv_tbl fa_api_types.inv_tbl_type;

157: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
158: l_dest_trans_rec fa_api_types.trans_rec_type;
159: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
160: l_inv_rec fa_api_types.inv_rec_type;
161: l_inv_tbl fa_api_types.inv_tbl_type;
162:
163: -- Column types for bulk fetch
164: l_mass_external_transfer_id num_tbl_type;
165: l_set_of_books_id num_tbl_type;

Line 628: p_log_level_rec in fa_api_types.log_level_rec_type default null) AS

624: p_book_type_code IN VARCHAR2,
625: p_batch_name IN VARCHAR2,
626: p_total_requests IN NUMBER,
627: x_return_status OUT NOCOPY NUMBER,
628: p_log_level_rec in fa_api_types.log_level_rec_type default null) AS
629:
630: l_max_mass_ext_transfer_id number(15);
631:
632: cursor group_lines is

Line 1066: p_log_level_rec IN fa_api_types.log_level_rec_type default null) IS

1062: p_sub_group_asset_id IN NUM_TBL_TYPE,
1063: p_sub_asset_id IN NUM_TBL_TYPE,
1064: px_new_group_total IN OUT NOCOPY NUMBER,
1065: px_new_asset_total IN OUT NOCOPY NUMBER,
1066: p_log_level_rec IN fa_api_types.log_level_rec_type default null) IS
1067:
1068: l_found boolean;
1069:
1070: BEGIN

Line 1141: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

1137: p_transfer_amount IN NUMBER,
1138: p_source_line_id IN NUMBER,
1139: p_post_batch_id IN NUMBER,
1140: p_calling_fn IN VARCHAR2,
1141: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
1142:
1143: validate_err exception;
1144:
1145: l_calling_fn varchar2(40)