DBA Data[Home] [Help]

APPS.FA_MC_UPG1_PKG dependencies on FND_CONCURRENT

Line 926: FND_CONCURRENT.AF_ROLLBACK;

922: -- conversion history to force rerun of selection program phase 1
923: -- rollback assets that have been inserted into rates table since
924: -- the last commit
925:
926: FND_CONCURRENT.AF_ROLLBACK;
927: DELETE FROM fa_mc_conversion_history
928: WHERE set_of_books_id = p_rsob_id AND
929: book_type_code = p_book_type_code;
930:

Line 970: FND_CONCURRENT.AF_COMMIT;

966: set_of_books_id = p_rsob_id AND
967: book_type_code = p_book_type_code;
968: END IF;
969:
970: FND_CONCURRENT.AF_COMMIT;
971:
972: EXCEPTION
973: WHEN OTHERS THEN
974: fa_srvr_msg.add_sql_error (

Line 1084: FND_CONCURRENT.AF_COMMIT;

1080:
1081: IF SQL%NOTFOUND THEN
1082: EXIT;
1083: END IF;
1084: FND_CONCURRENT.AF_COMMIT;
1085:
1086: -- obtain lock again after commit
1087: l_lock_status := lock_book(
1088: p_book_type_code,

Line 1152: FND_CONCURRENT.AF_COMMIT;

1148:
1149: IF SQL%NOTFOUND THEN
1150: EXIT;
1151: END IF;
1152: FND_CONCURRENT.AF_COMMIT;
1153:
1154: l_lock_status := lock_book(
1155: p_book_type_code,
1156: p_rsob_id);

Line 1168: FND_CONCURRENT.AF_COMMIT;

1164: UPDATE fa_mc_conversion_history
1165: SET total_assets = X_total_assets
1166: WHERE book_type_code = p_book_type_code AND
1167: set_of_books_id = p_rsob_id;
1168: FND_CONCURRENT.AF_COMMIT;
1169:
1170: EXCEPTION
1171: WHEN lock_error THEN
1172: FND_CONCURRENT.AF_ROLLBACK ;

Line 1172: FND_CONCURRENT.AF_ROLLBACK ;

1168: FND_CONCURRENT.AF_COMMIT;
1169:
1170: EXCEPTION
1171: WHEN lock_error THEN
1172: FND_CONCURRENT.AF_ROLLBACK ;
1173: set_conversion_status(
1174: p_book_type_code,
1175: p_rsob_id,
1176: p_start_pc,

Line 1185: FND_CONCURRENT.AF_ROLLBACK ;

1181: calling_fn => 'fa_mc_upg1_pkg.get_candidate_assets');
1182: app_exception.raise_exception;
1183:
1184: WHEN OTHERS THEN
1185: FND_CONCURRENT.AF_ROLLBACK ;
1186: set_conversion_status(
1187: p_book_type_code,
1188: p_rsob_id,
1189: p_start_pc,

Line 1823: FND_CONCURRENT.AF_COMMIT;

1819: WHERE
1820: set_of_books_id = p_rsob_id AND
1821: book_type_code = p_book_type_code AND
1822: STATUS = 'S';
1823: FND_CONCURRENT.AF_COMMIT;
1824: l_assets_processed := l_assets_processed + l_commit_size;
1825:
1826: END LOOP; -- while LOOP
1827:

Line 1875: FND_CONCURRENT.AF_ROLLBACK ;

1871:
1872: EXCEPTION
1873: WHEN OTHERS THEN
1874: -- rollback everything since last commit
1875: FND_CONCURRENT.AF_ROLLBACK ;
1876: /*
1877: IF (index_flag) THEN
1878: create_drop_indexes('C');
1879: END IF;