APPS.FA_CUA_ASSET_APIS dependencies on FA_CUA_DERIVE_ASSET_ATTR_PKG

Line 1229: v_asset_attr_tab FA_CUA_DERIVE_ASSET_ATTR_PKG.asset_tabtype;

1225: v_created_by NUMBER;
1226: v_last_update_login NUMBER;
1227: v_last_updated_by NUMBER;
1228: v_conc_request_id NUMBER;
1229: v_asset_attr_tab FA_CUA_DERIVE_ASSET_ATTR_PKG.asset_tabtype;
1230: --v_distribution_array_out distribution_tabtype;
1231: i binary_integer:=0;
1232: j binary_integer:= 0;
1233: v_cat_id_out NUMBER;

Line 1334: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_hdrs (

1330:
1331: -- insert into batch_headers if not called from conc_process
1332: if G_conc_process <> 'Y' then
1333: x_err_stage:= 'Calling insert_mass_update_batch_headers';
1334: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_hdrs (
1335: x_event_code
1336: , x_book_type_code
1337: , 'P'
1338: , x_src_entity_name

Line 1383: FA_CUA_DERIVE_ASSET_ATTR_PKG.select_assets( x_event_code

1379: end if;
1380:
1381: x_err_stage:= 'Calling select_assets';
1382: -- dbms_output.put_line(x_err_stage);
1383: FA_CUA_DERIVE_ASSET_ATTR_PKG.select_assets( x_event_code
1384: , x_book_type_code
1385: , v_book_class
1386: , x_src_entity_value
1387: , v_parent_id -- new parent id in case of HR_MASS_TRANSFER

Line 1460: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1456:
1457: if ( v_derivation_type = 'ALL' AND
1458: nvl(v_asset_attr_tab(i).asset_category_id,0) <> nvl(v_cat_id_out,0)) then
1459: x_err_stage:= 'Insert_mass_update_batch_details: asset_category';
1460: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1461: x_batch_id
1462: , x_book_type_code
1463: , 'CATEGORY'
1464: , v_asset_attr_tab(i).asset_id

Line 1493: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1489:
1490: if( v_derivation_type IN ('ALL', 'LEASE_NUMBER') AND
1491: nvl(v_asset_attr_tab(i).lease_id,0) <> nvl(v_lease_id_out,0) ) then
1492: x_err_stage:= 'Insert_mass_update_batch_details: lease_number';
1493: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1494: x_batch_id
1495: , x_book_type_code
1496: , 'LEASE_NUMBER'
1497: , v_asset_attr_tab(i).asset_id

Line 1551: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1547:
1548: if ( (v_dist_count2 <> v_dist_count) AND (v_dist_count<> 0) ) then
1549: --CREATE NEW DISTRIBUTION;
1550: x_err_stage:= 'Insert_mass_update_batch_details: distribution_set';
1551: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1552: x_batch_id
1553: , x_book_type_code
1554: , 'DISTRIBUTION'
1555: , v_asset_attr_tab(i).asset_id

Line 1586: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1582:
1583: if ( v_derivation_type IN ('ALL', 'SERIAL_NUMBER') AND
1584: nvl(v_asset_attr_tab(i).serial_number,'0') <> nvl(v_serial_number_out,'0')) then
1585: x_err_stage:= 'Insert_mass_update_batch_details: serial_number';
1586: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1587: x_batch_id
1588: , x_book_type_code
1589: , 'SERIAL_NUMBER'
1590: , v_asset_attr_tab(i).asset_id

Line 1619: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1615:
1616: if ( v_derivation_type IN ('ALL', 'ASSET_KEY') AND
1617: nvl(v_asset_attr_tab(i).asset_key_ccid,0)<> nvl(v_asset_key_ccid_out,0)) then
1618: x_err_stage:= 'Insert_mass_update_batch_details: asset_key';
1619: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1620: x_batch_id
1621: , x_book_type_code
1622: , 'ASSET_KEY'
1623: , nvl(v_asset_attr_tab(i).asset_id, 0)

Line 1652: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(

1648:
1649: if ( v_derivation_type IN ('ALL', 'LEASE_NUMBER', 'LIFE_END_DATE') AND
1650: nvl(v_asset_attr_tab(i).life_in_months,0) <> nvl(v_life_in_months_out,0) ) then
1651: x_err_stage:= 'Insert_mass_update_batch_details: life_end_date';
1652: FA_CUA_DERIVE_ASSET_ATTR_PKG.insert_mass_update_batch_dtls(
1653: x_batch_id
1654: , x_book_type_code
1655: , 'LIFE_END_DATE'
1656: , nvl(v_asset_attr_tab(i).asset_id, 0)