APPS.FA_CUA_ASSET_APIS dependencies on FA_CUA_DERIVE_ASSET_ATTR_PKG

Line 1222: v_asset_attr_tab FA_CUA_DERIVE_ASSET_ATTR_PKG.asset_tabtype;

1218: v_created_by NUMBER;
1219: v_last_update_login NUMBER;
1220: v_last_updated_by NUMBER;
1221: v_conc_request_id NUMBER;
1222: v_asset_attr_tab FA_CUA_DERIVE_ASSET_ATTR_PKG.asset_tabtype;
1223: --v_distribution_array_out distribution_tabtype;
1224: i binary_integer:=0;
1225: j binary_integer:= 0;
1226: v_cat_id_out NUMBER;

Line 1327: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_hdrs (

1323:
1324: -- insert into batch_headers if not called from conc_process
1325: if G_conc_process <> 'Y' then
1326: x_err_stage:= 'Calling insert_mass_update_batch_headers';
1327: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_hdrs (
1328: x_event_code
1329: , x_book_type_code
1330: , 'P'
1331: , x_src_entity_name

Line 1376: FA_CUA_DERIVE_ASSET_ATTR_PKG.select_assets( x_event_code

1372: end if;
1373:
1374: x_err_stage:= 'Calling select_assets';
1375: -- dbms_output.put_line(x_err_stage);
1376: FA_CUA_DERIVE_ASSET_ATTR_PKG.select_assets( x_event_code
1377: , x_book_type_code
1378: , v_book_class
1379: , x_src_entity_value
1380: , v_parent_id -- new parent id in case of HR_MASS_TRANSFER

Line 1451: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1447:
1448: if ( v_derivation_type = 'ALL' AND
1449: nvl(v_asset_attr_tab(i).asset_category_id,0) <> nvl(v_cat_id_out,0)) then
1450: x_err_stage:= 'Insert_mass_update_batch_details: asset_category';
1451: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1452: x_batch_id
1453: , x_book_type_code
1454: , 'CATEGORY'
1455: , v_asset_attr_tab(i).asset_id

Line 1483: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1479:
1480: if( v_derivation_type IN ('ALL', 'LEASE_NUMBER') AND
1481: nvl(v_asset_attr_tab(i).lease_id,0) <> nvl(v_lease_id_out,0) ) then
1482: x_err_stage:= 'Insert_mass_update_batch_details: lease_number';
1483: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1484: x_batch_id
1485: , x_book_type_code
1486: , 'LEASE_NUMBER'
1487: , v_asset_attr_tab(i).asset_id

Line 1540: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1536:
1537: if ( (v_dist_count2 <> v_dist_count) AND (v_dist_count<> 0) ) then
1538: --CREATE NEW DISTRIBUTION;
1539: x_err_stage:= 'Insert_mass_update_batch_details: distribution_set';
1540: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1541: x_batch_id
1542: , x_book_type_code
1543: , 'DISTRIBUTION'
1544: , v_asset_attr_tab(i).asset_id

Line 1574: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1570:
1571: if ( v_derivation_type IN ('ALL', 'SERIAL_NUMBER') AND
1572: nvl(v_asset_attr_tab(i).serial_number,'0') <> nvl(v_serial_number_out,'0')) then
1573: x_err_stage:= 'Insert_mass_update_batch_details: serial_number';
1574: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1575: x_batch_id
1576: , x_book_type_code
1577: , 'SERIAL_NUMBER'
1578: , v_asset_attr_tab(i).asset_id

Line 1606: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1602:
1603: if ( v_derivation_type IN ('ALL', 'ASSET_KEY') AND
1604: nvl(v_asset_attr_tab(i).asset_key_ccid,0)<> nvl(v_asset_key_ccid_out,0)) then
1605: x_err_stage:= 'Insert_mass_update_batch_details: asset_key';
1606: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1607: x_batch_id
1608: , x_book_type_code
1609: , 'ASSET_KEY'
1610: , nvl(v_asset_attr_tab(i).asset_id, 0)

Line 1638: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1634:
1635: if ( v_derivation_type IN ('ALL', 'LEASE_NUMBER', 'LIFE_END_DATE') AND
1636: nvl(v_asset_attr_tab(i).life_in_months,0) <> nvl(v_life_in_months_out,0) ) then
1637: x_err_stage:= 'Insert_mass_update_batch_details: life_end_date';
1638: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1639: x_batch_id
1640: , x_book_type_code
1641: , 'LIFE_END_DATE'
1642: , nvl(v_asset_attr_tab(i).asset_id, 0)